Table: dbo.Contact_Address_N_Address | |||
This table links a contact address record to an address record. | |||
Columns | |||
Name | Type | Constraints | Description |
contact_address_KEY | int (4) | NOT NULL | Primary Key for this table; FK to the Contact_Address table |
address_KEY | int (4) | NOT NULL | FK to the Address table |
Primary key | |||
Name | Columns | Description | |
PK_Contact_Address_N_Address$contact_address_KEY | contact_address_KEY | ||
Unique constraints | |||
Name | Columns | Description | |
UK_Contact_Address_N_Address$contact_address_KEY | contact_address_KEY |
Foreign keys | |||
Name | Columns | Referenced table | Description |
FK_Contact_Address_N_Address__Address__address_KEY | address_KEY | Address (address_KEY) | |
FK_Contact_Address_N_Address__Contact_Address__contact_address_KEY | contact_address_KEY | Contact_Address (contact_address_KEY) |