Table: dbo.Contact
Columns
NameTypeConstraintsDescription
contact_KEYint (4)NOT NULLDatabase assigned primary key for this table.
namenvarchar (100)NOT NULLName of the contact.
companynvarchar (100)NOT NULLCompany of the contact.
titlenvarchar (40)NOT NULLTitle of the contact.
salutationnvarchar (80)NOT NULLSalutation for opening letters.
urlnvarchar (4096)NOT NULLWebsite address.
phone_positionnvarchar (28)NOT NULLSemicolon seperated list of contact_phone_type_KEY values indicating the user's preferred order of phone numbers.
address_positionnvarchar (8)NOT NULLSemicolon seperated list of contact_address_type_KEY values indicating the user's preferred order of displaying addresses.
email_positionnvarchar (12)NOT NULLSemicolon seperated list of contact_email_type_KEY values indicating the user's preferred order of displaying e-mail addresses.
primary__contact_phone_type_KEYint (4)NOT NULLIndicates which phone type is the primary phone number.
primary__contact_address_type_KEYint (4)NOT NULLIndicates which address type is the primary address.
mailing__contact_address_type_KEYint (4)NOT NULLIndicates which address type is the mailing address.
contact_type_KEYint (4)NOT NULLKey to Contact Type.
file_asnvarchar (100)NOT NULLName as it appears in Outlook's "File as"
contact_guiduniqueidentifier (16)NOT NULL
primary__contact_email_type_KEYint (4)NOT NULLIndicates which email type is the primary email.
Primary key
NameColumnsDescription
PK_Contactcontact_KEY
Unique constraints
NameColumnsDescription
UK_Contact$contact_guidcontact_guid
Foreign keys
NameColumnsReferenced tableDescription
FK_Contact__Contact_Address_Type__mailing__contact_address_type_KEYmailing__contact_address_type_KEYContact_Address_Type (contact_address_type_KEY)
FK_Contact__Contact_Address_Type__primary__contact_address_type_KEYprimary__contact_address_type_KEYContact_Address_Type (contact_address_type_KEY)
FK_Contact__Contact_Email_Type__primary__contact_email_type_KEYprimary__contact_email_type_KEYContact_Email_Type (contact_email_type_KEY)
FK_Contact__Contact_Phone_Type__primary__contact_phone_type_KEYprimary__contact_phone_type_KEYContact_Phone_Type (contact_phone_type_KEY)
FK_Contact__Contact_Type__contact_type_KEYcontact_type_KEYContact_Type (contact_type_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Office__Contact__contact_KEYcontact_KEYOffice
FK_Contact_Email__Contact__contact_KEYcontact_KEYContact_Email
FK_Tax_Agent__Contact__contact_KEYcontact_KEYTax_Agent
FK_Client__Contact__contact_KEYcontact_KEYClient
FK_Bank__Contact__contact_KEYcontact_KEYBank
FK_Contact_Phone__Contact__contact_KEYcontact_KEYContact_Phone
FK_Contact_Address__Contact__contact_KEYcontact_KEYContact_Address
FK_Additional_Contact__Contact__child__contact_KEYchild__contact_KEYAdditional_Contact
FK_Additional_Contact__Contact__parent__contact_KEYparent__contact_KEYAdditional_Contact
FK_Client_Contact_Payroll_Administrator__Contact__contact_KEYcontact_KEYClient_Contact_Payroll_Administrator
FK_Client_1099_Tax_Form_Information__Contact__signature_1099__contact_KEYsignature_1099__contact_KEYClient_1099_Tax_Form_InformationFOREIGN 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_KEYcontact_1099__contact_KEYClient_1099_Tax_Form_InformationFOREIGN KEY constraint of contact_KEY for the Client_1099_Tax_Form_Information table.
FK_Staff__Contact__contact_KEYcontact_KEYStaff
FK_Client_Contact_Payroll_Tax_Information__Contact__contact_KEYcontact_KEYClient_Contact_Payroll_Tax_Information
FK_Firm__Contact__electronic_filing__contact_KEYelectronic_filing__contact_KEYFirm
FK_Location__Contact__contact_KEYcontact_KEYLocation
FK_Employer_Jurisdiction_Payroll_Tax_Information__Contact__form1095c_signature__contact_KEYform1095c_signature__contact_KEYEmployer_Jurisdiction_Payroll_Tax_Information
FK_Employer_Jurisdiction_Payroll_Tax_Information__Contact__form1095c_contact__contact_KEYform1095c_contact__contact_KEYEmployer_Jurisdiction_Payroll_Tax_Information
FK_Employer_Jurisdiction_Payroll_Tax_Information__Contact__contact_1099__contact_KEYcontact_1099__contact_KEYEmployer_Jurisdiction_Payroll_Tax_Information
FK_Employer_Jurisdiction_Payroll_Tax_Information__Contact__payment__contact_KEYpayment__contact_KEYEmployer_Jurisdiction_Payroll_Tax_Information
FK_Employer_Jurisdiction_Payroll_Tax_Information__Contact__preparer_signer__contact_KEYpreparer_signer__contact_KEYEmployer_Jurisdiction_Payroll_Tax_Information
FK_Employer_Jurisdiction_Payroll_Tax_Information__Contact__signature_1099__contact_KEYsignature_1099__contact_KEYEmployer_Jurisdiction_Payroll_Tax_Information
FK_Employer_Jurisdiction_Payroll_Tax_Information__Contact__taxpayer_signer__contact_KEYtaxpayer_signer__contact_KEYEmployer_Jurisdiction_Payroll_Tax_Information
FK_Employer_Jurisdiction_Payroll_Tax_Information__Contact__third_party_designee_signer__contact_KEYthird_party_designee_signer__contact_KEYEmployer_Jurisdiction_Payroll_Tax_Information
FK_Employer_Jurisdiction_Payroll_Tax_Information__Contact__w2_contact__contact_KEYw2_contact__contact_KEYEmployer_Jurisdiction_Payroll_Tax_Information
FK_Employer_Jurisdiction_Payroll_Tax_Information__Contact__w2_signature__contact_KEYw2_signature__contact_KEYEmployer_Jurisdiction_Payroll_Tax_Information
FK_Firm_Contact_Payroll_Tax_Information__Contact__contact_KEYcontact_KEYFirm_Contact_Payroll_Tax_Information
FK_Print_1096_Selection__Contact__contact_KEYcontact_KEYPrint_1096_Selection
FK_Print_1096_Selection__Contact__signature__contact_KEYsignature__contact_KEYPrint_1096_Selection
FK_Print_W3_Selection__Contact__contact_KEYcontact_KEYPrint_W3_Selection
FK_Print_W3_Selection__Contact__signature__contact_KEYsignature__contact_KEYPrint_W3_Selection
FK_Customer__Contact__contact_KEYcontact_KEYCustomer
FK_Vendor__Contact__contact_KEYcontact_KEYVendor
FK_Employee__Contact__contact_KEYcontact_KEYEmployee

Schema diagram