contact_KEY | int (4) | NOT NULL | Database assigned primary key for this table. |
name | nvarchar (100) | NOT NULL | Name of the contact. |
company | nvarchar (100) | NOT NULL | Company of the contact. |
title | nvarchar (40) | NOT NULL | Title of the contact. |
salutation | nvarchar (80) | NOT NULL | Salutation for opening letters. |
url | nvarchar (4096) | NOT NULL | Website address. |
phone_position | nvarchar (28) | NOT NULL | Semicolon seperated list of contact_phone_type_KEY values indicating the user's preferred order of phone numbers. |
address_position | nvarchar (8) | NOT NULL | Semicolon seperated list of contact_address_type_KEY values indicating the user's preferred order of displaying addresses. |
email_position | nvarchar (12) | 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 (4) | NOT NULL | Indicates which phone type is the primary phone number. |
primary__contact_address_type_KEY | int (4) | NOT NULL | Indicates which address type is the primary address. |
mailing__contact_address_type_KEY | int (4) | NOT NULL | Indicates which address type is the mailing address. |
contact_type_KEY | int (4) | NOT NULL | Key to Contact Type. |
file_as | nvarchar (100) | NOT NULL | Name as it appears in Outlook's "File as" |
contact_guid | uniqueidentifier (16) | NOT NULL | |
primary__contact_email_type_KEY | int (4) | NOT NULL | Indicates which email type is the primary email. |