Online Escrow Service

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. USERS userid (integer, autoincrement) username (text) password (text) allowed_to_purchase (Y/N) allowed_to_sell (Y/N) allowed_to_adimn (Y/N) ...various other fields such as contact info etc TRANSACTIONS transactionid (integer, autoincrement) sellerid (Foreign Key to user table) buyerid (Foreign Key to user table) description (text) value (real) status (FK to transaction_status table) TRANSACTION_STATUS statusid (int) 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 How's that?