POSC Specifications Version 2.2 Epicentre Relational Implementation

CREATE TABLE GENERAL_WB_PT
(
DEPTH_1_OFLOAT,
DEPTH_1_OUCHAR VARYING (15) REFERENCES R_UOM (ACRONYM),
DEPTH_CSCHAR VARYING (40) REFERENCES COORDINATE_SYS (COORDINATE_SYS_ID),
DEPTH_O_SCHAR VARYING (19),
DEPTH_O_TCHAR VARYING (16),
DESCRIPTIONCHAR VARYING (255),
EMODEL_OBJECT_IDCHAR VARYING (40),
GENERAL_WB_PT_SCHAR VARYING (19) NOT NULL PRIMARY KEY,
GEOLOGIC_FTR_SCHAR VARYING (19),
GEOLOGIC_FTR_TCHAR VARYING (16),
GEOSCIENCE_NTRP_SCHAR VARYING (19) REFERENCES GEOSCIENCE_NTRP (GEOSCIENCE_NTRP_S),
PT_1_OFLOAT,
PT_1_OUCHAR VARYING (15) REFERENCES R_UOM (ACRONYM),
PT_2_OFLOAT,
PT_2_OUCHAR VARYING (15) REFERENCES R_UOM (ACRONYM),
PT_CSCHAR VARYING (40) REFERENCES COORDINATE_SYS (COORDINATE_SYS_ID),
PT_O_SCHAR VARYING (19),
PT_O_TCHAR VARYING (16),
ROCK_FTR_PART_SCHAR VARYING (19),
ROCK_FTR_PART_TCHAR VARYING (16),
R_WELLBORE_PT_NAMECHAR VARYING (40) REFERENCES R_WELLBORE_PT (R_WELLBORE_PT_NAME),
WB_CMPN_FCL_SCHAR VARYING (19),
WB_CMPN_FCL_TCHAR VARYING (16),
WELLBORE_IDCHAR VARYING (40),
WELLBORE_SCHAR VARYING (19) NOT NULL REFERENCES WELLBORE (WELLBORE_S),
WELL_CMPL_SCHAR VARYING (19) REFERENCES WELL_COMPLETION (WELL_COMPLETION_S)
)


Generated on Sat Nov 15 15:34:19 1997
© Copyright 1997 POSC. All rights reserved.