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) |