| 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 |
| 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? |
