シナリオ
A restaurant chain issues coupon campaigns; customers redeem coupons at the table through servers, with each redemption linked to a specific order and coupon.
この図に含まれるもの
図の背後にある意思決定を読み解く。
01
Model coupons as instances issued from campaigns to track unique codes and status
02
Separate redemption as a link entity between coupon, order, and server to capture redemption audit
03
Use many-to-one relationships from orders/redemptions to reference entities for referential integrity
Reusable for retail, hospitality, or any coupon/promotions module where customers redeem offers in an order context.