planting_site_histories

0 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_fkeyC
observations.planting_site_history_id observations_planting_site_history_id_fkeyC
planting_zone_histories.planting_site_history_id planting_zone_histories_planting_site_history_id_fkeyC
planting_site_id int8 19 null
planting_sites.id planting_site_histories_planting_site_id_fkeyC
created_by int8 19 null
users.id planting_site_histories_created_by_fkeyR
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

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