This database defines a sophisticated 5-layer affiliate marketing structure with progressive tiers, commissions, and requirements.
| id | tier | minReferrals | maxAffiliates | earningsPotential | commission |
|---|---|---|---|---|---|
| DirectAffiliate | 1 | 0 | 100 | 1000 | 10 |
| SilverLeader | 2 | 10 | 50 | 2500 | 5 |
| GoldManager | 3 | 25 | 25 | 5000 | 3 |
| PlatinumDirector | 4 | 50 | 10 | 7500 | 2 |
| DiamondExecutive | 5 | 100 | 5 | 10000 | 1 |