CONDITIONALCONTENTRECIPIENT

Holds recipient info for conditional content email

Primary Key

Primary Key	Field Type
ID	uniqueidentifier

Fields

Field	Field Type	Null	Notes	Description
EMAILADDRESS	nvarchar(255)		Default = ''
JOBKEY	nvarchar(1000)		Default = ''
EMAILLIST_SUBSCRIPTIONID	int		Default = 0
APPEALEMAILLISTMEMBERID	int		Default = 0

Foreign Keys

Foreign Key	Field Type	Null	Notes	Description
EMAILJOBID	int		EmailJob.ID	FK to EMAILJOB
BOSPID	int	yes	BackOfficeSystemPeople.ID	FK to BACKOFFICESYSTEMPEOPLE
USERID	int	yes	ClientUsers.ID	FK to CLIENTUSERS
EMAILLISTID	int	yes	EmailList.ID	FK to EMAILLIST
EMAILLISTUPLOADMASTERLISTID	int	yes	EmailListUploadMasterList.BB_XListRecordID	FK to EMAILLISTUPLOADMASTERLIST
EMAILLIST_USERDEFINEDID	int	yes	EmailList_UserDefined.ID	FK to EMAILLIST_USERDEFINED

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_CONDITIONALCONTENTRECIPIENT_EMAILJOBID_EMAILADDRESS	EMAILJOBID, EMAILADDRESS
IX_CONDITIONALCONTENTRECIPIENT_EMAILJOBID_EMAILLISTID_BOSPID_EMAILLIST_USERDEFINEDID_USERID_APPEALEMAILLISTMEMBERID	EMAILJOBID, EMAILLISTID, BOSPID, EMAILLIST_USERDEFINEDID, USERID, APPEALEMAILLISTMEMBERID
IX_CONDITIONALCONTENTRECIPIENT_EMAILLISTUPLOADMASTERLISTID	EMAILLISTUPLOADMASTERLISTID
PK_CONDITIONALCONTENTRECIPIENT	ID	yes	yes	yes