| Name | R_Equipment_Symbol |
|---|---|
| Entity Type | Table |
| Description | Symbols that are used to represent specific types of equipment when generating a wellbore schematic. |
| Submodel | Reference |
| Entity Scope | Reference |
| Primary Key | Ref_Id |
| Natural Key | Table_Name , Attribute_Name , Equipment_Type , Equipment_Sub_Type , Name |
| Generalizations | R_Symbol , Ref_Entity_Surrogate_Key , 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) |
| Attribute_Name | STRING32 | NA |
The name of the attribute within the table that holds the type of the equipment that we wish to represent. | No |
VARCHAR2(32) |
| Code | CODE | NA |
A standard abbreviation, mnemonic, or short code that represents the reference value. | No |
VARCHAR2(64) |
| Description | STRING2000 | NA |
A textual definition of the reference value. | No |
VARCHAR2(2000) |
| Equipment_Sub_Type | STRING64 | NA |
The sub type of equipment that we wish to represent. | No |
VARCHAR2(64) |
| Equipment_Type | STRING64 | NA |
The type of equipment that we wish to represent | 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) |
| Path | FILE_NAME_STR | NA |
Fully qualified path name of the symbol file. | No |
VARCHAR2(999) |
| Ref_Id | ID | No_Unit |
The surrogate identifier of an instance of reference data. | Yes |
NUMBER(38) |
| 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) |
| Storage_Unit_System | R_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 | No |
VARCHAR2(64) |
| Symbol | BLOB | NA |
The symbol to be used to display the equipment. | No |
BLOB |
| Table_Name | STRING32 | NA |
The name of the table that stores the equipment we want to represent | 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 |
|---|---|---|---|---|
| R_Facility_Cat | Equipment_Symbol | The display symbol associated with the equipment catalog entry. | Restrict | No |
| Link | To Entity | Description | Implementation Technique | Required |
|---|---|---|---|---|
| Storage_Unit_System | R_Unit_System | _ | Restrict | No |