Primary Key Field Type
 ID int

Field Field Type Null Notes Description
 Name nvarchar(50)
 OwnerID int  
 GUID uniqueidentifier   Default = (newid())
 CreateDate datetime   Default = getutcdate()
 ContentHTML ntext
 ContentTEXT ntext
 FromAddress nvarchar(255)
 FromDisplayName nvarchar(255)
 Subject nvarchar(255)
 Priority int
 ReplyAddress nvarchar(255)
 ReturnReceipt bit   Default = 0
 ReturnReceiptAddress nvarchar(255)
 ForwardDSN bit   Default = 0
 ForwardDSNAddress nvarchar(255)
 XMLDataSetAddressees ntext
 XMLDataSetMergeData ntext
 Status tinyint
 WSSMTPJobIdentifier uniqueidentifier
 WSDateLastAccessed datetime
 NumberRequested int
 NumberAbsentAddress int
 NumberOptedOut int
 StatusReport ntext
 SendAfterDate datetime   Default = getutcdate()
 EmailTemplateID int
 Current bit   Default = 1
 NumberInvalidAccount int
 ClientIP nchar
 MERGEDATASETSCHEMA xml
 MERGEVIEWID uniqueidentifier
 STATUSID uniqueidentifier

Foreign Key Field Type Null Notes Description
 EmailID int   Email.ID
 ConditionalParentJobID int EmailJob.ID

Index Name Field(s) Unique Primary Clustered
 EmailJob__7 EmailID, ID, Status      
 IX_EmailJob__Status_CreateDate_ID Status, CreateDate, ID      
 IX_EmailJob_ConditionalParentJobID_EmailID ConditionalParentJobID, EmailID      
 IX_EmailJob_Status_ID_WSSMTPJobIdentifier Status      
 IX_EmailJob_WSSMTPJobIdentifier WSSMTPJobIdentifier, Status      
 PK_EmailJob ID

Referenced by Field
 CONDITIONALCONTENTRECIPIENT EMAILJOBID
 EmailJobConditionBlockCondition EmailJobID
 EMAILJOBDATA EMAILJOBID
 EMAILJOBEXTENSION EMAILJOBID
 EmailJobStatus EmailJobID
 EMAILJOBTEMPORARYMETATDATA EMAILJOBID
 FAFCOMMUNICATIONSLOG EMAILJOBID
 FAFEVENTCOMMUNICATIONCHANNEL EMAILJOBID
 FundraiserSolicitorEmail EmailJobID

Entity-Relationship diagram of this table