app_workshop_assessments

0 rows


Description

Info about the made assessment and automatically calculated grade for it. The proposed grade can be overridden by teacher.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('app_workshop_assessments_id_seq'::regclass)
app_workshop_comments_old.assessmentid Defined in XMLR
app_workshop_grades.assessmentid Defined in XMLR
app_workshop_grades_old.assessmentid Defined in XMLR
submissionid int8 19 null
app_workshop_submissions.id Defined in XMLR
reviewerid int8 19 null
app_user.id Defined in XMLR
weight int8 19 1
timecreated int8 19 √ 0
timemodified int8 19 √ 0
grade numeric 10,5 √ null
gradinggrade numeric 10,5 √ null
gradinggradeover numeric 10,5 √ null
gradinggradeoverby int8 19 √ null
app_user.id Defined in XMLR
feedbackauthor text 2147483647 √ null
feedbackauthorformat int2 5 √ 0
feedbackauthorattachment int2 5 √ 0
feedbackreviewer text 2147483647 √ null
feedbackreviewerformat int2 5 √ 0

Indexes

Constraint Name Type Sort Column(s)
app_workasse_id_pk Primary key Asc id
app_workasse_gra_ix Performance Asc gradinggradeoverby
app_workasse_rev_ix Performance Asc reviewerid
app_workasse_sub_ix Performance Asc submissionid

Relationships

Close relationships within degrees of separation