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.