ChatDiagram
database · ecommerce · system design

Large-Scale Flash Sale Coupon System ERD

النوع ERDالمعيار Chen 1976 / Everest 1976 (crow's foot)المحرّك schematex-erdآخر تحديث 20‏/8‏/2026
Large-Scale Flash Sale Coupon System ERD
Drawing preview
السيناريو

Design the core data model for a large-scale flash sale platform that issues limited coupons, handles high-concurrency redemption, and records orders.

ما الذي يتضمنه هذا الرسم

اقرأ القرارات الكامنة وراءه.

01

Separated CouponTemplate from Coupon to support millions of generated coupon codes with shared rules

02

Linked UserCoupon to both User and Coupon to track redemption state per user

03

Modeled FlashSaleItem as an independent entity connecting flash events to coupon templates with dedicated stock counters

Reuse for any coupon-driven promotion system that needs to model inventory-limited coupons, per-user issuance limits, flash sale events, and order history.

تصفّح جميع قوالب ERD ←