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

Close relationships within degrees of separation