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_qui2_ix | Performance | Asc | quizid |
| quizsect_quifir2_uix | Must be unique | Asc/Asc | quizid + firstslot |
Relationships
Close relationships within degrees of separation
