シナリオ
Design a coupon aggregation platform that normalizes multiple brands, storefronts, coupon codes, categories, user accounts, and redemption transactions.
この図に含まれるもの
図の背後にある意思決定を読み解く。
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.