Primary Key Field Type
 ID int

Field Field Type Null Notes Description
 EmailJobID int  
 UserID int
 EmailAddress nvarchar(255)  
 MessageDate datetime
 SentDate datetime
 UpdateDate datetime  
 Sent bit   Default = 0
 Opened bit   Default = 0
 OpenedDate datetime
 DSNed bit   Default = 0
 RecentDSNDate datetime
 RecentDSNSignatureID int
 StatusReport ntext
 Completed bit   Default = 0
 AddressBookID int
 Current bit   Default = 1
 RecentDSNCategory int
 BackOfficeSystemPeopleID int
 EMAILJOBDATAID uniqueidentifier
 MERGEID uniqueidentifier
 SOURCEID uniqueidentifier
 GlobalOptedOut bit   Default = 0

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

Index Name Field(s) Unique Primary Clustered
 EmailJob_Recipient_EmailRecipientID_Current_Opened_MessageDate EmailRecipientID, Current, Opened, MessageDate      
 IX_EmailJob_Recipient_EMAILJOBDATAID_ID_MERGEID EMAILJOBDATAID      
 IX_EmailJob_Recipient_EmailJobID_BackOfficeSystemPeopleID_ID_UserID_AddressbookID_EmailAddress EmailJobID, BackOfficeSystemPeopleID, ID, UserID, AddressBookID, EmailAddress      
 IX_EmailJob_Recipient_EmailJobID_SentDate_DSNed_RecentDSNDate EmailJobID      
 IX_EmailJob_Recipient_ID_EmailID_Opened_DSNed ID      
 IX_EmailJob_Recipient_MergeID MERGEID      
 IX_EmailJob_Recipient_SOURCEID SOURCEID, EmailJobID      
 IX_EmailJob_Recipient_UpdateDate_ID_EmailID_BackOfficeSystemPeopleID_UserID UpdateDate, EmailID, ID, BackOfficeSystemPeopleID, UserID      
 PK_EmailJob_Recipient ID

Referenced by Field
 DonationTransactions EmailJobRecipientID
 EmailInvalidAccountRecipient EmailJobRecipientID
 EventTransactions EmailJobRecipientID
 FundraiserSolicitorContactAction EmailJobRecipientID
 MembershipTransactions EmailJobRecipientID
 ProfileUpdateTransactions EmailJobRecipientID
 SignupTransactions EmailJobRecipientID
 VolunteerTransactions EmailJobRecipientID

Entity-Relationship diagram of this table