I have three problems that I need to solve that are closely related
There are tasks:
Task 1) Salesman access an application to submit information on a
sales they made.
This information includes data about the customer (name, address etc)
data about the product (color, model, part number etc) and a picture.
This is private information and I want to remove the information daily.
2) an email needs to be sent to the customer 3 days later that takes a
form letter template and merges with it information about the
transaction (customer name, product, salesman picture etc.). There
will be a link on the email that directs the customer to a form where
they can refer another potential customer to the salesman. For each
referral they will be put in the draw for the monthly prize.
3) The customer will get login information to a website. Once the
customer logs in they will be asked to complete a survey, they will be
asked to referr others that may be interested in the product. For each
referral the will be put in the draw for a monthly price.
I would like to make these three separate applications for simplicity
and reliability.
The question is that I don't want to keep the customers information
online in (Task 1) so I will download and clear each order every day.
Every day I would like to move the daily transactions from Task 1
application to the Task 2 application so that email can be sent 3 days
later.
I would also like to move the data from Task 1 to Task 3 application.
Is this possible with postgresql?
Thanks