Table xonstatdb.xonstat.player_ranks 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 int4 10
players.player_id player_ranks_fk01 R
nick varchar 128  √  null
game_type_cd varchar 10
cd_game_type.game_type_cd player_ranks_fk02 R
elo numeric 131089
rank int4 10
create_dt timestamp 29,6 timezone('UTC'::text, now())

Analyzed at Sat Sep 19 14:38 EDT 2015

Indexes:
Column(s) Type Sort Constraint Name
player_id + game_type_cd Primary key Asc/Asc player_ranks_pk

Close relationships  within of separation: