Quiz Slots Table Schema (quiz_slots)


Description

Stores the question used in a quiz, with the order, and for each question, which page it appears on, and the maximum mark (weight).

quiz_slots table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
quiz_slot_tags.slotid quizslottags_slo2_fk R
slot BIGINT 19 null

Where this question comes in order in the list of questions in this quiz. Like question_attempts.slot.
quizid BIGINT 19 0
quiz.id quizslot_qui2_fk R

Foreign key references quiz.id.
page BIGINT 19 null

The page number that this questions appears on. If the question in slot n appears on page p, then the question in slot n+1 must appear on page p or p+1. Well, except that when a quiz is being created, there may be empty pages, which would cause the page number to jump here.
requireprevious SMALLINT 5 0

Set to 1 when current question requires previous one to be answered first.
questionid BIGINT 19 0
question.id quizslot_que3_fk R

Foreign key references question.id.
questioncategoryid BIGINT 19 √ null
question_categories.id quizslot_que4_fk R

The question category that the random question will be picked from. Will be null if and only if the question is not a random question.
includingsubcategories SMALLINT 5 √ null

Whether the random question can be picked from sub categories or not. Will be null if questioncategoryid is null.
maxmark DECIMAL 12,7 0.0000000

How many marks this question contributes to quiz.sumgrades.

Table contained -1 rows

quiz_slots table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
quizslot_que2_ix Performance Asc questioncategoryid
quizslot_que_ix Performance Asc questionid
quizslot_qui_ix Performance Asc quizid
quizslot_quislo_uix Must be unique Asc/Asc quizid + slot

quiz_slots table relationships

Close relationships within degrees of separation