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 |