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