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 |