| id |
BIGINT |
19 |
|
√ |
null |
|
|
|
| name |
VARCHAR |
255 |
√ |
|
null |
|
|
Name for scale value |
| idnumber |
VARCHAR |
100 |
√ |
|
null |
|
|
Identifies a value that can be given to a scale value |
| description |
LONGTEXT |
2147483647 |
√ |
|
null |
|
|
Description of the scale value |
| priorityscaleid |
BIGINT |
19 |
|
|
null |
|
|
Identifies the priority scale that a value belongs to |
| numericscore |
DECIMAL |
10,5 |
√ |
|
null |
|
|
|
| sortorder |
BIGINT |
19 |
|
|
null |
|
|
Identifies the order scale values appear in |
| timemodified |
BIGINT |
19 |
|
|
null |
|
|
Identifies the last time a scale value was modified |
| usermodified |
BIGINT |
19 |
|
|
null |
|
|
user.id
|
dpprioscalvalu_use2_fk R
|
|
Identifies the id of the user who last modified the scale value |
