POSC Specifications: Epicentre Version 3.0 | Relational Implementation |
A naturally-occurring feature or intersection of features found within or on the Earth. Features are described in classes of geologic regions having substance and form, and/or geologic interfaces, expressing the topologic relationships of geologic regions or other intersections.
- instance_s (PK, M: CHAR VARYING(19))
- Surrogate key of the table.
- identifier (M: CHAR VARYING(80))
- earth_feature.identifier
The identifying name for the earth feature.
- instance_create_date (O: TIMESTAMP)
- e_and_p_data.instance_create_date
This is the date that this instance was created. This date is defined by the source if imported, or is the date the instance is created if a new instance.
- last_updated (O: TIMESTAMP)
- e_and_p_data.last_updated
This is the date that this instance was last updated. This value should be updated when any part of this instance is altered (except for inverse relationships).
- entity_type_nm (M: CHAR VARYING(30))
- Column that contains the name of the entity that this row is an instance of in case a table represents multiple entities. Possible values are: 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.
- abandonment_date (O: DATE)
- reservoir.abandonment_date
This is the date that the reservoir was officially abandoned.
- description (O: CHAR VARYING(2000))
- e_and_p_data.description
A remark or comment about the instance.
- discovery_date (O: DATE)
- reservoir.discovery_date
This is the date that the reservoir was officially discovered.
- instance_creator (O: CHAR VARYING(80))
- e_and_p_data.instance_creator
This is the person, company or application that created this instance. This identifies the party responsible for loading this instance.
- last_updated_by (O: CHAR VARYING(80))
- e_and_p_data.last_updated_by
This records the person or application making the update to this instance.
- source (O: CHAR VARYING(80))
- e_and_p_data.source
The provider of this instance, which is usually a data provider for imported/purchased data. If this instance is provided by POSC, then this attribute must be "POSC".
- source_content (O: CHAR VARYING(80))
- earth_feature.source_content
This is the original source of the data. This is the person, company or application that defined or specified the data (content) for this instance and is considered to be responslble for it. For example, POSC, EPSG, API, ISO, etc. This may be the same as or different from the provider of the instance (e.g., POSC).
- source_reference (O: CHAR VARYING(2000))
- earth_feature.source_reference
The reference used by source to provide the standard instance, such as Petroleum Industry Data Dictionary (PIDD), Websters Ninth New Collegiate Dictionary, etc.
- status (O: CHAR VARYING(11))
- earth_feature.status
The status of this instance in the version of Epicentre running in a data store. This is an enumerated datatype for which the following are the possible values: current, provisional, deprecated. Current - use without restriction. Provisional - use with caution, this value is for comment and may not appear in future releases of Epicentre. Deprecated - avoid use if possible, it is planned to remove this value in the next major release of Epicentre.
- surface_only (O: CHAR(1))
- earth_feature.surface_only
When set to TRUE, this earth_feature represents only the surface of the Earth and does not extend into the subsurface.
- feature_boundary_s (FSK, O: CHAR VARYING(19))
- feature_boundary_part.feature_boundary
This is the feature boundary of which this is a part.
Defines a foreign key to table geologic_feature.
- field_s (FSK, O: CHAR VARYING(19))
- pool.field
Specifies the field to which this pool is assigned.
Defines a foreign key to table field.
- kind_s (FSK, O: CHAR VARYING(19))
- earth_feature.kind
The class which asserts the fundamental nature of the feature.
Defines a foreign key to table earth_feature_class.
- lithostratigraphic_formation_s (FSK, O: CHAR VARYING(19))
- pool.lithostratigraphic_formation
This is the rock feature, specifically a lithostratigraphic formation, within which the pool is defined.
Defines a foreign key to table geologic_feature.
- naming_system (FNK, O: CHAR VARYING(80))
- earth_feature.naming_system
The naming system in which the identifier is defined and unique.
Defines a foreign key to table naming_system.
- r_fluid_contact (FNK, O: CHAR VARYING(80))
- fluid_feature_contact.ref_fluid_contact
A classification of a fluid contact based on such information as fluid types, (i.e., gas - oil or oil - water), or by a contrast in fluid characteristics, such as a water - water contact marking a density or salinity contrast.
Defines a foreign key to table r_fluid_contact.
- r_pool (FNK, O: CHAR VARYING(80))
- pool.ref_pool
The type of a pool, such as those defined by ERCB (defined, commingled, integrated scheme, undefined).
Defines a foreign key to table r_pool.
- r_reservoir_zone (FNK, O: CHAR VARYING(80))
- reservoir_zone.ref_reservoir_zone
The kind of reservoir zone, such as gas cap, invaded zone, oil leg, thief zone, etc.
Defines a foreign key to table r_reservoir_zone.
- reservoir_s (FSK, O: CHAR VARYING(19))
- reservoir_part.reservoir
Specifies the reservoir in which this is a part.
Defines a foreign key to table geologic_feature.
- seismic_geometry_set_s (FSK, O: CHAR VARYING(19))
- seismic_feature.seismic_geometry_set
Defines the geometry set which identifies this feature. This defines a scope for the name of the feature.
Defines a foreign key to table geophysical_geometry_set.
- unique_within_s (FSK, O: CHAR VARYING(19))
unique_within_t (O: CHAR VARYING(30))
- earth_feature.unique_within
This is another earth feature within which this earth feature is uniquely identified.
unique_within_s: Implements a foreign key to a row in one of the tables projected from entity earth_feature depending on the value of the next column (See below).
unique_within_t: Defines the name of the referenced table. Possible values are defined in @earth_feature.
- version_s (FSK, O: CHAR VARYING(19))
- earth_feature.version
This describes the version of this instance as defined by the provider.
Defines a foreign key to table r_version.
- well_s (FSK, O: CHAR VARYING(19))
- reservoir_drainage_feature.well
This is the well that the reservoir drainage region is defined for.
Defines a foreign key to table well.
- well_completion_s (FSK, O: CHAR VARYING(19))
- reservoir_drainage_feature.well_completion
This is the well completion that the reservoir drainage region is defined for.
Defines a foreign key to table well_completion.
- well_pattern_s (FSK, O: CHAR VARYING(19))
- reservoir_drainage_feature.well_pattern
This is the well pattern that the reservoir drainage region is defined for.
reservoir_pattern_feature.well_pattern
This is the well pattern that the reservoir pattern feature is defined for.
Defines a foreign key to table pfnu_group.
- whole_s (FSK, O: CHAR VARYING(19))
- seismic_feature.whole
Defines the feature that this feature is a part of.
Defines a foreign key to table geologic_feature.