Table: dbo.Bank_Transaction_Reversal
Columns
NameTypeConstraintsDescription
reversed__bank_transaction_KEYint (4)NOT NULLPrimary key and foreign key to the parent bank transaction being reversed
reversal__bank_transaction_KEYint (4)NOT NULLForeign key to the bank transaction created to reverse the other
Primary key
NameColumnsDescription
PK_Bank_Transaction_Reversal$reversal__bank_transaction_KEYreversal__bank_transaction_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Bank_Transaction_Reversal__Bank_Transaction__reversal__bank_transaction_KEYreversal__bank_transaction_KEYBank_Transaction (bank_transaction_KEY)
FK_Bank_Transaction_Reversal__Bank_Transaction__reversed__bank_transaction_KEYreversed__bank_transaction_KEYBank_Transaction (bank_transaction_KEY)

Schema diagram