축제 원격 줄서기

테이블 (6)

entry_logs

  • id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • store_id — BIGINT — 외래 키 → stores.id — NOT NULL
  • called_at — DATETIME
  • entered_at — DATETIME — NOT NULL
  • INDEX — `idx_entry_user`
  • INDEX — `idx_entry_store`

managers

  • id — BIGINT — 기본 키 — NOT NULL
  • store_id — BIGINT — 외래 키 → stores.id — NOT NULL
  • username — VARCHAR(30) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • INDEX — `idx_managers_store`

menus

  • id — BIGINT — 기본 키 — NOT NULL
  • store_id — BIGINT — 외래 키 → stores.id — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • description — TEXT
  • price — INT — NOT NULL
  • image_url — VARCHAR(255)
  • created_at — DATETIME — NOT NULL
  • INDEX — `idx_menus_store`

stores

  • id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • location — VARCHAR(100)
  • description — TEXT
  • menu_image_url — VARCHAR(255)
  • store_image_url — VARCHAR(255)
  • is_active — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL

users

  • id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • phone — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • INDEX — `idx_users_phone`

waiting_requests

  • id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • store_id — BIGINT — 외래 키 → stores.id — NOT NULL
  • requested_at — DATETIME — NOT NULL
  • status — ENUM('WAITING','CALLED','CANCELLED') — NOT NULL