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

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

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_fkR

Foreign key references question.id.

questioncategoryid BIGINT 19 null
question_categories.id quizslot_que4_fkR

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.

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