quiz_overrides

0 rows


Description

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

Columns

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

Foreign key references quiz.id

groupid BIGINT 19 null
groups.id quizover_gro2_fkR

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

userid BIGINT 19 null
user.id quizover_use2_fkR

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.

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

Relationships