Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 CUSTOMID int   Default = 0 Custom Target ID Stored on Central Server
 FIRSTNAME nvarchar(100)   Default = ''
 LASTNAME nvarchar(100)   Default = ''
 MIDDLENAME nvarchar(20)   Default = ''
 ORGANIZATION nvarchar(100)   Default = '' Organization Name
 ADDRESSBLOCK nvarchar(150)   Default = '' Street Name and Numner
 CITY nvarchar(50)   Default = '' City Name
 ZIP nvarchar(10)   Default = '' Postal Code
 PHONE nvarchar(20)   Default = '' Target Phone
 FAX nvarchar(20)   Default = '' Target Fax
 EMAIL nvarchar(255)   Default = '' Email or Web Address
 ADDRESSBLOCKOVERRIDE nvarchar(1000)   Default = '' Address Block Override
 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.
 TITLE nvarchar(20)   Default = '' Title
 SALUATIONOVERRIDE nvarchar(200)   Default = '' Saluation Override
 OWNERID int   Default = 1 Action item owner ID

Foreign Key Field Type Null Notes Description
 STATEID uniqueidentifier STATE.LOCALID FK to STATE
 COUNTRYID uniqueidentifier COUNTRY.LOCALID FK to COUNTRY
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_ADVOCACY_CUSTOM_DATEADDED DATEADDED    
 IX_ADVOCACY_CUSTOM_DATECHANGED DATECHANGED      
 PK_ADVOCACY_CUSTOM ID  
 UIX_ADVOCACY_CUSTOM_CUSTOMID CUSTOMID    

Trigger Name Description
 TR_ADVOCACY_CUSTOM_AUDIT_UPDATE
 TR_ADVOCACY_CUSTOM_AUDIT_DELETE

Entity-Relationship diagram of this table