Table: dbo.Contact
Columns
Name | Type | Constraints | Description
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.

Primary key
Name | Columns | Description
PK_Contact | contact_KEY |
Unique constraints
Name | Columns | Description
UK_Contact$contact_guid | contact_guid |

Foreign keys
Name | Columns | Referenced table | Description
FK_Contact__Contact_Address_Type__mailing__contact_address_type_KEY | mailing__contact_address_type_KEY | Contact_Address_Type (contact_address_type_KEY) |
FK_Contact__Contact_Address_Type__primary__contact_address_type_KEY | primary__contact_address_type_KEY | Contact_Address_Type (contact_address_type_KEY) |
FK_Contact__Contact_Email_Type__primary__contact_email_type_KEY | primary__contact_email_type_KEY | Contact_Email_Type (contact_email_type_KEY) |
FK_Contact__Contact_Phone_Type__primary__contact_phone_type_KEY | primary__contact_phone_type_KEY | Contact_Phone_Type (contact_phone_type_KEY) |
FK_Contact__Contact_Type__contact_type_KEY | contact_type_KEY | Contact_Type (contact_type_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Office__Contact__contact_KEY | contact_KEY | Office |
FK_Contact_Email__Contact__contact_KEY | contact_KEY | Contact_Email |
FK_Tax_Agent__Contact__contact_KEY | contact_KEY | Tax_Agent |
FK_Client__Contact__contact_KEY | contact_KEY | Client |
FK_Bank__Contact__contact_KEY | contact_KEY | Bank |
FK_Contact_Phone__Contact__contact_KEY | contact_KEY | Contact_Phone |
FK_Contact_Address__Contact__contact_KEY | contact_KEY | Contact_Address |
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_Client_Contact_Payroll_Administrator__Contact__contact_KEY | contact_KEY | Client_Contact_Payroll_Administrator |
FK_Client_1099_Tax_Form_Information__Contact__signature_1099__contact_KEY | signature_1099__contact_KEY | Client_1099_Tax_Form_Information | FOREIGN KEY constraint of signature 1099 contact_KEY for the Client_1099_Tax_Form_Information table.
FK_Client_1099_Tax_Form_Information__Contact__contact_1099__contact_KEY | contact_1099__contact_KEY | Client_1099_Tax_Form_Information | FOREIGN KEY constraint of contact_KEY for the Client_1099_Tax_Form_Information table.
FK_Staff__Contact__contact_KEY | contact_KEY | Staff |
FK_Client_Contact_Payroll_Tax_Information__Contact__contact_KEY | contact_KEY | Client_Contact_Payroll_Tax_Information |
FK_Firm__Contact__electronic_filing__contact_KEY | electronic_filing__contact_KEY | Firm |
FK_Location__Contact__contact_KEY | contact_KEY | Location |
FK_Employer_Jurisdiction_Payroll_Tax_Information__Contact__form1095c_signature__contact_KEY | form1095c_signature__contact_KEY | Employer_Jurisdiction_Payroll_Tax_Information |
FK_Employer_Jurisdiction_Payroll_Tax_Information__Contact__form1095c_contact__contact_KEY | form1095c_contact__contact_KEY | Employer_Jurisdiction_Payroll_Tax_Information |
FK_Employer_Jurisdiction_Payroll_Tax_Information__Contact__contact_1099__contact_KEY | contact_1099__contact_KEY | Employer_Jurisdiction_Payroll_Tax_Information |
FK_Employer_Jurisdiction_Payroll_Tax_Information__Contact__payment__contact_KEY | payment__contact_KEY | Employer_Jurisdiction_Payroll_Tax_Information |
FK_Employer_Jurisdiction_Payroll_Tax_Information__Contact__preparer_signer__contact_KEY | preparer_signer__contact_KEY | Employer_Jurisdiction_Payroll_Tax_Information |
FK_Employer_Jurisdiction_Payroll_Tax_Information__Contact__signature_1099__contact_KEY | signature_1099__contact_KEY | Employer_Jurisdiction_Payroll_Tax_Information |
FK_Employer_Jurisdiction_Payroll_Tax_Information__Contact__taxpayer_signer__contact_KEY | taxpayer_signer__contact_KEY | Employer_Jurisdiction_Payroll_Tax_Information |
FK_Employer_Jurisdiction_Payroll_Tax_Information__Contact__third_party_designee_signer__contact_KEY | third_party_designee_signer__contact_KEY | Employer_Jurisdiction_Payroll_Tax_Information |
FK_Employer_Jurisdiction_Payroll_Tax_Information__Contact__w2_contact__contact_KEY | w2_contact__contact_KEY | Employer_Jurisdiction_Payroll_Tax_Information |
FK_Employer_Jurisdiction_Payroll_Tax_Information__Contact__w2_signature__contact_KEY | w2_signature__contact_KEY | Employer_Jurisdiction_Payroll_Tax_Information |
FK_Firm_Contact_Payroll_Tax_Information__Contact__contact_KEY | contact_KEY | Firm_Contact_Payroll_Tax_Information |
FK_Print_1096_Selection__Contact__contact_KEY | contact_KEY | Print_1096_Selection |
FK_Print_1096_Selection__Contact__signature__contact_KEY | signature__contact_KEY | Print_1096_Selection |
FK_Print_W3_Selection__Contact__contact_KEY | contact_KEY | Print_W3_Selection |
FK_Print_W3_Selection__Contact__signature__contact_KEY | signature__contact_KEY | Print_W3_Selection |
FK_Customer__Contact__contact_KEY | contact_KEY | Customer |
FK_Vendor__Contact__contact_KEY | contact_KEY | Vendor |
FK_Employee__Contact__contact_KEY | contact_KEY | Employee |