Table: Contact_Address_Type
Tags: read-only

Content:
1Business
2Home
3Other
Columns
NameTypeConstraintsDescription
contact_address_type_KEYintNOT NULL1=Business
2=Home
3=Other
descriptionnvarchar (30)NOT NULLDescription.
Primary key
NameColumnsDescription
PK_Contact_Address_Type$contact_address_type_KEYcontact_address_type_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Contact_Address_Type__descriptiondescriptionEach description must be unique.
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Contact__Contact_Address_Type__mailing__contact_address_type_KEYmailing__contact_address_type_KEYContact
FK_Contact__Contact_Address_Type__primary__contact_address_type_KEYprimary__contact_address_type_KEYContact
FK_Contact_Address__Contact_Address_Type__contact_address_type_KEYcontact_address_type_KEYContact_Address

Schema diagram