Lesson Overrides Table Schema (lesson_overrides)


Description

The overrides to lesson settings.

lesson_overrides table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
lessonid BIGINT 19 0
lesson.id lessover_les2_fk R

Foreign key references lesson.id
groupid BIGINT 19 √ null
groups.id lessover_gro2_fk R

Foreign key references groups.id. Can be null if this is a per-user override.
userid BIGINT 19 √ null
user.id lessover_use2_fk R

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.

Table contained -1 rows

lesson_overrides table 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

lesson_overrides table relationships

Close relationships within degrees of separation