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 |
|||
| grade | BIGINT | 19 | null |
|
|
If greater than 0, then the value is maximum grade on a scale 0..grade. If lesser than 0, then its absolute value is the id of a record in scale table. If equals 0, then no grading is possible for this dimension, just commenting. |
||||
| weight | MEDIUMINT | 7 | √ | 1 |
|
|
The weigh of the dimension |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| workaccu_wor2_ix | Performance | Asc | workshopid |
Relationships
Close relationships within degrees of separation
