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 | datetime | NOT NULL | |
name | nvarchar (50) | NOT NULL | Name of the contact. |
company | nvarchar (50) | NOT NULL | Company of the contact. |
title | nvarchar (20) | 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 (50) | NOT NULL | Name as it appears in Outlook's "File as" |
create_date | 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 |
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 |