affiliation_phases

Properties
Property Value    Property Value
OID24701Total size24.0 KB
OwnerpostgresTable size8.0 KB
Tablespacepg_defaultIndexes size16.0 KB
Primary key(s)Toast size0 bytes
Estimated rows55
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 - 7
Name Type Length Default value Allow null Unique Comment
id integer nextval('affiliation_phases_id_seq'::regclass) false true Unique identifier
affiliation_id integer false false Immediate affiliate.
ancestor_affiliation_id integer true false Main affiliate.
start_season_id integer true false
start_date_time timestamp without time zone true false
end_season_id integer true false
end_date_time timestamp without time zone true false
Indexes - 1
Name (scan, tup_read, tup_fetch) Primary Unique Clustered Size Definition
affiliation_phases_id_key  (0, 0, 0) false true false 16.0 KB
btree (id)
Unique constraints - 1
Name Columns Comment
affiliation_phases_id_key id
Foreign keys - 4
Name Keys Reference table Reference keys Match type Delete type Update type
fk_seasons_affiliation_phases1 end_season_id seasons id no action no action
fk_affiliations_affiliation_phases affiliation_id affiliations id no action no action
fk_affiliations_affiliation_phases1 ancestor_affiliation_id affiliations id no action no action
fk_seasons_affiliation_phases start_season_id seasons id no action no action