Table ilias4_3.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
random_test varchar 1  √  0
keep_questions tinyint 3 0
random_question_count int 10  √  null
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

Table contained 0 rows at Sun May 01 00:15 CEST 2016

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