| Name | R_Unit_System |
|---|---|
| Entity Type | Table |
| Description | Types of unit systems, such as English, Metric, Canadian Metric, etc. Each system has its own assignments based on unit quantity. |
| 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) |
| Description | STRING2000 | NA |
A textual definition of the reference value. | No |
VARCHAR2(2000) |
| Inherit_From | R_Unit_System |
|
Name of the parent Unit System | No |
VARCHAR2(64) |
| 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) |
| 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) |
| Standard | STANDARD_CODE | NA |
Name of standard defining this Unit System | No |
VARCHAR2(32) |
| 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) |
| From Entity | Link | Description | Implementation Technique | Required |
|---|---|---|---|---|
| Project_Default | Storage_Unit_System | Unit system for storing project data. This value is set at project creation time and cannot be changed. | Restrict | No |
| R_Tubular_Grade | Storage_Unit_System | The unit system in which the numeric values are stored. It is expected that every numeric value in this table will be of the same unit system e.g. Metric, English etc. | Restrict | No |
| R_Tubular_Material | Storage_Unit_System | The unit system in which the numeric values are stored | Restrict | No |
| R_Unit_Assignment | Unit_System_Code | Unit System | Restrict | Yes |
| R_Unit_System | Inherit_From | Name of the parent Unit System | Cascade | No |
| Ref_Entity_Surrogate_Key | Storage_Unit_System | The unit system in which the numeric values are stored. It is expected that every numeric value in this table will be of the same unit system e.g Metric, English etc | Restrict | No |
| Link | To Entity | Description | Implementation Technique | Required |
|---|---|---|---|---|
| Inherit_From | R_Unit_System | Name of the parent Unit System | Cascade | No |