workshop_assessments_old table columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
---|---|---|---|---|---|---|---|---|---|---|
id | BIGINT | 19 | √ | null |
|
|
||||
workshopid | BIGINT | 19 | 0 |
|
|
|||||
submissionid | BIGINT | 19 | 0 |
|
|
|||||
userid | BIGINT | 19 | 0 |
|
|
|||||
timecreated | BIGINT | 19 | 0 |
|
|
|||||
timegraded | BIGINT | 19 | 0 |
|
|
|||||
timeagreed | BIGINT | 19 | 0 |
|
|
|||||
grade | DOUBLE | 22 | 0 |
|
|
|||||
gradinggrade | SMALLINT | 5 | 0 |
|
|
|||||
teachergraded | SMALLINT | 5 | 0 |
|
|
|||||
mailed | SMALLINT | 5 | 0 |
|
|
|||||
resubmission | SMALLINT | 5 | 0 |
|
|
|||||
donotuse | SMALLINT | 5 | 0 |
|
|
|||||
generalcomment | LONGTEXT | 2147483647 | √ | null |
|
|
||||
teachercomment | LONGTEXT | 2147483647 | √ | null |
|
|
||||
newplugin | VARCHAR | 28 | √ | null |
|
|
||||
newid | BIGINT | 19 | √ | null |
|
|
Table contained -1 rows
workshop_assessments_old table indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
PRIMARY | Primary key | Asc | id |
workasseold_mai_ix | Performance | Asc | mailed |
workasseold_sub_ix | Performance | Asc | submissionid |
workasseold_use_ix | Performance | Asc | userid |
workasseold_wor_ix | Performance | Asc | workshopid |