Table: dbo.Notification_Queue
This table stores data for notifications that need to be processed by Cron tasks.
Columns
Name | Type | Constraints | Description
notification_queue_KEY | int (4) | NOT NULL | The primary key used for identifying a record in the notification queue.
notification_type_KEY | tinyint (1) | NOT NULL | The notification type of the record (set when the record is created).
client_KEY | int (4) | NOT NULL | The client key for the record (set when the record is created).
notification_status_KEY | tinyint (1) | NOT NULL | The notification status of the record (set to pending when the record is created and later updated by a Cron task).
details | nvarchar (-1) |  | The details of the notification (e.g., threshold amount, may be in xml format; set when the records is created).
recipients | nvarchar (-1) | NOT NULL | The list of recipients the email should be sent to (set by the Cron task via database lookup).
sender | nvarchar (600) | NOT NULL | The from address of the email (set by the Cron task).
enqueued_time_utc | datetime (8, 3) | NOT NULL | The date on which the notification was created and added to the table.
sent_time_utc | datetime (8, 3) |  | Indicates the time the email was sent. This is saved for audit purposes.

Primary key
Name | Columns | Description
PK_Notification_Queue | notification_queue_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Notification_Queue__Notification_Type__notification_type_KEY | notification_type_KEY | Notification_Type (notification_type_KEY) |
FK_Notification_Queue__Client__client_KEY | client_KEY | Client (client_KEY) |
FK_Notification_Queue__Notification_Status__notification_status_KEY | notification_status_KEY | Notification_Status (notification_status_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Notification_Queue_Record_Lock__Notification_Queue__notification_queue_KEY | notification_queue_KEY | Notification_Queue_Record_Lock |