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

• event_id
• event_type
• ...?

CategoryTF2Stats