Stores notifications that need to be processed by a Worker task
Data model
Fields
| Field | Type | Description |
|---|---|---|
| created_date* | DATETIME | Date and time of notification creation |
| error_message | NVARCHAR (MAX) | Error generated for notifications with failed status |
| id* | INT | Registry ID |
| last_attempt_date | DATETIME | Date and time of last processing attempt |
| message_body* | NVARCHAR (MAX) | Message to be sent in JSON format |
| message_type* | TINYINT | Message type, 1-> WhatsApp, 2-> Teams |
| processed_date | DATETIME | Date and time of successful processing |
| retry_count* | TINYINT | Number of processing attempts |
| status* | TINYINT | Notification Status, 1-> Pending, 2-> Processing, 3-> Processing, 4-> Failed |
Primary Key
| PK_ASMS_NOTIFICATIONS_QUEUE |
|---|
| id |