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

Differences between version 13 and previous revision of RobertButler.

Other diffs: Previous Major Revision, Previous Author

Newer page: version 13 Last edited on Tuesday, 28 March 2017 10:52:15 by RobertButler Revert
Older page: version 12 Last edited on Tuesday, 28 March 2017 9:45:13 by RobertButler Revert
@@ -10,4 +10,49 @@
  # 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  
+* === Returned  
+ # id  
+ # idnum  
+ # timestamp  
+* === Cache  
+ # idnum  
+ # first  
+ # middle  
+ # last  
+ # address  
+ # city  
+ # state  
+ # zip  
+ # entered  
+ # submttd  
+ # uid  

version 13

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

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

  • Returned

    1. id
    2. idnum
    3. timestamp

  • Cache

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