Table: dbo.Web_Services_Client_Deletion_Queue
Table to track deleted clients pending transmission to Web Services
Columns
NameTypeConstraintsDescription
web_services_client_deletion_queue_KEYint (4)NOT NULLPrimary Key; queue of deleted client guids pending transmission to Web Services
web_services_transmit_queue_KEYint (4)NOT NULLForeign key; queue of all data pending transmission to Web Services
client_guiduniqueidentifier (16)NOT NULLGuid of a client which has been deleted from SBPR
Primary key
NameColumnsDescription
PK_Web_Services_Client_Deletion_Queueweb_services_client_deletion_queue_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Web_Services_Client_Deletion_Queue__Web_Services_Transmit_Queue__web_services_transmit_queue_KEYweb_services_transmit_queue_KEYWeb_Services_Transmit_Queue (web_services_transmit_queue_KEY)

Schema diagram