Table: dbo.Payable_Transaction_N_Magnetic_Media_File_Client
Maps the payable transaction to the magnetic media file client that paid it.
Columns
NameTypeConstraintsDescription
payable_transaction_KEYint (4)NOT NULLForeign key to the payable transaction that is being paid by the associated magnetic media file client.
magnetic_media_file_client_KEYint (4)NOT NULLForeign key to the magnetic media file client that is paying the associated liability.
Primary key
NameColumnsDescription
PK_Payable_Transaction_N_Magnetic_Media_File_Client$payable_transaction_KEYpayable_transaction_KEY
Unique constraints
NameColumnsDescription
UK_Payable_Transaction_N_Magnetic_Media_File_Client$payable_transaction_KEY$magnetic_media_file_client_KEYpayable_transaction_KEY, magnetic_media_file_client_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Payable_Transaction_N_Magnetic_Media_File_Client__Magnetic_Media_File_Client__magnetic_media_file_client_KEYmagnetic_media_file_client_KEYMagnetic_Media_File_Client (magnetic_media_file_client_KEY)
FK_Payable_Transaction_N_Magnetic_Media_File_Client__Payable_Transaction__payable_transaction_KEYpayable_transaction_KEYPayable_Transaction (payable_transaction_KEY)

Schema diagram