An association indicating that one facility is a component or part of a general facility. A facility may be a part of many general facilities, sequentially and simultaneously. A composition is one of two types: assembly, which implies a structured whole; or collection, which implies independent parts. For example, a gathering center facility may be an assembly of separation, gas treatment, gas compression, and liquid stabilization and storage facilities.

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

Surrogate key of the table.


part_s (FSK, M: CHAR VARYING(19))
part_t (M: CHAR VARYING(16))

facility_composition.part
Indicates the facility that is described as being a part of a whole facility.
part_s: Implements a foreign key to a row in one of the tables projected from entity facility depending on the value of the next column (See below).
part_t: Defines the name of the referenced table. Possible values are defined in @facility.


whole_s (FSK, M: CHAR VARYING(19))
whole_t (M: CHAR VARYING(16))

facility_composition.whole
Indicates the general facility that acts as the whole for the part.
whole_s: Implements a foreign key to a row in one of the tables projected from entity general_facility depending on the value of the next column (See below).
whole_t: Defines the name of the referenced table. Possible values are defined in @general_facility.


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: facility_assembly, facility_collection.


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.


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.