outcome_totals

Properties
Property Value    Property Value
OID25176Total size16.0 KB
OwnerpostgresTable size0 bytes
Tablespacepg_defaultIndexes size8.0 KB
Primary key(s)Toast size8.0 KB
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 - 19
Name Type Length Default value Allow null Unique Comment
id integer nextval('outcome_totals_id_seq'::regclass) false true
standing_subgroup_id integer false false
outcome_holder_type character varying 100 true false
outcome_holder_id integer true false
rank character varying 100 true false
wins character varying 100 true false
losses character varying 100 true false
ties character varying 100 true false
undecideds character varying 100 true false
winning_percentage character varying 100 true false
points_scored_for character varying 100 true false
points_scored_against character varying 100 true false
points_difference character varying 100 true false
standing_points character varying 100 true false
streak_type character varying 100 true false
streak_duration character varying 100 true false
streak_total character varying 100 true false
streak_start date true false
streak_end date true false
Indexes - 1
Name (scan, tup_read, tup_fetch) Primary Unique Clustered Size Definition
outcome_totals_id_key  (0, 0, 0) false true false 8.0 KB
btree (id)
Unique constraints - 1
Name Columns Comment
outcome_totals_id_key id
Foreign keys - 1
Name Keys Reference table Reference keys Match type Delete type Update type
fk_out_tot_sta_sub_id__sta_sub_id standing_subgroup_id standing_subgroups id no action no action