quiz_sections

0 rows


Description

Stores sections of a quiz with section name (heading), from

Columns

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

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.

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

Relationships