Table ilias5_1.tst_tests
Tests in ILIAS Assessment

Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
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
starting_time varchar 14  √  null
ending_time varchar 14  √  null
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

Table contained 0 rows at Di Mai 22 20:26 GMT+01:00 2018

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