0 rows


Aggregated grades for assessment are stored here. The aggreg


Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
workshopid BIGINT 19 null workaggr_wor2_fkR

the id of the workshop instance

userid BIGINT 19 null 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.


Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
workaggr_use4_ix Performance Asc userid
workaggr_wor4_ix Performance Asc workshopid
workaggr_woruse2_uix Must be unique Asc/Asc workshopid + userid