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 10 null
lessonid bigint 10 0
lesson.id lessover_les2_fk R

Foreign key references lesson.id

groupid bigint 10 null
groups.id lessover_gro2_fk R

Foreign key references groups.id. Can be null if this is a per-user override.

userid bigint 10 null
user.id lessover_use2_fk R

Foreign key references user.id. Can be null if this is a per-group override.

available bigint 10 null

Time at which students may start attempting this lesson. Can be null, in which case the lesson default is used.

deadline bigint 10 null

Time by which students must have completed their attempt. Can be null, in which case the lesson default is used.

timelimit bigint 10 null

Time limit in seconds. Can be null, in which case the lesson default is used.

review smallint 3 null
maxattempts smallint 3 null
retake smallint 3 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