baseball_action_substitutions

Properties
Property Value    Property Value
OID24854Total size8.0 KB
OwnerpostgresTable size0 bytes
Tablespacepg_defaultIndexes size8.0 KB
Primary key(s)Toast size0 bytes
Estimated rows0
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 - 12
Name Type Length Default value Allow null Unique Comment
id integer nextval('baseball_action_substitutions_id_seq'::regclass) false true
baseball_event_state_id integer false false
sequence_number integer true false
person_type character varying 100 true false
person_original_id integer true false
person_original_position_id integer true false
person_original_lineup_slot integer true false
person_replacing_id integer true false
person_replacing_position_id integer true false
person_replacing_lineup_slot integer true false
substitution_reason character varying 100 true false
comment character varying 100 true false
Indexes - 1
Name (scan, tup_read, tup_fetch) Primary Unique Clustered Size Definition
baseball_action_substitutions_id_key  (0, 0, 0) false true false 8.0 KB
btree (id)
Unique constraints - 1
Name Columns Comment
baseball_action_substitutions_id_key id
Foreign keys - 5
Name Keys Reference table Reference keys Match type Delete type Update type
fk_bas_act_sub_per_rep_id__per_id person_replacing_id persons id no action no action
fk_bas_act_sub_per_rep_pos_id__pos_id person_replacing_position_id positions id no action no action
fk_bas_act_sub_per_ori_pos_id__pos_id person_original_position_id positions id no action no action
fk_bas_act_sub_per_ori_id__per_id person_original_id persons id no action no action
fk_bas_act_sub_bas_eve_sta_id__bas_eve_sta_id baseball_event_state_id baseball_event_states id no action no action