american_football_event_states

american_football_event_states

Properties

Property	Value		Property	Value
OID	24755		Total size	88.0 KB
Owner	postgres		Table size	40.0 KB
Tablespace	pg_default		Indexes size	48.0 KB
Primary key(s)			Toast size	0 bytes
Estimated rows	193
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 - 14

Name	Type	Length	Default value	Allow null	Unique	Comment
id	integer		nextval('american_football_event_states_id_seq'::regclass)	false	true
event_id	integer			false	false
current_state	smallint			true	false
sequence_number	integer			true	false
period_value	integer			true	false
period_time_elapsed	character varying	100		true	false
period_time_remaining	character varying	100		true	false
clock_state	character varying	100		true	false
down	integer			true	false
team_in_possession_id	integer			true	false
distance_for_1st_down	integer			true	false
field_side	character varying	100		true	false
field_line	integer			true	false
context	character varying	40		true	false

Indexes - 3

Name (scan, tup_read, tup_fetch)	Primary	Unique	Clustered	Size	Definition
american_football_event_states_id_key (0, 0, 0)	false	true	false	16.0 KB	btree (id)
idx_american_football_event_states_1 (0, 0, 0)	false	false	false	16.0 KB	btree (current_state)
idx_fk_ame_foo_eve_sta_eve_id__eve_id (0, 0, 0)	false	false	false	16.0 KB	btree (event_id)

Unique constraints - 1

Name	Columns	Comment
american_football_event_states_id_key	id

Foreign keys - 2

Name	Keys	Reference table	Reference keys	Match type	Delete type	Update type
fk_ame_foo_eve_sta_tea_in_pos_id__tea_id	team_in_possession_id	teams	id		no action	no action
fk_ame_foo_eve_sta_eve_id__eve_id	event_id	events	id		no action	no action