Workshop Assessments Table Schema (workshop_assessments)


Description

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

workshop_assessments table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
workshop_grades.assessmentid workgrad_ass2_fk R
submissionid BIGINT 19 null
workshop_submissions.id workasse_sub2_fk R

The id of the assessed submission
reviewerid BIGINT 19 null
user.id workasse_rev2_fk R

The id of the reviewer who makes this assessment
weight BIGINT 19 1

The weight of the assessment for the purposes of aggregation
timecreated BIGINT 19 √ 0

If 0 then the assessment was allocated but the reviewer has not assessed yet. If greater than 0 then the timestamp of when the reviewer assessed for the first time
timemodified BIGINT 19 √ 0

If 0 then the assessment was allocated but the reviewer has not assessed yet. If greater than 0 then the timestamp of when the reviewer assessed for the last time
grade DECIMAL 10,5 √ null

The aggregated grade for submission suggested by the reviewer. The grade 0..100 is computed from the values assigned to the assessment dimensions fields. If NULL then it has not been aggregated yet.
gradinggrade DECIMAL 10,5 √ null

The computed grade 0..100 for this assessment. If NULL then it has not been computed yet.
gradinggradeover DECIMAL 10,5 √ null

Grade for the assessment manually overridden by a teacher. Grade is always from interval 0..100. If NULL then the grade is not overriden.
gradinggradeoverby BIGINT 19 √ null
user.id workasse_gra2_fk R

The id of the user who has overridden the grade for submission.
feedbackauthor LONGTEXT 2147483647 √ null

The comment/feedback from the reviewer for the author.
feedbackauthorformat SMALLINT 5 √ 0
feedbackauthorattachment SMALLINT 5 √ 0

Are there some files attached to the feedbackauthor field? Sets to 1 by file_postupdate_standard_filemanager().
feedbackreviewer LONGTEXT 2147483647 √ null

The comment/feedback from the teacher for the reviewer. For example the reason why the grade for assessment was overridden
feedbackreviewerformat SMALLINT 5 √ 0

Table contained -1 rows

workshop_assessments table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
workasse_gra_ix Performance Asc gradinggradeoverby
workasse_rev_ix Performance Asc reviewerid
workasse_sub_ix Performance Asc submissionid

workshop_assessments table relationships

Close relationships within degrees of separation