My application records member fees, purchases, overdue charges and payments.
I have read many articles that suggest the use of double entry accounting.
Currently here's my table and I want to convert it to double entry or better database schema.
MembersAccount(id, name, address)
Purchases(member_id, amount, product_id, date)
Fees(member_id, amount, fee_type, date)
PurchasePayments(purchase_id, amount, date)
FeePayments(fee_id, amount, date)
Any suggestion is much appreciated.