A specific point in a wellbore that has a defined nature, role or purpose, such as being a datum for measurement.

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

Surrogate key of the table.


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.


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

wellbore_component_facility.wellbore
Specifies the wellbore in which this facility is installed.
Defines a foreign key to table wellbore.


entity_type_nm (M: CHAR VARYING(40))

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: bottomhole, derrick_floor_reference, ground_level, kelly_bushing_reference, kick_off_point.


description (O: CHAR VARYING(2000))

facility.description
A description of the facility.


end_date (O: TIMESTAMP)

wellbore_component_facility.end_date
This is the date and time of day when this wellbore component facility was permanently removed from service.


wb_cmpn_fcl_id (O: CHAR VARYING(40))

wellbore_component_facility.identifier
The label used to identify a facility.


start_date (O: TIMESTAMP)

wellbore_component_facility.start_date
This is the date and time when this wellbore component facility was placed in service within the wellbore.


belongs_to_assy_s (FSK, O: CHAR VARYING(19))
belongs_to_assy_t (O: CHAR VARYING(16))
belongs_to_assy_l (O: INTEGER)

wellbore_component_facility.component_parts
This points to the wellbore_component_facilities that this assembly is made up from. This relationship is a unique list, which represents the order in which the wellbore_component_facilities were assembled. This means that facilities next to each other in the list can be interpreted as connected to each other. The order is; the first in the list was first in the hole, i.e. is nearest the bottom of the well.
belongs_to_assy_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).
belongs_to_assy_t: Defines the name of the referenced table. Possible values are defined in @wellbore_component_facility.
belongs_to_assy_l: Provides the ordering of rows.


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.