An association indicating a material is installed for a facility. The material is not consumed by its installation as a facility and may be reusable for many facilities.

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

Surrogate key of the table.


facility_s (FSK, M: CHAR VARYING(19))
facility_t (M: CHAR VARYING(16))

material_installation.facility
Indicates the facility that describes the business service the material is put to.
facility_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).
facility_t: Defines the name of the referenced table. Possible values are defined in @facility.


material_s (FSK, M: CHAR VARYING(19))
material_t (M: CHAR VARYING(16))

material_installation.material
Specifies the material being used for a facility or within an activity.
material_s: Implements a foreign key to a row in one of the tables projected from entity material depending on the value of the next column (See below).
material_t: Defines the name of the referenced table. Possible values are defined in @material.


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.