Table Structure Setup for Commissions
I need to setup commission tracking for my database and I'd really like to get some guidance so that I don't screw it up.
I have a Deals table and a salesperson table that are related. Is it best to set up a payments table and relate it to the deal table? Or should I also make a commissions table and make a join table CommissionPayments?