Entity name | tce_answers | ||
Data type | Text | ||
Not null | YES |
Answer description. |
This text may contain special markup tags for formatting and image linking. |
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. |
Only enabled answers may be evaluated during test generation for a specific user. |
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 | ||
Data type | Bigint | ||
Not null | NO |
Keyboard key used to select this answer. NULL = no key. |
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 | Bigint | ||
Not null | NO |
Indicates the right answer order. |
This field can be used for ordering questions or for specify the appearance order of answers. This order is used when test_random_answers_select and test_random_answers_order are both set to false. |
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_modules | ||
Data type | Char (20) | ||
Not null | YES | ||
Default | '0' |
The legal values are: FALSE = disabled; TRUE = enabled. |
Only enabled modules can be used for a new test. |
Name | Value |
Attribute Is Array | No |
Array Dimensions | |
Generate Unique as unique Index | No |
Using index tablespace (for Unique) |
Entity name | tce_modules | ||
Data type | BigSerial | ||
Not null | YES |
This number represents the internal module unique ID. |
Name | Value |
Attribute Is Array | No |
Array Dimensions | |
Generate Unique as unique Index | No |
Using index tablespace (for Unique) |
Entity name | tce_modules | ||
Data type | Varchar(n) (255) | ||
Not null | YES | ||
Unique | YES |
Unique name for the module. |
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 | NO | ||
Default | '0' |
If TRUE automatically moves on next question when a MCSA answer is selected. |
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?). |
This text may contain special markup tags for formatting and image linking. |
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. |
Higher values represent questions with an high grade of difficulty. |
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. |
Only enabled questions may be evaluated during test generation for a specific user. |
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' |
If true diplay the question using the full screen area. |
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 | Boolean | ||
Not null | YES | ||
Default | '0' |
If TRUE display answers one next each other instead of vertical list layout. |
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 | Bigint | ||
Not null | NO |
Indicates the right question appearance order. |
This order is used when test_random_questions_select and test_random_questions_order are both set to false. |
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 | NO |
Maximum visualization time 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_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); 4 = answers odering. |
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. |
In PHP this information may be encoded/decoded using the session_encode/session_decode functions. |
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. |
This information is used to close the user's session automatically, if there has been no session-related activity for the prescribed amount of time. |
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). |
Session IDs are identification tokens for users, and servers can use them to maintain session data (e.g., variables) for creating a session-like experience to the users. |
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_module_id | ||
Data type | Bigint | ||
Not null | YES | ||
Default | 1 |
This number represents the internal module unique ID. Indicates to which module this subject belongs. |
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. |
This text may contain special markup tags for formatting and image linking. |
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. |
Only enabled subjects can be used for a new test. |
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 | Boolean | ||
Not null | YES | ||
Default | '1' |
If true enable test comment: the user may leave a general test comment on a textarea. 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 | Text | ||
Not null | YES |
Test description. |
This text may contain special markup tags for formatting and image linking. |
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. |
Once started, the test will have to be completed within the specified amount of time. |
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. |
This attribute may contain a comma-separated list of the different IP addresses of the client computers entitled to perform the test. An IP address can also contain wildcards (* = any number), (e.g.: 192.168.1.*, 192.168.2.*). |
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 | Boolean | ||
Not null | YES | ||
Default | '1' |
If true uses radiobuttons instead of checkboxes for MCMA questions. 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 | '1' |
If true enables the navigation menu for questions during test execution. 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 | 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 enable the 'no-answe' option on available answers. 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 | '1' |
If true the answers will be ordered randomly for each question. 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 | '1' |
If true the answers will be selected randomly for each question. 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 | '1' |
If true the questions will be ordered 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 | '1' |
If true the questions will be selected 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 | NO | ||
Default | '0' |
If true enable users to view a detailed report on executed tests. |
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 | ||
Data type | Numeric(p,s) (10,3) | ||
Not null | NO | ||
Default | 0 |
Minimum score required to pass the exam. |
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 |
Score to be assigned to the unanswered questions. 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 | ||
Data type | Numeric(p,s) (10,3) | ||
Not null | NO |
Score to be assigned to the wrong 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. |
Only the administrator and the author of the test (or his/her group) may update/delete 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. |
This will be set only if the question is free-answer type. |
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 | Text | ||
Not null | NO |
Teacher or Supervisor comment to 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 | ||
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 | Smallint | ||
Not null | YES | ||
Default | 0 |
Number of alternative answers associated to 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 | Smallint | ||
Not null | YES | ||
Default | 1 |
Display order of the questions. |
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 | Bigint | ||
Not null | NO | ||
Default | 0 |
Time (milliseconds) elapsed between question visualisation and user's answer. |
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. |
This score may be automatically calculated in case of multiple-choice question, otherwise may be manually 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 | 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 |
Presentation order of the answer inside the question |
This avoid an automatic ordering problem that happens in MySQL |
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 | Bigint | ||
Not null | NO |
User's selected order for this answer. |
This field is used only for ordering questions. |
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 |
Indicate the user's answer. Legal values are: -1 = no answer; 0 = false or not selected; 1 = true or selecte |
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. |
TCExam legal values are: 0 = the test generation process is started but not completed; 1 = the test has been successfully created; 2 = all questions have been displayed to the user; 3 = all questions have been answered; 4 = test locked (for timeout); |
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. |
To gain access to a specific resource, the user's level must be equal or greater to the one specified for the requested resource. TCExam has 10 predefined user's levels: 0 = anonymous user (not registered). 1 = basic user (registered); 2-9 = configurable/custom levels; 10 = administrator with full access rights |
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. |
Passwords are encrypted by a one way algorithm (MD5). |
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) |