Table xonstatdb.xonstat.team_game_stats 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
team_game_stat_id bigserial 19  √  nextval('team_game_stats_team_game_stat_id_seq'::regclass)
game_id int8 19
games.game_id team_game_stats_fk001 C
team int4 10
score int4 10  √  null
rounds int4 10  √  null
caps int4 10  √  null
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
team_game_stat_id Primary key Asc team_game_stats_pk
game_id Performance Asc team_game_stats_ix01
game_id + team Must be unique Asc/Asc team_game_stats_uk001

Close relationships  within of separation: