NAR.GG
Tables (10)
Ban (벤)
- ban_id (Key) — LONG — Primary key — NOT NULL
- game_id (Key2) — LONG — Foreign key → Game.game_id — NOT NULL
- team_id (Key4) — LONG — Foreign key → Team.team_id — NOT NULL
- champion_id (Key5) — LONG — Foreign key → Champion.champion_id — NOT NULL
Champion (챔피언)
- champion_id (Key) — LONG — Primary key — NOT NULL
- champion_name_kr (Field) — VARCHAR
- champion_name_en (Field2) — VARCHAR
- image_url (Field3) — VARCHAR
Game (경기 정보)
- game_id (Key) — LONG — Primary key — NOT NULL
- league_id (Key2) — LONG — Foreign key → League.league_id — NOT NULL
- game_date (Field) — DATETIME
- game_number (Field2) — INTEGER
- patch (Field3) — VARCHAR
- game_length_seconds (Field4) — INTEGER
- game_origin_id (Field5) — VARCHAR
GameParticipant (경기 참가자 및 결과)
- participant_game_id (Key) — LONG — Primary key — NOT NULL
- game_id (Key4) — LONG — Foreign key → Game.game_id — NOT NULL
- team_id (Key2) — LONG — Foreign key → Team.team_id — NOT NULL
- player_id (Key3) — LONG — Foreign key → Player.player_id — NOT NULL
- side (Field) — VARCHAR
- position (Field2) — VARCHAR
- is_win (Field4) — BOOLEAN
- champion_id (Key5) — LONG — Foreign key → Champion.champion_id — NOT NULL
GamePlayerStat (게임 내 선수 스탯)
- game_player_stat_id (Key) — LONG — Primary key — NOT NULL
- participant_game_id (Key2) — LONG — Foreign key → GameParticipant.participant_game_id — NOT NULL
- 110가지 상세 필드 (Field) — VARCHAR
GameTeamStat (게임 내 팀 스탯)
- champion_id (Key) — LONG — Primary key — NOT NULL
- game_id (Key2) — LONG — Foreign key → Game.game_id — NOT NULL
- team_id (Key3) — LONG — Foreign key → Team.team_id — NOT NULL
- 56가지 상세 필드 (Field) — VARCHAR
League (대회 정보)
- league_id (Key) — LONG — Primary key — NOT NULL
- league_name (Field) — VARCHAR
- season_split (Field2) — VARCHAR
- is_playoffs (Field3) — BOOLEAN
- season_year (Field4) — INTEGER
LeagueTeam (CopyOf대회 정보)
- league_team_id (Key) — LONG — Primary key — NOT NULL
- team_id (Key2) — LONG — Foreign key → Team.team_id — NOT NULL
- league_id (Key3) — LONG — Foreign key → League.league_id — NOT NULL
Player (선수 정보)
- player_id (Key) — LONG — Primary key — NOT NULL
- player_origin_id (Field2) — VARCHAR
- player_name (Field) — VARCHAR
Team (팀 정보)
- team_id (Key) — LONG — Primary key — NOT NULL
- origin_id (Field2) — VARCHAR
- team_name (Field) — VARCHAR