planting_zone_histories

-1 rows


Description

Versions of planting zone maps over time. Each time a planting site map changes, its zones’ maps are inserted into this table.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
planting_subzone_histories.planting_zone_history_id planting_subzone_histories_planting_zone_history_id_fkey C
planting_site_history_id int8 19 null
planting_site_histories.id planting_zone_histories_planting_site_history_id_fkey C
planting_zone_id int8 19 √ null
planting_zones.id planting_zone_histories_planting_zone_id_fkey N
name text 2147483647 null
boundary geometry 2147483647 null
area_ha numeric 0 √ null
stable_id text 2147483647 null

Indexes

Constraint Name Type Sort Column(s)
planting_zone_histories_pkey Primary key Asc id
planting_zone_histories_planting_site_history_id_idx Performance Asc planting_site_history_id
planting_zone_histories_planting_zone_id_idx Performance Asc planting_zone_id

Relationships

Close relationships within degrees of separation