grading_instances

0 rows


Description

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

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
gradingform_guide_fillings.instanceid gradguidfill_ins2_fkR
gradingform_rubric_fillings.instanceid gradrubrfill_ins2_fkR
definitionid BIGINT 19 null
grading_definitions.id gradinst_def2_fkR

The ID of the form definition this is instance of

raterid BIGINT 19 null
user.id gradinst_rat2_fkR

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

Indexes

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

Relationships