Table: dbo.Elf_Transmission
Columns
NameTypeConstraintsDescription
elf_transmission_KEYint (4)NOT NULLKey for the Elf Transmission
elf_file_KEYint (4)NOT NULLKey into the associated ELF File table for the current row
elf_transmission_status_KEYint (4)NOT NULLThe current transmission status
status_change_datedatetime (8, 3)NOT NULLThe date that the status of the file has changed.
ack_data_xmlnvarchar (-1)The data from the acknowledgement file.
connect_event_idint (4)NOT NULLThe associated event id from Connect. This connect_event_id will be used to determine the chronological order of events when multiple events take place at the same time.
Primary key
NameColumnsDescription
PK_Elf_Transmissionelf_transmission_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Elf_Transmission__Elf_File__elf_file_KEYelf_file_KEYElf_File (elf_file_KEY)
FK_Elf_Transmission__Elf_Transmission_Status__elf_transmission_status_KEYelf_transmission_status_KEYElf_Transmission_Status (elf_transmission_status_KEY)

Schema diagram