| Primary Key | Field Type |
|---|---|
 ID |
int |
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
 UserID |
int |  |
||
| AddressBookID |
int | |
||
| DisplayName |
nvarchar(255) | |||
| EmailAddress |
nvarchar(255) | |||
| OptOut |
bit | Default = 0 | ||
| InvalidAddress |
bit | Default = 0 | ||
| ClickedThrough |
bit | |
Default = 0 | |
| BackOfficeSystemPeopleID |
int | |
||
| DataSourceID |
int | |
||
| InvalidAccount |
bit | Default = 0 | ||
| MERGEID |
uniqueidentifier | |
||
| EMAILJOBDATAID |
uniqueidentifier | |
||
| SOURCEID |
uniqueidentifier | |
| Foreign Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
 EmailID |
int | Email.ID |
| Index Name | Field(s) | Unique | Primary | Clustered |
|---|---|---|---|---|
 Email_Recipient__EmailAddress |
EmailAddress | |||
| Email_Recipient__UniqueKey |
EmailID, UserID, AddressBookID, BackOfficeSystemPeopleID, EmailAddress | |||
| EmailRecipient_EmailID_BackOfficeSystemPeopleID |
EmailID, BackOfficeSystemPeopleID | |||
| EmailRecipient_EmailID_OptOut_InvalidAddress |
EmailID, OptOut, InvalidAddress | |||
| IX_Email_Recipient_EmailID_DisplayName_ID_ |
EmailID, DisplayName | |||
| IX_Email_Recipient_SOURCEID |
SOURCEID, EmailID | |||
| PK_Email_Recipient |
ID | |
|
|
| Referenced by | Field |
|---|---|
 Email_Recipient_Source |
Email_RecipientID |
| EmailJob_Recipient |
EmailRecipientID |
| FundraiserSolicitorContactAction |
EmailRecipientID |