I have a web app that will support multiple payment method/gateway such as pay via PayPal, Credit Card, Debit Card, and more.
Which scenario that probably fit for this case ?
I only have 2 tables: Payments & Payment_Details
Payments will holds data such as price, user who paid, and what item. While the Payment_Details will have payment_id, method.
I have 1 master/parent table and * childs table
table: Payments, Payments_PayPal, Payments_DebitC, Payments_CreditC, Payments_*
Please help me to understand which scenario that fits or probably what is your scenario if you are having this case.