Gradingform Rubric Fillings Table Schema (gradingform_rubric_fillings)


Description

Stores the data of how the rubric is filled by a particular rater

gradingform_rubric_fillings table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
instanceid BIGINT 19 null
grading_instances.id gradrubrfill_ins2_fk R

The ID of the grading form instance
criterionid BIGINT 19 null
gradingform_rubric_criteria.id gradrubrfill_cri2_fk R

The ID of the criterion (row) in the rubric
levelid BIGINT 19 √ null

If a particular level was selected during the assessment, its ID is stored here
remark LONGTEXT 2147483647 √ null

Side note feedback regarding this particular criterion
remarkformat TINYINT 3 √ null

The format of the remark field

Table contained -1 rows

gradingform_rubric_fillings table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
gradrubrfill_cri_ix Performance Asc criterionid
gradrubrfill_ins_ix Performance Asc instanceid
gradrubrfill_inscri_uix Must be unique Asc/Asc instanceid + criterionid
gradrubrfill_lev_ix Performance Asc levelid

gradingform_rubric_fillings table relationships

Close relationships within degrees of separation