EmailJobStatus

Primary Key

Primary Key	Field Type
GUID	uniqueidentifier

Fields

Field	Field Type	Null	Notes	Description
ID	int
CreateDate	datetime		Default = getutcdate()
UpdateDate	datetime		Default = getutcdate()
Status	nvarchar(32)	yes
ErrorText	nvarchar(max)	yes
Verbose	bit		Default = 0

Foreign Keys

Foreign Key	Field Type	Null	Notes	Description
EmailID	int		Email.ID
EmailJobID	int		EmailJob.ID
UserID	int	yes	ClientUsers.ID

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_USR_EMAILJOBSTATUS_EMAILID	EmailID
IX_USR_EMAILJOBSTATUS_EMAILJOBID	EmailJobID
IX__EmailJobStatus__ID	ID	yes
PK__EmailJobStatus__GUID	GUID	yes	yes	yes