| Primary Key | Field Type |
|---|---|
 ID |
uniqueidentifier |
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
 EMAILADDRESS |
nvarchar(255) | Default = '' | ||
| JOBKEY |
nvarchar(1000) | Default = '' | ||
| EMAILLIST_SUBSCRIPTIONID |
int | Default = 0 | ||
| APPEALEMAILLISTMEMBERID |
int | Default = 0 |
| Foreign Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
 EMAILJOBID |
int | EmailJob.ID | FK to EMAILJOB | |
| BOSPID |
int |  |
BackOfficeSystemPeople.ID | FK to BACKOFFICESYSTEMPEOPLE |
| USERID |
int | |
ClientUsers.ID | FK to CLIENTUSERS |
| EMAILLISTID |
int | |
EmailList.ID | FK to EMAILLIST |
| EMAILLISTUPLOADMASTERLISTID |
int | |
EmailListUploadMasterList.BB_XListRecordID | FK to EMAILLISTUPLOADMASTERLIST |
| EMAILLIST_USERDEFINEDID |
int | |
EmailList_UserDefined.ID | FK to EMAILLIST_USERDEFINED |
| Index Name | Field(s) | Unique | Primary | Clustered |
|---|---|---|---|---|
 IX_CONDITIONALCONTENTRECIPIENT_EMAILJOBID_EMAILADDRESS |
EMAILJOBID, EMAILADDRESS | |||
| IX_CONDITIONALCONTENTRECIPIENT_EMAILJOBID_JOBKEY_EMAILLISTID_BOSPID_EMAILLIST_USERDEFINEDID_USERID_APPEALEMAILLISTMEMBERID |
EMAILJOBID, JOBKEY, EMAILLISTID, BOSPID, EMAILLIST_USERDEFINEDID, USERID, APPEALEMAILLISTMEMBERID | |||
| PK_CONDITIONALCONTENTRECIPIENT |
ID | |
|
|