| Table: dbo.Bank_Transaction_Address | |||
| Columns | |||
| Name | Type | Constraints | Description |
| bank_transaction_KEY | int (4) | NOT NULL | Primary key and foreign key to the parent bank transaction |
| address_KEY | int (4) | NOT NULL | Foreign key to the related address table |
| Primary key | |||
| Name | Columns | Description | |
| PK_Bank_Transaction_Address$bank_transaction_KEY | bank_transaction_KEY | ||
| Unique constraints | |||
| Name | Columns | Description | |
| UK_Bank_Transaction_Address$address_KEY | address_KEY | ||
| Foreign keys | |||
| Name | Columns | Referenced table | Description |
| FK_Bank_Transaction_Address__Address__address_KEY | address_KEY | Address (address_KEY) | |
| FK_Bank_Transaction_Address__Bank_Transaction__bank_transaction_KEY | bank_transaction_KEY | Bank_Transaction (bank_transaction_KEY) | |