The representation of spatial position in a wellbore as a composite of wellbore positions.

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


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.


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.