TABLE LIST: TRAINEE, SECTION, GROUP, TEACHER, ASSIGNMENT, GR_SESSION, IT_SESSION, TR_SESSION
DEFINED DATATYPES: ID, WORD, FILE, PATH, DATE
| table | column | type | description | cross-ref |
| TRAINEE | trainee | id | reference id | primary |
| first_name | word | trainee's first name | ||
| last_name | word | trainee's last name | ||
| date_of_birth | date | trainee's date of birth | ||
| section | id | trainee's section | foreign | |
| SECTION | section | id | reference id | primary |
| grade | id | section's grade | foreign | |
| teacher | id | section's teacher | foreign | |
| GROUP | group | id | reference id | primary |
| section | list | group's section(s) | foreign | |
| teacher | id | group's teacher | foreign | |
| TEACHER | teacher | id | reference id | primary |
| first_name | word | teacher's first name | ||
| last_name | word | teacher's last name | ||
| directory | path | teacher's working directory | ||
| ASSIGNMENT | assignment | id | id for this particular assignment | primary |
| item_list | list | chained list of items, each one referenced with : grade+topic+item | ||
| level_of_demand | integer | a parameter used by the kernel | ||
| GR_SESSION | session | id | reference id | primary [= f(date, group, section)] |
| date | date | session's date and time of the day | ||
| group | id | working group | foreign | |
| teacher | id | teacher in charge of session | foreign | |
| assignment | file | stuff teacher prepared for them | foreign | |
| TR_IT_SESSION | session | id | training session (foreign) | Primary=session+item+trainee |
| item | id | one particular item | foreign | |
| trainee | id | trainee doing this particular item | foreign | |
| tr_it_log | file | what actually happened | ||
| mark | integer | mark for item done by trainee | ||
| TR_SESSION | trainee | id | Primary=session+trainee | |
| session | id | present working session | foreign | |
| assignment | id | case secific to this particular trainee | foreign | |
| level_of_demand | integer | case specific to this particular trainee | ||
| tr_log | file | what the trainee actually did | ||
| mark | integer | what mark the trainee deserved for his effort |