POSC Specifications: Epicentre Version 3.0 Relational Implementation

CREATE TABLE GEOPHYSICAL_GEOMETRY_SET
(
ACQUISITION_INDEX_SLCHAR VARYING (16),
ACQUISITION_LINE_INDEXFLOAT (6),
CHANNEL_CONNECTION_SLCHAR VARYING (16),
CHANNEL_DEFINITION_SCHAR VARYING (19) REFERENCES GEOPHYSICAL_GEOMETRY_SET (INSTANCE_S),
CHANNEL_FACILITY_SLCHAR VARYING (16),
CHANNEL_NUMBER_SLCHAR VARYING (16),
CHANNEL_SEISMOGRAPH_SLCHAR VARYING (16),
CHANNEL_UID_SCHAR VARYING (19) REFERENCES GRID_1D (INSTANCE_S),
DESCRIPTIONCHAR VARYING (2000),
ENTITY_TYPE_NMCHAR VARYING (30) NOT NULL CHECK (ENTITY_TYPE_NM IN ('POTENTIAL_FIELD_GEOMETRY_SET', 'SEISMIC_GEOMETRY_SET')),
FIELD_TRACE_GRID_SCHAR VARYING (19) REFERENCES GRID_DEFINED_GRID (INSTANCE_S),
IDENTIFIERCHAR VARYING (80) NOT NULL,
INSTANCE_CREATE_DATETIMESTAMP ,
INSTANCE_CREATORCHAR VARYING (80),
INSTANCE_SCHAR VARYING (19) NOT NULL PRIMARY KEY,
KIND_SCHAR VARYING (19) REFERENCES EARTH_FEATURE_CLASS (INSTANCE_S),
LAST_UPDATEDTIMESTAMP ,
LAST_UPDATED_BYCHAR VARYING (80),
LINE_INDEXFLOAT (6),
MEASUREMENT_INDEX_SLCHAR VARYING (16),
MEASUREMENT_NAME_SLCHAR VARYING (16),
MEASUREMENT_SEISMIC_STATION_SLCHAR VARYING (16),
MEASUREMENT_SENSOR_FACILITY_SLCHAR VARYING (16),
MEASUREMENT_STATION_SLCHAR VARYING (16),
MEASUREMENT_TIME_ORIGINTIMESTAMP,
MEASUREMENT_TIME_ORIGIN_CDCHAR (1),
MEASUREMENT_TIME_ORIGIN_DYINTEGER,
MEASUREMENT_TIME_ORIGIN_HRINTEGER,
MEASUREMENT_TIME_ORIGIN_MTINTEGER,
MEASUREMENT_TIME_ORIGIN_OFFLOAT,
MEASUREMENT_TIME_ORIGIN_STFLOAT,
MEASUREMENT_TIME_ORIGIN_YPINTEGER,
MEASUREMENT_TIME_ORIGIN_YRFLOAT,
MEASUREMENT_TIME_SLCHAR VARYING (16),
MEASUREMENT_UID_SCHAR VARYING (19) REFERENCES GRID_1D (INSTANCE_S),
NAMING_SYSTEMCHAR VARYING (80) REFERENCES NAMING_SYSTEM (IDENTIFIER),
PART_OF_SCHAR VARYING (19) REFERENCES GEOPHYSICAL_GEOMETRY_SET (INSTANCE_S),
RECEIVER_CLASS_SCHAR VARYING (19) REFERENCES FACILITY_CLASS (INSTANCE_S),
RECEIVER_FACILITY_SLCHAR VARYING (16),
RECEIVER_STATION_SLCHAR VARYING (16),
RECEIVER_UID_SCHAR VARYING (19) REFERENCES GRID_1D (INSTANCE_S),
SEISMIC_GEOMETRY_SET_UIDINTEGER,
SEISMIC_STATION_UID_SCHAR VARYING (19) REFERENCES GRID_1D (INSTANCE_S),
SOURCECHAR VARYING (80),
SOURCE_CONTENTCHAR VARYING (80),
SOURCE_EVENT_NAME_SLCHAR VARYING (16),
SOURCE_EVENT_ORDER_SLCHAR VARYING (16),
SOURCE_EVENT_UID_SCHAR VARYING (19) REFERENCES GRID_1D (INSTANCE_S),
SOURCE_FACILITY_SLCHAR VARYING (16),
SOURCE_REFERENCECHAR VARYING (2000),
SOURCE_STATION_SLCHAR VARYING (16),
STATION_INDEX_SLCHAR VARYING (16),
STATION_NAME_SLCHAR VARYING (16),
STATION_UID_SCHAR VARYING (19) REFERENCES GRID_1D (INSTANCE_S),
STATUSCHAR VARYING (11),
SURFACE_ONLYCHAR (1),
UNIQUE_WITHIN_SCHAR VARYING (19),
UNIQUE_WITHIN_TCHAR VARYING (30),
VERSION_SCHAR VARYING (19) REFERENCES R_VERSION (INSTANCE_S),
WELLBORE_SCHAR VARYING (19) REFERENCES WELLBORE (INSTANCE_S)
)


Generated on Tue Jul 10 19:40:37 2001
© Copyright 2001 POSC. All rights reserved.