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. |
digita_entityid | uniqueidentifier | | The entity id is a unique identifier which is used to identify the same entity across products. Each product may have their own primary or identifying key for an entity. This identifier allows data for the same entity to flow between applications. |
digita_metadata | nvarchar (-1) | | The metadata is a block of xml (serialized object) which describes the scope of the entities data this product is interested in. This reduces the number of phantom changes being fired when changes are outside of the scope. |
PK_Contact$contact_KEY | contact_KEY | CLUSTERED |
UK_Contact$contact_guid | contact_guid | Each Contact must have its own contact_guid value. |
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 |