american_football_action_participants

Properties
Property Value    Property Value
OID24722Total size120.0 KB
OwnerpostgresTable size40.0 KB
Tablespacepg_defaultIndexes size80.0 KB
Primary key(s)Toast size0 bytes
Estimated rows213
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 - 9
Name Type Length Default value Allow null Unique Comment
id integer nextval('american_football_action_participants_id_seq'::regclass) false true
american_football_action_play_id integer false false
person_id integer false false
participant_role character varying 100 false false
score_type character varying 100 true false
field_line integer true false
yardage integer true false
score_credit integer true false
yards_gained integer true false
Indexes - 5
Name (scan, tup_read, tup_fetch) Primary Unique Clustered Size Definition
idx_fk_ame_foo_act_par_ame_foo_act_pla_id__ame_foo_act_pla_id  (0, 0, 0) false false false 16.0 KB
btree (american_football_action_play_id)
american_football_action_participants_id_key  (0, 0, 0) false true false 16.0 KB
btree (id)
idx_american_football_action_participants_1  (0, 0, 0) false false false 16.0 KB
btree (participant_role)
idx_american_football_action_participants_2  (0, 0, 0) false false false 16.0 KB
btree (score_type)
idx_fk_ame_foo_act_par_per_id__per_id  (0, 0, 0) false false false 16.0 KB
btree (person_id)
Unique constraints - 1
Name Columns Comment
american_football_action_participants_id_key id
Foreign keys - 2
Name Keys Reference table Reference keys Match type Delete type Update type
fk_ame_foo_act_par_ame_foo_act_pla_id__ame_foo_act_pla_id american_football_action_play_id american_football_action_plays id no action no action
fk_ame_foo_act_par_per_id__per_id person_id persons id no action no action