# quiz_sections

0 rows

### Description

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

### 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