This defines the activities contained by a schedule. The relative times of activities resulting from resolving the schedule are optionally defined with respect to another activity in the schedule using relative offset.

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

Surrogate key of the table.


activity_s (FSK, M: CHAR VARYING(19))
activity_t (M: CHAR VARYING(16))

schedule_activity.activity
Specifies this activity as being part of a schedule.
activity_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).
activity_t: Defines the name of the referenced table. Possible values are defined in @activity.


schedule_s (FSK, M: CHAR VARYING(19))

schedule_activity.schedule
Indicates the schedule in which the activity is being described.
Defines a foreign key to table schedule.


relative_time (O: FLOAT)
relative_time_u (FNK, O: CHAR VARYING(15))

schedule_activity.relative_time
The relative offset of the start time of the scheduled activity from the start time of the "relative to" schedule activity. Positive offsets are interpreted as meaning later in time.
relative_time_u: Defines the unit of measure. Defines a foreign key to table r_uom.


scheduled_cost (O: FLOAT)
scheduled_cost_u (FNK, O: CHAR VARYING(15))

schedule_activity.scheduled_cost
The cost of an activity, estimated in the context of the schedule.
scheduled_cost_u: Defines the currency unit. Defines a foreign key to table r_currency_unit.


relative_to_s (FSK, O: CHAR VARYING(19))

schedule_activity.relative_to
Indicates an activity schedule which acts as a reference for the relative start time of this activity schedule.
Defines a foreign key to table schedule_act.