Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
---|---|---|---|---|---|---|---|---|---|---|
id | BIGINT | 19 | √ | null |
|
|
||||
workshopid | BIGINT | 19 | null |
|
|
the id of the workshop instance |
||||
example | TINYINT | 3 | √ | 0 |
|
|
Is this submission an example from teacher |
|||
BIGINT | 19 | null |
|
|
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 |
|
|
The id of the user who has overridden the grade for submission. |
|||
LONGTEXT | 2147483647 | √ | null |
|
|
Teacher comment/feedback for the author of the submission, for example describing the reasons for the grade overriding |
||||
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 |