Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | BIGINT | 19 | √ | null |
|
|
||||
| workshopid | BIGINT | 19 | null |
|
|
Workshop ID |
||||
| sort | BIGINT | 19 | √ | 0 |
|
|
Defines the dimension order within the assessment form |
|||
| description | LONGTEXT | 2147483647 | √ | null |
|
|
The description of the dimension |
|||
| descriptionformat | SMALLINT | 5 | √ | 0 |
|
|
The format of the description field |
|||
| descriptiontrust | BIGINT | 19 | √ | null |
|
|
||||
| grade0 | VARCHAR | 50 | √ | null |
|
|
The word describing the negative evaluation (like Poor, Missing, Absent, etc.). If NULL, it defaults to a translated string False |
|||
| grade1 | VARCHAR | 50 | √ | null |
|
|
A word for possitive evaluation (like Good, Present, OK etc). If NULL, it defaults to a translated string True |
|||
| weight | MEDIUMINT | 7 | √ | 1 |
|
|
Weight of this dimension |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| worknume_wor_ix | Performance | Asc | workshopid |