Differences between version 15 and predecessor to the previous major change of RobertButler.
Other diffs: Previous Revision, Previous Author
Newer page: | version 15 | Last edited on Tuesday, 28 March 2017 10:54:02 | by RobertButler | Revert |
Older page: | version 7 | Last edited on Tuesday, 28 March 2017 9:42:12 | by RobertButler | Revert |
@@ -1,5 +1,4 @@
-<<<<<<< Your version
== EMAIL CAMPAIGN MANAGER DESCRIPTION
* Email Manager Back-end Component
# Manages Email Campaigns internally
# Requests email tokens from the front-end (PHP) website.
@@ -9,6 +8,55 @@
* 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.)
- # Starts, stops email campaign manager. (systemd, TODO.)
+
+----
+
+== Database Schema
+ * Tables
+
# Campaigns
+ # Processed
+ # Returned
+ # OptOuts
+ # Cache
+<<<<<<< Your version
+=======
+
+== 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
+>>>>>>> Other version
version 15
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
<<<<<<< Your version
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
Other version