TABLE LIST: TOOL, TOOL_ELT, GRADE, TOPIC, ITEM, POOL, QUESTION, RESP_TYPE, RESP_STRING, TREATMENT, MSG_GENE, MSG_PART
DEFINED DATATYPES: STRING, LIST, TOOLT, TOPIC, RESPT, NQUEST
| table | column | type | description | cross-ref |
| TOOL | tool_id | id | reference id | primary = type+id |
| tool_type | toolt | button-palette, list-box, ... | ||
| tool_elt_list | list | element list for the tool | ||
| TOOL_ELT | tool_elt_id | id | primary = type+id | |
| tool_type | toolt | button for the palette, item in the list-box, ... | ||
| face | file | the button face (case graphic or special character) | ||
| word | word | button label or list item, or... (case one word) | ||
| string | string | button label or list item, or... (case more than one word) |
| table | column | type | description | cross-ref |
| GRADE | grade | id | reference id | primary |
| name | word | grade name | ||
| student_label | file | introductory text for the student | ||
| teacher_label | file | introductory text for the teacher | ||
| TOPIC | grade | id | foreign | |
| topic | topic | reference id | primary = grade+topic | |
| name | string | topic name | ||
| student_label | file | introductory text for the student | ||
| teacher_label | file | introductory text for the teacher | ||
| ITEM | grade | id | foreign | |
| topic | topic | foreign | ||
| item | id | reference id | primary = grade+topic+item | |
| tool_id | id | reference id for the interactive tool | ||
| student_label | file | item text for the student | ||
| teacher_label | file | item text for the teacher | ||
| POOL | grade | id | foreign | |
| topic | topic | foreign | ||
| item | id | foreign | ||
| pool | id | reference id | primary = grade+topic+item+pool | |
| min | byte | iteration minimum for the pool | ||
| max | byte | iteration maximum for the pool | ||
| it_fct | file | iteration function for the pool | ||
| mk_fct | file | marking function for the pool | ||
| student_label | file | explanatory text for the student | ||
| teacher_label | file | explanatory text for the teacher | ||
| QUESTION | grade | id | foreign | |
| topic | topic | foreign | ||
| item | id | foreign | ||
| pool | id | foreign | ||
| question | id | reference id | primary = grade+topic+item+pool+question | |
| label | string | question label |
| table | column | type | description | cross-ref |
| RESP_TYPE | resp_type | respt | reference id | primary = grade+topic+item+pool+resp_type |
| teacher_label | file | explanatory text for the teacher | ||
| RESP_STRING | resp_string | word | the one provided by the training student | primary = grade+topic+ item+pool+question+resp_string |
| resp_type | respt | response type corresponding to provided string | ||
| TREATMENT | resp_num | byte | "this resp_type is being provided for the resp_numth time inside the pool" | primary = grade+topic+ item+pool+resp_type+resp_num |
| msg_gene | id | short, generic message | ||
| msg_short | string | merely depends on the pool, not on the question | ||
| msg_long | file | merely depends on the pool | ||
| msg_special | bool | depends on the question (case there is one at all) | ||
| new_quest | nquest | what question shall I send next ? | ||
| new_pool | id | note: "-1"=new item | ||
| new_item | id | note:"-1"=new topic | ||
| new_topic | id | (case you need to change topic) | ||
| MSG_GENE | msg_gene | id | reference id | primary |
| text_short | word | case one word | ||
| text_long | string | case more than one word | ||
| MSG_SPECIAL | text_short | string | short special message | identified by: grade+topic+item+ +pool+resp_type+resp_num+question |
| text_long | file | long special message |
| data-type | situation | ranking from | to | full explanation |
| STRING | short text | - | - | character string with limited size (else it is a file) |
| LIST | chained list | - | - | |
| TOOLT | tool-type id | 0 | 9 | 0=no tool;1=button palette;2=list box;[3-9]=else |
| TOPIC | topic id, 4 letters | - | - | example:"vect" stands for vectors |
| RESPT | answer-typing system | 0 | 9 | 0=no answer;1=good answer;9=desperate;[2-8]=else |
| NQUEST | what comes next ? | -1 | 1 | 0=same question;1=same pool;-1=else |