The USERNOTIFICATION table contains activity confirmation requests and responses. The information includes the Activity ID, the user receiving the request, the user sending the request, any notes for the request, the send date and the type such as Confirm, Decline, Change, etc.
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
NOTIFYID (PK) |
STANDARDID(12) |
NOT NULL |
USERNOTIFICATION_NOTIFYID_PK (CA) |
|
|
|
ACTIVITYID (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
TOUSERID (FK) |
STANDARDID(12) |
NOT NULL |
USERNOTIFICATION_TOUSERID (IE) |
(Many) to (One) |
|
|
FROMUSERID (FK) |
STANDARDID(12) |
NOT NULL |
|
(Many) to (One) |
|
|
NOTES |
varchar(128) |
NULLS |
|
|
|
|
SENDDATE |
datetime(8) |
NULLS |
|
|
|
|
TYPE |
varchar(64) |
NULLS |
|
|
|
|
MODIFYDATE |
datetime(8) |
NULLS |
|
|
|
|
MODIFYUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
CREATEDATE |
datetime(8) |
NULLS |
|
|
|
|
CREATEUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
CREATESOURCE |
varchar(64) |
NULLS |
|
|
|