quiz_grades

0 rows


Description

Stores the overall grade for each user on the quiz, based on

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
user.id Implied ConstraintR

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_qui2_ix Performance Asc quiz
quizgrad_use2_ix Performance Asc userid

Relationships