POSC Specifications: Epicentre Version 3.0 | Relational Implementation |
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.
- instance_s (PK, M: CHAR VARYING(19))
- Surrogate key of the table.
- instance_create_date (O: TIMESTAMP)
- e_and_p_data.instance_create_date
This is the date that this instance was created. This date is defined by the source if imported, or is the date the instance is created if a new instance.
- last_updated (O: TIMESTAMP)
- e_and_p_data.last_updated
This is the date that this instance was last updated. This value should be updated when any part of this instance is altered (except for inverse relationships).
- caused_by_s (FSK, M: CHAR VARYING(19))
- 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.
Defines a foreign key to table activity.
- result_s (FSK, M: CHAR VARYING(19))
- 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.
Defines a foreign key to table activity.
- description (O: CHAR VARYING(2000))
- e_and_p_data.description
A remark or comment about the instance.
- instance_creator (O: CHAR VARYING(80))
- e_and_p_data.instance_creator
This is the person, company or application that created this instance. This identifies the party responsible for loading this instance.
- 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.
- last_updated_by (O: CHAR VARYING(80))
- e_and_p_data.last_updated_by
This records the person or application making the update to this instance.
- source (O: CHAR VARYING(80))
- e_and_p_data.source
The provider of this instance, which is usually a data provider for imported/purchased data. If this instance is provided by POSC, then this attribute must be "POSC".
Table is related to: data_collection_content, document_specification_part, @graphical_element
Primary Key Constraint on: INSTANCE_S
Fully implemented Unique Constraint on: CAUSED_BY_S, RESULT_S
Generated on Tue Jul 10 15:59:22 2001
© Copyright 2001 POSC. All rights reserved.