The 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.
What is in this drawing
Read the decisions behind it.
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.
More like this