Table: dbo.Payable_Transaction_N_Shortfall_Transaction
This dictionary table associates a payable transaction with the shortfall transaction for which it was created.
Columns
NameTypeConstraintsDescription
payable_transaction_KEYint (4)NOT NULLPrimary key for the table and foreign key to Payable_Transaction table
shortfall_transaction_KEYint (4)NOT NULLForeign key to Shortfall_Transaction table
Primary key
NameColumnsDescription
PK_Payable_Transaction_N_Shortfall_Transaction$payable_transaction_KEYpayable_transaction_KEY
Unique constraints
NameColumnsDescription
UK_Payable_Transaction_N_Shortfall_Transaction$shortfall_transaction_KEYshortfall_transaction_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Payable_Transaction_N_Shortfall_Transaction__Payable_Transaction__payable_transaction_KEYpayable_transaction_KEYPayable_Transaction (payable_transaction_KEY)
FK_Payable_Transaction_N_Shortfall_Transaction__Shortfall_Transaction__shortfall_transaction_KEYshortfall_transaction_KEYShortfall_Transaction (shortfall_transaction_KEY)

Schema diagram