would like to write a script for establishing an escrow system but I have no idea for how should be structure of database table. In this system, users can send money to "escrow system" through a kind of payment gateways (a payment gateway API is already available). There are 3 parties in transactions, a buyer, a seller and an escrow account. And system should work as folowings:
- Buyer send payment to escrow account. And when payment confirmed by escrow mods/admins emails should be sent to buyer and seller
- Seller send the item to buyer. When he/she sends the item, emails should be sent to buyer and escrow account.
- If buyer gives confirmation when he/she receives the item without any problem, money from the escrow account should be transferred to seller. If buyer does not give a confirmation in a certain period or gives negative comments system should work to backwards ..Confirmation info should be email to seller and escrow account.
userid (integer, autoincrement)
...various other fields such as contact info etc
transactionid (integer, autoincrement)
sellerid (Foreign Key to user table)
buyerid (Foreign Key to user table)
status (FK to transaction_status table)
meaning (enum "Awaiting Payment", "Payment Received by Escrow", "Order despatched", "Order received", "Seller Paid")
This is a very basic data set but sould get your prototype up and running.
Form 1 could allow people to register.
Form 2 could allow an admin to assign buy/sell/admin rights to users
Form 3 could allow a buyer to create an escrow payment
Form 4 could allow an admin to acknowledge receipt of payment
Form 5 could allow a seller to signal dispatch of goods
Form 6 could allow a buyr to acknowledge receipt
Form 7 could allow an admin to release payment for the goods