Table: dbo.Contact_Address_N_Address
This table links a contact address record to an address record.
Columns
NameTypeConstraintsDescription
contact_address_KEYint (4)NOT NULLPrimary Key for this table; FK to the Contact_Address table
address_KEYint (4)NOT NULLFK to the Address table
Primary key
NameColumnsDescription
PK_Contact_Address_N_Address$contact_address_KEYcontact_address_KEY
Unique constraints
NameColumnsDescription
UK_Contact_Address_N_Address$contact_address_KEYcontact_address_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Contact_Address_N_Address__Address__address_KEYaddress_KEYAddress (address_KEY)
FK_Contact_Address_N_Address__Contact_Address__contact_address_KEYcontact_address_KEYContact_Address (contact_address_KEY)

Schema diagram