갈릭폰

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