POSC Specifications Version 2.2 Epicentre Relational Implementation

CREATE TABLE P_LOCATION_1D
(
ACTIVITY_SCHAR VARYING (19),
ACTIVITY_TCHAR VARYING (16),
CASING_STRING_SCHAR VARYING (19) REFERENCES WELLBORE_TUBULAR (WELLBORE_TUBULAR_S),
DATA_VALUE_1_OFLOAT NOT NULL,
DATA_VALUE_1_OUCHAR VARYING (15) NOT NULL REFERENCES R_UOM (ACRONYM),
DATA_VALUE_CSCHAR VARYING (40) NOT NULL REFERENCES COORDINATE_SYS (COORDINATE_SYS_ID),
DATA_VALUE_O_SCHAR VARYING (19),
DATA_VALUE_O_TCHAR VARYING (16),
DESCRIPTIONCHAR VARYING (255),
EARTH_POS_VRTX_SCHAR VARYING (19) REFERENCES EARTH_POS_VRTX (EARTH_POS_VRTX_S),
FACILITY_REF_PT_SCHAR VARYING (19) REFERENCES FACILITY_REF_PT (FACILITY_REF_PT_S),
GENERAL_ESRF_PT_SCHAR VARYING (19) REFERENCES GENERAL_ESRF_PT (GENERAL_ESRF_PT_S),
LEGAL_SURVEY_PT_SCHAR VARYING (19) REFERENCES LEGAL_SURVEY_PT (LEGAL_SURVEY_PT_S),
OTHER_SPTL_OBJ_SCHAR VARYING (19),
OTHER_SPTL_OBJ_TCHAR VARYING (16),
OTHER_VERTEX_SCHAR VARYING (19) REFERENCES OTHER_VERTEX (OTHER_VERTEX_S),
PREFERRED_FLAGCHAR (1),
PRS_MEAS_DTM_SCHAR VARYING (19) REFERENCES PRS_MEAS_DTM (PRS_MEAS_DTM_S),
P_LOCATION_1D_SCHAR VARYING (19) NOT NULL PRIMARY KEY,
SEIS_FCL_NODE_SCHAR VARYING (19) REFERENCES SEIS_FCL_NODE (SEIS_FCL_NODE_S),
WELLBORE_POINT_SCHAR VARYING (19),
WELLBORE_POINT_TCHAR VARYING (16),
WELL_SURFACE_PT_SCHAR VARYING (19) REFERENCES WELL_SURFACE_PT (WELL_SURFACE_PT_S)
)


Generated on Sat Nov 15 15:37:57 1997
© Copyright 1997 POSC. All rights reserved.