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)