LoLDuo

Tables (15)

champion (Champion)

  • id — binint(20) — Primary key — NOT NULL
  • img_url (imgUrl) — varchar(255)
  • name — varchar(255)

double_combi (DoubleCombi)

  • id — binint(20) — Primary key — NOT NULL
  • all_count (allCount) — binint(20)
  • champion_id (championId) — longtext
  • perk_list (perkList) — longtext
  • perk_myth_item (perkMythItem) — varchar(255)
  • position — longtext
  • spell_list (spellList) — longtext
  • win_count (winCount) — binint(20)

double_match (DoubleMatch)

  • id — binint(20) — Primary key — NOT NULL
  • champion — binint(20)
  • date — date
  • item_list (itemList) — longtext
  • perk_list (perkList) — longtext
  • position — longtext
  • spell_list (spellList) — longtext
  • win — bit(1)
  • tier — varchar(255)

item (Item)

  • id — binint(20) — Primary key — NOT NULL
  • img_url (imgUrl) — varchar(255)
  • name — varchar(255)

item_full (ItemFull)

  • id — binint(20) — Primary key — NOT NULL

lol_user (LoLUser)

  • puuid — binint(20) — Primary key — NOT NULL
  • tier — varchar(255)

match_detail (MatchDetail)

  • id — binint(20) — Primary key — NOT NULL
  • date — date
  • match_info (matchInfo) — longtext
  • item_list (itemList) — longtext
  • puuid_list (puuidList) — longtext
  • tier — varchar(255)

penta_combi (PentaCombi)

  • id — binint(20) — Primary key — NOT NULL
  • all_count (allCount) — binint(20)
  • champion_id (championId) — longtext
  • perk_list (perkList) — longtext
  • perk_myth_item (perkMythItem) — varchar(255)
  • position — longtext
  • spell_list (spellList) — longtext
  • win_count (winCount) — binint(20)

penta_match (PentaMatch)

  • id — binint(20) — Primary key — NOT NULL
  • champion — binint(20)
  • date — date
  • item_list (itemList) — longtext
  • perk_list (perkList) — longtext
  • position — longtext
  • spell_list (spellList) — longtext
  • win — bit(1)
  • tier — varchar(255)

perk_id (Perk)

  • id — binint(20) — Primary key — NOT NULL
  • img_url (imgUrl) — varchar(255)
  • name — varchar(255)

solo_combi (SoloCombi)

  • id — binint(20) — Primary key — NOT NULL
  • all_count (allCount) — binint(20)
  • champion_id (championId) — longtext
  • perk_list (perkList) — longtext
  • perk_myth_item (perkMythItem) — varchar(255)
  • position — longtext
  • spell_list (spellList) — longtext
  • win_count (winCount) — binint(20)

solo_match (SoloMatch)

  • id — binint(20) — Primary key — NOT NULL
  • champion — binint(20)
  • date — date
  • item_list (itemList) — longtext
  • perk_list (perkList) — longtext
  • position — longtext
  • spell_list (spellList) — longtext
  • win — bit(1)
  • tier — varchar(255)

spell (Spell)

  • id — binint(20) — Primary key — NOT NULL
  • img_url (imgUrl) — varchar(255)
  • name — varchar(255)

triple_combi (TripleCombi)

  • id — binint(20) — Primary key — NOT NULL
  • all_count (allCount) — binint(20)
  • champion_id (championId) — longtext
  • perk_list (perkList) — longtext
  • perk_myth_item (perkMythItem) — varchar(255)
  • position — longtext
  • spell_list (spellList) — longtext
  • win_count (winCount) — binint(20)

triple_match (TripleMatch)

  • id — binint(20) — Primary key — NOT NULL
  • champion — binint(20)
  • date — date
  • item_list (itemList) — longtext
  • perk_list (perkList) — longtext
  • position — longtext
  • spell_list (spellList) — longtext
  • win — bit(1)
  • tier — varchar(255)