# 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 see https://moodledev.io/docs/apis/core/grading#grading-form-instance
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