POSC Specifications: Epicentre Version 3.0 | Relational Implementation |
A unique, oriented hole from the intended bottom of a drilled interval to the surface of the Earth. If more than one path exists from a wellbore bottom point to a surface point, then more than one wellbore exists. The wellbore provides a conduit for operations within a well.
- instance_s (PK, M: CHAR VARYING(19))
- Surrogate key of the table.
- identifier (M: CHAR VARYING(80))
- facility.identifier
The name of the facility.
- 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).
- r_existence_kind (FNK, M: CHAR VARYING(80))
- facility.ref_existence_kind
The existence kind for the facility e.g. actual, planned, required or predicted.
Defines a foreign key to table r_existence_kind.
- well_s (FSK, M: CHAR VARYING(19))
- wellbore.well
Specifies the well in which this wellbore is a part.
Defines a foreign key to table well.
- abandonment_date (O: TIMESTAMP)
abandonment_date_cd (O: CHAR(1))
abandonment_date_yr (O: FLOAT)
abandonment_date_yp (O: INTEGER)
abandonment_date_dy (O: INTEGER)
abandonment_date_hr (O: INTEGER)
abandonment_date_mt (O: INTEGER)
abandonment_date_st (O: FLOAT)
abandonment_date_of (O: FLOAT)
- wellbore.abandonment_date
This is the date and time of day that the wellbore was permanently removed from service.
- completion_date (O: TIMESTAMP)
completion_date_cd (O: CHAR(1))
completion_date_yr (O: FLOAT)
completion_date_yp (O: INTEGER)
completion_date_dy (O: INTEGER)
completion_date_hr (O: INTEGER)
completion_date_mt (O: INTEGER)
completion_date_st (O: FLOAT)
completion_date_of (O: FLOAT)
- wellbore.completion_date
This is the date that the activities that created the wellbore were completed and the wellbore was available for service.
- description (O: CHAR VARYING(2000))
- e_and_p_data.description
A remark or comment about the instance.
- 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".
- kind_s (FSK, O: CHAR VARYING(19))
- facility.kind
The class which asserts the fundamental nature of the facility.
Defines a foreign key to table facility_class.
- naming_system (FNK, O: CHAR VARYING(80))
- facility.naming_system
The naming system in which the identifier is specified and determined to be unique.
Defines a foreign key to table naming_system.
Table is related to: activity, address, business_assoc_facility_involv, contract_object_designation, contract_oblig_object_fulfil, bulk_material, data_collection_content, derived_interest_makeup, document_specification_part, facility_alias, facility_classification, facility_fulfillment, facility_composition, coordinate_system, general_facility, @graphical_element, guideline_compliance, material_installation, object_activity_involvement, object_remark, object_subject_to_guideline, property_damage, p_fluid_level, p_generic_property, geophysical_geometry_set, space_time_operation, spatial_object, subject_of_contract, topological_relationship, @wellbore_component_facility, wellbore_geologic_target, wellbore_pick, well_log, well_log_trace
Primary Key Constraint on: INSTANCE_S
Fully implemented Unique Constraint on: IDENTIFIER, R_EXISTENCE_KIND, WELL_S
Generated on Tue Jul 10 17:11:41 2001
© Copyright 2001 POSC. All rights reserved.