I’m designing a database schema that will track two levels of commissions… the first level earns a commission on their sales, then, they earn a smaller commission on the sales of those that they brought in…
User1 sells to User2 … User1 makes a commission.
User2 selles to User3 … User1 makes a small commission, User2 makes a commission. Two levels deep.
Can I pick your brains for a logical and clean solution?
