| Name | R_Tubular_Cat |
|---|---|
| Entity Type | Abstract |
| Description | The catalog properties of commonly used tubulars |
| Submodel | Tubular |
| Entity Scope | Reference |
| Primary Key | Ref_Id |
| Natural Key | |
| Generalizations | Ref_Entity_Surrogate_Key , Reference_Entity_Parent |
| Specializations | R_Casing_Cat , R_Drill_Pipe_Cat , R_Tubing_Cat |
| Name | Value Domain / Measurement | 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) |
| Burst_Pressure | double Pressure |
The internal pressure that will cause piece of drill pipe to fail. | No |
NUMBER |
| Cat_Inside_Diameter | double Cylinder_Diameter |
The typical inside diameter of a tubular | No |
NUMBER |
| Cat_Linear_Weight | double Mass_Per_Length |
The typical linear weight of a tubular | No |
NUMBER |
| Cat_Outside_Diameter | double Cylinder_Diameter |
The typical outside diameter of a tubular | No |
NUMBER |
| Cat_Wall_Thickness | double Cylinder_Diameter |
Wall thickness | No |
NUMBER |
| Code | CODE NA |
A standard abbreviation, mnemonic, or short code that represents the reference value. | No |
VARCHAR2(64) |
| Collapse_Pressure | double Pressure |
The minimum differential pressure which a tubular will withstand without permanent deformation | No |
NUMBER |
| Compression | double Force |
Compression | No |
NUMBER |
| Coupling_Outside_Diameter | double Cylinder_Diameter |
The outside diameter of the coupling on the tubular | No |
NUMBER |
| Coupling_Type | String NA |
The type of coupling on the tubular | No |
VARCHAR2(255) |
| Description | STRING2000 NA |
A textual definition of the reference value. | No |
VARCHAR2(2000) |
| Displacement_Volume | double Volume_Per_Length |
The cross-sectional area of steel (or other material if the tubular is not made of steel) in the tubular expressed in units of volume per unit length. | No |
NUMBER |
| Drift_Diameter | double Cylinder_Diameter |
Largest diameter of a perfect cylinder that can fit into the pipe. Because a pipe is slightly oval the drift diameter is always smaller than the quoted inner diameter. The drift diameter is used to know if a given pipe will run into a pipe. | No |
NUMBER |
| Fatigue_Endurance_Limit | double Stress |
The maximum stress below which the tubular could presumably endure an infinite number of cycles. | No |
NUMBER |
| Hydrostatic_Test_Pressure | double Pressure |
Hydrostatic Test Pressure | No |
NUMBER |
| Min_Make_Up_Torque | double High_Torque |
The minimum torque required to make up the joint to meet the leak resistance spec. | No |
NUMBER |
| Name | CODE NA |
The spelled-out name of the reference value. | No |
VARCHAR2(64) |
| Nom_Linear_Weight | double No_Unit |
The nominal linear weight of the tubular | Yes |
NUMBER |
| Nom_Linear_Weight_Str | STRING64 NA |
The string representation of the Nominal Linear Weight of the tubular. For example ""11 lb/ft"" | No |
VARCHAR2(64) |
| Nom_Linear_Weight_UOM | R_Unit |
The unit of measure associated with the Nominal Linear Weight | Yes |
VARCHAR2(64) |
| Nom_Outside_Diameter | double No_Unit |
Nominal Outside diameter of the tubular body | Yes |
NUMBER |
| Nom_Outside_Diameter_Str | STRING64 NA |
The string representation of the Nominal Outside Diameter of the tubular. For example ""8 1/2 inch"" | No |
VARCHAR2(64) |
| Nom_Outside_Diameter_UOM | R_Unit |
The unit of measure associated with the Nominal Outside Diameter | Yes |
VARCHAR2(64) |
| Non_Magnetic_Flag | boolean NA |
A flag indicating whether the tubular is made with non magnetic material | No |
NUMBER(1) |
| 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) |
| Standardization_Name | STRING64 NA |
Name of the body in charge of standardization of the data such as API, ISO | Yes |
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) |
| Tensile_Yield_Strength | double Force |
The tensile yield strength of the tubular | No |
NUMBER |
| Tension | double Force |
Tension | No |
NUMBER |
| Torsional_Yield_Strength | double Force |
The torsional yield strength of the tubular | No |
NUMBER |
| Tubular_Grade | R_Tubular_Grade |
The grade of the Tubular | No |
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) |
| Upset_Type | String NA |
The upset type of the tubular. Examples are IU, EU and IEU | No |
VARCHAR2(255) |
| Link | To Entity | Description | Implementation Technique | Required |
|---|---|---|---|---|
| Nom_Outside_Diameter_UOM | R_Unit | The unit of measure associated with the Nominal Outside Diameter | Restrict | Yes |
| Storage_Unit_System | R_Unit_System | _ | Restrict | No |
| Nom_Linear_Weight_UOM | R_Unit | The unit of measure associated with the Nominal Linear Weight | Restrict | Yes |
| Tubular_Grade | R_Tubular_Grade | The grade of the Tubular | Restrict | No |