| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id | BIGINT | 19 | √ | null |
|
|
Standard Moodle primary key. |
|||||||||||||
| course | BIGINT | 19 | 0 |
|
|
Foreign key reference to the course this quiz is part of. |
||||||||||||||
| name | VARCHAR | 255 |
|
|
Quiz name. |
|||||||||||||||
| intro | LONGTEXT | 2147483647 | null |
|
|
Quiz introduction text. |
||||||||||||||
| introformat | SMALLINT | 5 | 0 |
|
|
Quiz intro text format. |
||||||||||||||
| timeopen | BIGINT | 19 | 0 |
|
|
The time when this quiz opens. (0 = no restriction.) |
||||||||||||||
| timeclose | BIGINT | 19 | 0 |
|
|
The time when this quiz closes. (0 = no restriction.) |
||||||||||||||
| timelimit | BIGINT | 19 | 0 |
|
|
The time limit for quiz attempts, in seconds. |
||||||||||||||
| overduehandling | VARCHAR | 16 | autoabandon |
|
|
The method used to handle overdue attempts. 'autosubmit', 'graceperiod' or 'autoabandon'. |
||||||||||||||
| graceperiod | BIGINT | 19 | 0 |
|
|
The amount of time (in seconds) after the time limit runs out during which attempts can still be submitted, if overduehandling is set to allow it. |
