quiz_grades

0 rows


Description

Stores the overall grade for each user on the quiz, based on their various attempts and the quiz.grademethod setting.

Columns

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

Foreign key references quiz.id.

userid BIGINT 19 0

Foreign key references user.id.

grade DECIMAL 10,5 0.00000

The overall grade from the quiz. Not affected by overrides in the gradebook.

timemodified BIGINT 19 0

The last time this grade changed.

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
quizgrad_qui_ix Performance Asc quiz
quizgrad_use_ix Performance Asc userid

Relationships