attr_set
- Last UpdatedNov 20, 2024
- 1 minute read
The attr_set table defines the possible set of values for an attribute that has its predefined flag set. Allows any number of predefined values per attribute. Not used for possible values of system attributes, as they are instead stored in that table’s constraints field.
|
Field |
Datatype |
PK |
Nulls? |
Description |
|---|---|---|---|---|
|
attr_id |
int32 |
N |
N |
Attribute identifier |
|
possible_value |
string80 |
N |
N |
Possible value |
|
display_seq |
int32 |
N |
N |
Holds the display sequence value for the possible value of an attribute. This number determines the order of possible values when they are listed for the attribute in a drop-down list in the user interface. |
|
last_edit_comment |
string254 |
N |
Y |
Reserved for internal use to indicate why this record was changed |
|
last_edit_by |
string40 |
N |
Y |
Who last changed this record |
|
last_edit_at |
tdatetime |
N |
N |
When this record was last changed |
|
row_id |
ID 1 |
Y |
N |
Unique row identifier, for audit trail |
FK from attr_id to attr. (Cascade delete)
attr_id, possible_value is UK.