Thank you for your feedback! You have rated this topic in the last 30 days.
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.
This page has encountered an error. We've attempted to send the information to the server.