Kentico CMS 7.0 Developer's Guide

Database tables

Database tables

Previous topic Next topic Mail us feedback on this topic!  

Database tables

Previous topic Next topic JavaScript is required for the print function Mail us feedback on this topic!  

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.

 

devguide_clip1690