POSC Specifications: Epicentre Version 3.0 | Relational Implementation |
A limit or restriction on the times at which two activities may occur in a specified schedule. The constraints may describe the future (and constrain two planned activities) or the past (implying the times of actual activities were constrained). For example, assembly could not start until the components were delivered.
- 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).
- constraint_for_s (FSK, M: CHAR VARYING(19))
- schedule_constraint.constraint_for
Gives the activity that is constrained by this schedule constraint.
Defines a foreign key to table activity.
- r_schedule_constraint (FNK, M: CHAR VARYING(80))
- schedule_constraint.ref_schedule_constraint
The constraint kind, describing the logical condition of the constrained activity with respect to either the constraining activity or absolute time. Examples are: start of constrained activity leads the end of the constraining activity by relative time; start of constrained activity lags absolute time by relative time.
Defines a foreign key to table r_schedule_constraint.
- schedule_s (FSK, M: CHAR VARYING(19))
- schedule_constraint.schedule
Gives the schedule that the schedule constraint is valid for. A schedule constraint is only valid for one schedule.
Defines a foreign key to table schedule.
- absolute_time (O: TIMESTAMP)
absolute_time_cd (O: CHAR(1))
absolute_time_yr (O: FLOAT)
absolute_time_yp (O: INTEGER)
absolute_time_dy (O: INTEGER)
absolute_time_hr (O: INTEGER)
absolute_time_mt (O: INTEGER)
absolute_time_st (O: FLOAT)
absolute_time_of (O: FLOAT)
- schedule_constraint.absolute_time
A reference to a calendar date and clock time, constraining the time at which the constrained activity of the schedule constraint may be scheduled. The type of constraint using the absolute time value is given by the constraint kind.
- activity_duration (O: DAYTIMEINTERVAL)
- schedule_constraint.activity_duration
The duration of the constrained activity of the schedule constraint. This may act as an upper limit, a lower limit or both. The limit type is specified by the constraint kind.
- 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.
- relative_time (O: DAYTIMEINTERVAL)
- schedule_constraint.relative_time
The time interval between the constrained activity and either the constraining activity or the absolute time for the schedule constraint. The role of the time interval is given by the constraint kind.
- 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".
- constrained_by_s (FSK, O: CHAR VARYING(19))
- schedule_constraint.constrained_by
This activity acts as a constraint, via the schedule constraint, upon the other activity related to this schedule constraint.
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:59:58 2001
© Copyright 2001 POSC. All rights reserved.