Assign Grades Table Schema (assign_grades)


Grading information about a single assignment submission.

assign_grades table columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigint 10 null
assignfeedback_comments.grade assicomm_gra2_fk R
assignfeedback_editpdf_annot.gradeid assieditanno_gra2_fk R
assignfeedback_editpdf_cmnt.gradeid assieditcmnt_gra2_fk R
assignfeedback_file.grade assifile_gra2_fk R
assignment bigint 10 0 assigrad_ass2_fk R
userid bigint 10 0 Implied Constraint R
timecreated bigint 10 0

The time the assignment submission was first modified by a grader.

timemodified bigint 10 0

The most recent modification time for the assignment submission by a grader.

grader bigint 10 0
grade decimal 10 0.00000

The numerical grade for this assignment submission. Can be determined by scales/advancedgradingforms etc but will always be converted back to a floating point number.

attemptnumber bigint 10 0

The attempt number that this grade relates to

Table contained -1 rows

assign_grades table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
assigrad_ass_ix Performance Asc assignment
assigrad_assuseatt_uix Must be unique Asc/Asc/Asc assignment + userid + attemptnumber
assigrad_att_ix Performance Asc attemptnumber
assigrad_use_ix Performance Asc userid

assign_grades table relationships