I design a system that users can has multiple payments. Let me explain about it.
There is a
user table. Each user has a total credit amount. Ex. user Alex has $100. He can either increase his credit, or pay it for some services. We have 2 services, that he can pay for.
Beside increasing his credit, he can pay for those services directly. How does my table structures should be designed? Any idea?