갈릭폰
테이블 (4)
game_chains
- id — BIGINT — 기본 키 — NOT NULL
- room_id — BIGINT — 외래 키 → rooms.id — NOT NULL
- start_player_id — BIGINT — 외래 키 → room_players.id — NOT NULL
- chain_order — INT
room_players
- id — BIGINT — 기본 키 — NOT NULL
- room_id — BIGINT — 외래 키 → rooms.id — NOT NULL
- nickname — VARCHAR(30)
- is_host — BOOLEAN
rooms
- id — BIGINT — 기본 키 — NOT NULL
- room_code — VARCHAR(20)
- status — VARCHAR(20)
- current_round — INT
submissions
- id — BIGINT — 기본 키 — NOT NULL
- room_id — BIGINT — 외래 키 → rooms.id — NOT NULL
- player_id — BIGINT — 외래 키 → room_players.id — NOT NULL
- chain_id — BIGINT — 외래 키 → game_chains.id — NOT NULL
- round_number — INT
- submit_type — VARCHAR(20)
- text_content — TEXT
- image_path — TEXT