Workshop Aggregations Table Schema (workshop_aggregations)


Description

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

workshop_aggregations table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
workshopid BIGINT 19 null
workshop.id workaggr_wor2_fk R

the id of the workshop instance

userid BIGINT 19 null
user.id workaggr_use2_fk R

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.

Table contained -1 rows

workshop_aggregations table 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

workshop_aggregations table relationships