Each JobCoach/Parent can only have one employee assigned to them. Each employee can only have one assigned JobCoach/Parent. This means that an employee can also only have either a job coach or a parent. The new database should handle this, but PJCAdmin front-end and mobile will have to reflect the change. Perhaps list Parent and Job Coach separately.
Furthermore, anyone can be assigned to anyone. This means that an Employee can act as a JobCoach for an Administrator. We should restrict assignment so that only Employees/Users can be assigned. We should also separate Parent Assignment and JobCoach Assignment. Adminstrators should not be able to be assigned to anyone.
Each JobCoach/Parent can only have one employee assigned to them. Each employee can only have one assigned JobCoach/Parent. This means that an employee can also only have either a job coach or a parent. The new database should handle this, but PJCAdmin front-end and mobile will have to reflect the change. Perhaps list Parent and Job Coach separately.
Furthermore, anyone can be assigned to anyone. This means that an Employee can act as a JobCoach for an Administrator. We should restrict assignment so that only Employees/Users can be assigned. We should also separate Parent Assignment and JobCoach Assignment. Adminstrators should not be able to be assigned to anyone.