Quiz Grades Table Schema (quiz_grades)


Description

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

quiz_grades table columns

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

Foreign key references quiz.id.
userid BIGINT 19 0
user.id Implied Constraint R

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.

Table contained -1 rows

quiz_grades table indexes

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

quiz_grades table relationships

Close relationships within degrees of separation