I'm planning to use WebSchedule along with its database to store user Activities.
Qustion: How does WebSchedule database store the information that link user (who is logged in) with his/her Activities?
Looks like Resource is what suppose to represent a user. If that is so, then ResourceID needs to be linked with my custom User table, and I will have a table ResourceUserResource with two columns (ResourceID and UserID) where UserID is id of a user in my own database.
Am I on the right track here?
A resource can be a person, place or thing — so yes, you are on the right track. Resource was chosen to be general enough of a term that it allows for scheduling equipment, or listing events in a conference room, building or city. Most often, they are the users who own the activities, though.
There is an ActivityResource table that links a resource to its activities in a one-to-many relationship; see Data Model.
Hi,
I have a similar question. Let's say after getting a user name, then how do I feed the @OrganizerName in the storedprocedure Activity_SelByDate? Which method I need to call or modify and/or any changes to the current stored procedure? Also, the time adding a record to Activity table, how do I feed that @OrganizerName and create a link in the AcitivityResouce table? Thank you very much.
Do I have to build a custom solution to link my User table with Resource?
Like creating UserResource table with UserID and ResourceID.
The process as I imagine it would go like this.
I wonder if I'm missing something here. Is there a better way to do this or am I on the right track?