Workshop Grades Table Schema (workshop_grades)


Description

How the reviewers filled-up the grading forms, given grades and comments

workshop_grades table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
assessmentid BIGINT 19 null
workshop_assessments.id workgrad_ass2_fk R

Part of which assessment this grade is of
strategy VARCHAR 30
dimensionid BIGINT 19 null

Foreign key. References dimension id in one of the grading strategy tables.
grade DECIMAL 10,5 null

Given grade in the referenced assessment dimension.
peercomment LONGTEXT 2147483647 √ null

Reviewer's comment to the grade value.
peercommentformat SMALLINT 5 √ 0

The format of peercomment field

Table contained -1 rows

workshop_grades table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
workgrad_ass_ix Performance Asc assessmentid
workgrad_assstrdim_uix Must be unique Asc/Asc/Asc assessmentid + strategy + dimensionid

workshop_grades table relationships

Close relationships within degrees of separation