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