Gradingform Guide Fillings Table Schema (gradingform_guide_fillings)


Description

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

gradingform_guide_fillings table columns

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

The ID of the grading form instance
criterionid BIGINT 19 null
gradingform_guide_criteria.id gradguidfill_cri2_fk R

The ID of the criterion (row) in the guide
remark LONGTEXT 2147483647 √ null

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

The format of the remark field
score DECIMAL 10,5 null

The score assigned

Table contained -1 rows

gradingform_guide_fillings table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
gradguidfill_cri_ix Performance Asc criterionid
gradguidfill_ins_ix Performance Asc instanceid
gradguidfill_inscri_uix Must be unique Asc/Asc instanceid + criterionid

gradingform_guide_fillings table relationships

Close relationships within degrees of separation