EmailJob (4.0)

Primary Key
Primary Key	Field Type
ID	int

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

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

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

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