Database Tables

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

Table NameDescription

AO_544E33_ATTACHMENT_DIGEST

Attachment MD5 content digest for duplication filter

AO_544E33_ATTACHMENT_FILTER

Attachment fiters (by name, size, type)

AO_544E33_ATTACHMENT_TYPE_SIZE

Attachment type size filters

AO_544E33_AUDIT_LOG_ENTRY

Email audit log storing outgoing and incoming emails

AO_544E33_AUTO_REPLY_PARAMS

AO_544E33_CANNED_RESPONSE

AO_544E33_CERTIFICATE

Certificates and expiry dates

AO_544E33_CERT_TO_MAIL_ACCOUNT

Mapping for certificates and mail accounts

AO_544E33_CONFIGURATION

AO_544E33_CONTEXT

AO_544E33_DATA_PURGE

Data purge settings

AO_544E33_DISTRIBUTION_LIST

AO_544E33_FIELD_CONTEXT

AO_544E33_FIELD_RULE

AO_544E33_GDPR_USER

User details for GDPR compliance

AO_544E33_GENERAL_CONFIG

AO_544E33_INCOMING_QUEUE_ITEM

AO_544E33_INCOMING_MAIL_LOG

AO_544E33_KEY

ID and KEY information

AO_544E33_MAIL_ACCOUNT

AO_544E33_MAIL_ADDRESS_LIST

Mail Address List (i.e. Recipient Lists by Type)

AO_544E33_MAIL_HANDLER

AO_544E33_MAIL_HANDLER_LOG

AO_544E33_MAIL_IMAP_UIDS

UIDs of incoming emails

AO_544E33_MAIL_LAST_FETCH

Last fetch dates

AO_544E33_MAIL_OPTIONS

Mail options for manual email sending

AO_544E33_MAIL_UID

Mail Account IDs and UIDs

AO_544E33_MD5_PATTERN

MD5 patterns to filter attachments

AO_544E33_NOTIFICATION_EVENT

AO_544E33_NOTIFICATION_RECIP

Recipients in notification events

AO_544E33_NOTIFICATION_TEMPL

Notification templates (schemes)

AO_544E33_OAUTH2_CREDENTIALS

OAuth2 credentials

AO_544E33_OAUTH2_STATE_PASSWD

temporary unique password for state encryption

AO_544E33_OAUTH_REFRESH_TOKEN

OAuth2 refresh tokens

AO_544E33_OUTGOING_QUEUE_ITEM

Outgoing mail items sent via Outgoing mail connections configured in the app

AO_544E33_RECIPIENT

Recipient

AO_544E33_REC_TO_MAIL_ADDR

Recipient To Mail Address List (join table between the Recipient and MailAddressList tables)

AO_544E33_SMTP_CONNECTION

Outgoing Mail Connections configured in the app

AO_544E33_TEMPLATE

AO_544E33_USER_PREFERENCE

User preferences

AO_544E33_WEBHOOK

Webhooks

AO_544E33_WEBHOOK_EXECUTION

Webhook execution logs

Last updated