| Name | R_String_Enum |
|---|---|
| Entity Type | Table |
| Description | Stores all allowed string and integer enumerations. The allowable values for an attribute in the database are constrained by the string or integer enumeration of the value domain assigned to the attribute. |
| Submodel | Reference |
| Entity Scope | Reference |
| Primary Key | Value_Domain_Code , String_Value |
| Natural Key | Value_Domain_Code , String_Value |
| Generalizations | |
| Specializations |
| Name | Value Domain | Property / Storage Unit | Description | Required / Default | Type |
|---|---|---|---|---|---|
| Active_Flag | boolean | NA |
1 = use without restriction. 0 = avoid use - the value has been deprecated and may be removed in a later release. | Yes 1 |
NUMBER(1) |
| Description | STRING2000 | NA |
A textual definition of the reference value. | No |
VARCHAR2(2000) |
| Insert_Date | DATE | NA |
Date the entity was created in the repository | No |
DATE |
| Insert_User | STRING64 | NA |
The name of the user responsible for the creation of this entity in the repository. | No |
VARCHAR2(64) |
| Int_Value | int | No_Unit |
Integer representation of value (for Integer_Enum domains) | No |
NUMBER(10) |
| Original_String_Value | STRING64 | NA |
String value in native format (as obtained from source) | No |
VARCHAR2(64) |
| Source | CODE | NA |
The person, company or application that defined or specified the data (content) for this instance and is considered to be responsible for it. For example, POSC, EPSG, API, ISO, etc.. | No |
VARCHAR2(64) |
| String_Value | STRING64 | NA |
Normalized string value in the right case (Normally mixed case) | Yes |
VARCHAR2(64) |
| Update_Date | DATE | NA |
Date of the most-recent modification to the entity. | No |
DATE |
| Update_User | STRING64 | NA |
The name of the user responsible for the last modification to this entity. | No |
VARCHAR2(64) |
| Value_Domain_Code | R_Value_Domain |
|
Value domain code for which the enumerations are being described | Yes |
VARCHAR2(64) |
| Link | To Entity | Description | Implementation Technique | Required |
|---|---|---|---|---|
| Value_Domain_Code | R_Value_Domain | Value domain code for which the enumerations are being described | Restrict | Yes |