Table: dbo.Payable_Transaction_N_Elf_File
Maps the payable transaction to the electronic filing (ELF) file that paid it.
Columns
NameTypeConstraintsDescription
payable_transaction_KEYint (4)NOT NULLForeign key to the payable transaction that is being paid by the associated elf file.
elf_file_KEYint (4)NOT NULLForeign key to the elf file that is paying the associated liability.
Primary key
NameColumnsDescription
PK_Payable_Transaction_N_Elf_File$payable_transaction_KEYpayable_transaction_KEY
Unique constraints
NameColumnsDescription
UK_Payable_Transaction_N_Elf_File$payable_transaction_KEY$elf_file_KEYpayable_transaction_KEY, elf_file_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Payable_Transaction_N_Elf_File__Elf_File__elf_file_KEYelf_file_KEYElf_File (elf_file_KEY)
FK_Payable_Transaction_N_Elf_File__Payable_Transaction__payable_transaction_KEYpayable_transaction_KEYPayable_Transaction (payable_transaction_KEY)

Schema diagram