경품교환관리

테이블 (3)

coupons

  • coupon_id — BIGINT — 기본 키 — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • issue_date — DATE — NOT NULL
  • number — INT — NOT NULL

daily_stats

  • stats_date — DATE — 기본 키 — NOT NULL
  • issued — INT — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

daily_visit_hourly

  • visit_hourly_id — BIGINT — 기본 키 — NOT NULL
  • hour — TINYINT — NOT NULL
  • hall — CHAR(1) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • visit_date — DATE — NOT NULL
  • visits — INT — NOT NULL