workshop_old table columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | BIGINT | 19 | √ | null |
|
|
||
| course | BIGINT | 19 | 0 |
|
|
|||
| name | VARCHAR | 255 |
|
|
||||
| description | LONGTEXT | 2147483647 | null |
|
|
|||
| wtype | SMALLINT | 5 | 0 |
|
|
|||
| nelements | SMALLINT | 5 | 1 |
|
|
|||
| nattachments | SMALLINT | 5 | 0 |
|
|
|||
| phase | TINYINT | 3 | 0 |
|
|
|||
| format | TINYINT | 3 | 0 |
|
|
|||
| gradingstrategy | TINYINT | 3 | 1 |
|
|
|||
| resubmit | TINYINT | 3 | 0 |
|
|
|||
| agreeassessments | TINYINT | 3 | 0 |
|
|
|||
| hidegrades | TINYINT | 3 | 0 |
|
|
|||
| anonymous | TINYINT | 3 | 0 |
|
|
|||
| includeself | TINYINT | 3 | 0 |
|
|
|||
| maxbytes | BIGINT | 19 | 100000 |
|
|
|||
| submissionstart | BIGINT | 19 | 0 |
|
|
|||
| assessmentstart | BIGINT | 19 | 0 |
|
|
|||
| submissionend | BIGINT | 19 | 0 |
|
|
|||
| assessmentend | BIGINT | 19 | 0 |
|
|
|||
| releasegrades | BIGINT | 19 | 0 |
|
|
|||
| grade | SMALLINT | 5 | 0 |
|
|
|||
| gradinggrade | SMALLINT | 5 | 0 |
|
|
|||
| ntassessments | SMALLINT | 5 | 0 |
|
|
|||
| assessmentcomps | SMALLINT | 5 | 2 |
|
|
|||
| nsassessments | SMALLINT | 5 | 0 |
|
|
|||
| overallocation | SMALLINT | 5 | 0 |
|
|
|||
| timemodified | BIGINT | 19 | 0 |
|
|
|||
| teacherweight | SMALLINT | 5 | 1 |
|
|
|||
| showleaguetable | SMALLINT | 5 | 0 |
|
|
|||
| usepassword | SMALLINT | 5 | 0 |
|
|
|||
| password | VARCHAR | 32 |
|
|
||||
| newplugin | VARCHAR | 28 | √ | null |
|
|
||
| newid | BIGINT | 19 | √ | null |
|
|
Table contained -1 rows
workshop_old table indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| workold_cou_ix | Performance | Asc | course |