Kentico CMS 6.0 On-line Marketing 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 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.

 

onlinemarketingguide_clip0204