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