SchemaSpy Analysis of xonstatdb.xonstat - Columns | Generated by SchemaSpy |
Generated by SchemaSpy on Sat Sep 19 14:38 EDT 2015 |
| ||||||
|
xonstatdb.xonstat contains 152 columns - click on heading to sort:
Table | Column | Type | Size | Nulls | Auto | Default | Comments |
---|---|---|---|---|---|---|---|
games | players | _int4 | 10 | √ | null | ||
games | game_id | bigserial | 19 | √ | nextval('games_game_id_seq'::regclass) | ||
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_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) | ||
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 | ||||
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 | |||
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 | ||||
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 | ||||
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 | ||||
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 | ||
game_mutators | game_id | int8 | 19 | ||||
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_weapon_stats | player_game_stat_id | int8 | 19 | ||||
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 | ||||
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 | ||
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 | ||
achievements | achievement_id | serial | 10 | √ | nextval('achievements_achievement_id_seq'::regclass) | ||
maps | map_id | serial | 10 | √ | nextval('maps_map_id_seq'::regclass) | ||
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) | ||
servers | server_id | serial | 10 | √ | nextval('servers_server_id_seq'::regclass) | ||
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()) | |||
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 | ||||
db_version | version | varchar | 15 | ||||
cd_weapon | weapon_cd | varchar | 15 | ||||
player_weapon_stats | weapon_cd | varchar | 15 | ||||
player_groups | group_name | varchar | 30 | ||||
servers | ip_addr | varchar | 32 | √ | null | ||
hashkeys | hashkey | varchar | 44 | ||||
servers | hashkey | varchar | 44 | √ | 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 |