Table | cm_attribute_enumerations |
|---|---|
Description | Attribute enumerations (per-CO or platform wide) |
Column | Format | Description | Definition | Comments |
|---|---|---|---|---|
id | integer, primary key | Row identifier | autoincrement | |
co_id | integer, foreign key | CO ID | cm_cos:id | Null when Org Identities are pooled and enumeration applies to an Org Identity attribute |
attribute | varchar(80) | Attribute this enumeration applies to | Model.attribute | Only attributes that support enumerations may be used here |
optvalue | varchar(128) | Enumerated option | Deprecated in v4.0.0, but maintained for data migration purposes; will be removed in PE | |
status | varchar(2) | Type status |
| Suspending an enumeration does not remove any uses of it from operation records |
| dictionary_id | integer, foreign key | Dictionary ID | cm_dictionaries:id | Added v4.0.0 |
| allow_other | boolean | Allow non-enumerated, "other" values | Added v4.0.0 |