Quiz Sections Table Schema (quiz_sections)


Description

Stores sections of a quiz with section name (heading), from slot-number N and whether the question order should be shuffled.

quiz_sections table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
quizid BIGINT 19 null
quiz.id quizsect_qui2_fk R

Foreign key references quiz.id.
firstslot BIGINT 19 null

Number of the first slot in the section. The section runs from here to the start of the next section, or the end of the quiz.
heading VARCHAR 1333 √ null

The text of the heading. May be an empty string/null. Multilang format.
shufflequestions SMALLINT 5 0

Whether the question order within this section should be shuffled for each attempt.

Table contained -1 rows

quiz_sections table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
quizsect_qui_ix Performance Asc quizid
quizsect_quifir_uix Must be unique Asc/Asc quizid + firstslot

quiz_sections table relationships

Close relationships within degrees of separation