EmailJob
Primary Key
| Primary Key | Field Type |
|---|---|
| ID | int |
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| Name | nvarchar(50) | yes | ||
| OwnerID | int | |||
| GUID | uniqueidentifier | Default = (newid()) | ||
| CreateDate | datetime | Default = getutcdate() | ||
| ContentHTML | ntext | yes | ||
| ContentTEXT | ntext | yes | ||
| FromAddress | nvarchar(255) | yes | ||
| FromDisplayName | nvarchar(255) | yes | ||
| Subject | nvarchar(4000) | yes | ||
| Priority | int | yes | ||
| ReplyAddress | nvarchar(255) | yes | ||
| ReturnReceipt | bit | Default = 0 | ||
| ReturnReceiptAddress | nvarchar(255) | yes | ||
| ForwardDSN | bit | Default = 0 | ||
| ForwardDSNAddress | nvarchar(255) | yes | ||
| XMLDataSetAddressees | ntext | yes | ||
| XMLDataSetMergeData | ntext | yes | ||
| Status | tinyint | yes | ||
| WSSMTPJobIdentifier | uniqueidentifier | yes | ||
| WSDateLastAccessed | datetime | yes | ||
| NumberRequested | int | yes | ||
| NumberAbsentAddress | int | yes | ||
| NumberOptedOut | int | yes | ||
| StatusReport | ntext | yes | ||
| SendAfterDate | datetime | Default = getutcdate() | ||
| EmailTemplateID | int | yes | ||
| Current | bit | Default = 1 | ||
| NumberInvalidAccount | int | yes | ||
| ClientIP | nchar | yes | ||
| MERGEDATASETSCHEMA | xml | yes | ||
| MERGEVIEWID | uniqueidentifier | yes | ||
| STATUSID | uniqueidentifier | yes | ||
| NUMBERINACTIVEACCOUNT | int | yes | ||
| AlternateSubject | nvarchar(255) | yes | Default = NULL | |
| MERGESUBJECTSETSCHEMA | xml | yes | Default = (NULL) |
Foreign Keys
| Foreign Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| EmailID | int | Email.ID | ||
| ConditionalParentJobID | int | yes | EmailJob.ID |
Indexes
| Index Name | Fields | Unique | Primary | Clustered |
|---|---|---|---|---|
| EmailJob__7 | EmailID, ID, Status | |||
| IX_EmailJob__Status | Status | |||
| IX_EmailJob__Status_CreateDate_ID | Status, CreateDate, ID | |||
| IX_EmailJob__STATUSID | STATUSID | |||
| IX_EmailJob_ConditionalParentJobID_EmailID | ConditionalParentJobID, EmailID | |||
| IX_EmailJob_ConditionalParentJobID_Status | ConditionalParentJobID, Status | |||
| IX_EmailJob_Status_ID_WSSMTPJobIdentifier | Status | |||
| IX_EmailJob_WSSMTPJobIdentifier | WSSMTPJobIdentifier, Status | |||
| PK_EmailJob | ID | yes | yes | yes |
Referenced by
| Referenced by | Field |
|---|---|
| CONDITIONALCONTENTRECIPIENT | EMAILJOBID |
| EmailJobConditionBlockCondition | EmailJobID |
| EMAILJOBDATA | EMAILJOBID |
| EMAILJOBEXTENSION | EMAILJOBID |
| EmailJobStatus | EmailJobID |
| EMAILJOBTEMPORARYMETATDATA | EMAILJOBID |
| FAFCOMMUNICATIONSLOG | EMAILJOBID |
| FAFEVENTCOMMUNICATIONCHANNEL | EMAILJOBID |
| FundraiserSolicitorEmail | EmailJobID |