monitoring_plot_histories

-1 rows


Description

Versions of monitoring plots over time. Each time a planting site changes, its monitoring plots are added to this table.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
observation_plots.monitoring_plot_history_id observation_plots_monitoring_plot_history_id_fkey C
monitoring_plot_id int8 19 null
monitoring_plots.id monitoring_plot_histories_monitoring_plot_id_fkey C
planting_subzone_id int8 19 √ null
planting_subzones.id monitoring_plot_histories_planting_subzone_id_fkey N
planting_site_id int8 19 null
planting_sites.id monitoring_plot_histories_planting_site_id_fkey C
planting_subzone_history_id int8 19 √ null
planting_subzone_histories.id monitoring_plot_histories_planting_subzone_history_id_fkey C
planting_site_history_id int8 19 null
planting_site_histories.id monitoring_plot_histories_planting_site_history_id_fkey C
created_by int8 19 null
users.id monitoring_plot_histories_created_by_fkey R

Which user created or edited the monitoring plot or its planting site.
created_time timestamptz 35,6 null

When the monitoring plot was created, edited, or associated with a new planting site history record. May differ from the time when the subzone or planting site was created or edited since plots can be created when observations start.

Indexes

Constraint Name Type Sort Column(s)
monitoring_plot_histories_pkey Primary key Asc id
monitoring_plot_histories_created_by_idx Performance Asc created_by
monitoring_plot_histories_monitoring_plot_id_idx Performance Asc monitoring_plot_id
monitoring_plot_histories_planting_site_history_id_idx Performance Asc planting_site_history_id
monitoring_plot_histories_planting_site_id_idx Performance Asc planting_site_id
monitoring_plot_histories_planting_subzone_history_id_idx Performance Asc planting_subzone_history_id
monitoring_plot_histories_planting_subzone_id_idx Performance Asc planting_subzone_id

Relationships

Close relationships within degrees of separation