Onderstaand datamodel wordt gepubliceerd middels onze BI server.
Hier kunnen op verzoek uitbreidingen op gedaan worden.
Table | Description |
---|---|
company | Companies |
company_company | Table to determine the relation between companies (vestiging/moederbedrijf) |
course | All planned courses |
course_company | Companies which are connected to incompany courses |
course_daypart | Dayparts belonging to courses |
course_label | Labels connected to courses |
coursetemplate | Coursetemplates |
coursetemplate_daypart | Dayparts beloning to coursetemplates |
daypart | Dayparts |
daypart_instructor | Instructors plannend on a daypart |
daypart_label | Labels connected to a daypart |
daypart_location | Locations planned for a daypart |
daypart_material | Materials reserved for a daypart |
daypart_student | Students plannend on a daypart |
daypart_task | Tasks to do for a daypart |
employee | Employees of your own company |
instructor | Instructors |
label | Labels |
location | Locations where coursedayparts can be given |
material | Materials which can be reserved for dayparts |
student | Students (both private and from companies) |
student_code95 | Code95 periodes/amount for a student |
student_course | Followed courses by students (history) |
task | Tasks which can be done for dayparts |
Was dit artikel nuttig?
Dat is fantastisch!
Hartelijk dank voor uw beoordeling
Sorry dat we u niet konden helpen
Hartelijk dank voor uw beoordeling
Feedback verzonden
We stellen uw moeite op prijs en zullen proberen het artikel te verbeteren