planting_site_histories

-1 rows


Description

Versions of planting site maps over time. Each time a planting site map changes, the new map is inserted into this table and its child tables.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
monitoring_plot_histories.planting_site_history_id monitoring_plot_histories_planting_site_history_id_fkey C
observations.planting_site_history_id observations_planting_site_history_id_fkey C
planting_zone_histories.planting_site_history_id planting_zone_histories_planting_site_history_id_fkey C
planting_site_id int8 19 null
planting_sites.id planting_site_histories_planting_site_id_fkey C
created_by int8 19 null
users.id planting_site_histories_created_by_fkey R
created_time timestamptz 35,6 null

When the site map was created or updated. You can determine which map was active for a site at a particular time by looking for the maximum created_time less than or equal to the time in question.
boundary geometry 2147483647 null
grid_origin geometry 2147483647 √ null
exclusion geometry 2147483647 √ null
area_ha numeric 0 √ null

Indexes

Constraint Name Type Sort Column(s)
planting_site_histories_pkey Primary key Asc id
planting_site_histories_planting_site_id_idx Performance Asc planting_site_id

Relationships

Close relationships within degrees of separation