Table: dbo.Payable_Transaction_N_Elf_File | |||
Maps the payable transaction to the electronic filing (ELF) file that paid it. | |||
Columns | |||
Name | Type | Constraints | Description |
payable_transaction_KEY | int (4) | NOT NULL | Foreign key to the payable transaction that is being paid by the associated elf file. |
elf_file_KEY | int (4) | NOT NULL | Foreign key to the elf file that is paying the associated liability. |
Primary key | |||
Name | Columns | Description | |
PK_Payable_Transaction_N_Elf_File$payable_transaction_KEY | payable_transaction_KEY | ||
Unique constraints | |||
Name | Columns | Description | |
UK_Payable_Transaction_N_Elf_File$payable_transaction_KEY$elf_file_KEY | payable_transaction_KEY, elf_file_KEY |
Foreign keys | |||
Name | Columns | Referenced table | Description |
FK_Payable_Transaction_N_Elf_File__Elf_File__elf_file_KEY | elf_file_KEY | Elf_File (elf_file_KEY) | |
FK_Payable_Transaction_N_Elf_File__Payable_Transaction__payable_transaction_KEY | payable_transaction_KEY | Payable_Transaction (payable_transaction_KEY) |