Table: dbo.Web_Services_Client_Deletion_Queue | |||
Table to track deleted clients pending transmission to Web Services | |||
Columns | |||
Name | Type | Constraints | Description |
web_services_client_deletion_queue_KEY | int (4) | NOT NULL | Primary Key; queue of deleted client guids pending transmission to Web Services |
web_services_transmit_queue_KEY | int (4) | NOT NULL | Foreign key; queue of all data pending transmission to Web Services |
client_guid | uniqueidentifier (16) | NOT NULL | Guid of a client which has been deleted from SBPR |
Primary key | |||
Name | Columns | Description | |
PK_Web_Services_Client_Deletion_Queue | web_services_client_deletion_queue_KEY |
Foreign keys | |||
Name | Columns | Referenced table | Description |
FK_Web_Services_Client_Deletion_Queue__Web_Services_Transmit_Queue__web_services_transmit_queue_KEY | web_services_transmit_queue_KEY | Web_Services_Transmit_Queue (web_services_transmit_queue_KEY) |