Hello,
I do not know what is the best practice to design the tables for the following application.
The application is about a service providing company. Clients come in two flavors:
1) some clients are individuals who are paying themselves for the cost of services
2) for some other clients a patron does the payment on behalf of a group of clients (the services are provided to the members of the group of clients, not to the patron)
Thank you in advance.