lol

Tables (7)

challenger (챌린저정보)

  • no (Key) — int — Primary key — NOT NULL
  • tier (Field3) — varchar
  • summonerName (Field) — char
  • leaguePoints (Field4) — int
  • wins (Field5) — int
  • losses (Field6) — int
  • summonerLevel (Field7) — int
  • summonerId (Field8) — varchar
  • puuid (Field2) — char

champion (챔피언정보)

  • no (Key) — int — Primary key — NOT NULL
  • champion_key (Field) — int
  • name (Field2) — varchar
  • en_name (Field3) — varchar
  • image (Field4) — text

inGameData (인게임데이터)

  • no (Key) — int — Primary key — NOT NULL
  • gameId (Field) — bigint
  • kills (Field2) — int
  • deaths (Field3) — int
  • assists (Field4) — int
  • champLevel (Field5) — int
  • gainGold (Field6) — int
  • wardsKilled (Field7) — int
  • wardsPlaced (Field8) — int
  • visionWards (Field9) — int
  • cs (Field10) — int
  • dragonKills (Field11) — int
  • baronKills (Field12) — int
  • turretKills (Field13) — int
  • inhibitorKills (Field14) — int
  • totalDamageDealt (Field15) — int
  • totalDamageTaken (Field16) — int
  • defenseStat (Field17) — int
  • flexStat (Field18) — int
  • offenseStat (Field19) — int
  • mainPerk0 (Field20) — int
  • mainPerk1 (Field21) — int
  • mainPerk2 (Field22) — int
  • mainPerk3 (Field23) — int
  • mainPerk4 (Field24) — int
  • subPerk0 (Field25) — int
  • subPerk1 (Field26) — int
  • subPerk2 (Field27) — int
  • item0 (Field28) — int
  • item1 (Field29) — int
  • item2 (Field30) — int
  • item3 (Field31) — int
  • item4 (Field32) — int
  • item5 (Field33) — int
  • item6 (Field34) — int
  • summoner1Id (Field35) — int
  • summoner2Id (Field36) — int
  • doubleKills (Field37) — int
  • tripleKills (Field38) — int
  • quadraKills (Field39) — int
  • pentaKills (Field40) — int
  • championId (Field41) — int
  • summonerName (Field42) — varchar
  • teamId (Field43) — int
  • puuid (Field44) — varchar
  • teamPosition (Field45) — varchar
  • win (Field46) — int
  • gameDuration (Field47) — int
  • gameEndTimestamp (Field48) — bigint
  • ban (Field49) — int

per_min_champData (분당챔피언데이터)

  • no (Key) — int — Primary key — NOT NULL
  • gameId (Field) — bigint
  • timestamp (Field2) — int
  • participantId (Field3) — int
  • totalGold (Field4) — int
  • level (Field5) — int
  • cs (Field6) — int
  • xp (Field7) — int

per_min_userData (분당유저데이터)

  • no (Key) — int — Primary key — NOT NULL
  • gameId (Field) — bigint
  • participantId (Field2) — int
  • puuid (Field3) — text

rune (룬)

  • no (Key) — int — Primary key — NOT NULL
  • runeId (Field) — int
  • name (Field2) — varchar
  • icon (Field3) — text
  • shortDesc (Field4) — text
  • longDesc (Field5) — text

timelineData (타임라인데이터)

  • no (Key) — int — Primary key — NOT NULL
  • gameId (Field) — bigint
  • realTimestamp (Field2) — bigint
  • itemId (Field3) — int
  • level (Field4) — int
  • levelUpType (Field5) — text
  • creatorId (Field6) — int
  • participantId (Field7) — int
  • timestamp (Field8) — int
  • action_type (Field9) — text
  • skillSlot (Field10) — int
  • monsterType (Field11) — text
  • wardType (Field12) — text
  • killType (Field13) — text
  • killerId (Field14) — int
  • victimId (Field15) — int
  • position_x (Field16) — int
  • position_y (Field17) — int
  • winningTeam (Field18) — int