Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| test_id | INT | 10 | 0 |
|
|
|||
| obj_fi | INT | 10 | 0 |
|
|
|||
| 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