Table xonstatdb.xonstat.players 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
player_id serial 10  √  nextval('players_player_id_seq'::regclass)
achievements.player_id achievements_fk002 R
hashkeys.player_id hashkeys_fk001 R
player_elos.player_id player_elos_fk01 R
player_game_anticheats.player_id player_game_anticheats_fk01 R
player_game_stats.player_id player_game_stats_fk001 R
player_groups.player_id player_groups_fk001 R
player_map_captimes.player_id player_map_captimes_fk01 R
player_nicks.player_id player_nicks_fk01 R
player_ranks.player_id player_ranks_fk01 R
player_weapon_stats.player_id player_weapon_stats_fk001 R
nick varchar 128  √  null
location varchar 100  √  null
create_dt timestamp 29,6 timezone('UTC'::text, now())
stripped_nick varchar 128  √  null
active_ind bool 1 true
email_addr varchar 255  √  null

Analyzed at Sat Sep 19 14:38 EDT 2015

Indexes:
Column(s) Type Sort Constraint Name
player_id Primary key Asc players_pk

Close relationships  within of separation: