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.

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