Open topic with navigation

Email_Recipient (4.0)

dbo-4.0

Top
Primary Key
Foreign Key Fields
Fields
Indexes
Referenced by

Primary Key
Primary Key	Field Type
ID	int

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

Fields
Field	Field Type	Null	Notes	Description
UserID	int	true
AddressBookID	int	true
DisplayName	nvarchar(255)	false
EmailAddress	nvarchar(255)	false
OptOut	bit	false	0
InvalidAddress	bit	false	0
ClickedThrough	bit	true	0
BackOfficeSystemPeopleID	int	true
DataSourceID	int	true
InvalidAccount	bit	false	0
MERGEID	uniqueidentifier	true
EMAILJOBDATAID	uniqueidentifier	true
SOURCEID	uniqueidentifier	true

Indexes
Index Name	Field(s)	Unique	Primary	Clustered
Email_Recipient__EmailAddress	EmailAddress	False	False	False
Email_Recipient__UniqueKey	EmailID UserID AddressBookID BackOfficeSystemPeopleID EmailAddress	False	False	False
EmailRecipient_EmailID_BackOfficeSystemPeopleID	EmailID BackOfficeSystemPeopleID	False	False	False
IX_Email_Recipient_EmailID_DisplayName_ID_	EmailID DisplayName	False	False	False
IX_Email_Recipient_EmailID_OptOut_InvalidAddress_InvalidAccount	EmailID OptOut InvalidAddress InvalidAccount	False	False	False
IX_Email_Recipient_SOURCEID	SOURCEID EmailID	False	False	False
PK_Email_Recipient	ID	True	True	True

Referenced by
Referenced by	Field
Email_Recipient_Source	Email_RecipientID
EmailJob_Recipient	EmailRecipientID
FundraiserSolicitorContactAction	EmailRecipientID