El escenario
A restaurant chain issues coupon campaigns; customers redeem coupons at the table through servers, with each redemption linked to a specific order and coupon.
Qué hay en este dibujo
Lee las decisiones que hay detrás.
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.