Email_Recipient

Primary Key

Primary Key	Field Type
ID	int

Fields

Field	Field Type	Null	Notes	Description
UserID	int	yes
AddressBookID	int	yes
DisplayName	nvarchar(255)
EmailAddress	nvarchar(255)
OptOut	bit		Default = 0
InvalidAddress	bit		Default = 0
ClickedThrough	bit	yes	Default = 0
BackOfficeSystemPeopleID	int	yes
DataSourceID	int	yes
InvalidAccount	bit		Default = 0
MERGEID	uniqueidentifier	yes
EMAILJOBDATAID	uniqueidentifier	yes
SOURCEID	uniqueidentifier	yes
INACTIVE	bit	yes

Foreign Keys

Foreign Key	Field Type	Null	Notes	Description
EmailID	int		Email.ID

Indexes

Index Name	Fields	Unique	Primary	Clustered
Email_Recipient__EmailAddress	EmailAddress
Email_Recipient__UniqueKey	EmailID, UserID, AddressBookID, BackOfficeSystemPeopleID, EmailAddress
EmailRecipient_EmailID_BackOfficeSystemPeopleID	EmailID, BackOfficeSystemPeopleID
IX_Email_Recipient_EmailID_DisplayName_ID_	EmailID, DisplayName
IX_Email_Recipient_EmailID_OptOut_InvalidAddress_InvalidAccount	EmailID, OptOut, InvalidAddress, InvalidAccount
IX_Email_Recipient_SOURCEID	SOURCEID, EmailID
PK_Email_Recipient	ID	yes	yes	yes

Referenced by

Referenced by	Field
Email_Recipient_Source	Email_RecipientID
EmailJob_Recipient	EmailRecipientID
FundraiserSolicitorContactAction	EmailRecipientID