A nonspecific wellbore point.

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

Surrogate key of the table.


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

position_in_wellbore.wellbore
The wellbore in which this wellbore interval was created.
Defines a foreign key to table wellbore.


description (O: CHAR VARYING(2000))

earth_model_object.description
A textual description of the earth model object.


emodel_object_id (O: CHAR VARYING(40))

earth_model_object.identifier
The local label used to identify an earth model object.


depth_1_o (O: FLOAT)
depth_1_ou (FNK, O: CHAR VARYING(15))
depth_o_s (FSK, O: CHAR VARYING(19))
depth_o_t (O: CHAR VARYING(16))
depth_cs (FNK, O: CHAR VARYING(40))

pty_location_1d.data_value
A coordinate point in a one dimensional coordinate system.
These columns have been duplicated through attribute wellbore_point.pty_location_1d, which establishes the relationship between the original and duplicated column(s).
This column is a duplicate of column p_location_1d.data_value_1_o.
depth_1_ou: Defines the unit of measure. Defines a foreign key to table r_uom.
This column is a duplicate of column p_location_1d.data_value_1_ou.
depth_o_s: Defines the origin of the coordinate value(s).Implements a foreign key to a row in one of the tables projected from entity vertex depending on the value of the next column (See below).
This column is a duplicate of column p_location_1d.data_value_o_s.
depth_o_t: Defines the name of the referenced table. Possible values are: .
This column is a duplicate of column p_location_1d.data_value_o_t.
depth_cs: Defines the coordinate system of the coordinate value(s). Defines a foreign key to table coordinate_sys.
This column is a duplicate of column p_location_1d.data_value_cs.


pt_1_o (O: FLOAT)
pt_1_ou (FNK, O: CHAR VARYING(15))
pt_2_o (O: FLOAT)
pt_2_ou (FNK, O: CHAR VARYING(15))
pt_o_s (FSK, O: CHAR VARYING(19))
pt_o_t (O: CHAR VARYING(16))
pt_cs (FNK, O: CHAR VARYING(40))

pty_location_2d.data_value
The coordinates of a point in a two dimensional coordinate system.
These columns have been duplicated through attribute wellbore_point.pty_location_2d, which establishes the relationship between the original and duplicated column(s).
This column is a duplicate of column p_location_2d.data_value_1_o.
pt_1_ou: Defines the unit of measure. Defines a foreign key to table r_uom.
This column is a duplicate of column p_location_2d.data_value_1_ou.
This column is a duplicate of column p_location_2d.data_value_2_o.
pt_2_ou: Defines the unit of measure. Defines a foreign key to table r_uom.
This column is a duplicate of column p_location_2d.data_value_2_ou.
pt_o_s: Defines the origin of the coordinate value(s).Implements a foreign key to a row in one of the tables projected from entity vertex depending on the value of the next column (See below).
This column is a duplicate of column p_location_2d.data_value_o_s.
pt_o_t: Defines the name of the referenced table. Possible values are: .
This column is a duplicate of column p_location_2d.data_value_o_t.
pt_cs: Defines the coordinate system of the coordinate value(s). Defines a foreign key to table coordinate_sys.
This column is a duplicate of column p_location_2d.data_value_cs.


wellbore_id (O: 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.
This column has been duplicated through attribute position_in_wellbore.wellbore, which establishes the relationship between the original and duplicated column(s).
This column is a duplicate of column wellbore.wellbore_id.


geologic_ftr_s (FSK, O: CHAR VARYING(19))
geologic_ftr_t (O: CHAR VARYING(16))

position_in_wellbore.geologic_feature
Specifies a geologic feature intersecting the path of a wellbore.
geologic_ftr_s: Implements a foreign key to a row in one of the tables projected from entity geologic_feature depending on the value of the next column (See below).
geologic_ftr_t: Defines the name of the referenced table. Possible values are defined in @geologic_feature.


geoscience_ntrp_s (FSK, O: CHAR VARYING(19))

earth_model_object.geoscience_interpretation
The activity which created this object.
Defines a foreign key to table geoscience_ntrp.


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

wellbore_point.ref_wellbore_point
A meaningful classification based on industry terminology. Examples are spud point, kickoff point, side track point, casing shoe, core point etc.
Defines a foreign key to table r_wellbore_pt.


rock_ftr_part_s (FSK, O: CHAR VARYING(19))
rock_ftr_part_t (O: CHAR VARYING(16))

earth_model_object.rock_feature_part
This points to the rock feature part that this earth model object is representing spatially.
rock_ftr_part_s: Implements a foreign key to a row in one of the tables projected from entity rock_feature_part depending on the value of the next column (See below).
rock_ftr_part_t: Defines the name of the referenced table. Possible values are defined in @rock_feature_part.


wb_cmpn_fcl_s (FSK, O: CHAR VARYING(19))
wb_cmpn_fcl_t (O: CHAR VARYING(16))

position_in_wellbore.wellbore_component_facility
Indicates a facility which is located by this wellbore position.
wb_cmpn_fcl_s: Implements a foreign key to a row in one of the tables projected from entity wellbore_component_facility depending on the value of the next column (See below).
wb_cmpn_fcl_t: Defines the name of the referenced table. Possible values are defined in @wellbore_component_facility.


well_cmpl_s (FSK, O: CHAR VARYING(19))

position_in_wellbore.well_completion
Indicates the well completion which is found at this position.
Defines a foreign key to table well_completion.