Coupon

Tables (3)

Coupon (Untitled2)

  • id (PK) — Primary key — NOT NULL
  • name (쿠폰 이름)
  • total_stock (쿠폰 재고)
  • available_stock (남은 재고)
  • start_at (시작시각)
  • end_at (종료시각)

Coupon_ISSUE (Untitled3)

  • id (PK) — Primary key — NOT NULL
  • member_id (PK2) — Foreign key → Member.id — NOT NULL
  • coupon_id (PK3) — Foreign key → Coupon.id — NOT NULL
  • datetime (issued_at)

Member (Untitled)

  • id (PK) — Primary key — NOT NULL
  • nickname (닉네임)