Member

Tables (8)

GAME_LOBBY

  • id — BIGINT — NOT NULL
  • map_id — BIGINT — Foreign key → map.id — NOT NULL
  • uuid — VARCHAR(255) — NOT NULL
  • max_players — INT — NOT NULL
  • status — ENUM('WAITING', 'FULL', 'PLAYING', 'FINISHED') — NOT NULL
  • created_at — DATETIME — NOT NULL

GAME_PLAYER

  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • lobby_id — BIGINT — Foreign key → GAME_LOBBY.id — NOT NULL
  • score — INT — NOT NULL
  • is_ready — BOOLEAN — NOT NULL
  • is_kicked — BOOLEAN — NOT NULL

GAME_SESSION

  • id — BIGINT — NOT NULL
  • lobby_id — BIGINT — Foreign key → GAME_LOBBY.id — NOT NULL
  • status — ENUM('IN_PROGRESS', 'COMPLETED') — NOT NULL
  • start_time — DATETIME — NOT NULL
  • end_at — DATETIME

MAIN_CHAT

  • id — BIGINT — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • context — VARCHAR(500) — NOT NULL
  • created_at — DATETIME — NOT NULL

map

  • id — BIGINT — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • category — VARCHAR(100) — NOT NULL
  • num_of_song — INT — NOT NULL

mapItem

  • id — BIGINT — NOT NULL
  • map_id — BIGINT — Foreign key → map.id — NOT NULL
  • youtube_url — VARCHAR(255) — NOT NULL
  • start_time — INT — NOT NULL
  • end_time — INT — NOT NULL
  • hint — VARCHAR(255) — NOT NULL
  • hint_time — INT — NOT NULL
  • answer — VARCHAR(255) — NOT NULL

user_credentials

  • id — BIGINT — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • login_id — VARCHAR(50) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • failed_login_count — INT — NOT NULL
  • locked_until — DATETIME
  • created_at — DATETIME — NOT NULL

users

  • id — BIGINT — NOT NULL
  • username — VARCHAR(50) — NOT NULL
  • user_type — ENUM('REGISTERED', 'GUEST') — NOT NULL
  • status — ENUM('ACTIVE', 'BANNED', 'DELETED') — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • last_login_at — DATETIME