Lo scenario
A restaurant chain issues coupon campaigns; customers redeem coupons at the table through servers, with each redemption linked to a specific order and coupon.
Cosa contiene questo disegno
Leggi le decisioni che ne stanno alla base.
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.