observation_plots

-1 rows


Description

Information about monitoring plots that are required to be surveyed as part of observations. This is not populated until the scheduled start time of the observation.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
observation_id int8 19 null
observation_biomass_details.observation_id observation_biomass_details_observation_id_monitoring_plot_fkey R
observation_media_files.observation_id observation_photos_observation_id_monitoring_plot_id_fkey R
observed_plot_coordinates.observation_id observed_plot_coordinates_observation_id_monitoring_plot_i_fkey R
plot_t0_observations.observation_id plot_t0_observations_observation_id_monitoring_plot_id_fkey C
recorded_plants.observation_id recorded_plants_observation_id_monitoring_plot_id_fkey C
observations.id observation_plots_observation_id_fkey C
monitoring_plot_id int8 19 null
observation_biomass_details.monitoring_plot_id observation_biomass_details_observation_id_monitoring_plot_fkey R
observation_media_files.monitoring_plot_id observation_photos_observation_id_monitoring_plot_id_fkey R
observed_plot_coordinates.monitoring_plot_id observed_plot_coordinates_observation_id_monitoring_plot_i_fkey R
plot_t0_observations.monitoring_plot_id plot_t0_observations_observation_id_monitoring_plot_id_fkey C
recorded_plants.monitoring_plot_id recorded_plants_observation_id_monitoring_plot_id_fkey C
monitoring_plots.id observation_plots_monitoring_plot_id_fkey C
claimed_by int8 19 √ null
users.id observation_plots_claimed_by_fkey R
claimed_time timestamptz 35,6 √ null
completed_by int8 19 √ null
users.id observation_plots_completed_by_fkey R
completed_time timestamptz 35,6 √ null

Server-generated completion date and time. This is the time the observation was submitted to the server, not the time it was performed in the field.
created_by int8 19 null
users.id observation_plots_created_by_fkey R
created_time timestamptz 35,6 null
is_permanent bool 1 null

If true, this plot was selected for observation as a permanent monitoring plot. If false, this plot was selected as a temporary monitoring plot.
modified_by int8 19 null
users.id observation_plots_modified_by_fkey R
modified_time timestamptz 35,6 √ null
observed_time timestamptz 35,6 √ null

Client-supplied observation date and time. This is the time the observation was performed in the field, not the time it was submitted to the server.
notes text 2147483647 √ null
status_id int4 10 null
observation_plot_statuses.id observation_plots_status_id_fkey R
monitoring_plot_history_id int8 19 null
monitoring_plot_histories.id observation_plots_monitoring_plot_history_id_fkey C

Indexes

Constraint Name Type Sort Column(s)
observation_plots_pkey Primary key Asc/Asc observation_id + monitoring_plot_id
observation_plots_monitoring_plot_history_id_idx Performance Asc monitoring_plot_history_id
observation_plots_monitoring_plot_id_idx Performance Asc monitoring_plot_id

Check Constraints

Constraint Name Constraint
cannot_unclaim_completed_plot ((completed_by IS NULL) OR ((completed_by IS NOT NULL) AND (claimed_by IS NOT NULL)))

Relationships

Close relationships within degrees of separation