workshop_submissions

0 rows


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.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
workshop_assessments.submissionid workasse_sub2_fkR
workshopid BIGINT 19 null
workshop.id worksubm_wor2_fkR

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_fkR

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_fkR

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?

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

Relationships