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 |