The ALERTNOTIFY table stores information about notifications that are specified for each alert. When an alert is activated, an e-mail message is sent to the appropriate user. The Urgency Manager in the Administrator is used to set up notification. The table includes information such as the selected alert, type of notification the user will receive, the user's e-mail address, and description of the notification.
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
ALERTNOTIFYID (PK) |
STANDARDID(12) |
NOT NULL |
ALERTNOTIFY_ALERTNOTIFYID_PK (CA) |
|
|
|
ALERTID (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
TYPE |
varchar(32) |
NULLS |
|
|
|
|
DATA |
varchar(255) |
NULLS |
|
|
|
|
DESCRIPTION |
varchar(128) |
NULLS |
|
|
|
|
CREATEUSER (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
CREATEDATE |
datetime(8) |
NULLS |
|
|
|
|
MODIFYUSER (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
MODIFYDATE |
datetime(8) |
NULLS |
|
|
|