Workshop Submissions Table Schema (workshop_submissions)


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 stored as of 0-100.

workshop_submissions table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
workshop_assessments.submissionid workasse_sub2_fk R
workshopid BIGINT 19 null
workshop.id worksubm_wor2_fk R

the id of the workshop instance
example TINYINT 3 √ 0

Is this submission an example from teacher
authorid BIGINT 19 null
user.id worksubm_aut2_fk R

The author of the submission
timecreated BIGINT 19 null

Timestamp when the work was submitted for the first time
timemodified BIGINT 19 null

Timestamp when the submission has been updated
title VARCHAR 255

The submission title
content LONGTEXT 2147483647 √ null

Submission text
contentformat SMALLINT 5 0

The format of submission text
contenttrust SMALLINT 5 0

The trust mode of the data
attachment TINYINT 3 √ 0

Used by File API file_postupdate_standard_filemanager
grade DECIMAL 10,5 √ null

Aggregated grade for the submission. The grade is a decimal number from interval 0..100. If NULL then the grade for submission has not been aggregated yet.
gradeover DECIMAL 10,5 √ null

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

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

Teacher comment/feedback for the author of the submission, for example describing the reasons for the grade overriding
feedbackauthorformat SMALLINT 5 √ 0
timegraded BIGINT 19 √ null

The timestamp when grade or gradeover was recently modified
published TINYINT 3 √ 0

Shall the submission be available to other when the workshop is closed
late TINYINT 3 0

Has this submission been submitted after the deadline or during the assessment phase?

Table contained -1 rows

workshop_submissions table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
worksubm_aut_ix Performance Asc authorid
worksubm_gra_ix Performance Asc gradeoverby
worksubm_wor_ix Performance Asc workshopid

workshop_submissions table relationships

Close relationships within degrees of separation