CDNWiki - View Source: RobertButler

Note: You are viewing an old version of this page. View the current version.
== EMAIL CAMPAIGN MANAGER DESCRIPTION
* Email Manager Back-end Component
  # Manages Email Campaigns internally
  # Requests email tokens from the front-end (PHP) website.
  # Delivers emails to addresses with with thankyou and optout tokens, taking note of
    bounces.
  # Updates shared database (SQLite, Pgsql?) for the front-end to be able to display campaign status

* Email Manager Front-end Component
  # written in PHP, uses shared database to update user(s) on campaign status,
    progress, bounces, opt-outs, etc.
  # Uses _*kohana*_ Web/MVC framework.
  # Requests Campaign information (create, delete, start, stop, etc.)

----

== Database Schema
 * Tables
   # Campaigns
   # Processed
   # Returned
   # OptOuts
   # Cache

== Tables

* === Campaigns
  # id
  # name
  # status
  # created_on
  # updated_on
* === Processed
  # id
  # idnum
  # status
  # timestamp
* === Returned
  # id
  # group
  # status
  # timestamp
* === OptOuts
  # id
  # idnum
  # reason
  # timestamp
* === Cache
  # idnum
  # first
  # middle
  # last
  # address
  # city
  # state
  # zip
  # entered
  # submttd
  # uid