선착순 예메

테이블 (3)

event (이벤트)

  • id (Key) — 기본 키 — NOT NULL
  • festival_id (Field)
  • name (Field2)
  • total (Field3)
  • remaining (Field4)
  • open_at (Field5)
  • created_at (Field6)

ticket (티켓)

  • id (Key2) — 기본 키 — NOT NULL
  • ticket_count (Field)
  • reservation_no (Field2)
  • phone_no (Key) — 외래 키 → event.id — NOT NULL

verification (검증)

  • id (Key) — 기본 키 — NOT NULL
  • phone_no (Field)
  • code (Field3)
  • is_verified (Field2)
  • code_expired_at (Field4)
  • verified_expired_at (Field5)