TF2 Stats: SQL tables
games
- game_id (uint 10)
- map_id (uint 5)
maps
- map_id (uint 5)
- map_name (vchar 50)
sessions
- session_id (uint 10)
- game_id (uint 10)
- player_id (uint 10)
- session_uid (uint 3)
- session_alias (vchar 50)
- session_starttime (dt)
- session_endtime (dt)
players
- player_id (uint 10)
- player_steamid (vchar 23)
roleperiods
- roleperiod_id (uint 10)
- session_id (uint 10)
- roleperiod_team (uint 1)
- class_id (uint 1)
- roleperiod_starttime (dt)
- roleperiod_endtime (dt)
classes
- class_id (uint 1)
- class_name (vchar 20)
- class_displayname (vchar 20)
class_modifiers
- modifier_id
- modifier_victimclass
- modifier_killerclass
- modifier_modifier
kills
- kill_id
- kill_killer
- kill_killer_position
- kill_victim
- kill_victim_position
- kill_assist
- kill_assist_position
- weapon_id
- kill_distance
- kill_timestamp
weapons
- weapon_id
- weapon_name
- weapon_modifier
- weapon_displayname
events
CategoryTF2Stats
Page was generated in 0.0479 seconds