갈릭폰

테이블 (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