quiz_slots

0 rows


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

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_qui3_fkR

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.

displaynumber VARCHAR 16 null

Stores customised question number such as 1.2, A1, B12. If this is null, the default number is used.

requireprevious SMALLINT 5 0

Set to 1 when current question requires previous one to be answered first.

maxmark DECIMAL 12,7 0.0000000

How many marks this question contributes to quiz.sumgrades.

quizgradeitemid BIGINT 19 null
quiz_grade_items.id quizslot_qui4_fkR

If the quiz suports multiple sub-grades, which one this slot contributes, if any.

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
quizslot_qui2_ix Performance Asc quizgradeitemid
quizslot_qui_ix Performance Asc quizid
quizslot_quislo_uix Must be unique Asc/Asc quizid + slot

Relationships