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