workshop_aggregations

0 rows


Description

Aggregated grades for assessment are stored here. The aggreg

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
workshopid BIGINT 19 null
workshop.id workaggr_wor2_fkR
userid BIGINT 19 null
user.id workaggr_use2_fkR
gradinggrade DECIMAL 10,5 √ null
timegraded BIGINT 19 √ null

Indexes

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

Relationships

Close relationships within degrees of separation