Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
---|---|---|---|---|---|---|---|---|---|---|
id | BIGINT | 19 | √ | null |
|
|
||||
quizid | BIGINT | 19 | null |
|
|
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 |