Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id | BIGINT | 19 | √ | null |
|
|
||||||
| definitionid | BIGINT | 19 | null |
|
|
The ID of the form definition this is instance of |
||||||
| raterid | BIGINT | 19 | null |
|
|
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 |