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