| id |
BIGINT |
19 |
|
√ |
null |
|
|
|
| objscaleid |
BIGINT |
19 |
|
|
null |
|
|
Identifies the objective scale id this value belongs to |
| name |
VARCHAR |
255 |
√ |
|
null |
|
|
Name of the scale value |
| idnumber |
VARCHAR |
100 |
√ |
|
null |
|
|
Defines a id that can be assigned to a scale value |
| description |
LONGTEXT |
2147483647 |
√ |
|
null |
|
|
The description of the scale value |
| numericscore |
DECIMAL |
10,5 |
√ |
|
null |
|
|
Identifies a score that can be assigned to a scale value |
| sortorder |
BIGINT |
19 |
|
|
null |
|
|
Defines the order of the priority scale values |
| timemodified |
BIGINT |
19 |
|
|
null |
|
|
Identifies the last time this scale value was modified |
| usermodified |
BIGINT |
19 |
|
|
null |
|
|
user.id
|
dpobjescalvalu_use2_fk R
|
|
Identifies the id of the user who last modified the scale value |
| achieved |
SMALLINT |
5 |
|
|
0 |
|
|
Identifies if this scale value is an achieved value |
