MAILEXPRESS

Basic Index   Expanded Index

Table Name: medatabase.Email
Description: Email message queue for emails that originally failed to send and have been rescheduled for a later delivery.
Primary Keys: identifier
Field Type Defaults Nulls? Comments
identifier numeric - Identity None No Unique ID for an entry.
createdDate datetime None No The original creation data/time for the entry.
modifiedDate datetime None No The last modified date/time for the entry.
version numeric (19) None No The version number for the entry.
content varbinary (MAX) None No The binary form of the email.
problem nvarchar (4000) None Yes The error message that caused the email to be queued, or the most recent error to be re-queued.
retries int None No The number of times this email has been tried to be send.
subject nvarchar (4000) None Yes The email subject. Used for reference only as the actual subject is included in the content field.
sender_identifier numeric (19) None Yes The identifier for the user account the originated the email.

Index Clustered? Unique? Fields
PK__Email__D112ED491CB3BB23 Yes Yes

No check constraints
Internal Foreign Key Constraint Affected Field Source Table
FK_Email_actor sender_identifier Actor

Primary Key as Foreign Key Constraint Affected Table Affected Field
FKC565428D270ED0AA Email_from Email_identifier
FKE2A1061D270ED0AA Email_recipients Email_identifier

No triggers