Note: You are viewing an old version of this page. View the current version.

Differences between version 15 and previous revision of RobertButler.

Other diffs: Previous Major Revision, Previous Author

Newer page: version 15 Last edited on Tuesday, 28 March 2017 10:54:02 by RobertButler Revert
Older page: version 14 Last edited on Tuesday, 28 March 2017 10:53:12 by RobertButler Revert
@@ -20,8 +20,10 @@
  # Processed 
  # Returned 
  # OptOuts 
  # Cache 
+<<<<<<< Your version  
+=======  
  
 == Tables 
  
 * === Campaigns 
@@ -56,4 +58,5 @@
  # zip 
  # entered 
  # submttd 
  # uid 
+>>>>>>> Other version  

version 15

EMAIL CAMPAIGN MANAGER DESCRIPTION

  • Email Manager Back-end Component

    1. Manages Email Campaigns internally
    2. Requests email tokens from the front-end (PHP) website.
    3. Delivers emails to addresses with with thankyou and optout tokens, taking note of bounces.
    4. Updates shared database (SQLite, Pgsql?) for the front-end to be able to display campaign status

  • Email Manager Front-end Component

    1. written in PHP, uses shared database to update user(s) on campaign status, progress, bounces, opt-outs, etc.
    2. Uses kohana Web/MVC framework.
    3. Requests Campaign information (create, delete, start, stop, etc.)

Database Schema

  • Tables

    1. Campaigns
    2. Processed
    3. Returned
    4. OptOuts?
    5. Cache

<<<<<<< Your version

Tables

  • Campaigns

    1. id
    2. name
    3. status
    4. created_on
    5. updated_on

  • Processed

    1. id
    2. idnum
    3. status
    4. timestamp

  • Returned

    1. id
    2. group
    3. status
    4. timestamp

  • OptOuts?

    1. id
    2. idnum
    3. reason
    4. timestamp

  • Cache

    1. idnum
    2. first
    3. middle
    4. last
    5. address
    6. city
    7. state
    8. zip
    9. entered
    10. submttd
    11. uid

Other version