EmailInvalidAccountRecipient

Primary Key

Primary Key	Field Type
ID	int

Fields

Field	Field Type	Null	Notes	Description
CreateDate	datetime		Default = getutcdate()
UpdateDate	datetime		Default = getutcdate()
EMAILADDRESS	nvarchar(255)	yes
SPAM	bit		Default = 0

Foreign Keys

Foreign Key	Field Type	Null	Notes	Description
EmailInvalidAccountID	int	yes	EmailInvalidAccount.ID
EmailJobRecipientID	int		EmailJob_Recipient.ID

Indexes

Index Name	Fields	Unique	Primary	Clustered
EmailInvalidAccountRecipient_EmailInvalidAccountID_EmailJobRecipientID	EmailInvalidAccountID, EmailJobRecipientID
PK_EmailInvalidAccountRecipient	ID	yes	yes	yes