EmailJob_Recipient
Primary Key
| Primary Key | Field Type |
|---|---|
| ID | int |
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| EmailJobID | int | |||
| UserID | int | yes | ||
| EmailAddress | nvarchar(255) | |||
| MessageDate | datetime | yes | ||
| SentDate | datetime | yes | ||
| UpdateDate | datetime | |||
| Sent | bit | Default = 0 | ||
| Opened | bit | Default = 0 | ||
| OpenedDate | datetime | yes | ||
| DSNed | bit | Default = 0 | ||
| RecentDSNDate | datetime | yes | ||
| RecentDSNSignatureID | int | yes | ||
| StatusReport | ntext | yes | ||
| Completed | bit | Default = 0 | ||
| AddressBookID | int | yes | ||
| Current | bit | Default = 1 | ||
| RecentDSNCategory | int | yes | ||
| BackOfficeSystemPeopleID | int | yes | ||
| EMAILJOBDATAID | uniqueidentifier | yes | ||
| MERGEID | uniqueidentifier | yes | ||
| SOURCEID | uniqueidentifier | yes | ||
| GlobalOptedOut | bit | Default = 0 | ||
| UnSubscribed | bit | yes | Default = 0 |
Foreign Keys
| Foreign Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| EmailID | int | Email.ID | ||
| EmailRecipientID | int | yes | Email_Recipient.ID |
Indexes
| Index Name | Fields | Unique | Primary | Clustered |
|---|---|---|---|---|
| EmailJob_Recipient_EmailRecipientID_Current_Opened_MessageDate | EmailRecipientID, Current, Opened, MessageDate | |||
| IDX_EmailJob_Recipient_EmailJobID_Current | EmailJobID, Current | |||
| 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 | |||
| IX_USR_EMAILJOB_RECIPIENT_EMAILID | EmailID | |||
| PK_EmailJob_Recipient | ID | yes | yes | yes |
Referenced by
| Referenced by | Field |
|---|---|
| EmailInvalidAccountRecipient | EmailJobRecipientID |
| EMAILJOB_RECIPIENT_DONATED | EMAILJOBRECIPIENTID |
| EventTransactions | EmailJobRecipientID |
| FundraiserSolicitorContactAction | EmailJobRecipientID |
| MembershipTransactions | EmailJobRecipientID |
| ProfileUpdateTransactions | EmailJobRecipientID |
| SignupTransactions | EmailJobRecipientID |
| VolunteerTransactions | EmailJobRecipientID |