# lesson_overrides

0 rows

### Description

The overrides to lesson settings.

### Columns

Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments
--- | --- | --- | --- | --- | --- | --- | --- | ---
id | BIGINT | 19 |  | √ | null |  |  |
lessonid | BIGINT | 19 |  |  | 0 |  |
lesson.id | lessover_les2_fkR
| Foreign key references lesson.id
groupid | BIGINT | 19 | √ |  | null |  |
groups.id | lessover_gro2_fkR
| Foreign key references groups.id. Can be null if this is a per-user override.
userid | BIGINT | 19 | √ |  | null |  |
user.id | lessover_use2_fkR
| Foreign key references user.id. Can be null if this is a per-group override.
available | BIGINT | 19 | √ |  | null |  |  | Time at which students may start attempting this lesson. Can be null, in which case the lesson default is used.
deadline | BIGINT | 19 | √ |  | null |  |  | Time by which students must have completed their attempt. Can be null, in which case the lesson default is used.
timelimit | BIGINT | 19 | √ |  | null |  |  | Time limit in seconds. Can be null, in which case the lesson default is used.
review | SMALLINT | 5 | √ |  | null |  |  |
maxattempts | SMALLINT | 5 | √ |  | null |  |  |
retake | SMALLINT | 5 | √ |  | null |  |  |
password | VARCHAR | 32 | √ |  | null |  |  | Lesson password. Can be null, in which case the lesson default is used.
reason | LONGTEXT | 2147483647 | √ |  | null |  |  | An optional reason explaining why this override was granted.
reasonformat | TINYINT | 3 |  |  | 0 |  |  | The internal format for the override reason.

### Indexes

Constraint Name | Type | Sort | Column(s)
--- | --- | --- | ---
PRIMARY | Primary key | Asc | id
lessover_gro_ix | Performance | Asc | groupid
lessover_les_ix | Performance | Asc | lessonid
lessover_use_ix | Performance | Asc | userid

### Relationships