상황
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.