| Name | R_Tubular_Grade |
|---|---|
| Entity Type | Table |
| Description | Reference class defining the grade for tubular |
| Submodel | Tubular |
| Entity Scope | Reference |
| Primary Key | Material_Grade |
| Natural Key | Material_Grade |
| Generalizations | 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) |
| 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) |
| Material_Grade | STRING64 | NA |
The grade of material defined by e.g. API | Yes |
VARCHAR2(64) |
| Max_Yield_Stress | double | Shear_Stress Pa |
Maximum Yield Stress for the grade | No |
NUMBER |
| Min_Yield_Stress | double | Shear_Stress Pa |
Minimum Yield Stress of the grade | No |
NUMBER |
| Minimum_Tensile_Strength | double | Strength kPa |
Minimum Tensile Strength | No |
NUMBER |
| 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) |
| 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) |
| Tubular_Material_Type | R_Tubular_Material |
|
Reference to Tubular material | 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) |
| From Entity | Link | Description | Implementation Technique | Required |
|---|---|---|---|---|
| R_Tubular_Cat | Tubular_Grade | The grade of the Tubular | Restrict | No |
| Link | To Entity | Description | Implementation Technique | Required |
|---|---|---|---|---|
| Tubular_Material_Type | R_Tubular_Material | Reference to Tubular material | Restrict | Yes |
| 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. | Restrict | No |