| Primary Key | Field Type |
|---|---|
 ID |
uniqueidentifier |
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
 DATA |
xml |  |
Chunk of merge data for x number of recipients | |
| SENT |
bit | Default = 0 | Value indicating the status of this chunk being sent to Shelby Services. | |
| RECIPIENTCOUNT |
int | Default = 0 | Count of recipients in merge data. | |
| SEQUENCEID |
int | Sequence of the chunks being added. |
| Foreign Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
 EMAILJOBID |
int | EmailJob.ID | Guid of the email job record. |
| Index Name | Field(s) | Unique | Primary | Clustered |
|---|---|---|---|---|
 IX_EMAILJOBDATA_EMAILJOBID |
EMAILJOBID | |||
| IX_EMAILJOBDATA_SEQUENCEID |
SEQUENCEID | |
||
| PK_EMAILJOBDATA |
ID | |
|
|