xonstatdb.xonstat contains 152 columns - click on heading to sort:

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