# Two-Tier Database Schema

**URL:** <https://forum.kirupa.com/t/two-tier-database-schema/306313>\
**Category:** programming\
**Created:** [March 12, 2010, 8:19pm UTC](https://forum.kirupa.com/t/two-tier-database-schema/306313 "2010-03-12T20:19:54Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![dColumbus](https://avatars.discourse-cdn.com/v4/letter/d/edb3f5/32.png) [@dColumbus](https://forum.kirupa.com/u/dColumbus)\
**Post date:** [March 12, 2010, 8:19pm UTC](https://forum.kirupa.com/t/two-tier-database-schema/306313/1 "2010-03-12T20:19:54Z")

</div>

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?