Table: Contact_Phone_Type
Tags: read-only Content:
1 | Business
2 | Fax
3 | Car
4 | Home
5 | Mobile
6 | Pager
7 | Other
Columns
Name | Type | Constraints | Description
contact_phone_type_KEY | int | NOT NULL | 1=Business 2=Fax 3=Car 4=Home 5=Mobile 6=Pager 7=Other
description | nvarchar (30) | NOT NULL | Description.

Primary key
Name | Columns | Description
PK_Contact_Phone_Type$contact_phone_type_KEY | contact_phone_type_KEY | CLUSTERED

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Contact__Contact_Phone_Type__primary__contact_phone_type_KEY | primary__contact_phone_type_KEY | Contact |
FK_Contact_Phone__Contact_Phone_Type__contact_phone_type_KEY | contact_phone_type_KEY | Contact_Phone |
FK_Interaction_Phone_Number__Contact_Phone_Type__contact_phone_type_KEY | contact_phone_type_KEY | Interaction_Phone_Number |