Table sem5.dbo.NOTIFICATIONALERTS
Keeps the notification conditions

Generated by
SchemaSpy
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
IDX char 32
NOTAG_IDX char 32 ('') Notification which triggered this alert (Pointer to table 'notification')
ALERTDATETIME datetime 16,3 ('19700101') Time stamp when the alert was generated
SUBJECT nvarchar 510 ('') Subject of alert
MSG nvarchar 2048 ('') Notification alert message text
HYPERLINK nvarchar 1024 ('') Link to report with details about alert situation
ACKNOWLEDGED int 4 ((0)) Flag whether the alert has been acknowledged
ACKNOWLEDGED_USERID char 32 ('') GUID of user who acknowledged this notification
ACKNOWLEDGED_TIME datetime 16,3 ('19700101') Time when notification was acknowledged
USN bigint 8 ((1)) A USN-based serial number; this ID is not unique.
TIME_STAMP bigint 8 ((0)) The time when the event is logged into system (GMT), which is server side time
DELETED tinyint 1 ((0)) Deleted row; 0 = Not deleted, 1 = deleted

Analyzed at Mon Oct 29 12:07 PDT 2012

Indexes:
Column(s) Type Sort Constraint Name
IDX Primary key Asc PK_NOTIFICATIONALERTS