I have collections with clients who take their children to school, have a separate collection with children and also a collection with a subject and a teacher. Who can help with the idea of how to do this?
Also there is a personal office of the client and the teacher. In the client's office I want to show the student's schedule. A pupil can go to several subjects, to different teachers on different days and at different times. In addition, the client's office should have a homework and a separate table view that shows what day and time the student was engaged in. What kind of homework was given to him. What would the client see the result of the teacher's work. That, on the basis of this data, it is possible to see what kind of discipline a student has.
The teacher's office should have his schedule, and a table for the daily report, on the basis of which the results are then summed up in the client's office.
There is also an administrator who monitors the teacher's work on reports and student attendance. And also the administrator can, in his office in case of not switching to the work of one of the teachers, change the schedule for the students who must come to their lessons, thereby replacing the lesson with another subject for the time of the absence of the other teacher. Thus, the client will see a change in the schedule and the teacher who came instead of the other teacher will be able to pass the report for his work done
At the same time, I can not load the teacher's job of submitting a report, so that he does not type each student separately into the form. It is necessary that he chose his priedmet, the day of the week and with almost one button filling only one line could send the report to the administrator. The data of this report will also be seen by the customers.
Approximately I see it this way:
There should be a collection separately for the client, the student, the teacher, the subject, the day of the week. But how to connect them so that clients and teachers can go to the dynamic page and see the data based on their ID.
I will be grateful for any help !!!