Databases

Affiliate Referral Tracking & Payout Schema

ER Diagrams · made in Skemio

ER diagram of affiliates, referral_links, referral_clicks, conversion_orders, and payout_ledgers.
ER diagram of affiliates, referral_links, referral_clicks, conversion_orders, and payout_ledgers.
Open it in SkemioMake your own

What it shows

  • Unique click tokens isolate touchpoints before conversion attribution.
  • Conversion orders map directly to the winning referral click ID.
  • Payout ledgers maintain immutable financial records for all settlements.

The takeaway

Separate click tracking from conversion attribution and ledger settlements to prevent payout discrepancies.

More er diagrams