tst_tests

0 rows


Description

Tests in ILIAS Assessment

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
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

Indexes

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

Diagram producer might be missing

No diagrams were produced please see application output for any errors