Installment for mysql [closed]

0

I am doing a sales system in which 1 sale generates 12 parcels to 3 users, being the seller, the manager and the supervisor, I would like to know the best method for storing these parcels.

Would you create 1 table for each user and when you made the sale generated the 36 lines, a cronjob that generated the installments every month or something else?

It is a system for more or less 100 users.

    
asked by anonymous 15.05.2017 / 20:07

1 answer

0

It does not take very far. In case you can use 3 simple tables, as you see in this ER diagram well pig I just did.

    
15.05.2017 / 20:24