Version

Data Model for the ActivityResource Table

The ActivityResource table relates one or more Activity rows to their primary Resource row. This table has no analogous object in the WebSchedule™ object model. Instead, this relationship supports SQL joins that allows WebSchedule to work in terms of the Activities belonging to the application’s active Resource.

Column Name Data Type Null Value Allowed Remarks

ActivityID

int

No

Composite Primary Key (part 1). A numeric value that uniquely identifies one of potentially many Activities tied to the Resource identified by ResourceID.

ResourceID

int

No

Composite Primary Key (part 2). A numeric that value uniquely identifies the primary Resource associated with the Activity identified by ActivityID.