Table xonstatdb.xonstat.games Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
game_id bigserial 19  √  nextval('games_game_id_seq'::regclass)
game_mutators.game_id game_mutators_fk001 R
player_game_stats.game_id player_game_stats_fk002 R
player_weapon_stats.game_id player_weapon_stats_fk002 R
team_game_stats.game_id team_game_stats_fk001 C
start_dt timestamp 29,6
game_type_cd varchar 10
cd_game_type.game_type_cd games_fk001 R
server_id int4 10
servers.server_id games_fk002 R
map_id int4 10
maps.map_id games_fk003 R
duration interval 49,6  √  null
winner int4 10  √  null
create_dt timestamp 29,6 timezone('UTC'::text, now())
match_id varchar 64  √  null
mod varchar 64  √  null
players _int4 10  √  null

Analyzed at Sat Sep 19 14:38 EDT 2015

Indexes:
Column(s) Type Sort Constraint Name
game_id Primary key Asc games_pk
create_dt Performance Asc games_ix001
map_id Performance Asc games_ix002
server_id + match_id Must be unique Asc/Asc games_uk001

Close relationships  within of separation: