Table: dbo.Transfer_Bank_Transaction
Columns
NameTypeConstraintsDescription
client__bank_transaction_KEYint (4)NOT NULLKey of client transaction involved in the transfer.
impound__bank_transaction_KEYint (4)NOT NULLKey of impound transaction involved in the transfer.
Primary key
NameColumnsDescription
PK_Transfer_Bank_Transaction$client__bank_transaction_KEYclient__bank_transaction_KEY
Unique constraints
NameColumnsDescription
UK_Transfer_Bank_Transaction$client__bank_transaction_KEY$impound__bank_transaction_KEYclient__bank_transaction_KEY, impound__bank_transaction_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Transfer_Bank_Transaction__Bank_Transaction__client__bank_transaction_KEYclient__bank_transaction_KEYBank_Transaction (bank_transaction_KEY)
FK_Transfer_Bank_Transaction__Bank_Transaction__impound__bank_transaction_KEYimpound__bank_transaction_KEYBank_Transaction (bank_transaction_KEY)

Schema diagram