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 |