SchemaSpy - Table xonstatdb.xonstat.player_map

Generated by
SchemaSpy

Legend:

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

√

nextval('player_map_captimes_player_map_captime_id_seq'::regclass)

player_id

int4

players.player_id

player_map_captimes_fk01 R

map_id

int4

maps.map_id

player_map_captimes_fk02 R

game_id

int8

fastest_cap

interval

49,6

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_map_captime_id	Primary key	Asc	player_map_captimes_pk
player_id + map_id	Must be unique	Asc/Asc	player_map_captimes_uk01