app_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 bigserial 19 √ nextval('app_workshop_aggregations_id_seq'::regclass)
workshopid int8 19 null
app_workshop.id Defined in XML R
userid int8 19 null
app_user.id Defined in XML R
gradinggrade numeric 10,5 √ null
timegraded int8 19 √ null

Indexes

Constraint Name Type Sort Column(s)
app_workaggr_id_pk Primary key Asc id
app_workaggr_use_ix Performance Asc userid
app_workaggr_wor_ix Performance Asc workshopid
app_workaggr_woruse_uix Must be unique Asc/Asc workshopid + userid

Relationships

Close relationships within degrees of separation