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_explanation
General info

Entity name | tce_answers
Data type | Text
Not null | NO

Description

Explantion of the answer.

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

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
Role name | module_user_id
Data type | Bigint
Not null | YES
Default | 1

Description

Author's ID. This module can be edited by the administrator, the author of this module and the users belonging to the same group of the author.

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_explanation
General info

Entity name | tce_questions
Data type | Text
Not null | NO

Description

Explanation of the question.

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'

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_user_id
Data type | Bigint
Not null | YES
Default | 1

Description

Author's ID. This module can be edited by the administrator, the author of this module and the users belonging to the same group of the author.

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_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.module_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.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_logout_on_timeout
General info

Entity name | tce_tests
Data type | Boolean
Not null | YES
Default | '0'

Description

If true, logs out the user when time expires.

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_partial_score
General info

Entity name | tce_tests
Data type | Boolean
Not null | YES
Default | '1'

Description

If true uses partial score for MCMA and ORDER 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.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_repeatable
General info

Entity name | tce_tests
Data type | Boolean
Not null | YES
Default | '0'

Description

If true the test can be repeated by the same 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_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) (39)
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.module_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_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_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.module_id
General info

Entity name | tce_users
Data type | Bigint
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_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_ip
General info

Entity name | tce_users
Data type | Varchar(n) (39)
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.module_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) |