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