Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | BIGINT | 19 | √ | null |
|
|
||||
| submissionid | BIGINT | 19 | null |
|
|
The id of the assessed submission |
||||
| reviewerid | BIGINT | 19 | null |
|
|
The id of the reviewer who makes this assessment |
||||
| weight | BIGINT | 19 | 1 |
|
|
The weight of the assessment for the purposes of aggregation |
||||
| timecreated | BIGINT | 19 | √ | 0 |
|
|
If 0 then the assessment was allocated but the reviewer has not assessed yet. If greater than 0 then the timestamp of when the reviewer assessed for the first time |
|||
| timemodified | BIGINT | 19 | √ | 0 |
|
|
If 0 then the assessment was allocated but the reviewer has not assessed yet. If greater than 0 then the timestamp of when the reviewer assessed for the last time |
|||
| grade | DECIMAL | 10,5 | √ | null |
|
|
The aggregated grade for submission suggested by the reviewer. The grade 0..100 is computed from the values assigned to the assessment dimensions fields. If NULL then it has not been aggregated yet. |
|||
| gradinggrade | DECIMAL | 10,5 | √ | null |
|
|
The computed grade 0..100 for this assessment. If NULL then it has not been computed yet. |
|||
| gradinggradeover | DECIMAL | 10,5 | √ | null |
|
|
Grade for the assessment manually overridden by a teacher. Grade is always from interval 0..100. If NULL then the grade is not overriden. |
|||
| gradinggradeoverby | BIGINT | 19 | √ | null |
|
|
The id of the user who has overridden the grade for submission. |
|||
| LONGTEXT | 2147483647 | √ | null |
|
|
The comment/feedback from the reviewer for the author. |
||||
| SMALLINT | 5 | √ | 0 |
|
|
|||||
| SMALLINT | 5 | √ | 0 |
|
|
Are there some files attached to the feedbackauthor field? Sets to 1 by file_postupdate_standard_filemanager(). |
||||
| feedbackreviewer | LONGTEXT | 2147483647 | √ | null |
|
|
The comment/feedback from the teacher for the reviewer. For example the reason why the grade for assessment was overridden |
|||
| feedbackreviewerformat | SMALLINT | 5 | √ | 0 |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| workasse_gra2_ix | Performance | Asc | gradinggradeoverby |
| workasse_rev2_ix | Performance | Asc | reviewerid |
| workasse_sub2_ix | Performance | Asc | submissionid |
Relationships
Close relationships within degrees of separation
