planting_subzone_histories

0 rows


Description

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

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 null
planting_zone_history_id int8 19 null
planting_zone_histories.id planting_subzone_histories_planting_zone_history_id_fkeyC
planting_subzone_id int8 19 √ null
planting_subzones.id planting_subzone_histories_planting_subzone_id_fkeyN
name text 2147483647 null
full_name text 2147483647 null
boundary geometry 2147483647 null

Indexes

Constraint Name Type Sort Column(s)
planting_subzone_histories_pkey Primary key Asc id
planting_subzone_histories_planting_subzone_id_idx Performance Asc planting_subzone_id
planting_subzone_histories_planting_zone_history_id_idx Performance Asc planting_zone_history_id

Relationships

Close relationships within degrees of separation