Le scénario
A restaurant chain issues coupon campaigns; customers redeem coupons at the table through servers, with each redemption linked to a specific order and coupon.
Ce que contient ce dessin
Comprenez les décisions qui le sous-tendent.
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.