# workshop_assessments

0 rows

### Description

Info about the made assessment and automatically calculated grade for it. The proposed grade can be overridden by teacher.

### Columns

Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments
--- | --- | --- | --- | --- | --- | --- | --- | ---
id | BIGINT | 19 |  | √ | null |
workshop_grades.assessmentid | workgrad_ass2_fkR
submissionid | BIGINT | 19 |  |  | null |  |
workshop_submissions.id | workasse_sub2_fkR
| The id of the assessed submission
reviewerid | BIGINT | 19 |  |  | null |  |
user.id | workasse_rev2_fkR
| 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 |  |
user.id | workasse_gra2_fkR
| The id of the user who has overridden the grade for submission.
feedbackauthor | LONGTEXT | 2147483647 | √ |  | null |  |  | The comment/feedback from the reviewer for the author.
feedbackauthorformat | SMALLINT | 5 | √ |  | 0 |  |  |
feedbackauthorattachment | 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_gra_ix | Performance | Asc | gradinggradeoverby
workasse_rev_ix | Performance | Asc | reviewerid
workasse_sub_ix | Performance | Asc | submissionid

### Relationships