Assign Grades Table Schema (assign_grades)


Description

Grading information about a single assignment submission.

assign_grades table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ 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 19 0
assign.id assigrad_ass2_fk R
userid BIGINT 19 0
user.id Implied Constraint R
timecreated BIGINT 19 0

The time the assignment submission was first modified by a grader.
timemodified BIGINT 19 0

The most recent modification time for the assignment submission by a grader.
grader BIGINT 19 0
grade DECIMAL 10,5 √ 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 19 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

Close relationships within degrees of separation