POSC Specifications Version 2.2 Epicentre Relational Implementation

CREATE TABLE CEMENT_CSG_STR
(
ACTIVITY_NAMECHAR VARYING (40),
CASING_STRING_SCHAR VARYING (19) NOT NULL REFERENCES WELLBORE_TUBULAR (WELLBORE_TUBULAR_S),
CEMENT_CSG_STR_SCHAR VARYING (19) NOT NULL PRIMARY KEY,
CONTAINING_ACT_SCHAR VARYING (19),
CONTAINING_ACT_TCHAR VARYING (16),
COSTFLOAT,
COST_UCHAR VARYING (15) REFERENCES R_CURRENCY_UNIT (ACRONYM),
DESCRIPTIONCHAR VARYING (255),
DURATIONFLOAT,
DURATION_UCHAR VARYING (15) REFERENCES R_UOM (ACRONYM),
END_TIMETIMESTAMP,
R_EXISTENCE_KD_NMCHAR VARYING (40) NOT NULL REFERENCES R_EXISTENCE_KD (R_EXISTENCE_KD_NM),
R_TRANSIENT_PERIODCHAR VARYING (40) REFERENCES R_TRANSIENT_PD (R_TRANSIENT_PD_NM),
START_TIMETIMESTAMP,
TYPICAL_ACT_NAMECHAR VARYING (40) REFERENCES TYPICAL_ACT (TYPICAL_ACT_NAME),
UTILIZE_EQP_SCHAR VARYING (19) REFERENCES EQUIPMENT_ITEM (EQUIPMENT_ITEM_S),
WELLBORE_IDCHAR VARYING (40),
WELLBORE_SCHAR VARYING (19) REFERENCES WELLBORE (WELLBORE_S)
)


Generated on Sat Nov 15 15:32:49 1997
© Copyright 1997 POSC. All rights reserved.