| Name | R_Value_Domain |
|---|---|
| Entity Type | Table |
| Description | Stores value domains, value_types, and DBMS datatypes used by attributes/properties. |
| Submodel | Reference |
| Entity Scope | Reference |
| Primary Key | Code |
| Natural Key | Code |
| Generalizations | Reference_Entity , Reference_Entity_Parent |
| 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) |
| Code | CODE | NA |
A standard abbreviation, mnemonic, or short code that represents the reference value. | Yes |
VARCHAR2(64) |
| Constraint_Code | STRING64 | NA |
Key Attribute of Object which constraints the Property values. For example, the Code Attribute in the R_String_Enum used to constraint a string-valued Property. | No |
VARCHAR2(64) |
| Constraint_Object | TABLE_NAME | NA |
Name of Object (usually a database table) holding descriptions of the constraints (e.g. R_String_Enum) | No |
VARCHAR2(30) |
| Constraint_Type | CONSTRAINT_TYPE | NA |
Type of constraint. Examples include UNCONSTRAINED, STRING_ENUM, INTEGER_ENUM, INTEGER_RANGE, FLOAT_RANGE, DATE_RANGE, CATALOG_ATTR, etc. | No |
VARCHAR2(32) |
| DB_Type | STRING64 | NA |
A datatype defines a set of properties applicable to the data to be stored in a database column such as the type of characters (variable or fixed length) or numbers allowed (integer versus floating point). Datatypes typically have native support in data base management systems (DBMS). | Yes |
VARCHAR2(64) |
| 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) |
| Name | STRING255 | NA |
The spelled-out name of the reference value. | No |
VARCHAR2(255) |
| Parent_Code | CODE | NA |
Supertype of a primitive Value Domain | No |
VARCHAR2(64) |
| Scale | int | No_Unit |
Number of decimal places | No |
NUMBER(10) |
| 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) |
| Submodel | SUBMODEL | NA |
Submodel of Value Domain; default is OSDD unless private to a Submodel | No |
VARCHAR2(30) |
| 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) |
| Width | int | No_Unit |
Width of database column | No |
NUMBER(10) |
| From Entity | Link | Description | Implementation Technique | Required |
|---|---|---|---|---|
| R_String_Enum | Value_Domain_Code | Value domain code for which the enumerations are being described | Restrict | Yes |