Table: dbo.Notification_Queue
This table stores data for notifications that need to be processed by Cron tasks.
Columns
NameTypeConstraintsDescription
notification_queue_KEYint (4)NOT NULLThe primary key used for identifying a record in the notification queue.
notification_type_KEYtinyint (1)NOT NULLThe notification type of the record (set when the record is created).
client_KEYint (4)NOT NULLThe client key for the record (set when the record is created).
notification_status_KEYtinyint (1)NOT NULLThe notification status of the record (set to pending when the record is created and later updated by a Cron task).
detailsnvarchar (-1)The details of the notification (e.g., threshold amount, may be in xml format; set when the records is created).
recipientsnvarchar (-1)NOT NULLThe list of recipients the email should be sent to (set by the Cron task via database lookup).
sendernvarchar (600)NOT NULLThe from address of the email (set by the Cron task).
enqueued_time_utcdatetime (8, 3)NOT NULLThe date on which the notification was created and added to the table.
sent_time_utcdatetime (8, 3)Indicates the time the email was sent. This is saved for audit purposes.
Primary key
NameColumnsDescription
PK_Notification_Queuenotification_queue_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Notification_Queue__Notification_Type__notification_type_KEYnotification_type_KEYNotification_Type (notification_type_KEY)
FK_Notification_Queue__Client__client_KEYclient_KEYClient (client_KEY)
FK_Notification_Queue__Notification_Status__notification_status_KEYnotification_status_KEYNotification_Status (notification_status_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Notification_Queue_Record_Lock__Notification_Queue__notification_queue_KEYnotification_queue_KEYNotification_Queue_Record_Lock

Schema diagram