POSC Specifications Version 2.2 Epicentre Relational Implementation

CREATE TABLE WELLBORE_REF
(
BELONGS_TO_ASSY_LINTEGER,
BELONGS_TO_ASSY_SCHAR VARYING (19),
BELONGS_TO_ASSY_TCHAR VARYING (16),
DESCRIPTIONCHAR VARYING (255),
END_DATETIMESTAMP,
ENTITY_TYPE_NMCHAR VARYING (40) NOT NULL CHECK (ENTITY_TYPE_NM IN ('BOTTOMHOLE', 'DERRICK_FLOOR_REFERENCE', 'GROUND_LEVEL', 'KELLY_BUSHING_REFERENCE', 'KICK_OFF_POINT')),
R_EXISTENCE_KD_NMCHAR VARYING (40) NOT NULL REFERENCES R_EXISTENCE_KD (R_EXISTENCE_KD_NM),
START_DATETIMESTAMP,
TYPICAL_FCL_NAMECHAR VARYING (40) REFERENCES TYPICAL_FCL (TYPICAL_FCL_NAME),
WB_CMPN_FCL_IDCHAR VARYING (40),
WELLBORE_REF_SCHAR VARYING (19) NOT NULL PRIMARY KEY,
WELLBORE_SCHAR VARYING (19) NOT NULL REFERENCES WELLBORE (WELLBORE_S)
)


Generated on Sat Nov 15 15:44:07 1997
© Copyright 1997 POSC. All rights reserved.