POSC Specifications: Epicentre Version 3.0 | Relational Implementation |
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. For example, a gathering center facility may be an assembly of separation, gas treatment, gas compression, and liquid stabilization and storage facilities.
- 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).
- composition_type (FNK, M: CHAR VARYING(80))
- facility_composition.composition_type
This defines the type of composition such as assembly, linear assembly or collection.
Defines a foreign key to table r_composition_type.
- whole_s (FSK, M: CHAR VARYING(19))
- facility_composition.whole
This is the general facility whose composition is being described. This represents the 'whole' of a 'parts-assembly' relationship.
Defines a foreign key to table general_facility.
- entity_type_nm (M: CHAR VARYING(30))
- 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_specific_composition, facility_type_composition.
- count (O: INTEGER)
- facility_type_composition.count
This declares the number of subfacilities of type 'part' that are components of the 'whole' facility. These components are not in a specified order among themselves. If sequence and count are both specified then this is a repetition count and there should normally not be any interspersed facilities.
- description (O: CHAR VARYING(2000))
- e_and_p_data.description
A remark or comment about the instance.
- 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_unit_of_measure.
- end_time (O: TIMESTAMP)
end_time_cd (O: CHAR(1))
end_time_yr (O: FLOAT)
end_time_yp (O: INTEGER)
end_time_dy (O: INTEGER)
end_time_hr (O: INTEGER)
end_time_mt (O: INTEGER)
end_time_st (O: FLOAT)
end_time_of (O: FLOAT)
- transient_association.end_time
End time of the association.
- 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.
- is_current (O: CHAR(1))
- transient_association.is_current
When TRUE, this flag indicates that this instance is designated as a current instance. This flag can be used in place of time based attributes or can be used in conjunction with them; however, it should not conflict with them.
- 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.
- sequence (O: INTEGER)
- facility_composition.sequence
This describes the sequence of the part facility as a component of the whole facility.
- 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".
- start_time (O: TIMESTAMP)
start_time_cd (O: CHAR(1))
start_time_yr (O: FLOAT)
start_time_yp (O: INTEGER)
start_time_dy (O: INTEGER)
start_time_hr (O: INTEGER)
start_time_mt (O: INTEGER)
start_time_st (O: FLOAT)
start_time_of (O: FLOAT)
- transient_association.start_time
Start time of the association.
- caused_by_s (FSK, O: CHAR VARYING(19))
- transient_association.caused_by
Specifies the activity which establishes this association.
Defines a foreign key to table activity.
- specific_part_s (FSK, O: CHAR VARYING(19))
specific_part_t (O: CHAR VARYING(30))
- facility_specific_composition.part
Indicates the facility that is described as being a part of the whole facility. This represents the 'part' of a 'parts-assembly' relationship.
specific_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).
specific_part_t: Defines the name of the referenced table. Possible values are defined in @facility.
- type_part_s (FSK, O: CHAR VARYING(19))
- facility_type_composition.part
Indicates that the part facility is a member of this class. This class represents the 'part' of a 'parts-assembly' relationship.
Defines a foreign key to table facility_class.
- r_transient_period (FNK, O: CHAR VARYING(80))
- 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_period.
- terminated_by_s (FSK, O: CHAR VARYING(19))
- transient_association.terminated_by
Specifies the activity which established the termination of a transient association between two objects.
Defines a foreign key to table activity.
Table is related to: data_collection_content, document_specification_part, @graphical_element
Primary Key Constraint on: INSTANCE_S
Generated on Tue Jul 10 16:22:25 2001
© Copyright 2001 POSC. All rights reserved.