축제 줄서기 v1.0.1
테이블 (7)
departments
- id — BIGINT — 기본 키 — NOT NULL
- name — VARCHAR(100) — NOT NULL
- created_at — DATETIME — NOT NULL
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 — NOT NULL
- store_id — BIGINT — NOT NULL
- requested_at — DATETIME — NOT NULL
- status — ENUM('WAITING','CALLED','CANCELLED') — NOT NULL
- INDEX — `idx_wr_user`
- INDEX — `idx_wr_store_status`