app_assign_grades

0 rows


Description

Grading information about a single assignment submission.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('app_assign_grades_id_seq'::regclass)
app_assignfeedback_comments.grade Defined in XML R
app_assignfeedback_editpdf_annot.gradeid Defined in XML R
app_assignfeedback_editpdf_cmnt.gradeid Defined in XML R
app_assignfeedback_file.grade Defined in XML R
assignment int8 19 0
app_assign.id Defined in XML R
userid int8 19 0
timecreated int8 19 0
timemodified int8 19 0
grader int8 19 0
grade numeric 10,5 √ 0
attemptnumber int8 19 0

Indexes

Constraint Name Type Sort Column(s)
app_assigrad_id_pk Primary key Asc id
app_assigrad_ass_ix Performance Asc assignment
app_assigrad_assuseatt_uix Must be unique Asc/Asc/Asc assignment + userid + attemptnumber
app_assigrad_att_ix Performance Asc attemptnumber
app_assigrad_use_ix Performance Asc userid

Relationships

Close relationships within degrees of separation