TCExam Database Documentation
Attributes
tce_answers.answer_description
General info
| Entity name | tce_answers | ||
| Data type | Text | ||
| Not null | YES | ||
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' | ||
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_explanation
General info
| Entity name | tce_answers | ||
| Data type | Text | ||
| Not null | NO | ||
Notes
| This field must be displayed only on results. |
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 | ||
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' | ||
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 | ||
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 | ||
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 | ||
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' | ||
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 | ||
| Role name | module_user_id | ||
| Data type | Bigint | ||
| Not null | YES | ||
| Default | 1 | ||
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 | ||
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 | ||
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' | ||
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 | ||
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 | ||
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' | ||
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_explanation
General info
| Entity name | tce_questions | ||
| Data type | Text | ||
| Not null | NO | ||
Notes
| This field must be displayed only on results. |
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' | ||
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 | ||
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' | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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_user_id | ||
| Data type | Bigint | ||
| Not null | YES | ||
| Default | 1 | ||
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 | ||
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 | ||
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' | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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.module_id
General info
| Entity name | tce_tests | ||
| Role name | test_user_id | ||
| Data type | Bigint | ||
| Not null | YES | ||
| Default | 1 | ||
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.test_begin_time
General info
| Entity name | tce_tests | ||
| Data type | Timestamp | ||
| Not null | NO | ||
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' | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | '*.*.*.*' | ||
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_logout_on_timeout
General info
| Entity name | tce_tests | ||
| Data type | Boolean | ||
| Not null | YES | ||
| Default | '0' | ||
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 | ||
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_partial_score
General info
| Entity name | tce_tests | ||
| Data type | Boolean | ||
| Not null | YES | ||
| Default | '1' | ||
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' | ||
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' | ||
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 | ||
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' | ||
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' | ||
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' | ||
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' | ||
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' | ||
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_repeatable
General info
| Entity name | tce_tests | ||
| Data type | Boolean | ||
| Not null | YES | ||
| Default | '0' | ||
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' | ||
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' | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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) (39) | ||
| Not null | NO | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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.module_id
General info
| Entity name | tce_tests_users | ||
| Role name | testuser_user_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_users.test_id
General info
| Entity name | tce_tests_users | ||
| Role name | testuser_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_users.testuser_comment
General info
| Entity name | tce_tests_users | ||
| Data type | Text | ||
| Not null | NO | ||
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 | ||
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 | ||
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) | ||
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_user_groups.group_id
General info
| Entity name | tce_user_groups | ||
| Data type | BigSerial | ||
| 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_user_groups.group_name
General info
| Entity name | tce_user_groups | ||
| Data type | Varchar(n) (255) | ||
| Not null | YES | ||
| Unique | YES | ||
User-defined variables
| Name | Value |
| Attribute Is Array | No |
| Array Dimensions | |
| Generate Unique as unique Index | No |
| Using index tablespace (for Unique) |
tce_users.module_id
General info
| Entity name | tce_users | ||
| 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_users.user_birthdate
General info
| Entity name | tce_users | ||
| Data type | Date | ||
| Not null | NO | ||
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 | ||
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 | ||
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 | ||
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) (39) | ||
| 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_users.user_lastname
General info
| Entity name | tce_users | ||
| Data type | Varchar(n) (255) | ||
| Not null | NO | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
User-defined variables
| Name | Value |
| Attribute Is Array | No |
| Array Dimensions | |
| Generate Unique as unique Index | No |
| Using index tablespace (for Unique) |
tce_usrgroups.module_id
General info
| Entity name | tce_usrgroups | ||
| Role name | usrgrp_user_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) |
