# workshop_aggregations

0 rows

### Description

Aggregated grades for assessment are stored here. The aggregated grade for submission is stored in workshop_submissions

### Columns

Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments
--- | --- | --- | --- | --- | --- | --- | --- | ---
id | BIGINT | 19 |  | √ | null |  |  |
workshopid | BIGINT | 19 |  |  | null |  |
workshop.id | workaggr_wor2_fkR
| the id of the workshop instance
userid | BIGINT | 19 |  |  | null |  |
user.id | workaggr_use2_fkR
| The id of the user which aggregated grades are calculated for
gradinggrade | DECIMAL | 10,5 | √ |  | null |  |  | The aggregated grade for all assessments made by this reviewer. The grade is a number from interval 0..100. If NULL then the grade for assessments has not been aggregated yet.
timegraded | BIGINT | 19 | √ |  | null |  |  | The timestamp of when the participant's gradinggrade was recently aggregated.

### Indexes

Constraint Name | Type | Sort | Column(s)
--- | --- | --- | ---
PRIMARY | Primary key | Asc | id
workaggr_use_ix | Performance | Asc | userid
workaggr_wor_ix | Performance | Asc | workshopid
workaggr_woruse_uix | Must be unique | Asc/Asc | workshopid + userid

### Relationships