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.

wellbore_s (PK, M: CHAR VARYING(19))

Surrogate key of the table.


wellbore_id (M: CHAR VARYING(40))

wellbore.identifier
Identifier used to identify a wellbore within a well. This is often a sequence number or character, such as 1, 2, A, B, C, etc.


r_existence_kd_nm (FNK, M: CHAR VARYING(40))

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_kd.


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.


well_id (O: CHAR VARYING(40))

well.identifier
A unique identifying name for the well.
This column has been duplicated through attribute wellbore.well, which establishes the relationship between the original and duplicated column(s).
This column is a duplicate of column well.well_id.


abandonment_date (O: TIMESTAMP)

wellbore.abandonment_date
This is the date and time of day that the wellbore was permanently removed from service.


completion_date (O: TIMESTAMP)

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))

facility.description
A description of the facility.


r_naming_system_kd (FNK, O: CHAR VARYING(40))

wellbore.ref_naming_system
The naming system in which the identifier is specified and determined to be unique. Examples include: 12 digit API numbers, regulatory wellbore names, etc.
Defines a foreign key to table r_naming_system.


r_wellbore_kind (FNK, O: CHAR VARYING(40))

wellbore.ref_wellbore
The type of wellbore, either initial, re-spud, remedial sidetrack or sidetrack. This does not describe the purpose of the wellbore, but rather the circumstances during which the wellbore was created.
Defines a foreign key to table r_wellbore.


r_wellbore_purp_kd (FNK, O: CHAR VARYING(40))

wellbore.ref_wellbore_purpose
A description of the initial purpose of a wellbore. In the case of "re-spuds" and "remedial sidetracks", a group of wellbores should have the same purpose. Examples of wellbore purpose are: development wellbore, delineation wellbore, new pool test, and extension wellbore.
Defines a foreign key to table r_wellbore_purp.


r_wb_traj_shap_nm (FNK, O: CHAR VARYING(40))

wellbore.ref_wellbore_trajectory_shape
A general description of the intended trajectory profile.
Defines a foreign key to table r_wb_traj_shap.


typical_fcl_name (FNK, O: CHAR VARYING(40))

facility.typical_facility
Gives the typical facility whose specification was used as the generic basis for this facility.
Defines a foreign key to table typical_fcl.