tce_answers.answer_description
General info

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

Description

Answer description.

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.

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.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_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?).

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.

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.

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_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).

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.

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.

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).

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.

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.

User-defined variables

Name | Value
Attribute Is Array | No
Array Dimensions |
Generate Unique as unique Index | No
Using index tablespace (for Unique) |

tce_subjects.subject_id
General info

Entity name | tce_subjects
Data type | BigSerial
Not null | YES

Description

This number represents the internal subject unique ID.

User-defined variables

Name | Value
Attribute Is Array | No
Array Dimensions |
Generate Unique as unique Index | No
Using index tablespace (for Unique) |

tce_subjects.subject_name
General info

Entity name | tce_subjects
Data type | Varchar(n) (255)
Not null | YES

Description

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

User-defined variables

Name | Value
Attribute Is Array | No
Array Dimensions |
Generate Unique as unique Index | No
Using index tablespace (for Unique) |

tce_subjects.user_id
General info

Entity name | tce_subjects
Role name | subject_user_id
Data type | Bigint
Not null | YES
Default | 1

Description

Only the administrator and the author of this subject (or his/her group) may update or delete this record.

User-defined variables

Name | Value
Attribute Is Array | No
Array Dimensions |
Generate Unique as unique Index | No
Using index tablespace (for Unique) |

tce_test_subject_set.test_id
General info

Entity name | tce_test_subject_set
Role name | tsubset_test_id
Data type | Bigint
Not null | YES

Description

ID of the test

User-defined variables

Name | Value
Attribute Is Array | No
Array Dimensions |
Generate Unique as unique Index | No
Using index tablespace (for Unique) |

tce_test_subject_set.tsubset_answers
General info

Entity name | tce_test_subject_set
Data type | Smallint
Not null | YES
Default | 0

Description

Number of alternative answers to be selected for the single and multiple questions.

User-defined variables

Name | Value
Attribute Is Array | No
Array Dimensions |
Generate Unique as unique Index | No
Using index tablespace (for Unique) |

tce_test_subject_set.tsubset_difficulty
General info

Entity name | tce_test_subject_set
Data type | Smallint
Not null | YES
Default | 1

Description

Integer value representing the difficulty level of the question.

User-defined variables

Name | Value
Attribute Is Array | No
Array Dimensions |
Generate Unique as unique Index | No
Using index tablespace (for Unique) |

tce_test_subject_set.tsubset_id
General info

Entity name | tce_test_subject_set
Data type | BigSerial
Not null | YES

Description

Unique ID representing a group of subjects for the specified test.

User-defined variables

Name | Value
Attribute Is Array | No
Array Dimensions |
Generate Unique as unique Index | No
Using index tablespace (for Unique) |

tce_test_subject_set.tsubset_quantity
General info

Entity name | tce_test_subject_set
Data type | Smallint
Not null | YES
Default | 1

Description

Maximum number of questions to be selected.

User-defined variables

Name | Value
Attribute Is Array | No
Array Dimensions |
Generate Unique as unique Index | No
Using index tablespace (for Unique) |

tce_test_subject_set.tsubset_type
General info

Entity name | tce_test_subject_set
Data type | Smallint
Not null | YES
Default | 1

Description

Indicates the type of question: 1 = MCSA - single [radiobutton] (only one answer is right); 2 = MCMA - multiple [checkbox] (more than one answer may be right); 3 = free-answer [textarea] (the user introduces the answer using keyboard).

User-defined variables

Name | Value
Attribute Is Array | No
Array Dimensions |
Generate Unique as unique Index | No
Using index tablespace (for Unique) |

tce_test_subjects.subject_id
General info

Entity name | tce_test_subjects
Role name | subjset_subject_id
Data type | Bigint
Not null | YES

Description

This number represents the internal test unique ID.

User-defined variables

Name | Value
Attribute Is Array | No
Array Dimensions |
Generate Unique as unique Index | No
Using index tablespace (for Unique) |

tce_test_subjects.tsubset_id
General info

Entity name | tce_test_subjects
Role name | subjset_tsubset_id
Data type | Bigint
Not null | YES

User-defined variables

Name | Value
Attribute Is Array | No
Array Dimensions |
Generate Unique as unique Index | No
Using index tablespace (for Unique) |

tce_testgroups.group_id
General info

Entity name | tce_testgroups
Role name | tstgrp_group_id
Data type | Bigint
Not null | YES

User-defined variables

Name | Value
Attribute Is Array | No
Array Dimensions |
Generate Unique as unique Index | No
Using index tablespace (for Unique) |

tce_testgroups.test_id
General info

Entity name | tce_testgroups
Role name | tstgrp_test_id
Data type | Bigint
Not null | YES

User-defined variables

Name | Value
Attribute Is Array | No
Array Dimensions |
Generate Unique as unique Index | No
Using index tablespace (for Unique) |

tce_tests.test_begin_time
General info

Entity name | tce_tests
Data type | Timestamp
Not null | NO

Description

Date and time (relative to server clock) after which the test will be active.

User-defined variables

Name | Value
Attribute Is Array | No
Array Dimensions |
Generate Unique as unique Index | No
Using index tablespace (for Unique) |

tce_tests.test_description
General info

Entity name | tce_tests
Data type | Text
Not null | YES

Description

Test description.

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.

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.

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_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_random_questions
General info

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

Description

If true the questions will be selected and sorted 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_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.user_id
General info

Entity name | tce_tests
Role name | test_user_id
Data type | Bigint
Not null | YES
Default | 1

Description

User ID of the author of the test.

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.

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_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_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.

User-defined variables

Name | Value
Attribute Is Array | No
Array Dimensions |
Generate Unique as unique Index | No
Using index tablespace (for Unique) |

tce_tests_logs.testlog_user_ip
General info

Entity name | tce_tests_logs
Data type | Varchar(n) (15)
Not null | NO

Description

IP address of the client computer from where the aswer has been received.

User-defined variables

Name | Value
Attribute Is Array | No
Array Dimensions |
Generate Unique as unique Index | No
Using index tablespace (for Unique) |

tce_tests_logs.testuser_id
General info

Entity name | tce_tests_logs
Role name | testlog_testuser_id
Data type | Bigint
Not null | YES

Description

This number represents the internal test-user unique ID.

User-defined variables

Name | Value
Attribute Is Array | No
Array Dimensions |
Generate Unique as unique Index | No
Using index tablespace (for Unique) |

tce_tests_logs_answers.answer_id
General info

Entity name | tce_tests_logs_answers
Role name | logansw_answer_id
Data type | Bigint
Not null | YES

Description

This number represents the internal answer unique ID.

User-defined variables

Name | Value
Attribute Is Array | No
Array Dimensions |
Generate Unique as unique Index | No
Using index tablespace (for Unique) |

tce_tests_logs_answers.logansw_order
General info

Entity name | tce_tests_logs_answers
Data type | Smallint
Not null | YES
Default | 1

Description

Order of the answer inside 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_answers.logansw_selected
General info

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

Description

Indicates when this alternative answer has been selected by user. The legal values are: FALSE = not selected; TRUE = selected.

User-defined variables

Name | Value
Attribute Is Array | No
Array Dimensions |
Generate Unique as unique Index | No
Using index tablespace (for Unique) |

tce_tests_logs_answers.testlog_id
General info

Entity name | tce_tests_logs_answers
Role name | logansw_testlog_id
Data type | Bigint
Not null | YES

Description

This number represents the internal test-log unique ID.

User-defined variables

Name | Value
Attribute Is Array | No
Array Dimensions |
Generate Unique as unique Index | No
Using index tablespace (for Unique) |

tce_tests_users.test_id
General info

Entity name | tce_tests_users
Role name | testuser_test_id
Data type | Bigint
Not null | YES

Description

This number represents the internal test unique ID. Indicates the test type selected by the user.

User-defined variables

Name | Value
Attribute Is Array | No
Array Dimensions |
Generate Unique as unique Index | No
Using index tablespace (for Unique) |

tce_tests_users.testuser_comment
General info

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

Description

User's optional comment about the test.

User-defined variables

Name | Value
Attribute Is Array | No
Array Dimensions |
Generate Unique as unique Index | No
Using index tablespace (for Unique) |

tce_tests_users.testuser_creation_time
General info

Entity name | tce_tests_users
Data type | Timestamp
Not null | YES

Description

Date and time (relative to server clock) indicating the end of the test creation process.

User-defined variables

Name | Value
Attribute Is Array | No
Array Dimensions |
Generate Unique as unique Index | No
Using index tablespace (for Unique) |

tce_tests_users.testuser_id
General info

Entity name | tce_tests_users
Data type | BigSerial
Not null | YES

Description

This number represents the internal user-test unique ID.

User-defined variables

Name | Value
Attribute Is Array | No
Array Dimensions |
Generate Unique as unique Index | No
Using index tablespace (for Unique) |

tce_tests_users.testuser_status
General info

Entity name | tce_tests_users
Data type | Smallint
Not null | YES
Default | 0
Check | testuser_status IN (0,1,2,3,4)

Description

Numeric code that indicates the user-test status.

User-defined variables

Name | Value
Attribute Is Array | No
Array Dimensions |
Generate Unique as unique Index | No
Using index tablespace (for Unique) |

tce_tests_users.user_id
General info

Entity name | tce_tests_users
Role name | testuser_user_id
Data type | Bigint
Not null | YES

Description

This number represents the internal user's identification (ID). Indicates to which user the test belongs.

User-defined variables

Name | Value
Attribute Is Array | No
Array Dimensions |
Generate Unique as unique Index | No
Using index tablespace (for Unique) |

tce_user_groups.group_id
General info

Entity name | tce_user_groups
Data type | BigSerial
Not null | YES

Description

This number represents the internal group identification (ID).

User-defined variables

Name | Value
Attribute Is Array | No
Array Dimensions |
Generate Unique as unique Index | No
Using index tablespace (for Unique) |

tce_user_groups.group_name
General info

Entity name | tce_user_groups
Data type | Varchar(n) (255)
Not null | YES
Unique | YES

Description

Unique name of this group.

User-defined variables

Name | Value
Attribute Is Array | No
Array Dimensions |
Generate Unique as unique Index | No
Using index tablespace (for Unique) |

tce_users.user_birthdate
General info

Entity name | tce_users
Data type | Date
Not null | NO

Description

Date of birth, year month and day on which user was born.

User-defined variables

Name | Value
Attribute Is Array | No
Array Dimensions |
Generate Unique as unique Index | No
Using index tablespace (for Unique) |

tce_users.user_birthplace
General info

Entity name | tce_users
Data type | Varchar(n) (255)
Not null | NO

Description

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

User-defined variables

Name | Value
Attribute Is Array | No
Array Dimensions |
Generate Unique as unique Index | No
Using index tablespace (for Unique) |

tce_users.user_email
General info

Entity name | tce_users
Data type | Varchar(n) (255)
Not null | NO

Description

User's email address (e.g.: name@domain.com).

User-defined variables

Name | Value
Attribute Is Array | No
Array Dimensions |
Generate Unique as unique Index | No
Using index tablespace (for Unique) |

tce_users.user_firstname
General info

Entity name | tce_users
Data type | Varchar(n) (255)
Not null | NO

Description

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

User-defined variables

Name | Value
Attribute Is Array | No
Array Dimensions |
Generate Unique as unique Index | No
Using index tablespace (for Unique) |

tce_users.user_id
General info

Entity name | tce_users
Data type | BigSerial
Not null | YES

Description

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

User-defined variables

Name | Value
Attribute Is Array | No
Array Dimensions |
Generate Unique as unique Index | No
Using index tablespace (for Unique) |

tce_users.user_ip
General info

Entity name | tce_users
Data type | Varchar(n) (15)
Not null | YES

Description

IP address of the client computer from where the user's registration request has been received.

User-defined variables

Name | Value
Attribute Is Array | No
Array Dimensions |
Generate Unique as unique Index | No
Using index tablespace (for Unique) |

tce_users.user_lastname
General info

Entity name | tce_users
Data type | Varchar(n) (255)
Not null | NO

Description

User's real last name, family name, surname (e.g.: Smith, Einstein).

User-defined variables

Name | Value
Attribute Is Array | No
Array Dimensions |
Generate Unique as unique Index | No
Using index tablespace (for Unique) |

tce_users.user_level
General info

Entity name | tce_users
Data type | Smallint
Not null | YES
Default | 1

Description

The user's level is a numeric value that indicates which resources (pages, modules, services) are accessible by the user.

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.

User-defined variables

Name | Value
Attribute Is Array | No
Array Dimensions |
Generate Unique as unique Index | No
Using index tablespace (for Unique) |

tce_users.user_regdate
General info

Entity name | tce_users
Data type | Timestamp
Not null | YES

Description

User registration date and time relative to server clock.

User-defined variables

Name | Value
Attribute Is Array | No
Array Dimensions |
Generate Unique as unique Index | No
Using index tablespace (for Unique) |

tce_users.user_regnumber
General info

Entity name | tce_users
Data type | Varchar(n) (255)
Not null | NO

Description

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

User-defined variables

Name | Value
Attribute Is Array | No
Array Dimensions |
Generate Unique as unique Index | No
Using index tablespace (for Unique) |

tce_users.user_ssn
General info

Entity name | tce_users
Data type | Varchar(n) (255)
Not null | NO

Description

User's Social Security number (SSN) or other equivalent unique code (e.g.: Codice Fiscale for Italian users)

User-defined variables

Name | Value
Attribute Is Array | No
Array Dimensions |
Generate Unique as unique Index | No
Using index tablespace (for Unique) |

tce_users.user_verifycode
General info

Entity name | tce_users
Data type | Varchar(n) (32)
Not null | NO
Unique | YES

Description

Unique code used to verify user's email during remote registration process.

User-defined variables

Name | Value
Attribute Is Array | No
Array Dimensions |
Generate Unique as unique Index | No
Using index tablespace (for Unique) |

tce_usrgroups.group_id
General info

Entity name | tce_usrgroups
Role name | usrgrp_group_id
Data type | Bigint
Not null | YES

Description

This number represents the internal group unique ID.

User-defined variables

Name | Value
Attribute Is Array | No
Array Dimensions |
Generate Unique as unique Index | No
Using index tablespace (for Unique) |

tce_usrgroups.user_id
General info

Entity name | tce_usrgroups
Role name | usrgrp_user_id
Data type | Bigint
Not null | YES

Description

This number represents the internal user unique ID.

User-defined variables

Name | Value
Attribute Is Array | No
Array Dimensions |
Generate Unique as unique Index | No
Using index tablespace (for Unique) |