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_author'
General info

Relationship type | non-identifying | Cardinality | 1:N
Parent entity | tce_users
Child entity | tce_modules

Partiality

Parent | mandatory
Child | optional

Referential integrity

| Insert | Update | Delete
Parent | ---- | NONE | CASCADE
Child | NONE | NONE | ----

Keys

Parent key | Child key
module_id | module_user_id

Description

This module can be edited by the administrator, the author of this module and the users belonging to the same group of the author.

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
module_id | subject_user_id

Description

This subject can be edited by the administrator, the author of this subject and the users belonging to the same group of the author.

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
module_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
module_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
module_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
module_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