Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 ADDRESS nvarchar(255)   Default = '' An invalid email address.
 FAILEDATTEMPTS int   Default = 0 The number of times we have tried to send email to this address since it was inserted into this table.
 FAILEDMESSAGE nvarchar(max)   Default = '' Holds the last failed message from the DSN.
 DATEADDED datetime   Default = getdate() Indicates the date this record was added.
 DATECHANGED datetime   Default = getdate() Indicates the date this record was last changed.
 TS timestamp   Timestamp.
 TSLONG bigint (Computed) CONVERT(bigint, TS) Numeric representation of the timestamp.
 DATEPROCESSED datetime   The date the bounce was processed by the DSN.
 ISBLACKLISTED bit   Default = 1 This value is used to determine if we should strip email out of sender list.
 CATEGORY tinyint   Default = 0 Category sent from external mail service.

Foreign Key Field Type Null Notes Description
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_EMAILINVALIDRECIPIENT_DATEADDED DATEADDED    
 IX_EMAILINVALIDRECIPIENT_DATECHANGED DATECHANGED      
 PK_EMAILINVALIDRECIPIENT ID  
 UC_EMAILINVALIDRECIPIENT_ADDRESS ADDRESS    

Trigger Name Description
 TR_EMAILINVALIDRECIPIENT_AUDIT_UPDATE
 TR_EMAILINVALIDRECIPIENT_AUDIT_DELETE