Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 FIRSTNAME nvarchar(255)   Default = '' First Name of the Contact Record
 LASTNAME nvarchar(255)   Default = '' Last Name of the Contact Record
 MIDDLENAME nvarchar(100)   Default = '' Middle Name of the Contact Record
 SALUTATION nvarchar(255)   Default = '' Salutation for the Contact Record
 EMAILADDRESS UDT_EMAILADDRESS   Default = '' Email Address of the Contact Record
 HOMEPHONE nvarchar(25)   Default = '' Primary Phone number of the Contact Record
 CELLPHONE nvarchar(25)   Default = '' Cell Phone number of the Contact Record
 ADDRESSBLOCK nvarchar(300)   Default = '' Street Name and Number for the Contact Address
 CITY nvarchar(100)   Default = '' City name for the Contact Address
 POSTCODE nvarchar(24)   Default = '' Postal/ZIP Code for the Contact Address
 PREFERREDCOMMUNICATIONCODE tinyint   Default = 1 Preferred communication method for contact
 DATEADDED datetime   Default = getdate() Indicates the date this record was added.
 DATECHANGED datetime   Default = getdate() Indicates the date this record was last changed.
 TS timestamp   Timestamp.
 TSLONG bigint (Computed) CONVERT(bigint, TS) Numeric representation of the timestamp.
 PREFERREDCOMMUNICATION nvarchar(12) (Computed) CASE [PREFERREDCOMMUNICATIONCODE] WHEN 1 THEN N'Email' WHEN 2 THEN N'Home Phone' WHEN 3 THEN N'Cell Phone' WHEN 4 THEN N'Regular Mail' WHEN 5 THEN N'Other' END Provides a translation for the 'PREFERREDCOMMUNICATIONCODE' field.
 TEXTMESSAGESEND bit   Default = 1 Indicates whether the contact receives text messages
 BUSINESSPHONE nvarchar(25)   Default = '' Business number of the Contact Record
 BUSINESSADDRESS nvarchar(300)   Default = '' Street Name and Number for the Business Address
 SECONDARYEMAILADDRESS UDT_EMAILADDRESS   Default = '' Secondary Email Address of the Record
 SECONDARYCITY nvarchar(100)   Default = '' Secondary City name for the Contact Address
 SECONDARYPOSTCODE nvarchar(24)   Default = '' Secondary Postal/ZIP Code for the Contact Address
 COMPANYNAME nvarchar(255)   Default = '' Company name
 NOTES nvarchar(1000)   Default = '' Notes

Foreign Key Field Type Null Notes Description
 TITLECODEID uniqueidentifier TITLECODE.LOCALID Contact Title
 STATEID uniqueidentifier STATE.LOCALID State name for the Contact Address
 COUNTRYID uniqueidentifier COUNTRY.LOCALID Country name for the Contact Address
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CLIENTUSERSID int   ClientUsers.ID userid of the client
 CONSTITUENTID uniqueidentifier CONSTITUENT.LOCALID Foreign Key to CONSTITUENT table
 SECONDARYSTATEID uniqueidentifier STATE.LOCALID Secondary State name for the Contact Address
 SECONDARYCOUNTRYID uniqueidentifier COUNTRY.LOCALID Secondary Country name for the Contact Address

Index Name Field(s) Unique Primary Clustered
 IX_ADDRESSBOOKFAF_CLIENTUSERSID CLIENTUSERSID      
 IX_ADDRESSBOOKFAF_CONSTITUENTID CONSTITUENTID      
 IX_ADDRESSBOOKFAF_DATEADDED DATEADDED    
 IX_ADDRESSBOOKFAF_DATECHANGED DATECHANGED      
 PK_ADDRESSBOOKFAF ID  

Trigger Name Description
 TR_ADDRESSBOOKFAF_AUDIT_UPDATE
 TR_ADDRESSBOOKFAF_AUDIT_DELETE

Referenced by Field
 FAFADDRESSBOOKCATEGORY ADDRESSBOOKFAFID
 FAFCOMMUNICATIONSLOG ADDRESSBOOKID

Entity-Relationship diagram of this table