# 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