observations

-1 rows


Description

Scheduled observations of planting sites. This table may contain rows describing future observations as well as current and past ones.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
observation_biomass_details.observation_id observation_biomass_details_observation_id_fkey C
observation_biomass_quadrat_details.observation_id observation_biomass_quadrat_details_observation_id_fkey C
observation_biomass_quadrat_species.observation_id observation_biomass_quadrat_species_observation_id_fkey C
observation_biomass_species.observation_id observation_biomass_species_observation_id_fkey C
observation_media_files.observation_id observation_photos_observation_id_fkey R
observation_plot_conditions.observation_id observation_plot_conditions_observation_id_fkey C
observation_plots.observation_id observation_plots_observation_id_fkey C
observation_requested_subzones.observation_id observation_requested_subzones_observation_id_fkey C
observed_plot_coordinates.observation_id observed_plot_coordinates_observation_id_fkey C
observed_plot_species_totals.observation_id observed_plot_species_totals_observation_id_fkey C
observed_site_species_totals.observation_id observed_site_species_totals_observation_id_fkey C
observed_subzone_species_totals.observation_id observed_subzone_species_totals_observation_id_fkey C
observed_zone_species_totals.observation_id observed_zone_species_totals_observation_id_fkey C
plot_t0_observations.observation_id plot_t0_observations_observation_id_fkey C
recorded_plants.observation_id recorded_plants_observation_id_fkey C
recorded_trees.observation_id recorded_trees_observation_id_fkey C
planting_site_id int8 19 null
planting_sites.id observations_planting_site_id_fkey C
created_time timestamptz 35,6 null
start_date date 13 null

First day of the observation. This is either the first day of the month following the end of the planting season, or 6 months after that day.
end_date date 13 null

Last day of the observation. This is typically the last day of the same month as start_date.
completed_time timestamptz 35,6 √ null

Server-generated date and time the final piece of data for the observation was received.
state_id int4 10 null
observation_states.id observations_state_id_fkey R
upcoming_notification_sent_time timestamptz 35,6 √ null

When the notification that the observation is starting in 1 month was sent. Null if the notification has not been sent yet.
planting_site_history_id int8 19 √ null
planting_site_histories.id observations_planting_site_history_id_fkey C

Which version of the planting site map was used for the observation. Null for upcoming observations since monitoring plots are only placed on the map when an observation starts.
observation_type_id int4 10 null
observation_types.id observations_observation_type_id_fkey R
is_ad_hoc bool 1 null

Indexes

Constraint Name Type Sort Column(s)
observations_pkey Primary key Asc id
observations_planting_site_history_id_idx Performance Asc planting_site_history_id
observations_planting_site_id_idx Performance Asc planting_site_id

Check Constraints

Constraint Name Constraint
end_after_start (start_date <= end_date)
history_id_required_at_start (((state_id = 1) AND (planting_site_history_id IS NULL)) OR ((state_id <> 1) AND (planting_site_history_id IS NOT NULL)))
completed_time_and_state (((completed_time IS NULL) AND (state_id <> ALL (ARRAY[3, 5]))) OR ((completed_time IS NOT NULL) AND (state_id = ANY (ARRAY[3, 5]))))

Relationships

Close relationships within degrees of separation