2 order pages with email confirmation and PayPal interface + simple referral program

I have designed 3 pages (2 order pages and a reward page based on referral program) and I need someone to work on the technical part that includes: - Creating/updating the database with the entries - Paypal interface - email confirmation when Payment is confirmed When ordering, clients can win rewards based on the amount of the order. Client can also refer a friend’s email who will gain a certain number of “Points” (the friend, not the client) based on the amount of the order. Those points that can be converted into rewards (referral program). 1) HOW PAGES WORK a) ORDER PAGE 1 - PLANS Client can choose between 20 plans spread over 5 locations (4 plans per locations, only the price and the rewards change). Each plan gives access to my website for a certain period of time. After picking a plan, the client must be redirected to the Paypal website for payment. If payment is successful, the order on my website has to be marked as paid and an email should be sent to the client. Some offers can give the client a reward. b) ORDER PAGE 2 – TOP-UP Client chooses how much he wants to top-up his account. He can win rewards based on the amount of his order. He can also refer a friend (see above) When clicking on the order, he has to be redirected to Paypal for payment. If payment is successful, the order on my website has to be updated so I know it has been paid. An email has to be sent to the client (same the 'plan' order) c) REWARD PAGE Based on the user’s (can be a client or a friend) points, he can convert them into one of the 3 different rewards available. If he does, it has to create an entry in the Reward table and update his number of points available. 2) TABLES AND FIELDS NEEDED WITH BUSINESS RULES I need 4 tables - ORDER table: store all information related to any order (Plan or Top-up) - REWARD table: To store the reward(s) linked to an order, if any - REFERRAL table: To store the points earned by each of clients’ friends. Only if the payment has been processed. - USER table: Information about the user (client or friend) a) List of fields for the USER table - ID of the user (can be a client, a friend…) - Email (used for the referral program) - Balance (to be updated with the order amount in case of a top-up). - Points available: Points can be won if a client refers his address email. Points are debited in case he converts them into a reward. The system should return an error in case the user has not enough points available The registration page of user is not done but you can create your own set of data to test your developments. b) List of fields for the ORDER table - ID or the order - ID of the client - Date of order (Date when client clicks on the order button. I just need the date, no need for the time) - Is order validated (Not validated per default. Validated once PayPal payment is done) - Type of order (Based on the type of order. Either “plan” or “top-up”) - Server (Location for the “plan” offer. Should be null in case of “top-up”) - Referral email (friend email address, can be null). The system should return an error if the referral email does not exist - Expiration date (Only for the “plan” offer. Should be null in case of “top-up” offer) c) List of fields for the REWARD table - ID of the reward - ID of the Order - Name of the reward (information will be given once the project is awarded) - Username (information to be entered by the client when converting his points into a reward. Free text, no control required) - Server (User will pick a value in a drop-down list.) d) List of fields for the REFERRAL table - ID of the referral - ID of the order - Points earned (based on the order amount. Information will be given once the project is awarded) - Date (Date of the order) - Friend ID 3) ADDITIONAL REQUIREMENT - I need a list of all records for each of the four tables. I do not need any design, just a table is fine. - Please mention the reference 'GERMANY' when bidding so I know it is not a generic bidding