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