Relationship type | identifying | Cardinality | 1:N |
Parent entity | tce_answers | ||
Child entity | tce_tests_logs_answers |
Parent | mandatory |
Child | optional |
Insert | Update | Delete | |
Parent | ---- | NONE | RESTRICT |
Child | NONE | NONE | ---- |
Parent key | Child key |
answer_id | logansw_answer_id |
Several answers can be combined for a single multiple-choice question. |
Name | Value |
Match Type | Default |
Deferrable (Deferre constraint to the end of the transaction) | No |
Deferred (Check constraint at the end of the transaction) | No |
Relationship type | identifying | Cardinality | 1:N |
Parent entity | tce_user_groups | ||
Child entity | tce_testgroups |
Parent | mandatory |
Child | optional |
Insert | Update | Delete | |
Parent | ---- | NONE | CASCADE |
Child | NONE | NONE | ---- |
Parent key | Child key |
group_id | tstgrp_group_id |
Name | Value |
Match Type | Default |
Deferrable (Deferre constraint to the end of the transaction) | No |
Deferred (Check constraint at the end of the transaction) | No |
Relationship type | identifying | Cardinality | 1:N |
Parent entity | tce_user_groups | ||
Child entity | tce_usrgroups |
Parent | mandatory |
Child | optional |
Insert | Update | Delete | |
Parent | ---- | NONE | CASCADE |
Child | NONE | NONE | ---- |
Parent key | Child key |
group_id | usrgrp_group_id |
Name | Value |
Match Type | Default |
Deferrable (Deferre constraint to the end of the transaction) | No |
Deferred (Check constraint at the end of the transaction) | No |
Relationship type | non-identifying | Cardinality | 1:N |
Parent entity | tce_modules | ||
Child entity | tce_subjects |
Parent | mandatory |
Child | optional |
Insert | Update | Delete | |
Parent | ---- | NONE | CASCADE |
Child | NONE | NONE | ---- |
Parent key | Child key |
module_id | subject_module_id |
Name | Value |
Match Type | Default |
Deferrable (Deferre constraint to the end of the transaction) | No |
Deferred (Check constraint at the end of the transaction) | No |
Relationship type | non-identifying | Cardinality | 1:N |
Parent entity | tce_questions | ||
Child entity | tce_answers |
Parent | mandatory |
Child | optional |
Insert | Update | Delete | |
Parent | ---- | NONE | CASCADE |
Child | NONE | NONE | ---- |
Parent key | Child key |
question_id | answer_question_id |
Each multiple-choice question can have an unlimited number of alternative answers. |
Name | Value |
Match Type | Default |
Deferrable (Deferre constraint to the end of the transaction) | No |
Deferred (Check constraint at the end of the transaction) | No |
Relationship type | non-identifying | Cardinality | 1:N |
Parent entity | tce_questions | ||
Child entity | tce_tests_logs |
Parent | mandatory |
Child | optional |
Insert | Update | Delete | |
Parent | ---- | NONE | RESTRICT |
Child | NONE | NONE | ---- |
Parent key | Child key |
question_id | testlog_question_id |
Each test-log is relative to one question. |
Name | Value |
Match Type | Default |
Deferrable (Deferre constraint to the end of the transaction) | No |
Deferred (Check constraint at the end of the transaction) | No |
Relationship type | identifying | Cardinality | 1:N |
Parent entity | tce_test_subject_set | ||
Child entity | tce_test_subjects |
Parent | mandatory |
Child | optional |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | RESTRICT |
Child | NONE | NONE | ---- |
Parent key | Child key |
tsubset_id | subjset_tsubset_id |
A set may contain one or more subjects. |
Name | Value |
Match Type | Default |
Deferrable (Deferre constraint to the end of the transaction) | No |
Deferred (Check constraint at the end of the transaction) | No |
Relationship type | non-identifying | Cardinality | 1:N |
Parent entity | tce_users | ||
Child entity | tce_subjects |
Parent | mandatory |
Child | optional |
Insert | Update | Delete | |
Parent | ---- | NONE | CASCADE |
Child | NONE | NONE | ---- |
Parent key | Child key |
user_id | subject_user_id |
Name | Value |
Match Type | Default |
Deferrable (Deferre constraint to the end of the transaction) | No |
Deferred (Check constraint at the end of the transaction) | No |
Relationship type | non-identifying | Cardinality | 1:N |
Parent entity | tce_subjects | ||
Child entity | tce_questions |
Parent | mandatory |
Child | optional |
Insert | Update | Delete | |
Parent | ---- | NONE | CASCADE |
Child | NONE | NONE | ---- |
Parent key | Child key |
subject_id | question_subject_id |
Each subject (topic) can have an unlimited number of questions. |
Name | Value |
Match Type | Default |
Deferrable (Deferre constraint to the end of the transaction) | No |
Deferred (Check constraint at the end of the transaction) | No |
Relationship type | identifying | Cardinality | 1:N |
Parent entity | tce_subjects | ||
Child entity | tce_test_subjects |
Parent | mandatory |
Child | optional |
Insert | Update | Delete | |
Parent | ---- | NONE | RESTRICT |
Child | NONE | NONE | ---- |
Parent key | Child key |
subject_id | subjset_subject_id |
Several topics may be combined in a set of subjects. |
Name | Value |
Match Type | Default |
Deferrable (Deferre constraint to the end of the transaction) | No |
Deferred (Check constraint at the end of the transaction) | No |
Relationship type | non-identifying | Cardinality | 1:N |
Parent entity | tce_users | ||
Child entity | tce_tests |
Parent | mandatory |
Child | optional |
Insert | Update | Delete | |
Parent | ---- | NONE | CASCADE |
Child | NONE | NONE | ---- |
Parent key | Child key |
user_id | test_user_id |
User ID of the author of the test. |
Name | Value |
Match Type | Default |
Deferrable (Deferre constraint to the end of the transaction) | No |
Deferred (Check constraint at the end of the transaction) | No |
Relationship type | identifying | Cardinality | 1:N |
Parent entity | tce_tests | ||
Child entity | tce_testgroups |
Parent | mandatory |
Child | optional |
Insert | Update | Delete | |
Parent | ---- | NONE | CASCADE |
Child | NONE | NONE | ---- |
Parent key | Child key |
test_id | tstgrp_test_id |
A test could be executed by one or more groups of users. |
Name | Value |
Match Type | Default |
Deferrable (Deferre constraint to the end of the transaction) | No |
Deferred (Check constraint at the end of the transaction) | No |
Relationship type | non-identifying | Cardinality | 1:N |
Parent entity | tce_tests | ||
Child entity | tce_test_subject_set |
Parent | mandatory |
Child | optional |
Insert | Update | Delete | |
Parent | ---- | NONE | CASCADE |
Child | NONE | NONE | ---- |
Parent key | Child key |
test_id | tsubset_test_id |
Each test may contain one or more set of subjects. |
Name | Value |
Match Type | Default |
Deferrable (Deferre constraint to the end of the transaction) | No |
Deferred (Check constraint at the end of the transaction) | No |
Relationship type | non-identifying | Cardinality | 1:N |
Parent entity | tce_tests | ||
Child entity | tce_tests_users |
Parent | mandatory |
Child | optional |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | CASCADE |
Child | NONE | NONE | ---- |
Parent key | Child key |
test_id | testuser_test_id |
Each test can be executed by an unlimited number of users. |
Name | Value |
Match Type | Default |
Deferrable (Deferre constraint to the end of the transaction) | No |
Deferred (Check constraint at the end of the transaction) | No |
Relationship type | identifying | Cardinality | 1:N |
Parent entity | tce_tests_logs | ||
Child entity | tce_tests_logs_answers |
Parent | mandatory |
Child | optional |
Insert | Update | Delete | |
Parent | ---- | NONE | CASCADE |
Child | NONE | NONE | ---- |
Parent key | Child key |
testlog_id | logansw_testlog_id |
Each multiple-choice question can have several alternative answers. |
Name | Value |
Match Type | Default |
Deferrable (Deferre constraint to the end of the transaction) | No |
Deferred (Check constraint at the end of the transaction) | No |
Relationship type | non-identifying | Cardinality | 1:N |
Parent entity | tce_tests_users | ||
Child entity | tce_tests_logs |
Parent | mandatory |
Child | optional |
Insert | Update | Delete | |
Parent | ---- | NONE | CASCADE |
Child | NONE | NONE | ---- |
Parent key | Child key |
testuser_id | testlog_testuser_id |
Each user-test can contain an unlimited number of questions. |
Name | Value |
Match Type | Default |
Deferrable (Deferre constraint to the end of the transaction) | No |
Deferred (Check constraint at the end of the transaction) | No |
Relationship type | identifying | Cardinality | 1:N |
Parent entity | tce_users | ||
Child entity | tce_usrgroups |
Parent | mandatory |
Child | optional |
Insert | Update | Delete | |
Parent | ---- | NONE | CASCADE |
Child | NONE | NONE | ---- |
Parent key | Child key |
user_id | usrgrp_user_id |
Users may belong to none, one, or many groups. |
Name | Value |
Match Type | Default |
Deferrable (Deferre constraint to the end of the transaction) | No |
Deferred (Check constraint at the end of the transaction) | No |
Relationship type | non-identifying | Cardinality | 1:N |
Parent entity | tce_users | ||
Child entity | tce_tests_users |
Parent | mandatory |
Child | optional |
Insert | Update | Delete | |
Parent | ---- | NONE | CASCADE |
Child | NONE | NONE | ---- |
Parent key | Child key |
user_id | testuser_user_id |
Each user may execute several tests. |
Name | Value |
Match Type | Default |
Deferrable (Deferre constraint to the end of the transaction) | No |
Deferred (Check constraint at the end of the transaction) | No |
Relationship type | informative | Cardinality | 1:N |
Parent entity | tce_users | ||
Child entity | tce_sessions |
Parent | optional |
Child | optional |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | RESTRICT |
Child | NONE | NONE | ---- |
Parent key | Child key |
user_id | ??? |
Some user's information (id, level,...) are stored as serialized data on tce_sessions.cpsession_data field |
Name | Value |
Match Type | Default |
Deferrable (Deferre constraint to the end of the transaction) | No |
Deferred (Check constraint at the end of the transaction) | No |