Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id | BIGINT | 19 | √ | null |
|
|
||||||||||||||||||||||
| course | BIGINT | 19 | null |
|
|
ID of the parent course |
||||||||||||||||||||||
| name | VARCHAR | 255 |
|
|
Name of the activity |
|||||||||||||||||||||||
| intro | LONGTEXT | 2147483647 | √ | null |
|
|
The introduction or description of the activity |
|||||||||||||||||||||
| introformat | SMALLINT | 5 | 0 |
|
|
The format of the intro field |
||||||||||||||||||||||
| LONGTEXT | 2147483647 | √ | null |
|
|
Instructions for the submission phase |
||||||||||||||||||||||
| SMALLINT | 5 | 0 |
|
|
||||||||||||||||||||||||
| instructreviewers | LONGTEXT | 2147483647 | √ | null |
|
|
Instructions for the assessment phase |
|||||||||||||||||||||
| instructreviewersformat | SMALLINT | 5 | 0 |
|
|
|||||||||||||||||||||||
| timemodified | BIGINT | 19 | null |
|
|
The timestamp when the module was modified |
||||||||||||||||||||||
| phase | SMALLINT | 5 | √ | 0 |
|
|
The current phase of workshop (0 = not available, 1 = submission, 2 = assessment, 3 = closed) |
|||||||||||||||||||||
| useexamples | TINYINT | 3 | √ | 0 |
|
|
optional feature: students practise evaluating on example submissions from teacher |
|||||||||||||||||||||
| usepeerassessment | TINYINT | 3 | √ | 0 |
|
|
optional feature: students perform peer assessment of others’ work |
|||||||||||||||||||||
| useselfassessment | TINYINT | 3 | √ | 0 |
|
|
optional feature: students perform self assessment of their own work |
|||||||||||||||||||||
| grade | DECIMAL | 10,5 | √ | 80.00000 |
|
|
The maximum grade for submission |
|||||||||||||||||||||
| gradinggrade | DECIMAL | 10,5 | √ | 20.00000 |
|
|
The maximum grade for assessment |
|||||||||||||||||||||
| strategy | VARCHAR | 30 |
|
|
The type of the current grading strategy used in this workshop |
|||||||||||||||||||||||
| evaluation | VARCHAR | 30 |
|
|
The recently used grading evaluation method |
|||||||||||||||||||||||
| gradedecimals | SMALLINT | 5 | √ | 0 |
|
|
Number of digits that should be shown after the decimal point when displaying grades |
|||||||||||||||||||||
| submissiontypetext | BIT | 1 | 1 |
|
|
Can students enter text for their submissions? 0 for no, 1 for optional, 2 for required. |
||||||||||||||||||||||
| submissiontypefile | BIT | 1 | 1 |
|
|
Can students attach files for their submissions? 0 for no, 1 for optional, 2 for required. |
||||||||||||||||||||||
| nattachments | SMALLINT | 5 | √ | 1 |
|
|
Maximum number of submission attachments |
|||||||||||||||||||||
| submissionfiletypes | VARCHAR | 255 | √ | null |
|
|
comma separated list of file extensions |
|||||||||||||||||||||
| latesubmissions | TINYINT | 3 | √ | 0 |
|
|
Allow submitting the work after the deadline |
|||||||||||||||||||||
| maxbytes | BIGINT | 19 | √ | 100000 |
|
|
Maximum size of the one attached file |
|||||||||||||||||||||
| examplesmode | SMALLINT | 5 | √ | 0 |
|
|
0 = example assessments are voluntary, 1 = examples must be assessed before submission, 2 = examples are available after own submission and must be assessed before peer/self assessment phase |
|||||||||||||||||||||
| submissionstart | BIGINT | 19 | √ | 0 |
|
|
0 = will be started manually, greater than 0 the timestamp of the start of the submission phase |
|||||||||||||||||||||
| submissionend | BIGINT | 19 | √ | 0 |
|
|
0 = will be closed manually, greater than 0 the timestamp of the end of the submission phase |
|||||||||||||||||||||
| assessmentstart | BIGINT | 19 | √ | 0 |
|
|
0 = will be started manually, greater than 0 the timestamp of the start of the assessment phase |
|||||||||||||||||||||
| assessmentend | BIGINT | 19 | √ | 0 |
|
|
0 = will be closed manually, greater than 0 the timestamp of the end of the assessment phase |
|||||||||||||||||||||
| phaseswitchassessment | TINYINT | 3 | 0 |
|
|
Automatically switch to the assessment phase after the submissions deadline |
||||||||||||||||||||||
| conclusion | LONGTEXT | 2147483647 | √ | null |
|
|
A text to be displayed at the end of the workshop. |
|||||||||||||||||||||
| conclusionformat | SMALLINT | 5 | 1 |
|
|
The format of the conclusion field content. |
||||||||||||||||||||||
| overallfeedbackmode | SMALLINT | 5 | √ | 1 |
|
|
Mode of the overall feedback support. |
|||||||||||||||||||||
| overallfeedbackfiles | SMALLINT | 5 | √ | 0 |
|
|
Number of allowed attachments to the overall feedback. |
|||||||||||||||||||||
| overallfeedbackfiletypes | VARCHAR | 255 | √ | null |
|
|
comma separated list of file extensions |
|||||||||||||||||||||
| overallfeedbackmaxbytes | BIGINT | 19 | √ | 100000 |
|
|
Maximum size of one file attached to the overall feedback. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| work_cou_ix | Performance | Asc | course |