The following database tables are used in 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_Emails - this table stores newsletter e‑mails could not be sent out successfully (i.e. the newsletter queue). This allows them to be resent 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.