상황
A retail chain runs a loyalty program where customers earn points on purchases and receive targeted coupons from campaigns that can be redeemed during future transactions.
이 도면에 담긴 내용
그 이면의 의사결정을 읽어 보세요.
01
Separate LoyaltyAccount from Customer to track tier and points balance without overloading the customer table.
02
Use CouponRedemption as an associative entity to record which coupon was applied to which purchase and when.
03
Link Coupon to Customer and Campaign so each issued coupon is traceable to its recipient and promotion.
Use when modeling coupon issuance, redemption, and loyalty point accrual for retail or e-commerce promotional systems.