Gradingform Rubric Fillings Table Schema (gradingform_rubric_fillings)


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 gradrubrfill_ins2_fk R

The ID of the grading form instance

criterionid BIGINT 19 null 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