baseball_event_states

Properties
Property Value    Property Value
OID24881Total size56.0 KB
OwnerpostgresTable size8.0 KB
Tablespacepg_defaultIndexes size48.0 KB
Primary key(s)Toast size0 bytes
Estimated rows17
Comment
Statistics
Property Value    Property Value
seq_scan0n_dead_tup0
seq_tup_read0last_vacuum-
idx_scan0last_autovacuum-
idx_tup_fetch0last_analyze-
n_tup_ins0last_autoanalyze-
n_tup_upd0vacuum_count0
n_tup_del0autovacuum_count0
n_tup_hot_upd0analyze_count0
n_live_tup0autoanalyze_count0
Columns - 21
Name Type Length Default value Allow null Unique Comment
id integer nextval('baseball_event_states_id_seq'::regclass) false true
event_id integer false false
current_state smallint true false
sequence_number integer true false
at_bat_number integer true false
inning_value integer true false
inning_half character varying 100 true false
outs integer true false
balls integer true false
strikes integer true false
runner_on_first_id integer true false
runner_on_second_id integer true false
runner_on_third_id integer true false
runner_on_first smallint true false
runner_on_second smallint true false
runner_on_third smallint true false
runs_this_inning_half integer true false
pitcher_id integer true false
batter_id integer true false
batter_side character varying 100 true false
context character varying 40 true false
Indexes - 3
Name (scan, tup_read, tup_fetch) Primary Unique Clustered Size Definition
idx_baseball_event_states_1  (0, 0, 0) false false false 16.0 KB
btree (current_state)
idx_fk_bas_eve_sta_eve_id__eve_id  (0, 0, 0) false false false 16.0 KB
btree (event_id)
baseball_event_states_id_key  (0, 0, 0) false true false 16.0 KB
btree (id)
Unique constraints - 1
Name Columns Comment
baseball_event_states_id_key id
Foreign keys - 6
Name Keys Reference table Reference keys Match type Delete type Update type
fk_bas_eve_sta_run_on_fir_id__per_id runner_on_first_id persons id no action no action
fk_bas_eve_sta_bat_id__per_id batter_id persons id no action no action
fk_bas_eve_sta_run_on_thi_id__per_id runner_on_third_id persons id no action no action
fk_bas_eve_sta_run_on_sec_id__per_id runner_on_second_id persons id no action no action
fk_bas_eve_sta_eve_id__eve_id event_id events id no action no action
fk_bas_eve_sta_pit_id__per_id pitcher_id persons id no action no action