POSC Specifications: Epicentre Version 3.0 Relational Implementation

CREATE TABLE BULK_MATERIAL
(
BASE_MISSING_SECTIONFLOAT,
BASE_MISSING_SECTION_UCHAR VARYING (15) REFERENCES R_UNIT_OF_MEASURE (ACRONYM),
COMBINED_TO_CREATE_SCHAR VARYING (19) REFERENCES BULK_MATERIAL (INSTANCE_S),
DESCRIPTIONCHAR VARYING (2000),
DRILLSTRING_SCHAR VARYING (19) REFERENCES WELLBORE_TUBULAR (INSTANCE_S),
EARTH_FEATURE_SCHAR VARYING (19),
EARTH_FEATURE_TCHAR VARYING (30),
ENTITY_TYPE_NMCHAR VARYING (30) NOT NULL CHECK (ENTITY_TYPE_NM IN ('CEMENT', 'CORE', 'DRILLING_KICK_FLUID', 'DRILLSTEM_TEST_RECOVERY', 'DRILL_CUTTINGS_SAMPLE', 'FILTER_CAKE', 'FLUID_FILTRATE', 'FLUID_SAMPLE', 'FRACTURE', 'LOCAL_ROCK_FEATURE', 'OTHER_MATERIAL', 'OUTCROP_SAMPLE', 'PALEONTOLOGY_SLIDE', 'PORE', 'RECOMBINED_FLUID_SAMPLE', 'RESERVOIR_FLUID_SYSTEM', 'ROCK_COMPONENT', 'ROCK_IN_OUTCROP', 'ROCK_POWDER_SAMPLE', 'ROCK_THIN_SECTION', 'SPECIFIC_FLUID_COMPONENT', 'SUBSURFACE_ROCK_SEGMENT', 'WELL_OPERATION_FLUID', 'WELL_OPERATION_SOLID', 'WELL_TEST_OPEN_PERIOD_RECOVERY', 'WIRELINE_FM_TEST_RECOVERY')),
FLUID_COMPONENT_SCHAR VARYING (19),
FLUID_COMPONENT_TCHAR VARYING (30),
FLUID_SYSTEM_SCHAR VARYING (19) REFERENCES BULK_MATERIAL (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 MATERIAL_CLASS (INSTANCE_S),
LAST_UPDATEDTIMESTAMP ,
LAST_UPDATED_BYCHAR VARYING (80),
NAMING_SYSTEMCHAR VARYING (80) REFERENCES NAMING_SYSTEM (IDENTIFIER),
OCCURRENCE_NUMBERINTEGER,
OUTCROP_SCHAR VARYING (19) REFERENCES GEOLOGIC_FEATURE (INSTANCE_S),
QUALITYCHAR VARYING (2000),
ROCK_MATERIAL_SCHAR VARYING (19) REFERENCES BULK_MATERIAL (INSTANCE_S),
R_DIAMETERCHAR VARYING (80) REFERENCES R_DIAMETER (IDENTIFIER),
R_EXISTENCE_KINDCHAR VARYING (80) NOT NULL REFERENCES R_EXISTENCE_KIND (IDENTIFIER),
SAMPLE_THICKNESSFLOAT,
SAMPLE_THICKNESS_UCHAR VARYING (15) REFERENCES R_UNIT_OF_MEASURE (ACRONYM),
SOURCECHAR VARYING (80),
TIME_TO_SURFACEFLOAT,
TIME_TO_SURFACE_UCHAR VARYING (15) REFERENCES R_UNIT_OF_MEASURE (ACRONYM),
TOP_MISSING_SECTIONFLOAT,
TOP_MISSING_SECTION_UCHAR VARYING (15) REFERENCES R_UNIT_OF_MEASURE (ACRONYM),
WELLBORE_SCHAR VARYING (19) REFERENCES WELLBORE (INSTANCE_S),
WELL_TEST_RECOVERY_SCHAR VARYING (19) REFERENCES BULK_MATERIAL (INSTANCE_S)
)


Generated on Tue Jul 10 19:39:42 2001
© Copyright 2001 POSC. All rights reserved.