The scenario
A referral application needs to track customer referrals, reward coupons, and order conversions for a coupon-based incentive program.
What is in this drawing
Read the decisions behind it.
01
Modeled referral programs separately to support multiple active campaigns with different reward rules.
02
Linked coupons to both referral and customer to record which party received the reward.
03
Attributed orders to referrals to measure conversion and reward eligibility.
Use this schema as a starting point for referral or loyalty features in e-commerce, SaaS, or marketplace platforms that issue coupon rewards for successful referrals.
More like this