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_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_CONFIGURATION
​General Configuration and manual email default settings​
AO_544E33_CONTEXT
​Contexts​
AO_544E33_DISTRIBUTION_LIST
​Distribution Lists​
AO_544E33_FIELD_CONTEXT
​Field Rules​
AO_544E33_FIELD_RULE
​Field Rules​
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_LOG
​Mail Handler Error Log​
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_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_OAUTH2STATEPASSWD
temporary unique password for state encryption

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_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_CONFIGURATION	General Configuration and manual email default settings
AO_544E33_CONTEXT	Contexts
AO_544E33_DISTRIBUTION_LIST	Distribution Lists
AO_544E33_FIELD_CONTEXT	Field Rules
AO_544E33_FIELD_RULE	Field Rules
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_LOG	Mail Handler Error Log
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_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_OAUTH2STATEPASSWD	temporary unique password for state encryption

Last modified 1yr ago