I designed this schema/structure for an online marketplace where users can buy products from sellers.
Each seller has an account (Funds) where they can view their payments, withdrawal history, and user refunds.
However, there are a two issues I have noticed in this design.
paymentis repeated in theOrderPaymentsandOrderscollections.dateis repeated in theWithdrawalsandPaymentscollections.
Should I remove the repeated fields, or does it not matter?
Also, are there any other flaws with this design? Thank you.
