TFT
Tables (6)
Match (match)
- Match Id (match_id) — String — Primary key — NOT NULL
- Data Version (data_version) — String
- Game Datetime (game_datetime) — long
- Game Length (game_length) — float
- Queue Id (queue_id) — int
- Game Variation (game_variation) — String
- Game Version (game_version) — String
- TFT Set Number (tft_set_number) — int
Participant (participant)
- Summoner Id (summoner_id) — String — Foreign key → Summoner.Summoner Id — NOT NULL
- Match Id (match_id) — String — Foreign key → Match.Match Id — NOT NULL
- Content Id (content_id) — String
- Skin Id (skin_id) — int
- Species (species) — String
- Gold Left (gold_left) — int
- Last Round (last_round) — int
- Level (level) — int
- Placement (placement) — int
- Player Eliminated (player_eliminated) — int
- Time Eliminated (time_eliminated) — float
- Total Damage To Players (total_damage_to_players) — int
Participant Trait (participant_trait)
- Name (name) — String — Primary key — NOT NULL
- Summoner Id (summoner_id) — String — Foreign key → Participant.Summoner Id — NOT NULL
- Match Id (match_id) — String — Foreign key → Participant.Match Id — NOT NULL
- Num Units (num_units) — int
- Style (style) — int
- Tier Current (tier_current) — int
- Tier Total (tier_total) — int
Participant Unit (participant_unit)
- Character Id (character_id) — String — Primary key
- Summoner Id (summoner_id) — String — Foreign key → Participant.Summoner Id — NOT NULL
- Match Id (match_id) — String — Foreign key → Participant.Match Id — NOT NULL
- Chosen (chosen) — String
- Name (name) — String
- Rarity (rarity) — int
- Tier (tier) — int
Participant Unit Item (participant_unit_item)
- Name (name) — String — Primary key
- Character Id (character_id) — String — Foreign key → Participant Unit.Character Id
- Summoner Id (summoner_id) — String — Foreign key → Participant Unit.Summoner Id — NOT NULL
- Match Id (match_id) — String — Foreign key → Participant Unit.Match Id — NOT NULL
Summoner (summoner)
- Summoner Id (summoner_id) — String — Primary key — NOT NULL
- Account Id (account_id) — String
- Puuid (puuid) — String
- Name (name) — String
- Profile Icon Id (profile_icon_id) — int
- Revision Date (revision_date) — long
- Summoner Level (summoner_level) — int