Lo scenario
Design a coupon aggregation platform that normalizes multiple brands, storefronts, coupon codes, categories, user accounts, and redemption transactions.
Cosa contiene questo disegno
Leggi le decisioni che ne stanno alla base.
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.