Table: Contact_Phone_Type
Tags: read-only

Content:
1Business
2Fax
3Car
4Home
5Mobile
6Pager
7Other
Columns
NameTypeConstraintsDescription
contact_phone_type_KEYintNOT NULL1=Business
2=Fax
3=Car
4=Home
5=Mobile
6=Pager
7=Other
descriptionnvarchar (30)NOT NULLDescription.
Primary key
NameColumnsDescription
PK_Contact_Phone_Type$contact_phone_type_KEYcontact_phone_type_KEYCLUSTERED
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Contact__Contact_Phone_Type__primary__contact_phone_type_KEYprimary__contact_phone_type_KEYContact
FK_Contact_Phone__Contact_Phone_Type__contact_phone_type_KEYcontact_phone_type_KEYContact_Phone
FK_Interaction_Phone_Number__Contact_Phone_Type__contact_phone_type_KEYcontact_phone_type_KEYInteraction_Phone_Number

Schema diagram