갈릭폰
테이블 (6)
game_states
- lobby_code — VARCHAR(10) — 외래 키 → lobbies.id — NOT NULL
- current_round — INT — NOT NULL
- updated_at — TIMESTAMP
- created_at — TIMESTAMP
- total_rounds — INT — NOT NULL
game_submissions
- lobby_code — VARCHAR(10) — 외래 키 → lobbies.id — NOT NULL
- round — INT — NOT NULL
- type — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- session_id — VARCHAR(255) — NOT NULL
game_topics
- lobby_code — VARCHAR(10) — 외래 키 → lobbies.id — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- session_id — VARCHAR(255) — NOT NULL
- content — VARCHAR(255) — NOT NULL
lobbies
- id — BIGINT — 기본 키 — NOT NULL
- host_avatar — VARCHAR(255)
- created_at — TIMESTAMP
- chat_enabled — BOOLEAN — NOT NULL
- updated_at — TIMESTAMP
- mode — VARCHAR(255) — NOT NULL
- max_players — INT — NOT NULL
- time_limit — INT — NOT NULL
- host_nickname — VARCHAR(255) — NOT NULL
- code — VARCHAR(10)
lobby_players
- lobby_code — VARCHAR(10) — 외래 키 → lobbies.id — NOT NULL
- avatar — VARCHAR(255)
- nickname — VARCHAR(255) — NOT NULL
- session_id — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- is_host — BOOLEAN — NOT NULL
- is_ready — BOOLEAN — NOT NULL
- status_message — VARCHAR(80)
users
- id — BIGINT — 기본 키 — NOT NULL
- created_at — TIMESTAMP
- session_id — VARCHAR(255)
- status_message — VARCHAR(255)
- discriminator — VARCHAR(255)
- avatar_url — VARCHAR(255)
- email — VARCHAR(255)
- name — VARCHAR(255) — NOT NULL
- discord_id — VARCHAR(255)
- updated_at — TIMESTAMP