POSC Specifications: Epicentre Version 3.0 | Relational Implementation |
An association indicating that activities characterized (via classification or kind of class) by an activity class may reasonably be expected to have a subactivity that is characterized by another activity class. This is not declaring the composition of a class. Rather it is declaring an expected composition of an activity that is a member of the class. A decomposition is not required but if a decomposition is defined then this is the expected decomposition. For example, a class of 'start car' might have three common compositions of class 'insert key', 'turn key' and 'release key' respectively. Thus, an activity which is characterized as 'start car' could be expected to have three subactivities which are respectively characterized as 'insert key', 'turn key' and 'release key'. This composition is the nominal composition of the actual activity (what is expected), but the actual activity composition should describe what was actually done rather than what was intended.
- 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).
- part_s (FSK, M: CHAR VARYING(19))
- common_activity_composition.part
This declares an activity class which commonly characterizes a subactivity of the 'assembly' activity. This class represents the 'part' activity of a 'parts-assembly' relationship.
Defines a foreign key to table activity_class.
- whole_s (FSK, M: CHAR VARYING(19))
- common_activity_composition.whole
This declares the activity class whose common composition is being described. This class represents the 'assembly' activity in a 'parts-assembly' relationship.
Defines a foreign key to table activity_class.
- count (O: INTEGER)
- common_activity_composition.count
This declares the number of subactivities of type 'part' that are normally expected to be components of 'whole' activity. These components are not in a specified order among themselves. A value of zero or a null value explicitly declares that any number of parts may be nominal components of the whole. If sequence and count are both specified then this is a repetition count and there should normally not be any interspersed activities.
- 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.
- 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.
- required_component (O: CHAR(1))
- common_activity_composition.required_component
True indicates that a member of the part class is a required component of a member of the whole class.
- sequence (O: INTEGER)
- common_activity_composition.sequence
This describes the expected sequence of the part activity as a nominal component of the whole activity. A value of zero or null explicitly declares that the sequence of this part is not defined.
- 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".
- source_content (O: CHAR VARYING(80))
- association_reference.source_content
This is the original source of the data. This is the person, company or application that defined or specified the data (content) for this instance and is considered to be responsible for it. For example, POSC, EPSG, API, ISO, etc. This may be the same as or different from the provider of the instance (e.g., POSC).
- source_reference (O: CHAR VARYING(2000))
- association_reference.source_reference
The reference used by source to provide the standard instance, such as Petroleum Industry Data Dictionary (PIDD), Websters Ninth New Collegiate Dictionary, etc.
- status (O: CHAR VARYING(11))
- association_reference.status
The status of this instance in the version of Epicentre running in a data store. This is an enumerated datatype for which the following are the possible values: current, provisional, deprecated. Current - use without restriction. Provisional - use with caution, this value is for comment and may not appear in future releases of Epicentre. Deprecated - avoid use if possible, it is planned to remove this value in the next major release of Epicentre.
- composition_type (FNK, O: CHAR VARYING(80))
- common_activity_composition.composition_type
This defines the expected type of composition such as assembly, linear assembly or collection.
Defines a foreign key to table r_composition_type.
- version_s (FSK, O: CHAR VARYING(19))
- association_reference.version
This describes the version of this instance as defined by the provider.
Defines a foreign key to table r_version.
Table is related to: data_collection_content, document_specification_part, @graphical_element
Primary Key Constraint on: INSTANCE_S
Generated on Tue Jul 10 16:07:33 2001
© Copyright 2001 POSC. All rights reserved.