| Table: dbo.Web_Services_Transmit_Queue | |||
| Top level table to track data that needs to be uploaded to a web service | |||
| Columns | |||
| Name | Type | Constraints | Description |
| web_services_transmit_queue_KEY | int (4) | NOT NULL | Primary key; queue of data needing transmission to a web service |
| creation__staff_KEY | int (4) | NOT NULL | Foreign key; staff member who queued the data |
| creation_date | datetime (8, 3) | NOT NULL | Date and time the data was queued |
| Primary key | |||
| Name | Columns | Description | |
| PK_Web_Services_Transmit_Queue | web_services_transmit_queue_KEY | ||
| Foreign keys | |||
| Name | Columns | Referenced table | Description |
| FK_Web_Services_Transmit_Queue__Staff__creation__staff_KEY | creation__staff_KEY | Staff (staff_KEY) | |