Quiz Overrides Table Schema (quiz_overrides)


Description

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

quiz_overrides table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
quiz BIGINT 19 0
quiz.id quizover_qui2_fk R

Foreign key references quiz.id
groupid BIGINT 19 √ null
groups.id quizover_gro2_fk R

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

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.

Table contained -1 rows

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

quiz_overrides table relationships

Close relationships within degrees of separation