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