Entity name | tce_answers | ||
Data type | Text | ||
Not null | YES |
Answer description. |
Name | Value |
Attribute Is Array | No |
Array Dimensions | |
Generate Unique as unique Index | No |
Using index tablespace (for Unique) |
Entity name | tce_answers | ||
Data type | Boolean | ||
Not null | YES | ||
Default | '0' |
Indicates when the answer is enabled. The legal values are: FALSE = disabled; TRUE = enabled. |
Name | Value |
Attribute Is Array | No |
Array Dimensions | |
Generate Unique as unique Index | No |
Using index tablespace (for Unique) |
Entity name | tce_answers | ||
Data type | BigSerial | ||
Not null | YES |
This number represents the internal answer unique ID. |
Name | Value |
Attribute Is Array | No |
Array Dimensions | |
Generate Unique as unique Index | No |
Using index tablespace (for Unique) |
Entity name | tce_answers | ||
Data type | Boolean | ||
Not null | YES | ||
Default | '0' |
Indicates when the answer is right. The legal values are: FALSE = wrong answer; TRUE = right answer. |
Name | Value |
Attribute Is Array | No |
Array Dimensions | |
Generate Unique as unique Index | No |
Using index tablespace (for Unique) |
Entity name | tce_answers | ||
Role name | answer_question_id | ||
Data type | Bigint | ||
Not null | YES |
This number represents the internal question unique ID. Indicates to which question this answer belongs. |
Name | Value |
Attribute Is Array | No |
Array Dimensions | |
Generate Unique as unique Index | No |
Using index tablespace (for Unique) |
Entity name | tce_questions | ||
Data type | Text | ||
Not null | YES |
Question description (e.g.: What is a carbonate, and what is it used for?). |
Name | Value |
Attribute Is Array | No |
Array Dimensions | |
Generate Unique as unique Index | No |
Using index tablespace (for Unique) |
Entity name | tce_questions | ||
Data type | Smallint | ||
Not null | YES | ||
Default | 1 |
Integer value representing the difficulty level of the question. This value will be multiplied with test_score_right to obtain the question score. |
Name | Value |
Attribute Is Array | No |
Array Dimensions | |
Generate Unique as unique Index | No |
Using index tablespace (for Unique) |
Entity name | tce_questions | ||
Data type | Boolean | ||
Not null | YES | ||
Default | '0' |
Indicates when the question is enabled. The legal values are: FALSE = disabled; TRUE = enabled. |
Name | Value |
Attribute Is Array | No |
Array Dimensions | |
Generate Unique as unique Index | No |
Using index tablespace (for Unique) |
Entity name | tce_questions | ||
Data type | BigSerial | ||
Not null | YES |
This number represents the internal question unique ID. |
Name | Value |
Attribute Is Array | No |
Array Dimensions | |
Generate Unique as unique Index | No |
Using index tablespace (for Unique) |
Entity name | tce_questions | ||
Data type | Smallint | ||
Not null | YES | ||
Default | 1 |
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). |
Name | Value |
Attribute Is Array | No |
Array Dimensions | |
Generate Unique as unique Index | No |
Using index tablespace (for Unique) |
Entity name | tce_questions | ||
Role name | question_subject_id | ||
Data type | Bigint | ||
Not null | YES |
This number represents the internal subject unique ID. Indicates to which subject this question belongs. |
Name | Value |
Attribute Is Array | No |
Array Dimensions | |
Generate Unique as unique Index | No |
Using index tablespace (for Unique) |
Entity name | tce_sessions | ||
Data type | Text | ||
Not null | YES |
This attribute stores the encoded user's session data. |
Name | Value |
Attribute Is Array | No |
Array Dimensions | |
Generate Unique as unique Index | No |
Using index tablespace (for Unique) |
Entity name | tce_sessions | ||
Data type | Timestamp | ||
Not null | YES |
This attribute stores the last time this session experienced any call activity. |
Name | Value |
Attribute Is Array | No |
Array Dimensions | |
Generate Unique as unique Index | No |
Using index tablespace (for Unique) |
Entity name | tce_sessions | ||
Data type | Varchar(n) (32) | ||
Not null | YES |
This string represents the user's Web session identification (ID). |
Name | Value |
Attribute Is Array | No |
Array Dimensions | |
Generate Unique as unique Index | No |
Using index tablespace (for Unique) |
Entity name | tce_subjects | ||
Data type | Text | ||
Not null | NO |
Subject description. |
Name | Value |
Attribute Is Array | No |
Array Dimensions | |
Generate Unique as unique Index | No |
Using index tablespace (for Unique) |
Entity name | tce_subjects | ||
Data type | Boolean | ||
Not null | YES | ||
Default | '0' |
Indicates when the subject is enabled. The legal values are: FALSE = disabled; TRUE = enabled. |
Name | Value |
Attribute Is Array | No |
Array Dimensions | |
Generate Unique as unique Index | No |
Using index tablespace (for Unique) |
Entity name | tce_subjects | ||
Data type | BigSerial | ||
Not null | YES |
This number represents the internal subject unique ID. |
Name | Value |
Attribute Is Array | No |
Array Dimensions | |
Generate Unique as unique Index | No |
Using index tablespace (for Unique) |
Entity name | tce_subjects | ||
Data type | Varchar(n) (255) | ||
Not null | YES |
Unique name of the subject (e.g.: History I, History II, Geography). |
Name | Value |
Attribute Is Array | No |
Array Dimensions | |
Generate Unique as unique Index | No |
Using index tablespace (for Unique) |
Entity name | tce_subjects | ||
Role name | subject_user_id | ||
Data type | Bigint | ||
Not null | YES | ||
Default | 1 |
Only the administrator and the author of this subject (or his/her group) may update or delete this record. |
Name | Value |
Attribute Is Array | No |
Array Dimensions | |
Generate Unique as unique Index | No |
Using index tablespace (for Unique) |
Entity name | tce_test_subject_set | ||
Role name | tsubset_test_id | ||
Data type | Bigint | ||
Not null | YES |
ID of the test |
Name | Value |
Attribute Is Array | No |
Array Dimensions | |
Generate Unique as unique Index | No |
Using index tablespace (for Unique) |
Entity name | tce_test_subject_set | ||
Data type | Smallint | ||
Not null | YES | ||
Default | 0 |
Number of alternative answers to be selected for the single and multiple questions. |
Name | Value |
Attribute Is Array | No |
Array Dimensions | |
Generate Unique as unique Index | No |
Using index tablespace (for Unique) |
Entity name | tce_test_subject_set | ||
Data type | Smallint | ||
Not null | YES | ||
Default | 1 |
Integer value representing the difficulty level of the question. |
Name | Value |
Attribute Is Array | No |
Array Dimensions | |
Generate Unique as unique Index | No |
Using index tablespace (for Unique) |
Entity name | tce_test_subject_set | ||
Data type | BigSerial | ||
Not null | YES |
Unique ID representing a group of subjects for the specified test. |
Name | Value |
Attribute Is Array | No |
Array Dimensions | |
Generate Unique as unique Index | No |
Using index tablespace (for Unique) |
Entity name | tce_test_subject_set | ||
Data type | Smallint | ||
Not null | YES | ||
Default | 1 |
Maximum number of questions to be selected. |
Name | Value |
Attribute Is Array | No |
Array Dimensions | |
Generate Unique as unique Index | No |
Using index tablespace (for Unique) |
Entity name | tce_test_subject_set | ||
Data type | Smallint | ||
Not null | YES | ||
Default | 1 |
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). |
Name | Value |
Attribute Is Array | No |
Array Dimensions | |
Generate Unique as unique Index | No |
Using index tablespace (for Unique) |
Entity name | tce_test_subjects | ||
Role name | subjset_subject_id | ||
Data type | Bigint | ||
Not null | YES |
This number represents the internal test unique ID. |
Name | Value |
Attribute Is Array | No |
Array Dimensions | |
Generate Unique as unique Index | No |
Using index tablespace (for Unique) |
Entity name | tce_test_subjects | ||
Role name | subjset_tsubset_id | ||
Data type | Bigint | ||
Not null | YES |
Name | Value |
Attribute Is Array | No |
Array Dimensions | |
Generate Unique as unique Index | No |
Using index tablespace (for Unique) |
Entity name | tce_testgroups | ||
Role name | tstgrp_group_id | ||
Data type | Bigint | ||
Not null | YES |
Name | Value |
Attribute Is Array | No |
Array Dimensions | |
Generate Unique as unique Index | No |
Using index tablespace (for Unique) |
Entity name | tce_testgroups | ||
Role name | tstgrp_test_id | ||
Data type | Bigint | ||
Not null | YES |
Name | Value |
Attribute Is Array | No |
Array Dimensions | |
Generate Unique as unique Index | No |
Using index tablespace (for Unique) |
Entity name | tce_tests | ||
Data type | Timestamp | ||
Not null | NO |
Date and time (relative to server clock) after which the test will be active. |
Name | Value |
Attribute Is Array | No |
Array Dimensions | |
Generate Unique as unique Index | No |
Using index tablespace (for Unique) |
Entity name | tce_tests | ||
Data type | Text | ||
Not null | YES |
Test description. |
Name | Value |
Attribute Is Array | No |
Array Dimensions | |
Generate Unique as unique Index | No |
Using index tablespace (for Unique) |
Entity name | tce_tests | ||
Data type | Smallint | ||
Not null | YES | ||
Default | 0 |
Maximum duration of the test in minutes. |
Name | Value |
Attribute Is Array | No |
Array Dimensions | |
Generate Unique as unique Index | No |
Using index tablespace (for Unique) |
Entity name | tce_tests | ||
Data type | Timestamp | ||
Not null | NO |
Date and time (relative to server clock) after which the test will be deactivated. |
Name | Value |
Attribute Is Array | No |
Array Dimensions | |
Generate Unique as unique Index | No |
Using index tablespace (for Unique) |
Entity name | tce_tests | ||
Data type | BigSerial | ||
Not null | YES |
This number represents the internal test unique ID. |
Name | Value |
Attribute Is Array | No |
Array Dimensions | |
Generate Unique as unique Index | No |
Using index tablespace (for Unique) |
Entity name | tce_tests | ||
Data type | Varchar(n) (255) | ||
Not null | YES | ||
Default | '*.*.*.*' |
Enabled IP addresses. |
Name | Value |
Attribute Is Array | No |
Array Dimensions | |
Generate Unique as unique Index | No |
Using index tablespace (for Unique) |
Entity name | tce_tests | ||
Data type | Numeric(p,s) (10,3) | ||
Not null | YES | ||
Default | 0 |
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. |
Name | Value |
Attribute Is Array | No |
Array Dimensions | |
Generate Unique as unique Index | No |
Using index tablespace (for Unique) |
Entity name | tce_tests | ||
Data type | Varchar(n) (255) | ||
Not null | YES |
Unique name of the test (e.g.: History I 2004, Geography 1st class 2005). |
Name | Value |
Attribute Is Array | No |
Array Dimensions | |
Generate Unique as unique Index | No |
Using index tablespace (for Unique) |
Entity name | tce_tests | ||
Data type | Boolean | ||
Not null | YES | ||
Default | '1' |
If true the questions will be selected and sorted randomly for each user. The legal values are: FALSE = disabled; TRUE = enabled. |
Name | Value |
Attribute Is Array | No |
Array Dimensions | |
Generate Unique as unique Index | No |
Using index tablespace (for Unique) |
Entity name | tce_tests | ||
Data type | Boolean | ||
Not null | YES | ||
Default | '0' |
If true enable users to view their test results immediately after finish. The legal values are: FALSE = disabled; TRUE = enabled. |
Name | Value |
Attribute Is Array | No |
Array Dimensions | |
Generate Unique as unique Index | No |
Using index tablespace (for Unique) |
Entity name | tce_tests | ||
Data type | Numeric(p,s) (10,3) | ||
Not null | NO | ||
Default | 0 |
Default score for right answers. This value will be multiplied by question_difficulty value to obtain the question score. |
Name | Value |
Attribute Is Array | No |
Array Dimensions | |
Generate Unique as unique Index | No |
Using index tablespace (for Unique) |
Entity name | tce_tests | ||
Role name | test_user_id | ||
Data type | Bigint | ||
Not null | YES | ||
Default | 1 |
User ID of the author of the test. |
Name | Value |
Attribute Is Array | No |
Array Dimensions | |
Generate Unique as unique Index | No |
Using index tablespace (for Unique) |
Entity name | tce_tests_logs | ||
Role name | testlog_question_id | ||
Data type | Bigint | ||
Not null | YES |
This number represents the internal question unique ID. |
Name | Value |
Attribute Is Array | No |
Array Dimensions | |
Generate Unique as unique Index | No |
Using index tablespace (for Unique) |
Entity name | tce_tests_logs | ||
Data type | Text | ||
Not null | NO |
Text of the answer given by user. |
Name | Value |
Attribute Is Array | No |
Array Dimensions | |
Generate Unique as unique Index | No |
Using index tablespace (for Unique) |
Entity name | tce_tests_logs | ||
Data type | Timestamp | ||
Not null | NO |
Date and time (relative to server clock) indicating when the last answer has been set. |
Name | Value |
Attribute Is Array | No |
Array Dimensions | |
Generate Unique as unique Index | No |
Using index tablespace (for Unique) |
Entity name | tce_tests_logs | ||
Data type | Timestamp | ||
Not null | NO |
Date and time (relative to server clock) indicating when the question (tuple) has been generated. |
Name | Value |
Attribute Is Array | No |
Array Dimensions | |
Generate Unique as unique Index | No |
Using index tablespace (for Unique) |
Entity name | tce_tests_logs | ||
Data type | Timestamp | ||
Not null | NO |
Date and time (relative to server clock) indicating when the question has been displayed to the user for the first time. |
Name | Value |
Attribute Is Array | No |
Array Dimensions | |
Generate Unique as unique Index | No |
Using index tablespace (for Unique) |
Entity name | tce_tests_logs | ||
Data type | BigSerial | ||
Not null | YES |
This number represents the internal test-log unique ID. |
Name | Value |
Attribute Is Array | No |
Array Dimensions | |
Generate Unique as unique Index | No |
Using index tablespace (for Unique) |
Entity name | tce_tests_logs | ||
Data type | Numeric(p,s) (10,3) | ||
Not null | NO |
Total score gained by the user for this question. |
Name | Value |
Attribute Is Array | No |
Array Dimensions | |
Generate Unique as unique Index | No |
Using index tablespace (for Unique) |
Entity name | tce_tests_logs | ||
Data type | Varchar(n) (15) | ||
Not null | NO |
IP address of the client computer from where the aswer has been received. |
Name | Value |
Attribute Is Array | No |
Array Dimensions | |
Generate Unique as unique Index | No |
Using index tablespace (for Unique) |
Entity name | tce_tests_logs | ||
Role name | testlog_testuser_id | ||
Data type | Bigint | ||
Not null | YES |
This number represents the internal test-user unique ID. |
Name | Value |
Attribute Is Array | No |
Array Dimensions | |
Generate Unique as unique Index | No |
Using index tablespace (for Unique) |
Entity name | tce_tests_logs_answers | ||
Role name | logansw_answer_id | ||
Data type | Bigint | ||
Not null | YES |
This number represents the internal answer unique ID. |
Name | Value |
Attribute Is Array | No |
Array Dimensions | |
Generate Unique as unique Index | No |
Using index tablespace (for Unique) |
Entity name | tce_tests_logs_answers | ||
Data type | Smallint | ||
Not null | YES | ||
Default | 1 |
Order of the answer inside the question |
Name | Value |
Attribute Is Array | No |
Array Dimensions | |
Generate Unique as unique Index | No |
Using index tablespace (for Unique) |
Entity name | tce_tests_logs_answers | ||
Data type | Boolean | ||
Not null | YES | ||
Default | '0' |
Indicates when this alternative answer has been selected by user. The legal values are: FALSE = not selected; TRUE = selected. |
Name | Value |
Attribute Is Array | No |
Array Dimensions | |
Generate Unique as unique Index | No |
Using index tablespace (for Unique) |
Entity name | tce_tests_logs_answers | ||
Role name | logansw_testlog_id | ||
Data type | Bigint | ||
Not null | YES |
This number represents the internal test-log unique ID. |
Name | Value |
Attribute Is Array | No |
Array Dimensions | |
Generate Unique as unique Index | No |
Using index tablespace (for Unique) |
Entity name | tce_tests_users | ||
Role name | testuser_test_id | ||
Data type | Bigint | ||
Not null | YES |
This number represents the internal test unique ID. Indicates the test type selected by the user. |
Name | Value |
Attribute Is Array | No |
Array Dimensions | |
Generate Unique as unique Index | No |
Using index tablespace (for Unique) |
Entity name | tce_tests_users | ||
Data type | Text | ||
Not null | NO |
User's optional comment about the test. |
Name | Value |
Attribute Is Array | No |
Array Dimensions | |
Generate Unique as unique Index | No |
Using index tablespace (for Unique) |
Entity name | tce_tests_users | ||
Data type | Timestamp | ||
Not null | YES |
Date and time (relative to server clock) indicating the end of the test creation process. |
Name | Value |
Attribute Is Array | No |
Array Dimensions | |
Generate Unique as unique Index | No |
Using index tablespace (for Unique) |
Entity name | tce_tests_users | ||
Data type | BigSerial | ||
Not null | YES |
This number represents the internal user-test unique ID. |
Name | Value |
Attribute Is Array | No |
Array Dimensions | |
Generate Unique as unique Index | No |
Using index tablespace (for Unique) |
Entity name | tce_tests_users | ||
Data type | Smallint | ||
Not null | YES | ||
Default | 0 | ||
Check | testuser_status IN (0,1,2,3,4) |
Numeric code that indicates the user-test status. |
Name | Value |
Attribute Is Array | No |
Array Dimensions | |
Generate Unique as unique Index | No |
Using index tablespace (for Unique) |
Entity name | tce_tests_users | ||
Role name | testuser_user_id | ||
Data type | Bigint | ||
Not null | YES |
This number represents the internal user's identification (ID). Indicates to which user the test belongs. |
Name | Value |
Attribute Is Array | No |
Array Dimensions | |
Generate Unique as unique Index | No |
Using index tablespace (for Unique) |
Entity name | tce_user_groups | ||
Data type | BigSerial | ||
Not null | YES |
This number represents the internal group identification (ID). |
Name | Value |
Attribute Is Array | No |
Array Dimensions | |
Generate Unique as unique Index | No |
Using index tablespace (for Unique) |
Entity name | tce_user_groups | ||
Data type | Varchar(n) (255) | ||
Not null | YES | ||
Unique | YES |
Unique name of this group. |
Name | Value |
Attribute Is Array | No |
Array Dimensions | |
Generate Unique as unique Index | No |
Using index tablespace (for Unique) |
Entity name | tce_users | ||
Data type | Date | ||
Not null | NO |
Date of birth, year month and day on which user was born. |
Name | Value |
Attribute Is Array | No |
Array Dimensions | |
Generate Unique as unique Index | No |
Using index tablespace (for Unique) |
Entity name | tce_users | ||
Data type | Varchar(n) (255) | ||
Not null | NO |
User's place of birth (city or country). |
Name | Value |
Attribute Is Array | No |
Array Dimensions | |
Generate Unique as unique Index | No |
Using index tablespace (for Unique) |
Entity name | tce_users | ||
Data type | Varchar(n) (255) | ||
Not null | NO |
User's email address (e.g.: name@domain.com). |
Name | Value |
Attribute Is Array | No |
Array Dimensions | |
Generate Unique as unique Index | No |
Using index tablespace (for Unique) |
Entity name | tce_users | ||
Data type | Varchar(n) (255) | ||
Not null | NO |
User's real first name (e.g.: Albert, Maria). |
Name | Value |
Attribute Is Array | No |
Array Dimensions | |
Generate Unique as unique Index | No |
Using index tablespace (for Unique) |
Entity name | tce_users | ||
Data type | BigSerial | ||
Not null | YES |
This number represents the internal user's identification (ID). |
Name | Value |
Attribute Is Array | No |
Array Dimensions | |
Generate Unique as unique Index | No |
Using index tablespace (for Unique) |
Entity name | tce_users | ||
Data type | Varchar(n) (15) | ||
Not null | YES |
IP address of the client computer from where the user's registration request has been received. |
Name | Value |
Attribute Is Array | No |
Array Dimensions | |
Generate Unique as unique Index | No |
Using index tablespace (for Unique) |
Entity name | tce_users | ||
Data type | Varchar(n) (255) | ||
Not null | NO |
User's real last name, family name, surname (e.g.: Smith, Einstein). |
Name | Value |
Attribute Is Array | No |
Array Dimensions | |
Generate Unique as unique Index | No |
Using index tablespace (for Unique) |
Entity name | tce_users | ||
Data type | Smallint | ||
Not null | YES | ||
Default | 1 |
The user's level is a numeric value that indicates which resources (pages, modules, services) are accessible by the user. |
Name | Value |
Attribute Is Array | No |
Array Dimensions | |
Generate Unique as unique Index | No |
Using index tablespace (for Unique) |
Entity name | tce_users | ||
Data type | Varchar(n) (255) | ||
Not null | YES |
Username, unique name by which a user is identified when accessing a multi-user system. |
Name | Value |
Attribute Is Array | No |
Array Dimensions | |
Generate Unique as unique Index | No |
Using index tablespace (for Unique) |
Entity name | tce_users | ||
Data type | Varchar(n) (255) | ||
Not null | YES |
Password, keyword, code word, alphanumeric code that together with the username is used to gain access to this system. |
Name | Value |
Attribute Is Array | No |
Array Dimensions | |
Generate Unique as unique Index | No |
Using index tablespace (for Unique) |
Entity name | tce_users | ||
Data type | Timestamp | ||
Not null | YES |
User registration date and time relative to server clock. |
Name | Value |
Attribute Is Array | No |
Array Dimensions | |
Generate Unique as unique Index | No |
Using index tablespace (for Unique) |
Entity name | tce_users | ||
Data type | Varchar(n) (255) | ||
Not null | NO |
Unique user's registration number (e.g.: school registration number). |
Name | Value |
Attribute Is Array | No |
Array Dimensions | |
Generate Unique as unique Index | No |
Using index tablespace (for Unique) |
Entity name | tce_users | ||
Data type | Varchar(n) (255) | ||
Not null | NO |
User's Social Security number (SSN) or other equivalent unique code (e.g.: Codice Fiscale for Italian users) |
Name | Value |
Attribute Is Array | No |
Array Dimensions | |
Generate Unique as unique Index | No |
Using index tablespace (for Unique) |
Entity name | tce_users | ||
Data type | Varchar(n) (32) | ||
Not null | NO | ||
Unique | YES |
Unique code used to verify user's email during remote registration process. |
Name | Value |
Attribute Is Array | No |
Array Dimensions | |
Generate Unique as unique Index | No |
Using index tablespace (for Unique) |
Entity name | tce_usrgroups | ||
Role name | usrgrp_group_id | ||
Data type | Bigint | ||
Not null | YES |
This number represents the internal group unique ID. |
Name | Value |
Attribute Is Array | No |
Array Dimensions | |
Generate Unique as unique Index | No |
Using index tablespace (for Unique) |
Entity name | tce_usrgroups | ||
Role name | usrgrp_user_id | ||
Data type | Bigint | ||
Not null | YES |
This number represents the internal user unique ID. |
Name | Value |
Attribute Is Array | No |
Array Dimensions | |
Generate Unique as unique Index | No |
Using index tablespace (for Unique) |