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