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) |