EMAILJOBDATA
Merge data for an email job.
Primary Key
| Primary Key | Field Type |
|---|---|
| ID | uniqueidentifier |
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| DATA | xml | yes | 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 Keys
| Foreign Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| EMAILJOBID | int | EmailJob.ID | Guid of the email job record. |
Indexes
| Index Name | Fields | Unique | Primary | Clustered |
|---|---|---|---|---|
| IX_EMAILJOBDATA_EMAILJOBID | EMAILJOBID | |||
| IX_EMAILJOBDATA_SEQUENCEID | SEQUENCEID | yes | ||
| PK_EMAILJOBDATA | ID | yes | yes | yes |