observation_plots

0 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_photos.observation_id observation_photos_observation_id_monitoring_plot_id_fkeyR
observed_plot_coordinates.observation_id observed_plot_coordinates_observation_id_monitoring_plot_i_fkeyR
recorded_plants.observation_id recorded_plants_observation_id_monitoring_plot_id_fkeyC
observations.id observation_plots_observation_id_fkeyC
monitoring_plot_id int8 19 null
observation_photos.monitoring_plot_id observation_photos_observation_id_monitoring_plot_id_fkeyR
observed_plot_coordinates.monitoring_plot_id observed_plot_coordinates_observation_id_monitoring_plot_i_fkeyR
recorded_plants.monitoring_plot_id recorded_plants_observation_id_monitoring_plot_id_fkeyC
monitoring_plots.id observation_plots_monitoring_plot_id_fkeyC
claimed_by int8 19 √ null
users.id observation_plots_claimed_by_fkeyR
claimed_time timestamptz 35,6 √ null
completed_by int8 19 √ null
users.id observation_plots_completed_by_fkeyR
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_fkeyR
created_time timestamptz 35,6 null
is_permanent bool 1 null

If true, this plot was selected for observation as part of a permanent monitoring plot cluster. If false, this plot was selected as a temporary monitoring plot.
modified_by int8 19 null
users.id observation_plots_modified_by_fkeyR
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_fkeyR
monitoring_plot_history_id int8 19 null
monitoring_plot_histories.id observation_plots_monitoring_plot_history_id_fkeyC

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