observation_biomass_details

-1 rows


Description

Recorded data for a biomass observation.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
observation_id int8 19 null
observation_biomass_quadrat_details.observation_id observation_biomass_quadrat_d_observation_id_monitoring_pl_fkey C
observation_biomass_species.observation_id observation_biomass_species_observation_id_monitoring_plot_fkey C
observation_plots.observation_id observation_biomass_details_observation_id_monitoring_plot_fkey R
observations.id observation_biomass_details_observation_id_fkey C
monitoring_plot_id int8 19 null
observation_biomass_quadrat_details.monitoring_plot_id observation_biomass_quadrat_d_observation_id_monitoring_pl_fkey C
observation_biomass_species.monitoring_plot_id observation_biomass_species_observation_id_monitoring_plot_fkey C
monitoring_plots.id observation_biomass_details_monitoring_plot_id_fkey C
observation_plots.monitoring_plot_id observation_biomass_details_observation_id_monitoring_plot_fkey R
description varchar 50 √ null
forest_type_id int4 10 null
biomass_forest_types.id observation_biomass_details_forest_type_id_fkey R
small_trees_count_low int4 10 null
small_trees_count_high int4 10 null
herbaceous_cover_percent int4 10 null
soil_assessment text 2147483647 null
water_depth_cm int4 10 √ null

Depth of water in centimeters (cm). Must be non-null if forest type is “Mangrove”.
salinity_ppt numeric 0 √ null

Salinity of water in parts per thousand (ppt). Must be non-null if forest type is “Mangrove”.
ph numeric 0 √ null

Acidity of water in pH. Must only exists if forest type is “Mangrove”.
tide_id int4 10 √ null
mangrove_tides.id observation_biomass_details_tide_id_fkey R

High/low tide during observation. Must be non-null if forest type is “Mangrove”.
tide_time timestamptz 35,6 √ null

Time when the tide is recorded. Must be non-null if forest type is “Mangrove”.

Indexes

Constraint Name Type Sort Column(s)
observation_biomass_details_pkey Primary key Asc/Asc observation_id + monitoring_plot_id
observation_biomass_details_monitoring_plot_id_idx Performance Asc monitoring_plot_id

Check Constraints

Constraint Name Constraint
mangrove_required_values (((forest_type_id = 1) AND (water_depth_cm IS NULL) AND (salinity_ppt IS NULL) AND (ph IS NULL) AND (tide_id IS NULL) AND (tide_time IS NULL)) OR ((forest_type_id = 2) AND (water_depth_cm IS NOT NULL) AND (salinity_ppt IS NOT NULL) AND (ph IS NOT NULL) AND (tide_id IS NOT NULL) AND (tide_time IS NOT NULL)))
observation_biomass_details_check (small_trees_count_low <= small_trees_count_high)
observation_biomass_details_water_depth_cm_check ((water_depth_cm)::numeric >= (0)::numeric)
observation_biomass_details_small_trees_count_low_check (small_trees_count_low >= 0)
observation_biomass_details_ph_check ((ph >= (0)::numeric) AND (ph <= (14)::numeric))
observation_biomass_details_herbaceous_cover_percent_check (((herbaceous_cover_percent)::numeric >= (0)::numeric) AND ((herbaceous_cover_percent)::numeric <= (100)::numeric))
observation_biomass_details_salinity_ppt_check (salinity_ppt >= (0)::numeric)

Relationships

Close relationships within degrees of separation