tst_tests

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
test_id INT 10 0
obj_fi INT 10 0
author VARCHAR 50 √ null
introduction VARCHAR 4000 √ null
sequence_settings TINYINT 3 0
score_reporting TINYINT 3 0
instant_verification VARCHAR 1 √ 0
answer_feedback VARCHAR 1 √ 0
answer_feedback_points VARCHAR 1 √ 0
fixed_participants VARCHAR 1 √ 0
show_cancel VARCHAR 1 √ 1
anonymity VARCHAR 1 √ 0
nr_of_tries SMALLINT 5 0
use_previous_answers VARCHAR 1 √ 1
title_output VARCHAR 1 √ 0
processing_time VARCHAR 8 √ null
enable_processing_time VARCHAR 1 √ 0
reset_processing_time TINYINT 3 0
reporting_date VARCHAR 14 √ null
shuffle_questions VARCHAR 1 √ 0
ects_output VARCHAR 1 √ 0
ects_fx DOUBLE 22 √ null
complete VARCHAR 1 √ 1
ects_a DOUBLE 22 90
ects_b DOUBLE 22 65
ects_c DOUBLE 22 35
ects_d DOUBLE 22 10
ects_e DOUBLE 22 0
keep_questions TINYINT 3 0
count_system VARCHAR 1 √ 0
mc_scoring VARCHAR 1 √ 0
score_cutting VARCHAR 1 √ 0
pass_scoring VARCHAR 1 √ 0
password VARCHAR 20 √ null
allowedusers INT 10 √ null
alloweduserstimegap INT 10 √ null
results_presentation INT 10 3
show_summary INT 10 0
show_question_titles VARCHAR 1 √ 1
certificate_visibility VARCHAR 1 √ 0
show_marker TINYINT 3 0
kiosk INT 10 0
resultoutput INT 10 0
finalstatement VARCHAR 4000 √ null
showfinalstatement INT 10 0
showinfo INT 10 1
forcejs INT 10 0
customstyle VARCHAR 128 √ null
tstamp INT 10 0
created INT 10 0
mailnotification TINYINT 3 √ 0
mailnottype SMALLINT 5 0
exportsettings INT 10 0
enabled_view_mode VARCHAR 20 √ 0
template_id INT 10 √ null
pool_usage TINYINT 3 √ null
online_status TINYINT 3 0
print_bs_with_res TINYINT 3 1
offer_question_hints TINYINT 3 0
highscore_enabled INT 10 √ 0
highscore_anon INT 10 √ 0
highscore_achieved_ts INT 10 √ 0
highscore_score INT 10 √ 0
highscore_percentage INT 10 √ 0
highscore_hints INT 10 √ 0
highscore_wtime INT 10 √ 0
highscore_own_table INT 10 √ 0
highscore_top_table INT 10 √ 0
highscore_top_num INT 10 √ 0
specific_feedback INT 10 √ 0
obligations_enabled TINYINT 3 0
autosave TINYINT 3 0
autosave_ival INT 10 0
pass_deletion_allowed INT 10 0
redirection_mode INT 10 0
redirection_url VARCHAR 128 √ null
examid_in_test_pass INT 10 0
examid_in_test_res INT 10 0
enable_examview TINYINT 3 √ null
show_examview_html TINYINT 3 √ null
show_examview_pdf TINYINT 3 √ null
enable_archiving TINYINT 3 √ null
question_set_type VARCHAR 32 FIXED_QUEST_SET
sign_submission INT 10 0
char_selector_availability INT 10 0
char_selector_definition VARCHAR 4000 √ null
skill_service TINYINT 3 √ null
result_tax_filters VARCHAR 255 √ null
show_grading_status TINYINT 3 √ 0
show_grading_mark TINYINT 3 √ 0
inst_fb_answer_fixation TINYINT 3 √ null
intro_enabled TINYINT 3 √ null
starting_time_enabled TINYINT 3 √ null
ending_time_enabled TINYINT 3 √ null
password_enabled TINYINT 3 √ null
limit_users_enabled TINYINT 3 √ null
broken TINYINT 3 √ null
force_inst_fb TINYINT 3 √ 0
starting_time INT 10 0
ending_time INT 10 0
pass_waiting VARCHAR 15 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc test_id
i1_idx Performance Asc obj_fi

Diagram producer might be missing

No diagrams were produced please see application output for any errors