fearless_draft

테이블 (4)

match (match_tbl)

  • match_id — BIGINT — 기본 키 — NOT NULL
  • team_a_id — BIGINT — NOT NULL
  • winner_team_id — BIGINT
  • match_password — VARCHAR(100)
  • number_of_games — INT
  • created_at — TIMESTAMP
  • team_id (team_b_id) — BIGINT — 외래 키 → 팀.team_id — NOT NULL

게임 (game_tbl)

  • game_id — BIGINT — 기본 키 — NOT NULL
  • game_order — INT
  • blue_team_id — BIGINT
  • red_team_id — BIGINT
  • winner_team_id — BIGINT
  • match_id — BIGINT — 외래 키 → match.match_id — NOT NULL

벤픽 (pick_ban_tbl)

  • ban_pick_id — BIGINT — 기본 키 — NOT NULL
  • type — ENUM('BAN', 'PICK')
  • champion_name — VARCHAR(100)
  • turn_order — INT
  • game_id — BIGINT — 외래 키 → 게임.game_id — NOT NULL
  • team_id — BIGINT — 외래 키 → 팀.team_id — NOT NULL

팀 (team_tbl)

  • team_id — BIGINT — 기본 키 — NOT NULL
  • team_name — VARCHAR(100)
  • team_logo — VARCHAR(255)