observation_biomass_details

0 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_fkeyC
observation_biomass_species.observation_id observation_biomass_species_observation_id_monitoring_plot_fkeyC
observation_plots.observation_id observation_biomass_details_observation_id_monitoring_plot_fkeyR
observations.id observation_biomass_details_observation_id_fkeyC
monitoring_plot_id int8 19 null
observation_biomass_quadrat_details.monitoring_plot_id observation_biomass_quadrat_d_observation_id_monitoring_pl_fkeyC
observation_biomass_species.monitoring_plot_id observation_biomass_species_observation_id_monitoring_plot_fkeyC
observation_plots.monitoring_plot_id observation_biomass_details_observation_id_monitoring_plot_fkeyR
monitoring_plots.id observation_biomass_details_monitoring_plot_id_fkeyC
description text 2147483647 √ null
forest_type_id int4 10 null
biomass_forest_types.id observation_biomass_details_forest_type_id_fkeyR
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 131089 √ null

Salinity of water in parts per thousand (ppt). Must be non-null if forest type is “Mangrove”.
ph numeric 131089 √ 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_fkeyR

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
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))
observation_biomass_details_small_trees_count_low_check ((small_trees_count_low >= 0))
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_ph_check (((ph >= (0)::numeric) AND (ph <= (14)::numeric)))
observation_biomass_details_water_depth_cm_check (((water_depth_cm)::numeric >= (0)::numeric))

Relationships

Close relationships within degrees of separation