Data Model for the Resource Table
The Resource table describes a WebSchedule™ Resource, which is any person, place, or thing, for which Activities may be scheduled. All columns correspond with .NET properties that have the same name on a Resource object, unless otherwise noted.
Column Name |
Data Type |
Null Allowed? |
Remarks |
|
|
|
Primary Key. A numeric value uniquely identifying this Resource.
|
|
|
|
Name that uniquely identifies the resource it is meant to be a more user-friendly key.
|
|
|
|
Free-form text that describes this Resource.
|
|
|
|
Free-form text that contains the Resource’s e-mail address.
|
|
|
|
Timestamp that is used to detect concurrency conflicts.
|
Note
|
Note:
WebSchedule assumes the existence of an "Unassigned Resource". This data model avoids having null values in relationships between tables by requiring the presence of one row in the Resource table that must be pre-populated with a ResourceID of -999.
|