rel_answer_logs (rel_answer_logs)
General info
Relationship type identifying Cardinality 1:N
Parent table tce_answers
Child table tce_tests_logs_answers
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


rel_group_test (rel_group_test)
General info
Relationship type identifying Cardinality 1:N
Parent table tce_user_groups
Child table tce_testgroups
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


rel_group_user (rel_group_user)
General info
Relationship type identifying Cardinality 1:N
Parent table tce_user_groups
Child table tce_usrgroups
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


rel_module_subjects (rel_module_subjects)
General info
Relationship type non-identifying Cardinality 1:N
Parent table tce_modules
Child table tce_subjects
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


rel_question_answers (rel_question_answers)
General info
Relationship type non-identifying Cardinality 1:N
Parent table tce_questions
Child table tce_answers
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


rel_question_logs (rel_question_logs)
General info
Relationship type non-identifying Cardinality 1:N
Parent table tce_questions
Child table tce_tests_logs
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


rel_set_subjects (rel_set_subjects)
General info
Relationship type identifying Cardinality 1:N
Parent table tce_test_subject_set
Child table tce_test_subjects
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


rel_subject_author (rel_subject_author)
General info
Relationship type non-identifying Cardinality 1:N
Parent table tce_users
Child table tce_subjects
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


rel_subject_questions (rel_subject_questions)
General info
Relationship type non-identifying Cardinality 1:N
Parent table tce_subjects
Child table tce_questions
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


rel_subject_set (rel_subject_set)
General info
Relationship type identifying Cardinality 1:N
Parent table tce_subjects
Child table tce_test_subjects
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


rel_test_author (rel_test_author)
General info
Relationship type non-identifying Cardinality 1:N
Parent table tce_users
Child table tce_tests
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


rel_test_group (rel_test_group)
General info
Relationship type identifying Cardinality 1:N
Parent table tce_tests
Child table tce_testgroups
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


rel_test_subjset (rel_test_subjset)
General info
Relationship type non-identifying Cardinality 1:N
Parent table tce_tests
Child table tce_test_subject_set
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


rel_test_users (rel_test_users)
General info
Relationship type non-identifying Cardinality 1:N
Parent table tce_tests
Child table tce_tests_users
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


rel_testlog_answers (rel_testlog_answers)
General info
Relationship type identifying Cardinality 1:N
Parent table tce_tests_logs
Child table tce_tests_logs_answers
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


rel_testuser_logs (rel_testuser_logs)
General info
Relationship type non-identifying Cardinality 1:N
Parent table tce_tests_users
Child table tce_tests_logs
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


rel_user_group (rel_user_group)
General info
Relationship type identifying Cardinality 1:N
Parent table tce_users
Child table tce_usrgroups
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


rel_user_tests (rel_user_tests)
General info
Relationship type non-identifying Cardinality 1:N
Parent table tce_users
Child table tce_tests_users
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


session_data (session_data)
General info
Relationship type informative Cardinality 1:N
Parent table tce_users
Child table tce_sessions
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