Table: Contact_Address_Type
Tags: read-only Content:
1 | Business
2 | Home
3 | Other
Columns
Name | Type | Constraints | Description
contact_address_type_KEY | int | NOT NULL | 1=Business 2=Home 3=Other
description | nvarchar (30) | NOT NULL | Description.

Primary key
Name | Columns | Description
PK_Contact_Address_Type$contact_address_type_KEY | contact_address_type_KEY | CLUSTERED
Unique constraints
Name | Columns | Description
UK_Contact_Address_Type__description | description | Each description must be unique.

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Contact__Contact_Address_Type__mailing__contact_address_type_KEY | mailing__contact_address_type_KEY | Contact |
FK_Contact__Contact_Address_Type__primary__contact_address_type_KEY | primary__contact_address_type_KEY | Contact |
FK_Contact_Address__Contact_Address_Type__contact_address_type_KEY | contact_address_type_KEY | Contact_Address |