app_workshop_submissions

0 rows


Description

Info about the submission and the aggregation of the grade for submission, grade for assessment and final grade. Both grade for submission and grade for assessment can be overridden by teacher. Final grade is always the sum of them. All grades are st

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('app_workshop_submissions_id_seq'::regclass)
app_workshop_assessments.submissionid Defined in XMLR
workshopid int8 19 null
app_workshop.id Defined in XMLR
example int2 5 √ 0
authorid int8 19 null
app_user.id Defined in XMLR
timecreated int8 19 null
timemodified int8 19 null
title varchar 255 ''::character varying
content text 2147483647 √ null
contentformat int2 5 0
contenttrust int2 5 0
attachment int2 5 √ 0
grade numeric 10,5 √ null
gradeover numeric 10,5 √ null
gradeoverby int8 19 √ null
app_user.id Defined in XMLR
feedbackauthor text 2147483647 √ null
feedbackauthorformat int2 5 √ 0
timegraded int8 19 √ null
published int2 5 √ 0
late int2 5 0

Indexes

Constraint Name Type Sort Column(s)
app_worksubm_id_pk Primary key Asc id
app_worksubm_aut_ix Performance Asc authorid
app_worksubm_gra_ix Performance Asc gradeoverby
app_worksubm_wor_ix Performance Asc workshopid

Relationships

Close relationships within degrees of separation