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