quiz_slots

0 rows


Description

Stores the question used in a quiz, with the order, and for

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
quiz_slot_tags.slotid quizslottags_slo2_fkR
slot BIGINT 19 null
quizid BIGINT 19 0
quiz.id quizslot_qui2_fkR
page BIGINT 19 null
requireprevious SMALLINT 5 0
questionid BIGINT 19 0
question.id quizslot_que3_fkR
questioncategoryid BIGINT 19 √ null
question_categories.id quizslot_que4_fkR
includingsubcategories SMALLINT 5 √ null
maxmark DECIMAL 12,7 0.0000000

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
quizslot_que6_ix Performance Asc questionid
quizslot_que8_ix Performance Asc questioncategoryid
quizslot_qui4_ix Performance Asc quizid
quizslot_quislo2_uix Must be unique Asc/Asc quizid + slot

Relationships

Close relationships within degrees of separation