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 10 null
quiz bigint 10 0
quiz.id quizover_qui2_fk R

Foreign key references quiz.id

groupid bigint 10 null
groups.id quizover_gro2_fk R

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

userid bigint 10 null
user.id quizover_use2_fk R

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

timeopen bigint 10 null

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

timeclose bigint 10 null

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

timelimit bigint 10 null

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

attempts mediumint 6 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