환쿠폰

테이블 (5)

coupon

  • id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • discount_type — VARCHAR(10) — NOT NULL
  • discount_value — INT — NOT NULL
  • total_quantity — INT
  • issued_quantity — INT — NOT NULL
  • min_order_amount — INT
  • issue_type — VARCHAR(20) — NOT NULL
  • issue_start_time — TIME
  • issue_end_time — TIME
  • expired_at — DATETIME(6) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

coupon_issue

  • id — BIGINT — 기본 키 — NOT NULL
  • coupon_id — BIGINT — 외래 키 → coupon.id — NOT NULL
  • user_id — BIGINT — 외래 키 → member.id — NOT NULL
  • status — VARCHAR(10) — NOT NULL
  • issued_at — DATETIME(6) — NOT NULL
  • used_at — DATETIME(6)

coupon_issue_batch

  • id — BIGINT — 기본 키 — NOT NULL
  • coupon_id — BIGINT — 외래 키 → coupon.id — NOT NULL
  • target_count — INT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • requested_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • completed_at — DATETIME(6)

coupon_issue_request

  • id — BIGINT — 기본 키 — NOT NULL
  • coupon_id — BIGINT — 외래 키 → coupon.id — NOT NULL
  • user_id — BIGINT — 외래 키 → member.id — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • requested_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • completed_at — DATETIME(6)
  • failure_reason — VARCHAR(255)

member

  • id — BIGINT — 기본 키 — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • birthdate — DATE — NOT NULL
  • phone — VARCHAR(20) — NOT NULL
  • role — VARCHAR(10) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL