Table: dbo.Notification_Queue_Record_Lock
This table locks records in parent table Notification_Queue, where a lock record indicates a queue record is being processed by a Cron task.
Columns
NameTypeConstraintsDescription
notification_queue_KEYint (4)NOT NULLPrimary key for this table and the key of the queue record that is locked for processing.
user_session_guiduniqueidentifier (16)NOT NULLThe user session guid associated with the Cron task that is locking and processing a queue record.
Primary key
NameColumnsDescription
PK_Notification_Queue_Record_Lock$notification_queue_KEYnotification_queue_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Notification_Queue_Record_Lock__Notification_Queue__notification_queue_KEYnotification_queue_KEYNotification_Queue (notification_queue_KEY)
FK_Notification_Queue_Record_Lock__User_Session__user_session_guiduser_session_guidUser_Session (user_session_guid)

Schema diagram