The scenario
Design a coupon aggregation platform that normalizes multiple brands, storefronts, coupon codes, categories, user accounts, and redemption transactions.
What is in this drawing
Read the decisions behind it.
01
Introduced a CouponCategory join table to model many-to-many coupon-to-category relationships
02
Separated Brand and Store so a single brand can operate multiple storefronts
03
Tracked redemptions as a separate entity to preserve user-coupon transaction history
Use when building multi-brand coupon, deal, or cashback aggregators that require normalized merchant hierarchies and redemption audit trails.
More like this