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

Differences between version 23 and previous revision of RobertButler.

Other diffs: Previous Major Revision, Previous Author

Newer page: version 23 Last edited on Tuesday, 28 March 2017 11:44:30 by RobertButler Revert
Older page: version 22 Last edited on Tuesday, 28 March 2017 11:40:18 by RobertButler Revert
@@ -13,11 +13,11 @@
  # Requests Campaign information (create, delete, start, stop, etc.) 
  
 ---- 
  
-== Database Schema 
+== Shared Database Schema 
 === Table 
  * [[RobertButler/Campaigns|Campaigns]] 
  * [[RobertButler/Processed|Processed]] 
- * Returned 
+ * [[RobertButler/ Returned|Returned]]  
  * OptOuts 
  * Cache 

version 23

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.)

Shared Database Schema

Table