SOCIALMEDIAACCOUNT

Primary Key

Primary Key	Field Type
ID	uniqueidentifier

Fields

Field	Field Type	Null	Notes	Description
USERID	nvarchar(100)		Default = ''
URL	UDT_WEBADDRESS		Default = ''
DONOTCONTACT	bit		Default = 0
DATEADDED	datetime		Default = getdate()
DATECHANGED	datetime		Default = getdate()
TS	timestamp
TSLONG	bigint (Computed)	yes	CONVERT(bigint, TS)
SEQUENCE	int		Default = 0
CONFIRMED	bit		Default = 0
DATECONFIRMED	datetime	yes
REJECTED	bit		Default = 0
DATEREJECTED	datetime	yes
WPMATCHCODE	nvarchar(3)		Default = ''
EMAILADDRESS	UDT_EMAILADDRESS		Default = ''
WEALTHSOURCE	nvarchar(100)		Default = ''
FULLHASH	nvarchar(32)		Default = ''
PARTIALHASH	nvarchar(32)		Default = ''

Foreign Keys

Foreign Key	Field Type	Null	Notes	Description
CONSTITUENTID	uniqueidentifier		CONSTITUENT.LOCALID
SOCIALMEDIASERVICEID	uniqueidentifier		SOCIALMEDIASERVICE.ID
SOCIALMEDIAACCOUNTTYPECODEID	uniqueidentifier	yes	SOCIALMEDIAACCOUNTTYPECODE.ID
INFOSOURCECODEID	uniqueidentifier	yes	INFOSOURCECODE.ID
ADDEDBYID	uniqueidentifier		CHANGEAGENT.ID
CHANGEDBYID	uniqueidentifier		CHANGEAGENT.ID
CONFIRMEDBYAPPUSERID	uniqueidentifier	yes	APPUSER.ID
REJECTEDBYAPPUSERID	uniqueidentifier	yes	APPUSER.ID

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_SOCIALMEDIAACCOUNT_CONSTITUENTID	CONSTITUENTID
IX_SOCIALMEDIAACCOUNT_CONSTITUENTID_FULLHASH	CONSTITUENTID, FULLHASH
IX_SOCIALMEDIAACCOUNT_CONSTITUENTID_PARTIALHASH	CONSTITUENTID, PARTIALHASH
IX_SOCIALMEDIAACCOUNT_DATEADDED	DATEADDED			yes
IX_SOCIALMEDIAACCOUNT_DATECHANGED	DATECHANGED
PK_SOCIALMEDIAACCOUNT	ID	yes	yes

Triggers

Trigger Name	Description
TR_SOCIALMEDIAACCOUNT_AUDIT_UPDATE
TR_SOCIALMEDIAACCOUNT_AUDIT_DELETE

Referenced by

Referenced by	Field
BATCHCONSTITUENTUPDATESOCIALMEDIAACCOUNT	SOCIALMEDIAACCOUNTID