This entity describes the connection between two wellbore component facilities. It is not necessary to use this entitiy to describe components connected together to form an assembly, as the parts and assembly list relationship on wellbore component facility can be understood to contain this. Rather this should be used where, for example, two wellbore_component_facilities that are both assemblies are connected together, without one becoming part of the other.

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

Surrogate key of the table.


connected_with_s (FSK, M: CHAR VARYING(19))
connected_with_t (M: CHAR VARYING(16))

wellbore_component_facility_connection.connected_with
This is the other wellbore_component_facility that is connected to the designated wellbore_component_facility. To describe a packer connected to a casing_string, this attribute points to the casing_string.
connected_with_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).
connected_with_t: Defines the name of the referenced table. Possible values are defined in @wellbore_component_facility.


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

wellbore_component_facility_connection.wellbore_component_facility
This is the designated wellbore_component_facility that this connection is described for. For example, to describe a packer connected to a casing_string, this attribute points to thte packer.
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.


description (O: CHAR VARYING(2000))

transient_association.description
A description of the transient association.


duration (O: FLOAT)
duration_u (FNK, O: CHAR VARYING(15))

transient_association.duration
Defines the duration of the association expressed in any valid units of time.
duration_u: Defines the unit of measure. Defines a foreign key to table r_uom.


end_time (O: TIMESTAMP)

transient_association.end_time
End time of the association.


start_time (O: TIMESTAMP)

transient_association.start_time
Start time of the association.


caused_by_s (FSK, O: CHAR VARYING(19))
caused_by_t (O: CHAR VARYING(16))

transient_association.caused_by
Specifies the activity which establishes this association.
caused_by_s: Implements a foreign key to a row in one of the tables projected from entity activity depending on the value of the next column (See below).
caused_by_t: Defines the name of the referenced table. Possible values are defined in @activity.


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

wellbore_component_facility_connection.kind
The kind or type of wellbore component facility connection. For example, this might be "inside", "outside", "above" or "below".
Defines a foreign key to table r_wb_cmpn_fclcon.


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

transient_association.ref_transient_period
The type of period over which the property applies, such as day, month, quarter, cumulative, etc.
Defines a foreign key to table r_transient_pd.


terminated_by_s (FSK, O: CHAR VARYING(19))
terminated_by_t (O: CHAR VARYING(16))

transient_association.terminated_by
Specifies the activity which established the termination of a transient association between two objects.
terminated_by_s: Implements a foreign key to a row in one of the tables projected from entity activity depending on the value of the next column (See below).
terminated_by_t: Defines the name of the referenced table. Possible values are defined in @activity.