Entity type: | independent |
Key | Attribute/role name | Data type | Not null | Unique | Description | |
PK | answer_id | BigSerial | YES | NO | This number represents the internal answer unique ID. | |
FK | question_id/answer_question_id | Bigint | YES | NO | This number represents the internal question unique ID. Indicates to which question this answer belongs. | |
answer_description | Text | YES | NO | Answer description. | ||
answer_isright | Boolean | YES | NO | Indicates when the answer is right. The legal values are: FALSE = wrong answer; TRUE = right answer. | ||
answer_enabled | Boolean | YES | NO | Indicates when the answer is enabled. The legal values are: FALSE = disabled; TRUE = enabled. |
Relationship name | Type | Parent entity | Child entity | Card. |
rel_question_answers | Non-identifying | tce_questions | tce_answers | 1:N |
rel_answer_logs | Identifying | tce_answers | tce_tests_logs_answers | 1:N |
Name | Attributes |
ak_answer | question_id, answer_description |
This table contains all answers relative to a specific questions. |
Name | Value |
Temporary Table | No |
Inherited Tables | |
Without OIDs | Yes |
Schema | |
Tablespace | |
Using index tablespace (for Primary key) |
Entity type: | independent |
Key | Attribute/role name | Data type | Not null | Unique | Description | |
PK | question_id | BigSerial | YES | NO | This number represents the internal question unique ID. | |
FK | subject_id/question_subject_id | Bigint | YES | NO | This number represents the internal subject unique ID. Indicates to which subject this question belongs. | |
question_description | Text | YES | NO | Question description (e.g.: What is a carbonate, and what is it used for?). | ||
question_type | Smallint | YES | NO | Indicates the type of question: 1 = single [radiobutton] (only one answer is right); 2 = multiple [checkbox] (more than one answer may be right); 3 = free-answer [textarea] (the user introduces the answer using keyboard). | ||
question_difficulty | Smallint | YES | NO | Integer value representing the difficulty level of the question. This value will be multiplied with test_score_right to obtain the question score. | ||
question_enabled | Boolean | YES | NO | Indicates when the question is enabled. The legal values are: FALSE = disabled; TRUE = enabled. |
Relationship name | Type | Parent entity | Child entity | Card. |
rel_subject_questions | Non-identifying | tce_subjects | tce_questions | 1:N |
rel_question_answers | Non-identifying | tce_questions | tce_answers | 1:N |
rel_question_logs | Non-identifying | tce_questions | tce_tests_logs | 1:N |
Name | Attributes |
ak_question | subject_id, question_description |
This table contains all questions relative to specific subjects. |
Name | Value |
Temporary Table | No |
Inherited Tables | |
Without OIDs | Yes |
Schema | |
Tablespace | |
Using index tablespace (for Primary key) |
Entity type: | independent |
Key | Attribute/role name | Data type | Not null | Unique | Description | |
PK | cpsession_id | Varchar(n) (32) | YES | NO | This string represents the user's Web session identification (ID). | |
cpsession_expiry | Timestamp | YES | NO | This attribute stores the last time this session experienced any call activity. | ||
cpsession_data | Text | YES | NO | This attribute stores the encoded user's session data. |
Relationship name | Type | Parent entity | Child entity | Card. |
session_data | Informative | tce_users | tce_sessions | 1:N |
This table stores information about users' Web sessions. |
Name | Value |
Temporary Table | No |
Inherited Tables | |
Without OIDs | Yes |
Schema | |
Tablespace | |
Using index tablespace (for Primary key) |
Entity type: | independent |
Key | Attribute/role name | Data type | Not null | Unique | Description | |
PK | subject_id | BigSerial | YES | NO | This number represents the internal subject unique ID. | |
subject_name | Varchar(n) (255) | YES | NO | Unique name of the subject (e.g.: History I, History II, Geography). | ||
subject_description | Text | NO | NO | Subject description. | ||
subject_enabled | Boolean | YES | NO | Indicates when the subject is enabled. The legal values are: FALSE = disabled; TRUE = enabled. | ||
FK | user_id/subject_user_id | Bigint | YES | NO | Only the administrator and the author of this subject (or his/her group) may update or delete this record. |
Relationship name | Type | Parent entity | Child entity | Card. |
rel_subject_questions | Non-identifying | tce_subjects | tce_questions | 1:N |
rel_subject_set | Identifying | tce_subjects | tce_test_subjects | 1:N |
rel_subject_author | Non-identifying | tce_users | tce_subjects | 1:N |
Name | Attributes |
ak_subject_name | subject_name |
This table contains all tests subjects (topics, branch of studies). |
Name | Value |
Temporary Table | No |
Inherited Tables | |
Without OIDs | Yes |
Schema | |
Tablespace | |
Using index tablespace (for Primary key) |
Entity type: | independent |
Key | Attribute/role name | Data type | Not null | Unique | Description | |
PK | tsubset_id | BigSerial | YES | NO | Unique ID representing a group of subjects for the specified test. | |
FK | test_id/tsubset_test_id | Bigint | YES | NO | ID of the test | |
tsubset_type | Smallint | YES | NO | Indicates the type of question: 1 = MCSA - single [radiobutton] (only one answer is right); 2 = MCMA - multiple [checkbox] (more than one answer may be right); 3 = free-answer [textarea] (the user introduces the answer using keyboard). | ||
tsubset_difficulty | Smallint | YES | NO | Integer value representing the difficulty level of the question. | ||
tsubset_quantity | Smallint | YES | NO | Maximum number of questions to be selected. | ||
tsubset_answers | Smallint | YES | NO | Number of alternative answers to be selected for the single and multiple questions. |
Relationship name | Type | Parent entity | Child entity | Card. |
rel_test_subjset | Non-identifying | tce_tests | tce_test_subject_set | 1:N |
rel_set_subjects | Identifying | tce_test_subject_set | tce_test_subjects | 1:N |
This table lists the type and quantity of the questions associated to each set of subjects selected for a particular test. |
Name | Value |
Temporary Table | No |
Inherited Tables | |
Without OIDs | No |
Schema | |
Tablespace | |
Using index tablespace (for Primary key) |
Entity type: | dependent |
Key | Attribute/role name | Data type | Not null | Unique | Description | |
PFK | tsubset_id/subjset_tsubset_id | Bigint | YES | NO | ||
PFK | subject_id/subjset_subject_id | Bigint | YES | NO | This number represents the internal test unique ID. |
Relationship name | Type | Parent entity | Child entity | Card. |
rel_subject_set | Identifying | tce_subjects | tce_test_subjects | 1:N |
rel_set_subjects | Identifying | tce_test_subject_set | tce_test_subjects | 1:N |
This table contains the list of subjects for each subject set relative to the selected test. |
Name | Value |
Temporary Table | No |
Inherited Tables | |
Without OIDs | Yes |
Schema | |
Tablespace | |
Using index tablespace (for Primary key) |
Entity type: | dependent |
Key | Attribute/role name | Data type | Not null | Unique | ||
PFK | test_id/tstgrp_test_id | Bigint | YES | NO | ||
PFK | group_id/tstgrp_group_id | Bigint | YES | NO |
Relationship name | Type | Parent entity | Child entity | Card. |
rel_test_group | Identifying | tce_tests | tce_testgroups | 1:N |
rel_group_test | Identifying | tce_user_groups | tce_testgroups | 1:N |
Name | Value |
Temporary Table | No |
Inherited Tables | |
Without OIDs | No |
Schema | |
Tablespace | |
Using index tablespace (for Primary key) |
Entity type: | independent |
Key | Attribute/role name | Data type | Not null | Unique | Description | |
PK | test_id | BigSerial | YES | NO | This number represents the internal test unique ID. | |
test_name | Varchar(n) (255) | YES | NO | Unique name of the test (e.g.: History I 2004, Geography 1st class 2005). | ||
test_description | Text | YES | NO | Test description. | ||
test_begin_time | Timestamp | NO | NO | Date and time (relative to server clock) after which the test will be active. | ||
test_end_time | Timestamp | NO | NO | Date and time (relative to server clock) after which the test will be deactivated. | ||
test_duration_time | Smallint | YES | NO | Maximum duration of the test in minutes. | ||
test_ip_range | Varchar(n) (255) | YES | NO | Enabled IP addresses. | ||
test_random_questions | Boolean | YES | NO | If true the questions will be selected and sorted randomly for each user. The legal values are: FALSE = disabled; TRUE = enabled. | ||
test_results_to_users | Boolean | YES | NO | If true enable users to view their test results immediately after finish. The legal values are: FALSE = disabled; TRUE = enabled. | ||
test_score_right | Numeric(p,s) (10,3) | NO | NO | Default score for right answers. This value will be multiplied by question_difficulty value to obtain the question score. | ||
test_max_score | Numeric(p,s) (10,3) | YES | NO | Maximum score that could be reached with this test. This value could be calculated using the related tables and it's saved for statistical purposes. | ||
FK | user_id/test_user_id | Bigint | YES | NO | User ID of the author of the test. |
Relationship name | Type | Parent entity | Child entity | Card. |
rel_test_users | Non-identifying | tce_tests | tce_tests_users | 1:N |
rel_test_author | Non-identifying | tce_users | tce_tests | 1:N |
rel_test_group | Identifying | tce_tests | tce_testgroups | 1:N |
rel_test_subjset | Non-identifying | tce_tests | tce_test_subject_set | 1:N |
Name | Attributes |
ak_test_name | test_name |
This table contains all tests data. |
Name | Value |
Temporary Table | No |
Inherited Tables | |
Without OIDs | Yes |
Schema | |
Tablespace | |
Using index tablespace (for Primary key) |
Entity type: | independent |
Key | Attribute/role name | Data type | Not null | Unique | Description | |
PK | testlog_id | BigSerial | YES | NO | This number represents the internal test-log unique ID. | |
FK | testuser_id/testlog_testuser_id | Bigint | YES | NO | This number represents the internal test-user unique ID. | |
testlog_user_ip | Varchar(n) (15) | NO | NO | IP address of the client computer from where the aswer has been received. | ||
FK | question_id/testlog_question_id | Bigint | YES | NO | This number represents the internal question unique ID. | |
testlog_answer_text | Text | NO | NO | Text of the answer given by user. | ||
testlog_score | Numeric(p,s) (10,3) | NO | NO | Total score gained by the user for this question. | ||
testlog_creation_time | Timestamp | NO | NO | Date and time (relative to server clock) indicating when the question (tuple) has been generated. | ||
testlog_display_time | Timestamp | NO | NO | Date and time (relative to server clock) indicating when the question has been displayed to the user for the first time. | ||
testlog_change_time | Timestamp | NO | NO | Date and time (relative to server clock) indicating when the last answer has been set. |
Relationship name | Type | Parent entity | Child entity | Card. |
rel_question_logs | Non-identifying | tce_questions | tce_tests_logs | 1:N |
rel_testuser_logs | Non-identifying | tce_tests_users | tce_tests_logs | 1:N |
rel_testlog_answers | Identifying | tce_tests_logs | tce_tests_logs_answers | 1:N |
Name | Attributes |
ak_testuser_question | testuser_id, question_id |
This table contains all questions and user answers relative to a specific test for a specific user. |
Name | Value |
Temporary Table | No |
Inherited Tables | |
Without OIDs | Yes |
Schema | |
Tablespace | |
Using index tablespace (for Primary key) |
Entity type: | dependent |
Key | Attribute/role name | Data type | Not null | Unique | Description | |
PFK | testlog_id/logansw_testlog_id | Bigint | YES | NO | This number represents the internal test-log unique ID. | |
PFK | answer_id/logansw_answer_id | Bigint | YES | NO | This number represents the internal answer unique ID. | |
logansw_selected | Boolean | YES | NO | Indicates when this alternative answer has been selected by user. The legal values are: FALSE = not selected; TRUE = selected. | ||
logansw_order | Smallint | YES | NO | Order of the answer inside the question |
Relationship name | Type | Parent entity | Child entity | Card. |
rel_answer_logs | Identifying | tce_answers | tce_tests_logs_answers | 1:N |
rel_testlog_answers | Identifying | tce_tests_logs | tce_tests_logs_answers | 1:N |
This table contains the list of the selected alternative answers for each multiple-choice question. |
Name | Value |
Temporary Table | No |
Inherited Tables | |
Without OIDs | Yes |
Schema | |
Tablespace | |
Using index tablespace (for Primary key) |
Entity type: | independent |
Key | Attribute/role name | Data type | Not null | Unique | Description | |
PK | testuser_id | BigSerial | YES | NO | This number represents the internal user-test unique ID. | |
FK | test_id/testuser_test_id | Bigint | YES | NO | This number represents the internal test unique ID. Indicates the test type selected by the user. | |
FK | user_id/testuser_user_id | Bigint | YES | NO | This number represents the internal user's identification (ID). Indicates to which user the test belongs. | |
testuser_status | Smallint | YES | NO | Numeric code that indicates the user-test status. | ||
testuser_creation_time | Timestamp | YES | NO | Date and time (relative to server clock) indicating the end of the test creation process. | ||
testuser_comment | Text | NO | NO | User's optional comment about the test. |
Relationship name | Type | Parent entity | Child entity | Card. |
rel_user_tests | Non-identifying | tce_users | tce_tests_users | 1:N |
rel_test_users | Non-identifying | tce_tests | tce_tests_users | 1:N |
rel_testuser_logs | Non-identifying | tce_tests_users | tce_tests_logs | 1:N |
Name | Attributes |
ak_testuser | test_id, user_id |
This table contains the list of tests generated for each user. |
Name | Value |
Temporary Table | No |
Inherited Tables | |
Without OIDs | Yes |
Schema | |
Tablespace | |
Using index tablespace (for Primary key) |
Entity type: | independent |
Key | Attribute/role name | Data type | Not null | Unique | Description | |
PK | group_id | BigSerial | YES | NO | This number represents the internal group identification (ID). | |
group_name | Varchar(n) (255) | YES | YES | Unique name of this group. |
Relationship name | Type | Parent entity | Child entity | Card. |
rel_group_user | Identifying | tce_user_groups | tce_usrgroups | 1:N |
rel_group_test | Identifying | tce_user_groups | tce_testgroups | 1:N |
Users' groups. Each user belongs to one of the groups defined in this table. |
Name | Value |
Temporary Table | No |
Inherited Tables | |
Without OIDs | No |
Schema | |
Tablespace | |
Using index tablespace (for Primary key) |
Entity type: | independent |
Key | Attribute/role name | Data type | Not null | Unique | Description | |
PK | user_id | BigSerial | YES | NO | This number represents the internal user's identification (ID). | |
user_name | Varchar(n) (255) | YES | NO | Username, unique name by which a user is identified when accessing a multi-user system. | ||
user_password | Varchar(n) (255) | YES | NO | Password, keyword, code word, alphanumeric code that together with the username is used to gain access to this system. | ||
user_email | Varchar(n) (255) | NO | NO | User's email address (e.g.: name@domain.com). | ||
user_regdate | Timestamp | YES | NO | User registration date and time relative to server clock. | ||
user_ip | Varchar(n) (15) | YES | NO | IP address of the client computer from where the user's registration request has been received. | ||
user_firstname | Varchar(n) (255) | NO | NO | User's real first name (e.g.: Albert, Maria). | ||
user_lastname | Varchar(n) (255) | NO | NO | User's real last name, family name, surname (e.g.: Smith, Einstein). | ||
user_birthdate | Date | NO | NO | Date of birth, year month and day on which user was born. | ||
user_birthplace | Varchar(n) (255) | NO | NO | User's place of birth (city or country). | ||
user_regnumber | Varchar(n) (255) | NO | NO | Unique user's registration number (e.g.: school registration number). | ||
user_ssn | Varchar(n) (255) | NO | NO | User's Social Security number (SSN) or other equivalent unique code (e.g.: Codice Fiscale for Italian users) | ||
user_level | Smallint | YES | NO | The user's level is a numeric value that indicates which resources (pages, modules, services) are accessible by the user. | ||
user_verifycode | Varchar(n) (32) | NO | YES | Unique code used to verify user's email during remote registration process. |
Relationship name | Type | Parent entity | Child entity | Card. |
rel_user_tests | Non-identifying | tce_users | tce_tests_users | 1:N |
session_data | Informative | tce_users | tce_sessions | 1:N |
rel_test_author | Non-identifying | tce_users | tce_tests | 1:N |
rel_subject_author | Non-identifying | tce_users | tce_subjects | 1:N |
rel_user_group | Identifying | tce_users | tce_usrgroups | 1:N |
Name | Attributes |
ak_user_name | user_name |
ak_user_regnumber | user_regnumber |
ak_user_ssn | user_ssn |
This table contains all registered users' data, including system administrators and a special 'anonymous' user. |
Name | Value |
Temporary Table | No |
Inherited Tables | |
Without OIDs | Yes |
Schema | |
Tablespace | |
Using index tablespace (for Primary key) |
Entity type: | dependent |
Key | Attribute/role name | Data type | Not null | Unique | Description | |
PFK | user_id/usrgrp_user_id | Bigint | YES | NO | This number represents the internal user unique ID. | |
PFK | group_id/usrgrp_group_id | Bigint | YES | NO | This number represents the internal group unique ID. |
Relationship name | Type | Parent entity | Child entity | Card. |
rel_user_group | Identifying | tce_users | tce_usrgroups | 1:N |
rel_group_user | Identifying | tce_user_groups | tce_usrgroups | 1:N |
This table contains the list of groups to whom each user belongs. |
Name | Value |
Temporary Table | No |
Inherited Tables | |
Without OIDs | No |
Schema | |
Tablespace | |
Using index tablespace (for Primary key) |