Grading Instances Table Schema (grading_instances)


Description

Grading form instance is an assessment record for one gradable item assessed by one rater

grading_instances table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
gradingform_guide_fillings.instanceid gradguidfill_ins2_fk R
gradingform_rubric_fillings.instanceid gradrubrfill_ins2_fk R
definitionid BIGINT 19 null
grading_definitions.id gradinst_def2_fk R

The ID of the form definition this is instance of
raterid BIGINT 19 null
user.id gradinst_rat2_fk R

The ID of the user who did the assessment
itemid BIGINT 19 √ null

This identifies the graded item within the grabable area
rawgrade DECIMAL 10,5 √ null

The raw normalized grade 0.00000 - 100.00000 as a result of the most recent assessment
status BIGINT 19 0

The status of the assessment. By default the instance is under-assessment state
feedback LONGTEXT 2147483647 √ null

Overall feedback from the rater for the author of the graded item
feedbackformat TINYINT 3 √ null

The format of the feedback field
timemodified BIGINT 19 null

The timestamp of when the assessment was most recently modified

Table contained -1 rows

grading_instances table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
gradinst_def_ix Performance Asc definitionid
gradinst_rat_ix Performance Asc raterid

grading_instances table relationships

Close relationships within degrees of separation