This association links two activities where one activity (pointed to by the "caused_by" attribute) causes another activity (pointed to by the "results_in" attribute)to happen. For example, an activity of spilling hazardous chemicals may result in a clean-up activity. In Epicentre, the activity_cause_and_effect entity would link the "caused_by" activity of spilling hazardous chemicals to the "results_in" activity of cleaning up.

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

Surrogate key of the table.


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

activity_cause_and_effect.caused_by
This is the activity that was the cause of the cause and effect association. For example, an activity of spilling hazardous chemicals may result in a clean-up activity. In Epicentre, the activity_cause_and_effect entity would link the "cause" activity of spilling hazardous chemicals to the result activity of cleaning up. This attribute points to the "cause" activity.
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.


result_s (FSK, M: CHAR VARYING(19))
result_t (M: CHAR VARYING(16))

activity_cause_and_effect.result
This is the activity that is the result of this activity cause and effect association. For example, an activity of spilling hazardous chemicals may result in a clean-up activity. In Epicentre, the activity_cause_and_effect entity would link the activity of spilling hazardous chemicals to the "result" activity of cleaning up. This attribute points to the "result" activity.
result_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).
result_t: Defines the name of the referenced table. Possible values are defined in @activity.


description (O: CHAR VARYING(2000))

activity_cause_and_effect.description
A description or comment on how or why one activity caused another one to happen.


intentional (O: CHAR(1))

activity_cause_and_effect.intentional
This attribute is used to describe the fact that one activity was intended to cause another activity to occur. If "True", then the cause was intended, if "False" then it was not intended.