Database Tables

Email This Issue stores configuration data and audit logs in the below db tables.

Table NameDescription
AO_544E33_ATTACHMENT_DIGESTAttachment MD5 content digest for duplication filter
AO_544E33_ATTACHMENT_FILTERAttachment fiters (by name, size, type)
AO_544E33_AUDIT_LOG_ENTRYEmail audit log storing outgoing and incoming emails
AO_544E33_AUTO_REPLY_PARAMSMail handlers
AO_544E33_CANNED_RESPONSECanned responses
AO_544E33_CONFIGURATIONGeneral Configuration and manual email default settings
AO_544E33_CONTEXTContexts
AO_544E33_DISTRIBUTION_LISTDistribution Lists
AO_544E33_FIELD_CONTEXTField Rules
AO_544E33_FIELD_RULEField Rules
AO_544E33_MAIL_ACCOUNTIncoming Mail Account
AO_544E33_MAIL_ADDRESS_LISTMail Address List (i.e. Recipient Lists by Type)
AO_544E33_MAIL_HANDLER_LOGMail Handler Error Log
AO_544E33_MD5_PATTERNMD5 patterns to filter attachments
AO_544E33_NOTIFICATION_EVENTNotification events
AO_544E33_NOTIFICATION_RECIPRecipients in notification events
AO_544E33_NOTIFICATION_TEMPLNotification templates (schemes)
AO_544E33_OUTGOING_QUEUE_ITEMOutgoing mail items sent via SMTP servers configured in the app
AO_544E33_RECIPIENTRecipient
AO_544E33_REC_TO_MAIL_ADDRRecipient To Mail Address List (join table between the Recipient and MailAddressList tables)
AO_544E33_SMTP_CONNECTIONOutgoing Mail Connections configured in the app
AO_544E33_TEMPLATEEmail Templates
AO_544E33_USER_PREFERENCEUser preferences
AO_544E33_OAUTH2STATEPASSWD
temporary unique password for state encryption