MailQueueItem

Queued mails to be sent by the OctoSAM import service. OctoSAM Inventory uses this to send notification mails.

erDiagram
    MailQueueItemState ||--o{ MailQueueItem : "MailQueueItemStateID"
    MailQueueItem ||--o{ MailAttachment : "MailQueueItemID"

Fields

Field	Type	Description
AlertIdentification	string	A unique identifier for the alert associated with this mail queue item - this is to prevent mail storms for items with the same alert
Created	datetime	Date/Time this mail queue item was created in the database
Delivered	datetime	Date/Time this mail queue item was delivered
ExtraData	string	Additional data for the mail queue item (JSON format)
FromAddress	string	Email address of the sender
HtmlBody	string	HTML body of the mail queue item
ID	numeric	Internal ID for the MailQueueItem entity (Primary Key)
LastAttemptAt	datetime	Date/Time of the last attempt to send this mail queue item
LastErrorMessage	string	Last error message encountered while processing this mail queue item
MailQueueItemStateID	numeric	Internal ID that references the MailQueueItemState entity (Foreign Key)
Message	string	The Message
ReplyToAddress	string	Reply-to email address
RetryCount	numeric	Number of retry attempts
Source	string	Source of the mail queue item
SourceObjectGuid	guid	Unique identifier for the source object
Subject	string	Subject of the mail queue item
TextBody	string	Text body of the mail queue item
ToAddress	string	Email address of the recipient

References

Column Name	Referenced Table	Description
MailQueueItemStateID	MailQueueItemState	State of a mail queue item

Referenced by

Table	Column Name	Description
MailAttachment	MailQueueItemID	Mail attachments for queued mail items