# quiz_overrides

0 rows

### Description

The overrides to quiz settings on a per-user and per-group basis.

### Columns

Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments
--- | --- | --- | --- | --- | --- | --- | --- | ---
id | BIGINT | 19 |  | √ | null |  |  |
quiz | BIGINT | 19 |  |  | 0 |  |
quiz.id | quizover_qui2_fkR
| Foreign key references quiz.id
groupid | BIGINT | 19 | √ |  | null |  |
groups.id | quizover_gro2_fkR
| Foreign key references groups.id. Can be null if this is a per-user override.
userid | BIGINT | 19 | √ |  | null |  |
user.id | quizover_use2_fkR
| Foreign key references user.id. Can be null if this is a per-group override.
timeopen | BIGINT | 19 | √ |  | null |  |  | Time at which students may start attempting this quiz. Can be null, in which case the quiz default is used.
timeclose | BIGINT | 19 | √ |  | null |  |  | Time by which students must have completed their attempt. Can be null, in which case the quiz default is used.
timelimit | BIGINT | 19 | √ |  | null |  |  | Time limit in seconds. Can be null, in which case the quiz default is used.
attempts | MEDIUMINT | 7 | √ |  | null |  |  |
password | VARCHAR | 255 | √ |  | null |  |  | Quiz password. Can be null, in which case the quiz default is used.

### Indexes

Constraint Name | Type | Sort | Column(s)
--- | --- | --- | ---
PRIMARY | Primary key | Asc | id
quizover_gro_ix | Performance | Asc | groupid
quizover_qui_ix | Performance | Asc | quiz
quizover_use_ix | Performance | Asc | userid

### Relationships