ABANDONMENT_DATE | DATE | , |
DESCRIPTION | CHAR VARYING (2000) | , |
DISCOVERY_DATE | DATE | , |
ENTITY_TYPE_NM | CHAR VARYING (30) | NOT NULL CHECK (ENTITY_TYPE_NM IN ('AQUIFER', 'FEATURE_BOUNDARY_PART', 'FLUID_FEATURE_CONTACT', 'GEOLOGIC_FAULT', 'OUTCROP', 'POOL', 'RESERVOIR', 'RESERVOIR_DRAINAGE_FEATURE', 'RESERVOIR_PATTERN_FEATURE', 'RESERVOIR_ZONE', 'ROCK_FEATURE', 'ROCK_SURFACE', 'SEISMIC_FEATURE', 'STRATIGRAPHIC_MARKER')), |
FEATURE_BOUNDARY_S | CHAR VARYING (19) | REFERENCES GEOLOGIC_FEATURE (INSTANCE_S), |
FIELD_S | CHAR VARYING (19) | REFERENCES FIELD (INSTANCE_S), |
IDENTIFIER | CHAR VARYING (80) | NOT NULL, |
INSTANCE_CREATE_DATE | TIMESTAMP | , |
INSTANCE_CREATOR | CHAR VARYING (80) | , |
INSTANCE_S | CHAR VARYING (19) | NOT NULL PRIMARY KEY, |
KIND_S | CHAR VARYING (19) | REFERENCES EARTH_FEATURE_CLASS (INSTANCE_S), |
LAST_UPDATED | TIMESTAMP | , |
LAST_UPDATED_BY | CHAR VARYING (80) | , |
LITHOSTRATIGRAPHIC_FORMATION_S | CHAR VARYING (19) | REFERENCES GEOLOGIC_FEATURE (INSTANCE_S), |
NAMING_SYSTEM | CHAR VARYING (80) | REFERENCES NAMING_SYSTEM (IDENTIFIER), |
RESERVOIR_S | CHAR VARYING (19) | REFERENCES GEOLOGIC_FEATURE (INSTANCE_S), |
R_FLUID_CONTACT | CHAR VARYING (80) | REFERENCES R_FLUID_CONTACT (IDENTIFIER), |
R_POOL | CHAR VARYING (80) | REFERENCES R_POOL (IDENTIFIER), |
R_RESERVOIR_ZONE | CHAR VARYING (80) | REFERENCES R_RESERVOIR_ZONE (IDENTIFIER), |
SEISMIC_GEOMETRY_SET_S | CHAR VARYING (19) | REFERENCES GEOPHYSICAL_GEOMETRY_SET (INSTANCE_S), |
SOURCE | CHAR VARYING (80) | , |
SOURCE_CONTENT | CHAR VARYING (80) | , |
SOURCE_REFERENCE | CHAR VARYING (2000) | , |
STATUS | CHAR VARYING (11) | , |
SURFACE_ONLY | CHAR (1) | , |
UNIQUE_WITHIN_S | CHAR VARYING (19) | , |
UNIQUE_WITHIN_T | CHAR VARYING (30) | , |
VERSION_S | CHAR VARYING (19) | REFERENCES R_VERSION (INSTANCE_S), |
WELL_COMPLETION_S | CHAR VARYING (19) | REFERENCES WELL_COMPLETION (INSTANCE_S), |
WELL_PATTERN_S | CHAR VARYING (19) | REFERENCES PFNU_GROUP (INSTANCE_S), |
WELL_S | CHAR VARYING (19) | REFERENCES WELL (INSTANCE_S), |
WHOLE_S | CHAR VARYING (19) | REFERENCES GEOLOGIC_FEATURE (INSTANCE_S) |
)