Game
Tables (10)
ai_judgement_logs
- ai_judgement_log_id — BIGINT — Primary key — NOT NULL
- round_id — BIGINT — Foreign key → rounds.round_id — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id
- ai_type — VARCHAR(50) — NOT NULL
- input_summary — TEXT
- detected_value — VARCHAR(255)
- confidence — DECIMAL(5,4)
- is_valid — TINYINT — NOT NULL
- judged_at — DATETIME — NOT NULL
forbidden_words
- forbidden_word_id — BIGINT — Primary key — NOT NULL
- mission_id — BIGINT — Foreign key → missions.mission_id — NOT NULL
- word — VARCHAR(100) — NOT NULL
game_sessions
- game_session_id — BIGINT — Primary key — NOT NULL
- room_id — BIGINT — Foreign key → rooms.room_id — NOT NULL
- game_id — BIGINT — Foreign key → games.game_id — NOT NULL
- status — VARCHAR(20) — NOT NULL
- current_round — INT — NOT NULL
- started_at — DATETIME
- ended_at — DATETIME
games
- game_id — BIGINT — Primary key — NOT NULL
- game_type — VARCHAR(50) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- description — TEXT
- is_active — TINYINT — NOT NULL
missions
- mission_id — BIGINT — Primary key — NOT NULL
- game_id — BIGINT — Foreign key → games.game_id — NOT NULL
- mission_type — VARCHAR(50) — NOT NULL
- keyword — VARCHAR(100)
- target_label — VARCHAR(100)
- description — TEXT
- difficulty — VARCHAR(20) — NOT NULL
- is_active — TINYINT — NOT NULL
room_participants
- room_participant_id — BIGINT — Primary key — NOT NULL
- room_id — BIGINT — Foreign key → rooms.room_id — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- role — VARCHAR(20) — NOT NULL
- connection_status — VARCHAR(20) — NOT NULL
- joined_at — DATETIME — NOT NULL
- left_at — DATETIME
rooms
- room_id — BIGINT — Primary key — NOT NULL
- host_user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- room_code — VARCHAR(20) — NOT NULL
- title — VARCHAR(100) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- max_players — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- closed_at — DATETIME
round_results
- round_result_id — BIGINT — Primary key — NOT NULL
- round_id — BIGINT — Foreign key → rounds.round_id — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- score — INT — NOT NULL
- is_success — TINYINT — NOT NULL
- result_detail — VARCHAR(255)
- created_at — DATETIME — NOT NULL
rounds
- round_id — BIGINT — Primary key — NOT NULL
- game_session_id — BIGINT — Foreign key → game_sessions.game_session_id — NOT NULL
- mission_id — BIGINT — Foreign key → missions.mission_id
- presenter_user_id — BIGINT — Foreign key → users.user_id
- round_number — INT — NOT NULL
- status — VARCHAR(20) — NOT NULL
- started_at — DATETIME
- ended_at — DATETIME
users
- user_id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(255)
- nickname — VARCHAR(50) — NOT NULL
- profile_image_url — VARCHAR(500)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL