종합프로젝트

테이블 (5)

app_user

  • user_id — BIGINT — 기본 키 — NOT NULL
  • login_id — VARCHAR(100) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • email — VARCHAR(255)
  • role — VARCHAR(30) — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

coupon

  • coupon_id — BIGINT — 기본 키 — NOT NULL
  • event_id — BIGINT — 외래 키 → coupon_event.event_id — NOT NULL
  • name — VARCHAR(150) — NOT NULL
  • discount_type — VARCHAR(30) — NOT NULL
  • discount_value — INT — NOT NULL
  • min_order_amount — INT
  • max_discount_amount — INT
  • total_quantity — INT — NOT NULL
  • remaining_quantity — INT — NOT NULL
  • per_user_limit — INT — NOT NULL
  • issue_start_at — DATETIME — NOT NULL
  • issue_end_at — DATETIME — NOT NULL
  • valid_days — INT
  • status — VARCHAR(30) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

coupon_event

  • event_id — BIGINT — 기본 키 — NOT NULL
  • created_by — BIGINT — 외래 키 → app_user.user_id — NOT NULL
  • name — VARCHAR(150) — NOT NULL
  • description — VARCHAR(1000)
  • open_at — DATETIME
  • start_at — DATETIME — NOT NULL
  • end_at — DATETIME — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

coupon_issue

  • coupon_issue_id — BIGINT — 기본 키 — NOT NULL
  • coupon_id — BIGINT — 외래 키 → coupon.coupon_id — NOT NULL
  • user_id — BIGINT — 외래 키 → app_user.user_id — NOT NULL
  • request_id — VARCHAR(100) — NOT NULL
  • sequence_no — BIGINT — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • issued_at — DATETIME — NOT NULL
  • used_at — DATETIME
  • canceled_at — DATETIME
  • expired_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

reconciliation_report

  • report_id — BIGINT — 기본 키 — NOT NULL
  • coupon_id — BIGINT — 외래 키 → coupon.coupon_id — NOT NULL
  • as_of_at — DATETIME — NOT NULL
  • total_quantity — INT — NOT NULL
  • db_issued_count — INT — NOT NULL
  • db_remaining — INT — NOT NULL
  • redis_remaining — INT — NOT NULL
  • difference_quantity — INT — NOT NULL
  • result — VARCHAR(30) — NOT NULL
  • started_at — DATETIME — NOT NULL
  • finished_at — DATETIME
  • created_at — DATETIME — NOT NULL