The RESOURCESCHEDULE table stores the information about the resources that are scheduled for activities. The information includes the resource ID, the activity ID, start and end dates for the resource being used, and the user responsible for the resource.
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
RSID (PK) |
STANDARDID(12) |
NOT NULL |
RESOURCESCHEDULE_RSID_PK (CA) |
|
|
|
RESOURCEID (FK) |
STANDARDID (12) |
NOT NULL |
RESOURCESCHEDULE_RESOURCEID (IE) |
(Many) to (One) |
|
|
ACTIVITYID (FK) |
STANDARDID(12) |
NULLS |
RESOURCESCHEDULE_ACTIVITYID (IE) |
(Many) to (One) |
|
|
STARTDATE |
datetime(8) |
NULLS |
|
|
|
|
ENDDATE |
datetime(8) |
NULLS |
|
|
|
|
USERID (FK) |
STANDARDID(12) |
NOT NULL |
|
(Many) to (One) |
|
|
DESCRIPTION |
varchar(128) |
NULLS |
|
|
|
|
CREATEDATE |
datetime(8) |
NULLS |
|
|
|
|
CREATEUSER (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
MODIFYDATE |
datetime(8) |
NULLS |
|
|
|
|
MODIFYUSER (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |