Table iliasRelease_4_0_x_branch.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
starting_time varchar 14  √  null
ending_time 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

Table contained 0 rows at Wed Apr 27 19:42 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