weather_conditions

Properties
Property Value    Property Value
OID25434Total size24.0 KB
OwnerpostgresTable size0 bytes
Tablespacepg_defaultIndexes size16.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 - 9
Name Type Length Default value Allow null Unique Comment
id integer nextval('weather_conditions_id_seq'::regclass) false true
event_id integer false false
temperature character varying 100 true false
temperature_units character varying 40 true false
humidity character varying 100 true false
clouds character varying 100 true false
wind_direction character varying 100 true false
wind_velocity character varying 100 true false
weather_code character varying 100 true false
Indexes - 2
Name (scan, tup_read, tup_fetch) Primary Unique Clustered Size Definition
weather_conditions_id_key  (0, 0, 0) false true false 8.0 KB
btree (id)
idx_fk_wea_con_eve_id__eve_id  (0, 0, 0) false false false 8.0 KB
btree (event_id)
Unique constraints - 1
Name Columns Comment
weather_conditions_id_key id
Foreign keys - 1
Name Keys Reference table Reference keys Match type Delete type Update type
fk_wea_con_eve_id__eve_id event_id events id no action no action