Need Advice from a db expert
I am designer a db for a commission shop.
where seller will come and submit their item to sell.
buy will come and buy the items.
After that, Buyer will make a payment and it come to site owner and he has to pay to seller
so, I am looking what is the best way to handle payments
Seller price: $10
buyer purchase $12
Buyer will send payment $12 to site owner, paypal fee is also deducted.
Site owner has not to pay to seller $1l and make near 1$ as commissions
I am looking some good way like accounting sort so that I can keep track how much current balance in PayPal