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 10 null
instanceid bigint 10 null
grading_instances.id gradrubrfill_ins2_fk R

The ID of the grading form instance

criterionid bigint 10 null
gradingform_rubric_criteria.id gradrubrfill_cri2_fk R

The ID of the criterion (row) in the rubric

levelid bigint 10 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 2 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