BELONGS_TO_ASSEMBLY_S | CHAR VARYING (19) | , |
BELONGS_TO_ASSEMBLY_T | CHAR VARYING (30) | , |
BURST | FLOAT | , |
BURST_U | CHAR VARYING (15) | REFERENCES R_UNIT_OF_MEASURE (ACRONYM), |
COLLAPSE | FLOAT | , |
COLLAPSE_U | CHAR VARYING (15) | REFERENCES R_UNIT_OF_MEASURE (ACRONYM), |
COMPONENT_ORDER | INTEGER | , |
DESCRIPTION | CHAR VARYING (2000) | , |
DRIFT_DIAMETER | FLOAT | , |
DRIFT_DIAMETER_U | CHAR VARYING (15) | REFERENCES R_UNIT_OF_MEASURE (ACRONYM), |
END_DATE | TIMESTAMP | , |
END_DATE_CD | CHAR (1) | , |
END_DATE_DY | INTEGER | , |
END_DATE_HR | INTEGER | , |
END_DATE_MT | INTEGER | , |
END_DATE_OF | FLOAT | , |
END_DATE_ST | FLOAT | , |
END_DATE_YP | INTEGER | , |
END_DATE_YR | FLOAT | , |
ENTITY_TYPE_NM | CHAR VARYING (30) | NOT NULL CHECK (ENTITY_TYPE_NM IN ('BLAST_JOINT', 'CASING_SEGMENT', 'CASING_STRING', 'CROSSOVER_NIPPLE', 'DRILLSTRING', 'DRILLSTRING_SEGMENT', 'EXPANSION_JOINT', 'HOLD_DOWN_NIPPLE', 'LANDING_NIPPLE', 'LINER', 'MULESHOE', 'NIPPLE', 'PERFORATED_JOINT', 'SAFETY_JOINT', 'SCREEN_LINER', 'SHOCK_SUB', 'TIE_BACK_STRING', 'TUBING_SEGMENT', 'TUBING_STRING')), |
IDENTIFIER | CHAR VARYING (80) | NOT NULL, |
INNER_DIAMETER | FLOAT | , |
INNER_DIAMETER_U | CHAR VARYING (15) | REFERENCES R_UNIT_OF_MEASURE (ACRONYM), |
INSTANCE_CREATE_DATE | TIMESTAMP | , |
INSTANCE_CREATOR | CHAR VARYING (80) | , |
INSTANCE_S | CHAR VARYING (19) | NOT NULL PRIMARY KEY, |
KIND_S | CHAR VARYING (19) | REFERENCES FACILITY_CLASS (INSTANCE_S), |
LAST_UPDATED | TIMESTAMP | , |
LAST_UPDATED_BY | CHAR VARYING (80) | , |
NAMING_SYSTEM | CHAR VARYING (80) | REFERENCES NAMING_SYSTEM (IDENTIFIER), |
OUTER_DIAMETER | FLOAT | , |
OUTER_DIAMETER_U | CHAR VARYING (15) | REFERENCES R_UNIT_OF_MEASURE (ACRONYM), |
R_EXISTENCE_KIND | CHAR VARYING (80) | NOT NULL REFERENCES R_EXISTENCE_KIND (IDENTIFIER), |
SMALLER_INNER_DIAMETER | FLOAT | , |
SMALLER_INNER_DIAMETER_U | CHAR VARYING (15) | REFERENCES R_UNIT_OF_MEASURE (ACRONYM), |
SMALLER_OUTER_DIAMETER | FLOAT | , |
SMALLER_OUTER_DIAMETER_U | CHAR VARYING (15) | REFERENCES R_UNIT_OF_MEASURE (ACRONYM), |
SOURCE | CHAR VARYING (80) | , |
START_DATE | TIMESTAMP | , |
START_DATE_CD | CHAR (1) | , |
START_DATE_DY | INTEGER | , |
START_DATE_HR | INTEGER | , |
START_DATE_MT | INTEGER | , |
START_DATE_OF | FLOAT | , |
START_DATE_ST | FLOAT | , |
START_DATE_YP | INTEGER | , |
START_DATE_YR | FLOAT | , |
WALL_THICKNESS | FLOAT | , |
WALL_THICKNESS_U | CHAR VARYING (15) | REFERENCES R_UNIT_OF_MEASURE (ACRONYM), |
WELLBORE_S | CHAR VARYING (19) | NOT NULL REFERENCES WELLBORE (INSTANCE_S), |
WELLBORE_TUBULAR_FCL_LENGTH | FLOAT | , |
WELLBORE_TUBULAR_FCL_LENGTH_U | CHAR VARYING (15) | REFERENCES R_UNIT_OF_MEASURE (ACRONYM), |
YIELD | FLOAT | , |
YIELD_U | CHAR VARYING (15) | REFERENCES R_UNIT_OF_MEASURE (ACRONYM) |
)