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_wor_ix | Performance | Asc | workshopid |