TFT-APP

Tables (9)

AGUMENTS

  • ID — INT AUTO_INCREMENT — Primary key — NOT NULL
  • CODE_ID — VARCHAR(50)
  • VERSION — VARCHAR(30)
  • NAME — VARCHAR(100)
  • IMAGE — JSON

CHAMPIONS

  • ID — INT AUTO_INCREMENT — Primary key — NOT NULL
  • CODE_ID — VARCHAR(50)
  • VERSION — VARCHAR(30)
  • NAME — VARCHAR(50)
  • TIER — TINYINT
  • IMAGE — JSON

ITEMS

  • ID — INT AUTO_INCREMENT — Primary key — NOT NULL
  • CODE_ID — VARCHAR(50)
  • VERSION — VARCHAR(30)
  • NAME — VARCHAR(100)
  • IMAGE — JSON

MATCH_DETAIL

  • MD_ID — INT AUTO_INCREMENT PRIMARY KEY — Primary key — NOT NULL
  • PUUID — VARCHAR(79) — Foreign key → USER_INFO.PUUID — NOT NULL
  • MATCH_ID — VARCHAR(30) — Foreign key → MATCH_INFO.MATCH_ID — NOT NULL
  • AUGMENTS — JSON
  • COMPANION — JSON
  • GOLD_LEFT — SMALLINT
  • LAST_ROUND — SMALLINT
  • LEVEL — TINYINT
  • PLACEMENT — TINYINT
  • PLAYERS_ELIMINATED — TINYINT
  • TIME_ELIMINATED — FLOAT
  • TOTAL_DAMAGE_TO_PLAYERS — SMALLINT

MATCH_INFO

  • MATCH_ID — VARCHAR(30) PRIMARY KEY — Primary key — NOT NULL
  • DATA_VERSION — VARCHAR(30)
  • PARTICIPANTS — JSON
  • GAME_DATETIME — BIGINT
  • GAME_LENGTH — FLOAT
  • GAME_VERSION — VARCHAR(200)

TRAITS

  • ID — INT AUTO_INCREMENT — Primary key — NOT NULL
  • CODE_ID — VARCHAR(50)
  • VERSION — VARCHAR(30)
  • NAME — VARCHAR(100)
  • IMAGE — JSON

TRAITS_DETAIL

  • TD_ID — INT AUTO_INCREMENT PRIMARY KEY — Primary key — NOT NULL
  • PUUID — VARCHAR(79) — Foreign key → USER_INFO.PUUID — NOT NULL
  • MATCH_ID — VARCHAR(30) — Foreign key → MATCH_INFO.MATCH_ID — NOT NULL
  • NAME — VARCHAR(50)
  • NUM_UNITS — TINYINT
  • STYLE — TINYINT
  • TIER_CURRENT — TINYINT
  • TIER_TOTAL — TINYINT

UNITS_DETAIL

  • UD_ID — INT AUTO_INCREMENT PRIMARY KEY — Primary key — NOT NULL
  • PUUID — VARCHAR(79) — Foreign key → USER_INFO.PUUID — NOT NULL
  • MATCH_ID — VARCHAR(30) — Foreign key → MATCH_INFO.MATCH_ID — NOT NULL
  • CHARACTOR_ID — VARCHAR(50)
  • ITEM_NAMES — JSON
  • NAME — VARCHAR(50)
  • RARITY — TINYINT
  • TIER — TINYINT

USER_INFO

  • PUUID — VARCHAR(79) — Primary key — NOT NULL
  • LEAGUEID — VARCHAR(79)
  • QUEUETYPE — VARCHAR(79)
  • TIER — VARCHAR(30)
  • DIVISION — VARCHAR(30)
  • SUMMONERID — VARCHAR(79)
  • SUMMONERNAME — VARCHAR(79)
  • LEAGUEPOINTS — TINYINT
  • WINS — SMALLINT
  • LOSSES — SMALLINT
  • VETERAN — TINYINT
  • INACTIVE — TINYINT
  • FRESHBLOOD — TINYINT
  • HOTSTREAK — TINYINT
  • TIMESTAMP — TIMESTAMP default current_timestamp — NOT NULL