Low-Level Design: Loyalty and Rewards Program — Points, Tiers, Redemption, and Expiry
6 min read Core Entities Member: member_id, user_id, tier (BRONZE, SILVER, GOLD, PLATINUM), points_balance, lifetime_points_earned, tier_qualifying_points_ytd, tier_expires_at, enrolled_at. PointTransaction: txn_id, member_id, txn_type (EARN, […] Read article