Table: dbo.Bank_Transaction_Address
Columns
NameTypeConstraintsDescription
bank_transaction_KEYint (4)NOT NULLPrimary key and foreign key to the parent bank transaction
address_KEYint (4)NOT NULLForeign key to the related address table
Primary key
NameColumnsDescription
PK_Bank_Transaction_Address$bank_transaction_KEYbank_transaction_KEY
Unique constraints
NameColumnsDescription
UK_Bank_Transaction_Address$address_KEYaddress_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Bank_Transaction_Address__Address__address_KEYaddress_KEYAddress (address_KEY)
FK_Bank_Transaction_Address__Bank_Transaction__bank_transaction_KEYbank_transaction_KEYBank_Transaction (bank_transaction_KEY)

Schema diagram