Database Tables

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

Table Name	Description
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	Mail handlers
AO_544E33_CANNED_RESPONSE	Canned responses
AO_544E33_CERTIFICATE	Certificates and expiry dates
AO_544E33_CERT_TO_MAIL_ACCOUNT	Mapping for certificates and mail accounts
AO_544E33_CONFIGURATION	General Configuration and manual email default settings
AO_544E33_CONTEXT	Contexts
AO_544E33_DATA_PURGE	Data purge settings
AO_544E33_DISTRIBUTION_LIST	Distribution Lists
AO_544E33_FIELD_CONTEXT	Field Rules
AO_544E33_FIELD_RULE	Field Rules
AO_544E33_GDPR_USER	User details for GDPR compliance
AO_544E33_GENERAL_CONFIG	General configuration settings
AO_544E33_INCOMING_QUEUE_ITEM	Incoming queue items
AO_544E33_INCOMING_MAIL_LOG	Incoming mail log items
AO_544E33_KEY	ID and KEY information
AO_544E33_MAIL_ACCOUNT	Incoming Mail Accounts
AO_544E33_MAIL_ADDRESS_LIST	Mail Address List (i.e. Recipient Lists by Type)
AO_544E33_MAIL_HANDLER	Mail handler data
AO_544E33_MAIL_HANDLER_LOG	Mail Handler Error 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	Notification events
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	Email Templates
AO_544E33_USER_PREFERENCE	User preferences
AO_544E33_WEBHOOK	Webhooks
AO_544E33_WEBHOOK_EXECUTION	Webhook execution logs