Table xonstatdb.xonstat.player_weapon_stats Generated by
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_weapon_stats_id bigserial 19  √  nextval('player_weapon_stats_player_weapon_stats_id_seq'::regclass)
player_id int4 10
players.player_id player_weapon_stats_fk001 R
game_id int8 19
games.game_id player_weapon_stats_fk002 R
player_game_stat_id int8 19
player_game_stats.player_game_stat_id player_weapon_stats_fk004 R
weapon_cd varchar 15
cd_weapon.weapon_cd player_weapon_stats_fk003 R
actual int4 10 0
max int4 10 0
hit int4 10 0
fired int4 10 0
frags int4 10 0
create_dt timestamp 29,6 timezone('UTC'::text, now())

Analyzed at Sat Sep 19 14:38 EDT 2015

Column(s) Type Sort Constraint Name
player_weapon_stats_id Primary key Asc player_weapon_stats_pk
create_dt Performance Asc player_weap_stats_ix01
game_id Performance Asc player_weap_stats_ix02
player_id Performance Asc player_weap_stats_ix03

Close relationships  within of separation: