workshop_grades

0 rows


Description

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

Columns

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

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

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

Relationships