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
substratum_id int8 19 √ null
substrata.id monitoring_plot_histories_substratum_id_fkey N
planting_site_id int8 19 null
planting_sites.id monitoring_plot_histories_planting_site_id_fkey C
substratum_history_id int8 19 √ null
substratum_histories.id monitoring_plot_histories_substratum_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 substratum 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_substratum_history_id_idx Performance Asc substratum_history_id
monitoring_plot_histories_substratum_id_idx Performance Asc substratum_id

Relationships

Close relationships within degrees of separation