TCExam Database Documentation





tce_answers.answer_description
 General info



Column name answer_description

Table name tce_answers

Primary key NO

Foreign key NO

Data type Text

Not null YES

Unique NO


 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




tce_answers.answer_enabled
 General info



Column name answer_enabled

Table name tce_answers

Primary key NO

Foreign key NO

Data type Boolean

Not null YES

Unique NO

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




tce_answers.answer_id
 General info



Column name answer_id

Table name tce_answers

Primary key YES

Foreign key NO

Data type BigSerial

Not null YES

Unique NO


 Description



This number represents the internal answer unique ID.


 User-defined variables



Name Value

Attribute Is Array No

Array Dimensions




tce_answers.answer_isright
 General info



Column name answer_isright

Table name tce_answers

Primary key NO

Foreign key NO

Data type Boolean

Not null YES

Unique NO

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




tce_answers.answer_question_id
 General info



Column name answer_question_id

Table name tce_answers

Primary key NO

Foreign key YES

Data type Bigint

Not null YES

Unique NO


 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




tce_questions.question_description
 General info



Column name question_description

Table name tce_questions

Primary key NO

Foreign key NO

Data type Text

Not null YES

Unique NO


 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




tce_questions.question_enable_textarea
 General info



Column name question_enable_textarea

Table name tce_questions

Primary key NO

Foreign key NO

Data type Boolean

Not null YES

Unique NO

Default '0'


 Description



Indicates when the question is free-answer of multiple-choice. The legal values are: FALSE = multiple-choice; TRUE = free-answer.


 User-defined variables



Name Value

Attribute Is Array No

Array Dimensions




tce_questions.question_enabled
 General info



Column name question_enabled

Table name tce_questions

Primary key NO

Foreign key NO

Data type Boolean

Not null YES

Unique NO

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




tce_questions.question_id
 General info



Column name question_id

Table name tce_questions

Primary key YES

Foreign key NO

Data type BigSerial

Not null YES

Unique NO


 Description



This number represents the internal question unique ID.


 User-defined variables



Name Value

Attribute Is Array No

Array Dimensions




tce_questions.question_subject_id
 General info



Column name question_subject_id

Table name tce_questions

Primary key NO

Foreign key YES

Data type Bigint

Not null YES

Unique NO


 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




tce_sessions.cpsession_data
 General info



Column name cpsession_data

Table name tce_sessions

Primary key NO

Foreign key NO

Data type Text

Not null YES

Unique NO


 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




tce_sessions.cpsession_expiry
 General info



Column name cpsession_expiry

Table name tce_sessions

Primary key NO

Foreign key NO

Data type Timestamp

Not null YES

Unique NO


 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




tce_sessions.cpsession_id
 General info



Column name cpsession_id

Table name tce_sessions

Primary key YES

Foreign key NO

Data type Varchar Length 32

Not null YES

Unique NO


 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




tce_subjects.subject_description
 General info



Column name subject_description

Table name tce_subjects

Primary key NO

Foreign key NO

Data type Text

Not null NO

Unique 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




tce_subjects.subject_enabled
 General info



Column name subject_enabled

Table name tce_subjects

Primary key NO

Foreign key NO

Data type Boolean

Not null YES

Unique NO

Default '0'


 Description



Indicates when the subject is enabled. The legal values are: FALSE = disabled; TRUE = enabled.


 Notes



Only enabled subjects may be used for a new test.


 User-defined variables



Name Value

Attribute Is Array No

Array Dimensions




tce_subjects.subject_id
 General info



Column name subject_id

Table name tce_subjects

Primary key YES

Foreign key NO

Data type BigSerial

Not null YES

Unique NO


 Description



This number represents the internal subject unique ID.


 User-defined variables



Name Value

Attribute Is Array No

Array Dimensions




tce_subjects.subject_name
 General info



Column name subject_name

Table name tce_subjects

Primary key NO

Foreign key NO

Data type Varchar Length 255

Not null YES

Unique NO


 Description



Unique name of the subject (e.g.: History I, History II, Geography).


 User-defined variables



Name Value

Attribute Is Array No

Array Dimensions




tce_test_subjects.tsubj_subject_id
 General info



Column name tsubj_subject_id

Table name tce_test_subjects

Primary key YES

Foreign key YES

Data type Bigint

Not null YES

Unique NO


 Description



This number represents the internal test unique ID.


 User-defined variables



Name Value

Attribute Is Array No

Array Dimensions




tce_test_subjects.tsubj_test_id
 General info



Column name tsubj_test_id

Table name tce_test_subjects

Primary key YES

Foreign key YES

Data type Bigint

Not null YES

Unique NO


 Description



This number represents the internal subject unique ID.


 User-defined variables



Name Value

Attribute Is Array No

Array Dimensions




tce_tests.test_begin_time
 General info



Column name test_begin_time

Table name tce_tests

Primary key NO

Foreign key NO

Data type Timestamp

Not null NO

Unique 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




tce_tests.test_description
 General info



Column name test_description

Table name tce_tests

Primary key NO

Foreign key NO

Data type Text

Not null YES

Unique NO


 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




tce_tests.test_duration_time
 General info



Column name test_duration_time

Table name tce_tests

Primary key NO

Foreign key NO

Data type Smallint

Not null YES

Unique NO

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




tce_tests.test_end_time
 General info



Column name test_end_time

Table name tce_tests

Primary key NO

Foreign key NO

Data type Timestamp

Not null NO

Unique 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




tce_tests.test_id
 General info



Column name test_id

Table name tce_tests

Primary key YES

Foreign key NO

Data type BigSerial

Not null YES

Unique NO


 Description



This number represents the internal test unique ID.


 User-defined variables



Name Value

Attribute Is Array No

Array Dimensions




tce_tests.test_ip_range
 General info



Column name test_ip_range

Table name tce_tests

Primary key NO

Foreign key NO

Data type Varchar Length 255

Not null YES

Unique NO

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




tce_tests.test_name
 General info



Column name test_name

Table name tce_tests

Primary key NO

Foreign key NO

Data type Varchar Length 255

Not null YES

Unique NO


 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




tce_tests.test_num_answers
 General info



Column name test_num_answers

Table name tce_tests

Primary key NO

Foreign key NO

Data type Smallint

Not null YES

Unique NO

Default 0


 Description



Maximum number of alternative answers that will be randomly extracted for each multiple-choice question.


 User-defined variables



Name Value

Attribute Is Array No

Array Dimensions




tce_tests.test_num_mquestions
 General info



Column name test_num_mquestions

Table name tce_tests

Primary key NO

Foreign key NO

Data type Smallint

Not null YES

Unique NO

Default 0


 Description



Maximum number of multiple-choice questions that will be randomly extracted.


 User-defined variables



Name Value

Attribute Is Array No

Array Dimensions




tce_tests.test_num_tquestions
 General info



Column name test_num_tquestions

Table name tce_tests

Primary key NO

Foreign key NO

Data type Smallint

Not null YES

Unique NO

Default 0


 Description



Maximum number of free-answer questions that will be randomly extracted.


 User-defined variables



Name Value

Attribute Is Array No

Array Dimensions




tce_tests.test_score_right
 General info



Column name test_score_right

Table name tce_tests

Primary key NO

Foreign key NO

Data type Numeric Length 10 Decimal 3

Not null YES

Unique NO

Default 0


 Description



Default score for right answers.


 User-defined variables



Name Value

Attribute Is Array No

Array Dimensions




tce_tests.test_score_unanswered
 General info



Column name test_score_unanswered

Table name tce_tests

Primary key NO

Foreign key NO

Data type Numeric Length 10 Decimal 3

Not null YES

Unique NO

Default 0


 Description



Default score for unanswered questions.


 User-defined variables



Name Value

Attribute Is Array No

Array Dimensions




tce_tests.test_score_wrong
 General info



Column name test_score_wrong

Table name tce_tests

Primary key NO

Foreign key NO

Data type Numeric Length 10 Decimal 3

Not null YES

Unique NO

Default 0


 Description



Default score for wrong answers.


 User-defined variables



Name Value

Attribute Is Array No

Array Dimensions




tce_tests_logs.testlog_answer_id
 General info



Column name testlog_answer_id

Table name tce_tests_logs

Primary key NO

Foreign key YES

Data type Bigint

Not null NO

Unique NO


 Description



This number represents the internal unique ID of the answer given by user.


 Notes



This will be set only if the question is multiple-choice type.


 User-defined variables



Name Value

Attribute Is Array No

Array Dimensions




tce_tests_logs.testlog_answer_text
 General info



Column name testlog_answer_text

Table name tce_tests_logs

Primary key NO

Foreign key NO

Data type Text

Not null NO

Unique 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




tce_tests_logs.testlog_change_time
 General info



Column name testlog_change_time

Table name tce_tests_logs

Primary key NO

Foreign key NO

Data type Timestamp

Not null NO

Unique 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




tce_tests_logs.testlog_creation_time
 General info



Column name testlog_creation_time

Table name tce_tests_logs

Primary key NO

Foreign key NO

Data type Timestamp

Not null NO

Unique 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




tce_tests_logs.testlog_display_time
 General info



Column name testlog_display_time

Table name tce_tests_logs

Primary key NO

Foreign key NO

Data type Timestamp

Not null NO

Unique 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




tce_tests_logs.testlog_id
 General info



Column name testlog_id

Table name tce_tests_logs

Primary key YES

Foreign key NO

Data type BigSerial

Not null YES

Unique NO


 Description



This number represents the internal test-log unique ID.


 User-defined variables



Name Value

Attribute Is Array No

Array Dimensions




tce_tests_logs.testlog_question_id
 General info



Column name testlog_question_id

Table name tce_tests_logs

Primary key NO

Foreign key YES

Data type Bigint

Not null YES

Unique NO


 Description



This number represents the internal question unique ID.


 User-defined variables



Name Value

Attribute Is Array No

Array Dimensions




tce_tests_logs.testlog_score
 General info



Column name testlog_score

Table name tce_tests_logs

Primary key NO

Foreign key NO

Data type Numeric Length 10 Decimal 3

Not null NO

Unique NO


 Description



Score assigned to the answer.


 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




tce_tests_logs.testlog_testuser_id
 General info



Column name testlog_testuser_id

Table name tce_tests_logs

Primary key NO

Foreign key YES

Data type Bigint

Not null YES

Unique NO


 Description



This number represents the internal test-user unique ID.


 User-defined variables



Name Value

Attribute Is Array No

Array Dimensions




tce_tests_logs.testlog_user_ip
 General info



Column name testlog_user_ip

Table name tce_tests_logs

Primary key NO

Foreign key NO

Data type Varchar Length 15

Not null NO

Unique 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




tce_tests_logs_answers.logansw_answer_id
 General info



Column name logansw_answer_id

Table name tce_tests_logs_answers

Primary key YES

Foreign key YES

Data type Bigint

Not null YES

Unique NO


 Description



This number represents the internal answer unique ID.


 User-defined variables



Name Value

Attribute Is Array No

Array Dimensions




tce_tests_logs_answers.logansw_testlog_id
 General info



Column name logansw_testlog_id

Table name tce_tests_logs_answers

Primary key YES

Foreign key YES

Data type Bigint

Not null YES

Unique NO


 Description



This number represents the internal test-log unique ID.


 User-defined variables



Name Value

Attribute Is Array No

Array Dimensions




tce_tests_users.testuser_creation_time
 General info



Column name testuser_creation_time

Table name tce_tests_users

Primary key NO

Foreign key NO

Data type Timestamp

Not null YES

Unique NO


 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




tce_tests_users.testuser_id
 General info



Column name testuser_id

Table name tce_tests_users

Primary key YES

Foreign key NO

Data type BigSerial

Not null YES

Unique NO


 Description



This number represents the internal user-test unique ID.


 User-defined variables



Name Value

Attribute Is Array No

Array Dimensions




tce_tests_users.testuser_status
 General info



Column name testuser_status

Table name tce_tests_users

Primary key NO

Foreign key NO

Data type Smallint

Not null YES

Unique NO

Check testuser_status IN (0,1,2,3,4)

Default 0


 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




tce_tests_users.testuser_test_id
 General info



Column name testuser_test_id

Table name tce_tests_users

Primary key NO

Foreign key YES

Data type Bigint

Not null YES

Unique NO


 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




tce_tests_users.testuser_user_id
 General info



Column name testuser_user_id

Table name tce_tests_users

Primary key NO

Foreign key YES

Data type Bigint

Not null YES

Unique NO


 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




tce_users.user_birthdate
 General info



Column name user_birthdate

Table name tce_users

Primary key NO

Foreign key NO

Data type Date

Not null NO

Unique 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




tce_users.user_birthplace
 General info



Column name user_birthplace

Table name tce_users

Primary key NO

Foreign key NO

Data type Varchar Length 255

Not null NO

Unique NO


 Description



User's place of birth (city or country).


 User-defined variables



Name Value

Attribute Is Array No

Array Dimensions




tce_users.user_email
 General info



Column name user_email

Table name tce_users

Primary key NO

Foreign key NO

Data type Varchar Length 255

Not null NO

Unique NO


 Description



User's email address (e.g.: [e-mail]).


 User-defined variables



Name Value

Attribute Is Array No

Array Dimensions




tce_users.user_firstname
 General info



Column name user_firstname

Table name tce_users

Primary key NO

Foreign key NO

Data type Varchar Length 255

Not null NO

Unique NO


 Description



User's real first name (e.g.: Albert, Maria).


 User-defined variables



Name Value

Attribute Is Array No

Array Dimensions




tce_users.user_id
 General info



Column name user_id

Table name tce_users

Primary key YES

Foreign key NO

Data type BigSerial

Not null YES

Unique NO


 Description



This number represents the internal user's identification (ID).


 User-defined variables



Name Value

Attribute Is Array No

Array Dimensions




tce_users.user_ip
 General info



Column name user_ip

Table name tce_users

Primary key NO

Foreign key NO

Data type Varchar Length 15

Not null YES

Unique NO


 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




tce_users.user_lastname
 General info



Column name user_lastname

Table name tce_users

Primary key NO

Foreign key NO

Data type Varchar Length 255

Not null NO

Unique 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




tce_users.user_level
 General info



Column name user_level

Table name tce_users

Primary key NO

Foreign key NO

Data type Smallint

Not null YES

Unique NO

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




tce_users.user_name
 General info



Column name user_name

Table name tce_users

Primary key NO

Foreign key NO

Data type Varchar Length 255

Not null YES

Unique NO


 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




tce_users.user_password
 General info



Column name user_password

Table name tce_users

Primary key NO

Foreign key NO

Data type Varchar Length 255

Not null YES

Unique NO


 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




tce_users.user_regdate
 General info



Column name user_regdate

Table name tce_users

Primary key NO

Foreign key NO

Data type Timestamp

Not null YES

Unique NO


 Description



User registration date and time relative to server clock.


 User-defined variables



Name Value

Attribute Is Array No

Array Dimensions




tce_users.user_regnumber
 General info



Column name user_regnumber

Table name tce_users

Primary key NO

Foreign key NO

Data type Varchar Length 255

Not null NO

Unique NO


 Description



Unique user's registration number (e.g.: school registration number).


 User-defined variables



Name Value

Attribute Is Array No

Array Dimensions




tce_users.user_ssn
 General info



Column name user_ssn

Table name tce_users

Primary key NO

Foreign key NO

Data type Varchar Length 255

Not null NO

Unique 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