The following database tables are used for the newsletters module:

 

•Newsletter_Newsletter - contains records representing newsletters and their configuration.

•Newsletter_NewsletterIssue - used to store individual newsletter issues, including their content.

•Newsletter_Subscriber - contains records representing newsletter subscribers.

•Newsletter_SubscriberNewsletter - stores relationships between subscribers and newsletters. This table also contains data that determines whether the subscriber is approved for the given newsletter.

•Newsletter_EmailTemplate - used to store the templates on which newsletter issues and notification messages are based (all types).

•Newsletter_EmailTemplateNewsletter - stores relationships between newsletter issue templates and static newsletters. Each record indicates that a certain template may be used for the issues of a specific newsletter.

•Newsletter_Emails - this table stores newsletter e‑mails that could not be sent out successfully (i.e. the newsletter queue). This allows them to be re-sent at a later time.

•Newsletter_OpenedEmail - stores relationships between subscribers and newsletter issues. Each record indicates that a subscriber has opened a specific issue.

•Newsletter_Link - contains records representing links inside the content of newsletter issues.

•Newsletter_SubscriberLink - stores relationships between subscribers and newsletter links. Each record indicates that a subscriber has clicked on a specific link.

•Newsletter_ABTest - stores records that contain the A/B testing configuration of newsletter issues. Individual A/B test variants of issues are saved as separate items in the Newsletter_NewsletterIssue table.