SchemaSpy Analysis of xonstatdb.xonstat - Columns Generated by
SchemaSpy
Generated by SchemaSpy on Sat Sep 19 14:38 EDT 2015
Legend: SourceForge.net
Primary key columns
Columns with indexes
 

xonstatdb.xonstat contains 152 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default Comments
cd_achievement active_ind bool 1 true
cd_game_type active_ind bool 1 true
cd_mutator active_ind bool 1 true
cd_weapon active_ind bool 1 true
hashkeys active_ind bool 1 true
player_elos active_ind bool 1 true
players active_ind bool 1 true
servers active_ind bool 1 true
servers pure_ind bool 1 true
achievements achievement_cd int4 10
cd_achievement achievement_cd int4 10
achievements achievement_id serial 10  √  nextval('achievements_achievement_id_seq'::regclass)
player_weapon_stats actual int4 10 0
team_game_stats caps int4 10  √  null
player_game_stats captures int4 10  √  null
player_game_stats carrier_frags int4 10  √  null
player_game_stats collects int4 10  √  null
player_game_stats deaths int4 10  √  null
player_game_stats destroys int4 10  √  null
player_game_stats drops int4 10  √  null
player_weapon_stats fired int4 10 0
player_weapon_stats frags int4 10 0
cd_game_type game_type_cd varchar 10
games game_type_cd varchar 10
map_game_types game_type_cd varchar 10
player_elos game_type_cd varchar 10
player_ranks game_type_cd varchar 10
player_elos games int4 10 0
player_weapon_stats hit int4 10 0
player_game_stats kills int4 10  √  null
player_game_stats laps int4 10  √  null
cd_achievement limit int4 10  √  null
player_game_stats lives int4 10  √  null
games map_id int4 10
map_game_types map_id int4 10
maps map_id serial 10  √  nextval('maps_map_id_seq'::regclass)
player_map_captimes map_id int4 10
player_weapon_stats max int4 10 0
servers max_players int4 10  √  null
cd_mutator mutator_cd int4 10
game_mutators mutator_cd int4 10
player_game_stats pickups int4 10  √  null
achievements player_id int4 10
hashkeys player_id int4 10
player_elos player_id int4 10
player_game_anticheats player_id int4 10
player_game_stats player_id int4 10
player_groups player_id int4 10
player_map_captimes player_id int4 10
player_nicks player_id int4 10
player_ranks player_id int4 10
player_weapon_stats player_id int4 10
players player_id serial 10  √  nextval('players_player_id_seq'::regclass)
player_map_captimes player_map_captime_id serial 10  √  nextval('player_map_captimes_player_map_captime_id_seq'::regclass)
games players _int4 10  √  null
servers port int4 10  √  null
player_game_stats pushes int4 10  √  null
player_game_stats rank int4 10  √  null
player_ranks rank int4 10
player_game_stats returns int4 10  √  null
player_game_stats revivals int4 10  √  null
team_game_stats rounds int4 10  √  null
player_game_stats score int4 10  √  null
team_game_stats score int4 10  √  null
player_game_stats scoreboardpos int4 10  √  null
games server_id int4 10
servers server_id serial 10  √  nextval('servers_server_id_seq'::regclass)
player_game_stats suicides int4 10  √  null
player_game_stats team int4 10  √  null
team_game_stats team int4 10
maps version int4 10 1
games winner int4 10  √  null
db_version version varchar 15
cd_weapon weapon_cd varchar 15
player_weapon_stats weapon_cd varchar 15
game_mutators game_id int8 19
games game_id bigserial 19  √  nextval('games_game_id_seq'::regclass)
player_game_anticheats game_id int8 19
player_game_stats game_id int8 19
player_map_captimes game_id int8 19
player_weapon_stats game_id int8 19
team_game_stats game_id int8 19
player_game_anticheats player_game_anticheat_id bigserial 19  √  nextval('player_game_anticheats_player_game_anticheat_id_seq'::regclass)
player_game_stats player_game_stat_id bigserial 19  √  nextval('player_game_stats_player_game_stat_id_seq'::regclass)
player_weapon_stats player_game_stat_id int8 19
player_weapon_stats player_weapon_stats_id bigserial 19  √  nextval('player_weapon_stats_player_weapon_stats_id_seq'::regclass)
summary_stats summary_stats_id bigserial 19  √  nextval('summary_stats_summary_stats_id_seq'::regclass)
team_game_stats team_game_stat_id bigserial 19  √  nextval('team_game_stats_team_game_stat_id_seq'::regclass)
summary_stats total_ctf_games int8 19
summary_stats total_dm_games int8 19
summary_stats total_duel_games int8 19
summary_stats total_games int8 19
summary_stats total_players int8 19
summary_stats total_servers int8 19
achievements create_dt timestamp 29,6 timezone('UTC'::text, now())
db_version create_dt timestamp 29,6 timezone('UTC'::text, now())
games create_dt timestamp 29,6 timezone('UTC'::text, now())
hashkeys create_dt timestamp 29,6 timezone('UTC'::text, now())
maps create_dt timestamp 29,6 timezone('UTC'::text, now())
player_elos create_dt timestamp 29,6 timezone('UTC'::text, now())
player_game_anticheats create_dt timestamp 29,6 timezone('UTC'::text, now())
player_game_stats create_dt timestamp 29,6
player_groups create_dt timestamp 29,6 timezone('UTC'::text, now())
player_map_captimes create_dt timestamp 29,6 timezone('UTC'::text, now())
player_nicks create_dt timestamp 29,6 timezone('UTC'::text, now())
player_ranks create_dt timestamp 29,6 timezone('UTC'::text, now())
player_weapon_stats create_dt timestamp 29,6 timezone('UTC'::text, now())
players create_dt timestamp 29,6 timezone('UTC'::text, now())
servers create_dt timestamp 29,6 now()
summary_stats create_dt timestamp 29,6 timezone('UTC'::text, now())
team_game_stats create_dt timestamp 29,6 timezone('UTC'::text, now())
games start_dt timestamp 29,6
player_elos update_dt timestamp 29,6 timezone('UTC'::text, now())
player_groups group_name varchar 30
servers ip_addr varchar 32  √  null
hashkeys hashkey varchar 44
servers hashkey varchar 44  √  null
player_game_stats alivetime interval 49,6  √  null
games duration interval 49,6  √  null
player_game_stats fastest interval 49,6  √  null
player_map_captimes fastest_cap interval 49,6
player_game_stats time interval 49,6  √  null
servers revision varchar 50  √  null
games match_id varchar 64  √  null
games mod varchar 64  √  null
cd_mutator name varchar 64
maps name varchar 64
servers name varchar 64  √  null
cd_achievement descr varchar 100
cd_game_type descr varchar 100
cd_mutator descr varchar 100  √  null
cd_weapon descr varchar 100
db_version descr varchar 100
players location varchar 100  √  null
servers location varchar 100  √  null
maps pk3_name varchar 100  √  null
player_game_anticheats key varchar 128  √  null
player_game_stats nick varchar 128  √  null
player_nicks nick varchar 128
player_ranks nick varchar 128  √  null
players nick varchar 128  √  null
player_game_stats stripped_nick varchar 128  √  null
player_nicks stripped_nick varchar 128
players stripped_nick varchar 128  √  null
players email_addr varchar 255  √  null
maps curl_url varchar 300  √  null
servers public_key varchar 725  √  null
player_game_stats avg_latency numeric 131089  √  null
player_elos elo numeric 131089
player_ranks elo numeric 131089
player_game_stats elo_delta numeric 131089  √  null
player_game_anticheats value numeric 131089  √  null