Table xonstatdb.xonstat.player_map_captimes 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_map_captime_id serial 10  √  nextval('player_map_captimes_player_map_captime_id_seq'::regclass)
player_id int4 10
players.player_id player_map_captimes_fk01 R
map_id int4 10
maps.map_id player_map_captimes_fk02 R
game_id int8 19
fastest_cap interval 49,6
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_map_captime_id Primary key Asc player_map_captimes_pk
player_id + map_id Must be unique Asc/Asc player_map_captimes_uk01

Close relationships  within of separation: