192.168.1.112

sportsdb

public

Tables

soccer_offensive_stats

soccer_offensive_stats

Properties

Property	Value		Property	Value
OID	25278		Total size	16.0 KB
Owner	postgres		Table size	0 bytes
Tablespace	pg_default		Indexes size	8.0 KB
Primary key(s)			Toast size	8.0 KB
Estimated rows	0
Comment

Statistics

Property	Value		Property	Value
seq_scan	0		n_dead_tup	0
seq_tup_read	0		last_vacuum	-
idx_scan	0		last_autovacuum	-
idx_tup_fetch	0		last_analyze	-
n_tup_ins	0		last_autoanalyze	-
n_tup_upd	0		vacuum_count	0
n_tup_del	0		autovacuum_count	0
n_tup_hot_upd	0		analyze_count	0
n_live_tup	0		autoanalyze_count	0

Columns - 26

Name	Type	Length	Default value	Allow null	Unique	Comment
id	integer		nextval('soccer_offensive_stats_id_seq'::regclass)	false	true
goals_game_winning	character varying	100		true	false
goals_game_tying	character varying	100		true	false
goals_overtime	character varying	100		true	false
goals_shootout	character varying	100		true	false
goals_total	character varying	100		true	false
assists_game_winning	character varying	100		true	false
assists_game_tying	character varying	100		true	false
assists_overtime	character varying	100		true	false
assists_total	character varying	100		true	false
points	character varying	100		true	false
shots_total	character varying	100		true	false
shots_on_goal_total	character varying	100		true	false
shots_hit_frame	character varying	100		true	false
shots_penalty_shot_taken	character varying	100		true	false
shots_penalty_shot_scored	character varying	100		true	false
shots_penalty_shot_missed	character varying	40		true	false
shots_penalty_shot_percentage	character varying	40		true	false
shots_shootout_taken	character varying	40		true	false
shots_shootout_scored	character varying	40		true	false
shots_shootout_missed	character varying	40		true	false
shots_shootout_percentage	character varying	40		true	false
giveaways	character varying	40		true	false
offsides	character varying	40		true	false
corner_kicks	character varying	40		true	false
hat_tricks	character varying	40		true	false

Indexes - 1

Name (scan, tup_read, tup_fetch)	Primary	Unique	Clustered	Size	Definition
soccer_offensive_stats_id_key (0, 0, 0)	false	true	false	8.0 KB	btree (id)

Unique constraints - 1

Name	Columns	Comment
soccer_offensive_stats_id_key	id