Quiz Slots Table Schema (quiz_slots)


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

Foreign key references question.id.

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_que_ix Performance Asc questionid
quizslot_qui_ix Performance Asc quizid
quizslot_quislo_ix Performance Asc/Asc quizid + slot

quiz_slots table relationships