Entities

It appears that you are using AdBlocking software. The cost of running this website is covered by advertisements. If you like it please feel free to a small amount of money to secure the future of this website.

Entity ‘tce_answers’

General info

Entity type:independent

Attributes

KeyAttribute/role nameData typeNot nullUniqueNotes
PKanswer_idBigSerialYESNO
FKquestion_id/answer_question_idBigintYESNO
answer_descriptionTextYESNOThis text may contain special markup tags for formatting and image linking.
answer_explanationTextNONOThis field must be displayed only on results.
answer_isrightBooleanYESNO
answer_enabledBooleanYESNOOnly enabled answers may be evaluated during test generation for a specific user.
answer_positionBigintNONOThis 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.
answer_keyboard_keyBigintNONO

Relationships

Relationship nameTypeParent entityChild entityCard.
rel_question_answersNon-identifyingtce_questionstce_answers1:N
rel_answer_logsIdentifyingtce_answerstce_tests_logs_answers1:N

Alternative keys

NameAttributes
ak_answerquestion_id, answer_description, answer_position

Notes

Each question may have an unlimited number of answers and at least one of these must be right.

User-defined variables

NameValue
Temporary TableNo
Inherited Tables
Without OIDsYes
Schema
Tablespace
Using index tablespace (for Primary key)



Entity ‘tce_modules’

General info

Entity type:independent

Attributes

KeyAttribute/role nameData typeNot nullUniqueNotes
PKmodule_idBigSerialYESNO
module_nameVarchar(n) (255)YESYES
module_enabledChar (20)YESNOOnly enabled modules can be used for a new test.
FKmodule_id/module_user_idBigintYESNO

Relationships

Relationship nameTypeParent entityChild entityCard.
rel_module_subjectsNon-identifyingtce_modulestce_subjects1:N
rel_module_authorNon-identifyingtce_userstce_modules1:N

Alternative keys

NameAttributes
ak_module_namemodule_name

User-defined variables

NameValue
Temporary TableNo
Inherited Tables
Without OIDsNo
Schema
Tablespace
Using index tablespace (for Primary key)



Entity ‘tce_questions’

General info

Entity type:independent

Attributes

KeyAttribute/role nameData typeNot nullUniqueNotes
PKquestion_idBigSerialYESNO
FKsubject_id/question_subject_idBigintYESNO
question_descriptionTextYESNOThis text may contain special markup tags for formatting and image linking.
question_explanationTextNONOThis field must be displayed only on results.
question_typeSmallintYESNO
question_difficultySmallintYESNOHigher values represent questions with an high grade of difficulty.
question_enabledBooleanYESNOOnly enabled questions may be evaluated during test generation for a specific user.
question_positionBigintNONOThis order is used when test_random_questions_select and test_random_questions_order are both set to false.
question_timerSmallintNONO
question_fullscreenBooleanYESNO
question_inline_answersBooleanYESNO
question_auto_nextBooleanNONO

Relationships

Relationship nameTypeParent entityChild entityCard.
rel_subject_questionsNon-identifyingtce_subjectstce_questions1:N
rel_question_answersNon-identifyingtce_questionstce_answers1:N
rel_question_logsNon-identifyingtce_questionstce_tests_logs1:N

Alternative keys

NameAttributes
ak_questionsubject_id, question_description

Notes

Each subject may have an unlimited number of questions.

User-defined variables

NameValue
Temporary TableNo
Inherited Tables
Without OIDsYes
Schema
Tablespace
Using index tablespace (for Primary key)



Entity ‘tce_sessions’

General info

Entity type:independent

Attributes

KeyAttribute/role nameData typeNot nullUniqueNotes
PKcpsession_idVarchar(n) (32)YESNOSession 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.
cpsession_expiryTimestampYESNOThis information is used to close the user’s session automatically, if there has been no session-related activity for the prescribed amount of time.
cpsession_dataTextYESNOIn PHP this information may be encoded/decoded using the session_encode/session_decode functions.

Relationships

Relationship nameTypeParent entityChild entityCard.
session_dataInformativetce_userstce_sessions1:N

Notes

The basic idea behind web session management is that the server generates a session identifier (ID) at some early point in user interaction, sends this ID to the user’s browser and makes sure that this same ID will be sent back by the browser along with each subsequent request. Session IDs thereby become 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

NameValue
Temporary TableNo
Inherited Tables
Without OIDsYes
Schema
Tablespace
Using index tablespace (for Primary key)



Entity ‘tce_subjects’

General info

Entity type:independent

Attributes

KeyAttribute/role nameData typeNot nullUniqueNotes
PKsubject_idBigSerialYESNO
subject_nameVarchar(n) (255)YESNO
subject_descriptionTextNONOThis text may contain special markup tags for formatting and image linking.
subject_enabledBooleanYESNOOnly enabled subjects can be used for a new test.
FKmodule_id/subject_user_idBigintYESNO
FKmodule_id/subject_module_idBigintYESNO

Relationships

Relationship nameTypeParent entityChild entityCard.
rel_subject_questionsNon-identifyingtce_subjectstce_questions1:N
rel_subject_setIdentifyingtce_subjectstce_test_subjects1:N
rel_subject_authorNon-identifyingtce_userstce_subjects1:N
rel_module_subjectsNon-identifyingtce_modulestce_subjects1:N

Alternative keys

NameAttributes
ak_subject_namemodule_id, subject_name

User-defined variables

NameValue
Temporary TableNo
Inherited Tables
Without OIDsYes
Schema
Tablespace
Using index tablespace (for Primary key)



Entity ‘tce_test_subject_set’

General info

Entity type:independent

Attributes

KeyAttribute/role nameData typeNot nullUnique
PKtsubset_idBigSerialYESNO
FKtest_id/tsubset_test_idBigintYESNO
tsubset_typeSmallintYESNO
tsubset_difficultySmallintYESNO
tsubset_quantitySmallintYESNO
tsubset_answersSmallintYESNO

Relationships

Relationship nameTypeParent entityChild entityCard.
rel_test_subjsetNon-identifyingtce_teststce_test_subject_set1:N
rel_set_subjectsIdentifyingtce_test_subject_settce_test_subjects1:N

User-defined variables

NameValue
Temporary TableNo
Inherited Tables
Without OIDsNo
Schema
Tablespace
Using index tablespace (for Primary key)



Entity ‘tce_test_subjects’

General info

Entity type:dependent

Attributes

KeyAttribute/role nameData typeNot nullUnique
PFKtsubset_id/subjset_tsubset_idBigintYESNO
PFKsubject_id/subjset_subject_idBigintYESNO

Relationships

Relationship nameTypeParent entityChild entityCard.
rel_subject_setIdentifyingtce_subjectstce_test_subjects1:N
rel_set_subjectsIdentifyingtce_test_subject_settce_test_subjects1:N

User-defined variables

NameValue
Temporary TableNo
Inherited Tables
Without OIDsYes
Schema
Tablespace
Using index tablespace (for Primary key)



Entity ‘tce_testgroups’

General info

Entity type:dependent

Attributes

KeyAttribute/role nameData typeNot nullUnique
PFKtest_id/tstgrp_test_idBigintYESNO
PFKgroup_id/tstgrp_group_idBigintYESNO

Relationships

Relationship nameTypeParent entityChild entityCard.
rel_test_groupIdentifyingtce_teststce_testgroups1:N
rel_group_testIdentifyingtce_user_groupstce_testgroups1:N

User-defined variables

NameValue
Temporary TableNo
Inherited Tables
Without OIDsNo
Schema
Tablespace
Using index tablespace (for Primary key)



Entity ‘tce_tests’

General info

Entity type:independent

Attributes

KeyAttribute/role nameData typeNot nullUniqueNotes
PKtest_idBigSerialYESNO
test_nameVarchar(n) (255)YESNO
test_descriptionTextYESNOThis text may contain special markup tags for formatting and image linking.
test_begin_timeTimestampNONO
test_end_timeTimestampNONO
test_duration_timeSmallintYESNOOnce started, the test will have to be completed within the specified amount of time.
test_ip_rangeVarchar(n) (255)YESNOThis 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.).
test_results_to_usersBooleanYESNO
test_report_to_usersBooleanNONO
test_score_rightNumeric(p,s) (10,3)NONO
test_score_wrongNumeric(p,s) (10,3)NONO
test_score_unansweredNumeric(p,s) (10,3)NONO
test_max_scoreNumeric(p,s) (10,3)YESNO
FKmodule_id/test_user_idBigintYESNOOnly the administrator and the author of the test (or his/her group) may update/delete the test.
test_score_thresholdNumeric(p,s) (10,3)NONO
test_random_questions_selectBooleanYESNO
test_random_questions_orderBooleanYESNO
test_questions_order_modeSmallintYESNO
test_random_answers_selectBooleanYESNO
test_random_answers_orderBooleanYESNO
test_answers_order_modeSmallintYESNO
test_comment_enabledBooleanYESNO
test_menu_enabledBooleanYESNO
test_noanswer_enabledBooleanYESNO
test_mcma_radioBooleanYESNO
test_repeatableBooleanYESNO
test_mcma_partial_scoreBooleanYESNO
test_logout_on_timeoutBooleanYESNO
test_passwordVarchar(n) (255)NONO

Relationships

Relationship nameTypeParent entityChild entityCard.
rel_test_usersNon-identifyingtce_teststce_tests_users1:N
rel_test_authorNon-identifyingtce_userstce_tests1:N
rel_test_groupIdentifyingtce_teststce_testgroups1:N
rel_test_subjsetNon-identifyingtce_teststce_test_subject_set1:N

Alternative keys

NameAttributes
ak_test_nametest_name

Notes

Tests can contain several topics (subjects).
You cannot modify a test that has already performed.
When a test is deleted, so they are all its logs.

User-defined variables

NameValue
Temporary TableNo
Inherited Tables
Without OIDsYes
Schema
Tablespace
Using index tablespace (for Primary key)



Entity ‘tce_tests_logs’

General info

Entity type:independent

Attributes

KeyAttribute/role nameData typeNot nullUniqueNotes
PKtestlog_idBigSerialYESNO
FKtestuser_id/testlog_testuser_idBigintYESNO
testlog_user_ipVarchar(n) (39)NONO
FKquestion_id/testlog_question_idBigintYESNO
testlog_answer_textTextNONOThis will be set only if the question is free-answer type.
testlog_scoreNumeric(p,s) (10,3)NONOThis score may be automatically calculated in case of multiple-choice question, otherwise may be manually set.
testlog_creation_timeTimestampNONO
testlog_display_timeTimestampNONO
testlog_change_timeTimestampNONO
testlog_reaction_timeBigintNONO
testlog_orderSmallintYESNO
testlog_num_answersSmallintYESNO
testlog_commentTextNONO

Relationships

Relationship nameTypeParent entityChild entityCard.
rel_question_logsNon-identifyingtce_questionstce_tests_logs1:N
rel_testuser_logsNon-identifyingtce_tests_userstce_tests_logs1:N
rel_testlog_answersIdentifyingtce_tests_logstce_tests_logs_answers1:N

Alternative keys

NameAttributes
ak_testuser_questiontestuser_id, question_id

Notes

All tuples (rows) are created during test creation process (when user request to execute a specific test).
The tuples are updated when user answer questions.

User-defined variables

NameValue
Temporary TableNo
Inherited Tables
Without OIDsYes
Schema
Tablespace
Using index tablespace (for Primary key)



Entity ‘tce_tests_logs_answers’

General info

Entity type:dependent

Attributes

KeyAttribute/role nameData typeNot nullUniqueNotes
PFKtestlog_id/logansw_testlog_idBigintYESNO
PFKanswer_id/logansw_answer_idBigintYESNO
logansw_selectedSmallintYESNO
logansw_orderSmallintYESNOThis avoid an automatic ordering problem that happens in MySQL
logansw_positionBigintNONOThis field is used only for ordering questions.

Relationships

Relationship nameTypeParent entityChild entityCard.
rel_answer_logsIdentifyingtce_answerstce_tests_logs_answers1:N
rel_testlog_answersIdentifyingtce_tests_logstce_tests_logs_answers1:N

User-defined variables

NameValue
Temporary TableNo
Inherited Tables
Without OIDsYes
Schema
Tablespace
Using index tablespace (for Primary key)



Entity ‘tce_tests_users’

General info

Entity type:independent

Attributes

KeyAttribute/role nameData typeNot nullUniqueNotes
PKtestuser_idBigSerialYESNO
FKtest_id/testuser_test_idBigintYESNO
FKmodule_id/testuser_user_idBigintYESNO
testuser_statusSmallintYESNOTCExam 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);
testuser_creation_timeTimestampYESNO
testuser_commentTextNONO

Relationships

Relationship nameTypeParent entityChild entityCard.
rel_user_testsNon-identifyingtce_userstce_tests_users1:N
rel_test_usersNon-identifyingtce_teststce_tests_users1:N
rel_testuser_logsNon-identifyingtce_tests_userstce_tests_logs1:N

Alternative keys

NameAttributes
ak_testusertest_id, module_id

User-defined variables

NameValue
Temporary TableNo
Inherited Tables
Without OIDsYes
Schema
Tablespace
Using index tablespace (for Primary key)



Entity ‘tce_user_groups’

General info

Entity type:independent

Attributes

KeyAttribute/role nameData typeNot nullUnique
PKgroup_idBigSerialYESNO
group_nameVarchar(n) (255)YESYES

Relationships

Relationship nameTypeParent entityChild entityCard.
rel_group_userIdentifyingtce_user_groupstce_usrgroups1:N
rel_group_testIdentifyingtce_user_groupstce_testgroups1:N

User-defined variables

NameValue
Temporary TableNo
Inherited Tables
Without OIDsNo
Schema
Tablespace
Using index tablespace (for Primary key)



Entity ‘tce_users’

General info

Entity type:independent

Attributes

KeyAttribute/role nameData typeNot nullUniqueNotes
PKmodule_idBigintYESNO
user_nameVarchar(n) (255)YESNO
user_passwordVarchar(n) (255)YESNOPasswords are encrypted by a one way algorithm (MD5).
user_emailVarchar(n) (255)NONO
user_regdateTimestampYESNO
user_ipVarchar(n) (39)YESNO
user_firstnameVarchar(n) (255)NONO
user_lastnameVarchar(n) (255)NONO
user_birthdateDateNONO
user_birthplaceVarchar(n) (255)NONO
user_regnumberVarchar(n) (255)NONO
user_ssnVarchar(n) (255)NONO
user_levelSmallintYESNOTo 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_verifycodeVarchar(n) (32)NOYES
user_otpkeyVarchar(n) (255)NONO

Relationships

Relationship nameTypeParent entityChild entityCard.
rel_user_testsNon-identifyingtce_userstce_tests_users1:N
session_dataInformativetce_userstce_sessions1:N
rel_test_authorNon-identifyingtce_userstce_tests1:N
rel_subject_authorNon-identifyingtce_userstce_subjects1:N
rel_user_groupIdentifyingtce_userstce_usrgroups1:N
rel_module_authorNon-identifyingtce_userstce_modules1:N

Alternative keys

NameAttributes
ak_user_nameuser_name
ak_user_regnumberuser_regnumber
ak_user_ssnuser_ssn

Notes

Just the registered users granted with a username and a password are entitled to access the restricted areas of TCExam and the public area to perform the tests.
It is possible to specify different access levels for users to gain access to a specific resource (pages, forms, sections). The user’s level must be equal or greater to the one specified for the requested resource.

User-defined variables

NameValue
Temporary TableNo
Inherited Tables
Without OIDsYes
Schema
Tablespace
Using index tablespace (for Primary key)



Entity ‘tce_usrgroups’

General info

Entity type:dependent

Attributes

KeyAttribute/role nameData typeNot nullUnique
PFKmodule_id/usrgrp_user_idBigintYESNO
PFKgroup_id/usrgrp_group_idBigintYESNO

Relationships

Relationship nameTypeParent entityChild entityCard.
rel_user_groupIdentifyingtce_userstce_usrgroups1:N
rel_group_userIdentifyingtce_user_groupstce_usrgroups1:N

User-defined variables

NameValue
Temporary TableNo
Inherited Tables
Without OIDsNo
Schema
Tablespace
Using index tablespace (for Primary key)

 

© 2004-2017 – Nicola Asuni - Tecnick.com - All rights reserved.
about - disclaimer - privacy