Table: Contact
Columns
Name | Type | Constraints | Description
contact_KEY | int | NOT NULL | Assigned by COMMON_dp_Allocate_Unique_Identifiers. Database assigned primary key for this table.
update__staff_KEY | int | NOT NULL |
update_date_utc | datetime | NOT NULL |
name | nvarchar (250) | NOT NULL | Name of the contact.
company | nvarchar (250) | NOT NULL | Company of the contact.
title | nvarchar (250) | NOT NULL | Title of the contact.
salutation | nvarchar (40) | NOT NULL | Salutation for opening letters.
url | nvarchar (2048) | NOT NULL | Website address.
phone_position | nvarchar (14) | NOT NULL | Semicolon seperated list of contact_phone_type_KEY values indicating the user's preferred order of phone numbers.
address_position | nvarchar (4) | NOT NULL | Semicolon seperated list of contact_address_type_KEY values indicating the user's preferred order of displaying addresses.
email_position | nvarchar (6) | NOT NULL | Semicolon seperated list of contact_email_type_KEY values indicating the user's preferred order of displaying e-mail addresses.
primary__contact_phone_type_KEY | int | NOT NULL | Indicates which phone type is the primary phone number.
primary__contact_address_type_KEY | int | NOT NULL | Indicates which address type is the primary address.
mailing__contact_address_type_KEY | int | NOT NULL | Indicates which address type is the mailing address.
contact_type_KEY | int | NOT NULL | Key to Contact Type.
file_as | nvarchar (250) | NOT NULL | Name as it appears in Outlook's "File as"
create_date_utc | datetime | NOT NULL |
contact_guid | uniqueidentifier | NOT NULL |
primary__contact_email_type_KEY | int | NOT NULL | Indicates which email type is the primary email.
create__changeset_KEY | int | NOT NULL |
update__changeset_KEY | int | NOT NULL |
portal_user_KEY | int |  |
preferred_locale | nvarchar (50) | NOT NULL | Preferred locale for the contact used for language and formatting of dates, times, numbers when the locale is not available or if code running in another place needs to use it
time_zone_KEY | smallint (5) | NOT NULL | The preferred timezone for the contact. Use this when displaying time to the user and the time zone is not known.

Primary key
Name | Columns | Description
PK_Contact$contact_KEY | contact_KEY | CLUSTERED
Unique constraints
Name | Columns | Description
UK_Contact$contact_guid | contact_guid | Each Contact must have its own contact_guid value.
Indexes
Name | Columns | Description
IX_Contact$contact_type_KEY | contact_type_KEY | Index supports foreign key FK_Contact__Contact_Type__contact_type_KEY
IX_Contact$mailing__contact_address_type_KEY | mailing__contact_address_type_KEY | Index supports foreign key FK_Contact__Contact_Address_Type__mailing__contact_address_type_KEY
IX_Contact$portal_user_KEY | portal_user_KEY | Index supports foreign key FK_Contact__Portal_User__portal_user_KEY
IX_Contact$primary__contact_address_type_KEY | primary__contact_address_type_KEY | Index supports foreign key FK_Contact__Contact_Address_Type__primary__contact_address_type_KEY
IX_Contact$primary__contact_email_type_KEY | primary__contact_email_type_KEY | Index supports foreign key FK_Contact__Contact_Email_Type__primary__contact_email_type_KEY
IX_Contact$primary__contact_phone_type_KEY | primary__contact_phone_type_KEY | Index supports foreign key FK_Contact__Contact_Phone_Type__primary__contact_phone_type_KEY

Foreign keys
Name | Columns | Referenced table | Description
FK_Contact__Portal_User__portal_user_KEY | portal_user_KEY | Portal_User |
FK_Contact__Time_Zone__time_zone_KEY | time_zone_KEY | Time_Zone |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Additional_Contact__Contact__child__contact_KEY | child__contact_KEY | Additional_Contact |
FK_Additional_Contact__Contact__parent__contact_KEY | parent__contact_KEY | Additional_Contact |
FK_Contact_Address__Contact__contact_KEY | contact_KEY | Contact_Address |
FK_Contact_Contact_Category__Contact__contact_KEY | contact_KEY | Contact_Contact_Category |
FK_Contact_Email__Contact__contact_KEY | contact_KEY | Contact_Email |
FK_Contact_Phone__Contact__contact_KEY | contact_KEY | Contact_Phone |
FK_File_Transfer__Contact__contact__contact_KEY | contact__contact_KEY | File_Transfer |
FK_File_Transfer__Contact__of__contact_KEY | of__contact_KEY | File_Transfer |
FK_File_Transfer__Contact__staff__contact_KEY | staff__contact_KEY | File_Transfer |
FK_Legacy_Contact_Portal_Mapping__Contact__contact_KEY | contact_KEY | Legacy_Contact_Portal_Mapping | on delete cascade;
FK_Legacy_Contact_Portal_Mapping__Contact__primary__contact_KEY | primary__contact_KEY | Legacy_Contact_Portal_Mapping |
FK_Office__Contact__contact_KEY | contact_KEY | Office |
FK_Staff__Contact__contact_KEY | contact_KEY | Staff |
FK_Client__Contact__billing__contact_KEY | billing__contact_KEY | Client |
FK_Client__Contact__contact_KEY | contact_KEY | Client |
FK_Client__Contact__preferred__contact_KEY | preferred__contact_KEY | Client |
FK_Client__Contact__referred_by__contact_KEY | referred_by__contact_KEY | Client |
FK_Interaction_Contact__Contact__contact_KEY | contact_KEY | Interaction_Contact | on delete cascade;
FK_Schedule_Item__Contact__of__contact_KEY | of__contact_KEY | Schedule_Item |
FK_Schedule_Item__Contact__with__contact_KEY | with__contact_KEY | Schedule_Item |