Relationship 'rel_answer_logs'
General info
Relationship type identifying Cardinality 1:N
Parent entity tce_answers
Child entity tce_tests_logs_answers
Partiality
Parent mandatory
Child optional
Referential integrity
Insert Update Delete
Parent ---- NONE RESTRICT
Child NONE NONE ----
Keys
Parent key Child key
answer_id logansw_answer_id
Description
Several answers can be combined for a single multiple-choice question.
User-defined variables
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 'rel_group_test'
General info
Relationship type identifying Cardinality 1:N
Parent entity tce_user_groups
Child entity tce_testgroups
Partiality
Parent mandatory
Child optional
Referential integrity
Insert Update Delete
Parent ---- NONE CASCADE
Child NONE NONE ----
Keys
Parent key Child key
group_id tstgrp_group_id
User-defined variables
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 'rel_group_user'
General info
Relationship type identifying Cardinality 1:N
Parent entity tce_user_groups
Child entity tce_usrgroups
Partiality
Parent mandatory
Child optional
Referential integrity
Insert Update Delete
Parent ---- NONE CASCADE
Child NONE NONE ----
Keys
Parent key Child key
group_id usrgrp_group_id
User-defined variables
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 'rel_module_subjects'
General info
Relationship type non-identifying Cardinality 1:N
Parent entity tce_modules
Child entity tce_subjects
Partiality
Parent mandatory
Child optional
Referential integrity
Insert Update Delete
Parent ---- NONE CASCADE
Child NONE NONE ----
Keys
Parent key Child key
module_id subject_module_id
User-defined variables
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 'rel_question_answers'
General info
Relationship type non-identifying Cardinality 1:N
Parent entity tce_questions
Child entity tce_answers
Partiality
Parent mandatory
Child optional
Referential integrity
Insert Update Delete
Parent ---- NONE CASCADE
Child NONE NONE ----
Keys
Parent key Child key
question_id answer_question_id
Description
Each multiple-choice question can have an unlimited number of alternative answers.
User-defined variables
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 'rel_question_logs'
General info
Relationship type non-identifying Cardinality 1:N
Parent entity tce_questions
Child entity tce_tests_logs
Partiality
Parent mandatory
Child optional
Referential integrity
Insert Update Delete
Parent ---- NONE RESTRICT
Child NONE NONE ----
Keys
Parent key Child key
question_id testlog_question_id
Description
Each test-log is relative to one question.
User-defined variables
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 'rel_set_subjects'
General info
Relationship type identifying Cardinality 1:N
Parent entity tce_test_subject_set
Child entity tce_test_subjects
Partiality
Parent mandatory
Child optional
Referential integrity
Insert Update Delete
Parent ---- RESTRICT RESTRICT
Child NONE NONE ----
Keys
Parent key Child key
tsubset_id subjset_tsubset_id
Description
A set may contain one or more subjects.
User-defined variables
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 'rel_subject_author'
General info
Relationship type non-identifying Cardinality 1:N
Parent entity tce_users
Child entity tce_subjects
Partiality
Parent mandatory
Child optional
Referential integrity
Insert Update Delete
Parent ---- NONE CASCADE
Child NONE NONE ----
Keys
Parent key Child key
user_id subject_user_id
User-defined variables
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 'rel_subject_questions'
General info
Relationship type non-identifying Cardinality 1:N
Parent entity tce_subjects
Child entity tce_questions
Partiality
Parent mandatory
Child optional
Referential integrity
Insert Update Delete
Parent ---- NONE CASCADE
Child NONE NONE ----
Keys
Parent key Child key
subject_id question_subject_id
Description
Each subject (topic) can have an unlimited number of questions.
User-defined variables
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 'rel_subject_set'
General info
Relationship type identifying Cardinality 1:N
Parent entity tce_subjects
Child entity tce_test_subjects
Partiality
Parent mandatory
Child optional
Referential integrity
Insert Update Delete
Parent ---- NONE RESTRICT
Child NONE NONE ----
Keys
Parent key Child key
subject_id subjset_subject_id
Description
Several topics may be combined in a set of subjects.
User-defined variables
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 'rel_test_author'
General info
Relationship type non-identifying Cardinality 1:N
Parent entity tce_users
Child entity tce_tests
Partiality
Parent mandatory
Child optional
Referential integrity
Insert Update Delete
Parent ---- NONE CASCADE
Child NONE NONE ----
Keys
Parent key Child key
user_id test_user_id
Description
User ID of the author of the test.
User-defined variables
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 'rel_test_group'
General info
Relationship type identifying Cardinality 1:N
Parent entity tce_tests
Child entity tce_testgroups
Partiality
Parent mandatory
Child optional
Referential integrity
Insert Update Delete
Parent ---- NONE CASCADE
Child NONE NONE ----
Keys
Parent key Child key
test_id tstgrp_test_id
Description
A test could be executed by one or more groups of users.
User-defined variables
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 'rel_test_subjset'
General info
Relationship type non-identifying Cardinality 1:N
Parent entity tce_tests
Child entity tce_test_subject_set
Partiality
Parent mandatory
Child optional
Referential integrity
Insert Update Delete
Parent ---- NONE CASCADE
Child NONE NONE ----
Keys
Parent key Child key
test_id tsubset_test_id
Description
Each test may contain one or more set of subjects.
User-defined variables
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 'rel_test_users'
General info
Relationship type non-identifying Cardinality 1:N
Parent entity tce_tests
Child entity tce_tests_users
Partiality
Parent mandatory
Child optional
Referential integrity
Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----
Keys
Parent key Child key
test_id testuser_test_id
Description
Each test can be executed by an unlimited number of users.
User-defined variables
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 'rel_testlog_answers'
General info
Relationship type identifying Cardinality 1:N
Parent entity tce_tests_logs
Child entity tce_tests_logs_answers
Partiality
Parent mandatory
Child optional
Referential integrity
Insert Update Delete
Parent ---- NONE CASCADE
Child NONE NONE ----
Keys
Parent key Child key
testlog_id logansw_testlog_id
Description
Each multiple-choice question can have several alternative answers.
User-defined variables
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 'rel_testuser_logs'
General info
Relationship type non-identifying Cardinality 1:N
Parent entity tce_tests_users
Child entity tce_tests_logs
Partiality
Parent mandatory
Child optional
Referential integrity
Insert Update Delete
Parent ---- NONE CASCADE
Child NONE NONE ----
Keys
Parent key Child key
testuser_id testlog_testuser_id
Description
Each user-test can contain an unlimited number of questions.
User-defined variables
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 'rel_user_group'
General info
Relationship type identifying Cardinality 1:N
Parent entity tce_users
Child entity tce_usrgroups
Partiality
Parent mandatory
Child optional
Referential integrity
Insert Update Delete
Parent ---- NONE CASCADE
Child NONE NONE ----
Keys
Parent key Child key
user_id usrgrp_user_id
Description
Users may belong to none, one, or many groups.
User-defined variables
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 'rel_user_tests'
General info
Relationship type non-identifying Cardinality 1:N
Parent entity tce_users
Child entity tce_tests_users
Partiality
Parent mandatory
Child optional
Referential integrity
Insert Update Delete
Parent ---- NONE CASCADE
Child NONE NONE ----
Keys
Parent key Child key
user_id testuser_user_id
Description
Each user may execute several tests.
User-defined variables
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 'session_data'
General info
Relationship type informative Cardinality 1:N
Parent entity tce_users
Child entity tce_sessions
Partiality
Parent optional
Child optional
Referential integrity
Insert Update Delete
Parent ---- RESTRICT RESTRICT
Child NONE NONE ----
Keys
Parent key Child key
user_id ???
Description
Some user's information (id, level,...) are stored as serialized data on tce_sessions.cpsession_data field
User-defined variables
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