tce_answers.answer_description
General info
Entity name tce_answers
Data type Text
Not null YES
Description
Answer description.
Notes
This text may contain special markup tags for formatting and image linking.
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_answers.answer_enabled
General info
Entity name tce_answers
Data type Boolean
Not null YES
Default '0'
Description
Indicates when the answer is enabled.
The legal values are:
FALSE = disabled;
TRUE = enabled.
Notes
Only enabled answers may be evaluated during test generation for a specific user.
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_answers.answer_id
General info
Entity name tce_answers
Data type BigSerial
Not null YES
Description
This number represents the internal answer unique ID.
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_answers.answer_isright
General info
Entity name tce_answers
Data type Boolean
Not null YES
Default '0'
Description
Indicates when the answer is right.
The legal values are:
FALSE = wrong answer;
TRUE = right answer.
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_answers.answer_keyboard_key
General info
Entity name tce_answers
Data type Bigint
Not null NO
Description
Keyboard key used to select this answer.
NULL = no key.
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_answers.answer_position
General info
Entity name tce_answers
Data type Bigint
Not null NO
Description
Indicates the right answer order.
Notes
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.
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_answers.question_id
General info
Entity name tce_answers
Role name answer_question_id
Data type Bigint
Not null YES
Description
This number represents the internal question unique ID.
Indicates to which question this answer belongs.
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_modules.module_enabled
General info
Entity name tce_modules
Data type Char (20)
Not null YES
Default '0'
Description
The legal values are:
FALSE = disabled;
TRUE = enabled.
Notes
Only enabled modules can be used for a new test.
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_modules.module_id
General info
Entity name tce_modules
Data type BigSerial
Not null YES
Description
This number represents the internal module unique ID.
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_modules.module_name
General info
Entity name tce_modules
Data type Varchar(n) (255)
Not null YES
Unique YES
Description
Unique name for the module.
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_questions.question_auto_next
General info
Entity name tce_questions
Data type Boolean
Not null NO
Default '0'
Description
If TRUE automatically moves on next question when a MCSA answer is selected.
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_questions.question_description
General info
Entity name tce_questions
Data type Text
Not null YES
Description
Question description (e.g.: What is a carbonate, and what is it used for?).
Notes
This text may contain special markup tags for formatting and image linking.
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_questions.question_difficulty
General info
Entity name tce_questions
Data type Smallint
Not null YES
Default 1
Description
Integer value representing the difficulty level of the question.
This value will be multiplied with test_score_right to obtain the question score.
Notes
Higher values represent questions with an high grade of difficulty.
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_questions.question_enabled
General info
Entity name tce_questions
Data type Boolean
Not null YES
Default '0'
Description
Indicates when the question is enabled.
The legal values are:
FALSE = disabled;
TRUE = enabled.
Notes
Only enabled questions may be evaluated during test generation for a specific user.
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_questions.question_fullscreen
General info
Entity name tce_questions
Data type Boolean
Not null YES
Default '0'
Description
If true diplay the question using the full screen area.
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_questions.question_id
General info
Entity name tce_questions
Data type BigSerial
Not null YES
Description
This number represents the internal question unique ID.
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_questions.question_inline_answers
General info
Entity name tce_questions
Data type Boolean
Not null YES
Default '0'
Description
If TRUE display answers one next each other instead of vertical list layout.
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_questions.question_position
General info
Entity name tce_questions
Data type Bigint
Not null NO
Description
Indicates the right question appearance order.
Notes
This order is used when test_random_questions_select and test_random_questions_order are both set to false.
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_questions.question_timer
General info
Entity name tce_questions
Data type Smallint
Not null NO
Description
Maximum visualization time for this question.
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_questions.question_type
General info
Entity name tce_questions
Data type Smallint
Not null YES
Default 1
Description
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.
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_questions.subject_id
General info
Entity name tce_questions
Role name question_subject_id
Data type Bigint
Not null YES
Description
This number represents the internal subject unique ID.
Indicates to which subject this question belongs.
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_sessions.cpsession_data
General info
Entity name tce_sessions
Data type Text
Not null YES
Description
This attribute stores the encoded user's session data.
Notes
In PHP this information may be encoded/decoded using the session_encode/session_decode functions.
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_sessions.cpsession_expiry
General info
Entity name tce_sessions
Data type Timestamp
Not null YES
Description
This attribute stores the last time this session experienced any call activity.
Notes
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.
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_sessions.cpsession_id
General info
Entity name tce_sessions
Data type Varchar(n) (32)
Not null YES
Description
This string represents the user's Web session identification (ID).
Notes
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.
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_subjects.module_id
General info
Entity name tce_subjects
Role name subject_module_id
Data type Bigint
Not null YES
Default 1
Description
This number represents the internal module unique ID.
Indicates to which module this subject belongs.
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_subjects.subject_description
General info
Entity name tce_subjects
Data type Text
Not null NO
Description
Subject description.
Notes
This text may contain special markup tags for formatting and image linking.
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_subjects.subject_enabled
General info
Entity name tce_subjects
Data type Boolean
Not null YES
Default '0'
Description
Indicates when the subject is enabled.
The legal values are:
FALSE = disabled;
TRUE = enabled.
Notes
Only enabled subjects can be used for a new test.
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_subjects.subject_id
General info
Entity name tce_subjects
Data type BigSerial
Not null YES
Description
This number represents the internal subject unique ID.
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_subjects.subject_name
General info
Entity name tce_subjects
Data type Varchar(n) (255)
Not null YES
Description
Unique name of the subject (e.g.: History I, History II, Geography).
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_subjects.user_id
General info
Entity name tce_subjects
Role name subject_user_id
Data type Bigint
Not null YES
Default 1
Description
Only the administrator and the author of this subject (or his/her group) may update or delete this record.
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_test_subject_set.test_id
General info
Entity name tce_test_subject_set
Role name tsubset_test_id
Data type Bigint
Not null YES
Description
ID of the test
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_test_subject_set.tsubset_answers
General info
Entity name tce_test_subject_set
Data type Smallint
Not null YES
Default 0
Description
Number of alternative answers to be selected for the single and multiple questions.
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_test_subject_set.tsubset_difficulty
General info
Entity name tce_test_subject_set
Data type Smallint
Not null YES
Default 1
Description
Integer value representing the difficulty level of the question.
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_test_subject_set.tsubset_id
General info
Entity name tce_test_subject_set
Data type BigSerial
Not null YES
Description
Unique ID representing a group of subjects for the specified test.
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_test_subject_set.tsubset_quantity
General info
Entity name tce_test_subject_set
Data type Smallint
Not null YES
Default 1
Description
Maximum number of questions to be selected.
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_test_subject_set.tsubset_type
General info
Entity name tce_test_subject_set
Data type Smallint
Not null YES
Default 1
Description
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).
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_test_subjects.subject_id
General info
Entity name tce_test_subjects
Role name subjset_subject_id
Data type Bigint
Not null YES
Description
This number represents the internal test unique ID.
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_test_subjects.tsubset_id
General info
Entity name tce_test_subjects
Role name subjset_tsubset_id
Data type Bigint
Not null YES
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_testgroups.group_id
General info
Entity name tce_testgroups
Role name tstgrp_group_id
Data type Bigint
Not null YES
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_testgroups.test_id
General info
Entity name tce_testgroups
Role name tstgrp_test_id
Data type Bigint
Not null YES
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_tests.test_begin_time
General info
Entity name tce_tests
Data type Timestamp
Not null NO
Description
Date and time (relative to server clock) after which the test will be active.
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_tests.test_comment_enabled
General info
Entity name tce_tests
Data type Boolean
Not null YES
Default '1'
Description
If true enable test comment: the user may leave a general test comment on a textarea.
The legal values are:
FALSE = disabled;
TRUE = enabled.
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_tests.test_description
General info
Entity name tce_tests
Data type Text
Not null YES
Description
Test description.
Notes
This text may contain special markup tags for formatting and image linking.
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_tests.test_duration_time
General info
Entity name tce_tests
Data type Smallint
Not null YES
Default 0
Description
Maximum duration of the test in minutes.
Notes
Once started, the test will have to be completed within the specified amount of time.
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_tests.test_end_time
General info
Entity name tce_tests
Data type Timestamp
Not null NO
Description
Date and time (relative to server clock) after which the test will be deactivated.
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_tests.test_id
General info
Entity name tce_tests
Data type BigSerial
Not null YES
Description
This number represents the internal test unique ID.
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_tests.test_ip_range
General info
Entity name tce_tests
Data type Varchar(n) (255)
Not null YES
Default '*.*.*.*'
Description
Enabled IP addresses.
Notes
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.*).
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_tests.test_max_score
General info
Entity name tce_tests
Data type Numeric(p,s) (10,3)
Not null YES
Default 0
Description
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.
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_tests.test_mcma_radio
General info
Entity name tce_tests
Data type Boolean
Not null YES
Default '1'
Description
If true uses radiobuttons instead of checkboxes for MCMA questions.
The legal values are:
FALSE = disabled;
TRUE = enabled.
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_tests.test_menu_enabled
General info
Entity name tce_tests
Data type Boolean
Not null YES
Default '1'
Description
If true enables the navigation menu for questions during test execution.
The legal values are:
FALSE = disabled;
TRUE = enabled.
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_tests.test_name
General info
Entity name tce_tests
Data type Varchar(n) (255)
Not null YES
Description
Unique name of the test (e.g.: History I 2004, Geography 1st class 2005).
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_tests.test_noanswer_enabled
General info
Entity name tce_tests
Data type Boolean
Not null YES
Default '1'
Description
If true enable the 'no-answe' option on available answers.
The legal values are:
FALSE = disabled;
TRUE = enabled.
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_tests.test_random_answers_order
General info
Entity name tce_tests
Data type Boolean
Not null YES
Default '1'
Description
If true the answers will be ordered randomly for each question.
The legal values are:
FALSE = disabled;
TRUE = enabled.
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_tests.test_random_answers_select
General info
Entity name tce_tests
Data type Boolean
Not null YES
Default '1'
Description
If true the answers will be selected randomly for each question.
The legal values are:
FALSE = disabled;
TRUE = enabled.
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_tests.test_random_questions_order
General info
Entity name tce_tests
Data type Boolean
Not null YES
Default '1'
Description
If true the questions will be ordered randomly for each user.
The legal values are:
FALSE = disabled;
TRUE = enabled.
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_tests.test_random_questions_select
General info
Entity name tce_tests
Data type Boolean
Not null YES
Default '1'
Description
If true the questions will be selected randomly for each user.
The legal values are:
FALSE = disabled;
TRUE = enabled.
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_tests.test_report_to_users
General info
Entity name tce_tests
Data type Boolean
Not null NO
Default '0'
Description
If true enable users to view a detailed report on executed tests.
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_tests.test_results_to_users
General info
Entity name tce_tests
Data type Boolean
Not null YES
Default '0'
Description
If true enable users to view their test results immediately after finish.
The legal values are:
FALSE = disabled;
TRUE = enabled.
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_tests.test_score_right
General info
Entity name tce_tests
Data type Numeric(p,s) (10,3)
Not null NO
Default 0
Description
Default score for right answers.
This value will be multiplied by question_difficulty value to obtain the question score.
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_tests.test_score_threshold
General info
Entity name tce_tests
Data type Numeric(p,s) (10,3)
Not null NO
Default 0
Description
Minimum score required to pass the exam.
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_tests.test_score_unanswered
General info
Entity name tce_tests
Data type Numeric(p,s) (10,3)
Not null NO
Default 0
Description
Score to be assigned to the unanswered questions.
This value will be multiplied by question_difficulty value to obtain the question score.
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_tests.test_score_wrong
General info
Entity name tce_tests
Data type Numeric(p,s) (10,3)
Not null NO
Description
Score to be assigned to the wrong answers.
This value will be multiplied by question_difficulty value to obtain the question score.
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_tests.user_id
General info
Entity name tce_tests
Role name test_user_id
Data type Bigint
Not null YES
Default 1
Description
User ID of the author of the test.
Notes
Only the administrator and the author of the test (or his/her group) may update/delete the test.
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_tests_logs.question_id
General info
Entity name tce_tests_logs
Role name testlog_question_id
Data type Bigint
Not null YES
Description
This number represents the internal question unique ID.
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_tests_logs.testlog_answer_text
General info
Entity name tce_tests_logs
Data type Text
Not null NO
Description
Text of the answer given by user.
Notes
This will be set only if the question is free-answer type.
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_tests_logs.testlog_change_time
General info
Entity name tce_tests_logs
Data type Timestamp
Not null NO
Description
Date and time (relative to server clock) indicating when the last answer has been set.
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_tests_logs.testlog_comment
General info
Entity name tce_tests_logs
Data type Text
Not null NO
Description
Teacher or Supervisor comment to the question
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_tests_logs.testlog_creation_time
General info
Entity name tce_tests_logs
Data type Timestamp
Not null NO
Description
Date and time (relative to server clock) indicating when the question (tuple) has been generated.
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_tests_logs.testlog_display_time
General info
Entity name tce_tests_logs
Data type Timestamp
Not null NO
Description
Date and time (relative to server clock) indicating when the question has been displayed to the user for the first time.
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_tests_logs.testlog_id
General info
Entity name tce_tests_logs
Data type BigSerial
Not null YES
Description
This number represents the internal test-log unique ID.
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_tests_logs.testlog_num_answers
General info
Entity name tce_tests_logs
Data type Smallint
Not null YES
Default 0
Description
Number of alternative answers associated to this question.
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_tests_logs.testlog_order
General info
Entity name tce_tests_logs
Data type Smallint
Not null YES
Default 1
Description
Display order of the questions.
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_tests_logs.testlog_reaction_time
General info
Entity name tce_tests_logs
Data type Bigint
Not null NO
Default 0
Description
Time (milliseconds) elapsed between question visualisation and user's answer.
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_tests_logs.testlog_score
General info
Entity name tce_tests_logs
Data type Numeric(p,s) (10,3)
Not null NO
Description
Total score gained by the user for this question.
Notes
This score may be automatically calculated in case of multiple-choice question, otherwise may be manually set.
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_tests_logs.testlog_user_ip
General info
Entity name tce_tests_logs
Data type Varchar(n) (15)
Not null NO
Description
IP address of the client computer from where the aswer has been received.
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_tests_logs.testuser_id
General info
Entity name tce_tests_logs
Role name testlog_testuser_id
Data type Bigint
Not null YES
Description
This number represents the internal test-user unique ID.
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_tests_logs_answers.answer_id
General info
Entity name tce_tests_logs_answers
Role name logansw_answer_id
Data type Bigint
Not null YES
Description
This number represents the internal answer unique ID.
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_tests_logs_answers.logansw_order
General info
Entity name tce_tests_logs_answers
Data type Smallint
Not null YES
Default 1
Description
Presentation order of the answer inside the question
Notes
This avoid an automatic ordering problem that happens in MySQL
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_tests_logs_answers.logansw_position
General info
Entity name tce_tests_logs_answers
Data type Bigint
Not null NO
Description
User's selected order for this answer.
Notes
This field is used only for ordering questions.
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_tests_logs_answers.logansw_selected
General info
Entity name tce_tests_logs_answers
Data type Smallint
Not null YES
Default -1
Description
Indicate the user's answer.
Legal values are:
-1 = no answer;
0 = false or not selected;
1 = true or selecte
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_tests_logs_answers.testlog_id
General info
Entity name tce_tests_logs_answers
Role name logansw_testlog_id
Data type Bigint
Not null YES
Description
This number represents the internal test-log unique ID.
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_tests_users.test_id
General info
Entity name tce_tests_users
Role name testuser_test_id
Data type Bigint
Not null YES
Description
This number represents the internal test unique ID.
Indicates the test type selected by the user.
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_tests_users.testuser_comment
General info
Entity name tce_tests_users
Data type Text
Not null NO
Description
User's optional comment about the test.
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_tests_users.testuser_creation_time
General info
Entity name tce_tests_users
Data type Timestamp
Not null YES
Description
Date and time (relative to server clock) indicating the end of the test creation process.
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_tests_users.testuser_id
General info
Entity name tce_tests_users
Data type BigSerial
Not null YES
Description
This number represents the internal user-test unique ID.
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_tests_users.testuser_status
General info
Entity name tce_tests_users
Data type Smallint
Not null YES
Default 0
Check testuser_status IN (0,1,2,3,4)
Description
Numeric code that indicates the user-test status.
Notes
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);
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_tests_users.user_id
General info
Entity name tce_tests_users
Role name testuser_user_id
Data type Bigint
Not null YES
Description
This number represents the internal user's identification (ID).
Indicates to which user the test belongs.
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_user_groups.group_id
General info
Entity name tce_user_groups
Data type BigSerial
Not null YES
Description
This number represents the internal group identification (ID).
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_user_groups.group_name
General info
Entity name tce_user_groups
Data type Varchar(n) (255)
Not null YES
Unique YES
Description
Unique name of this group.
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_users.user_birthdate
General info
Entity name tce_users
Data type Date
Not null NO
Description
Date of birth, year month and day on which user was born.
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_users.user_birthplace
General info
Entity name tce_users
Data type Varchar(n) (255)
Not null NO
Description
User's place of birth (city or country).
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_users.user_email
General info
Entity name tce_users
Data type Varchar(n) (255)
Not null NO
Description
User's email address (e.g.: name@domain.com).
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_users.user_firstname
General info
Entity name tce_users
Data type Varchar(n) (255)
Not null NO
Description
User's real first name (e.g.: Albert, Maria).
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_users.user_id
General info
Entity name tce_users
Data type BigSerial
Not null YES
Description
This number represents the internal user's identification (ID).
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_users.user_ip
General info
Entity name tce_users
Data type Varchar(n) (15)
Not null YES
Description
IP address of the client computer from where the user's registration request has been received.
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_users.user_lastname
General info
Entity name tce_users
Data type Varchar(n) (255)
Not null NO
Description
User's real last name, family name, surname (e.g.: Smith, Einstein).
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_users.user_level
General info
Entity name tce_users
Data type Smallint
Not null YES
Default 1
Description
The user's level is a numeric value that indicates which resources (pages, modules, services) are accessible by the user.


Notes
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
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_users.user_name
General info
Entity name tce_users
Data type Varchar(n) (255)
Not null YES
Description
Username, unique name by which a user is identified when accessing a multi-user system.
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_users.user_password
General info
Entity name tce_users
Data type Varchar(n) (255)
Not null YES
Description
Password, keyword, code word, alphanumeric code that together with the username is used to gain access to this system.
Notes
Passwords are encrypted by a one way algorithm (MD5).
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_users.user_regdate
General info
Entity name tce_users
Data type Timestamp
Not null YES
Description
User registration date and time relative to server clock.
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_users.user_regnumber
General info
Entity name tce_users
Data type Varchar(n) (255)
Not null NO
Description
Unique user's registration number (e.g.: school registration number).
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_users.user_ssn
General info
Entity name tce_users
Data type Varchar(n) (255)
Not null NO
Description
User's Social Security number (SSN) or other equivalent unique code (e.g.: Codice Fiscale for Italian users)
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_users.user_verifycode
General info
Entity name tce_users
Data type Varchar(n) (32)
Not null NO
Unique YES
Description
Unique code used to verify user's email during remote registration process.
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_usrgroups.group_id
General info
Entity name tce_usrgroups
Role name usrgrp_group_id
Data type Bigint
Not null YES
Description
This number represents the internal group unique ID.
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)


tce_usrgroups.user_id
General info
Entity name tce_usrgroups
Role name usrgrp_user_id
Data type Bigint
Not null YES
Description
This number represents the internal user unique ID.
User-defined variables
Name Value
Attribute Is Array No
Array Dimensions
Generate Unique as unique Index No
Using index tablespace (for Unique)