# workshop

0 rows

### Description

This table keeps information about the module instances and their settings

### Columns

Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments
--- | --- | --- | --- | --- | --- | --- | --- | ---
id | BIGINT | 19 |  | √ | null |
workshop_aggregations.workshopid | workaggr_wor2_fkR
workshop_submissions.workshopid | worksubm_wor2_fkR
workshopallocation_scheduled.workshopid | worksche_wor_fkR
workshopeval_best_settings.workshopid | workbestsett_wor_fkR
workshopform_accumulative.workshopid | workaccu_wor2_fkR
workshopform_comments.workshopid | workcomm_wor2_fkR
workshopform_numerrors.workshopid | worknume_wor2_fkR
workshopform_numerrors_map.workshopid | worknumemap_wor2_fkR
workshopform_rubric.workshopid | workshopform_rubric_erd_config_workshopidR
workshopform_rubric_config.workshopid | workshopform_rubric_config_erd_workshopidR
course | BIGINT | 19 |  |  | null |  |
course.id | work_cou2_fkR
| ID of the parent course
name | VARCHAR | 1333 |  |  |  |  |  | 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
instructauthors | LONGTEXT | 2147483647 | √ |  | null |  |  | Instructions for the submission phase
instructauthorsformat | 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

### Relationships