observation_biomass_species

-1 rows


Description

Herbaceous and tree species data for a biomass observation. Shared by all the monitoring plots in the observation.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
observation_biomass_additional_species.biomass_species_id observation_biomass_additional_species_biomass_species_id_fkey R
observation_biomass_quadrat_species.biomass_species_id observation_biomass_quadrat_species_biomass_species_id_fkey R
observed_plot_species_totals.biomass_species_id observed_plot_species_totals_biomass_species_id_observatio_fkey C
observed_site_species_totals.biomass_species_id observed_site_species_totals_biomass_species_id_observatio_fkey C
observed_stratum_species_totals.biomass_species_id observed_stratum_species_tota_biomass_species_id_observati_fkey C
observed_substratum_species_totals.biomass_species_id observed_substratum_species_t_biomass_species_id_observati_fkey C
recorded_trees.biomass_species_id recorded_trees_observation_id_biomass_species_id_fkey R
observation_id int8 19 null
observation_biomass_additional_species.observation_id observation_biomass_additiona_observation_id_biomass_speci_fkey R
observation_biomass_quadrat_species.observation_id observation_biomass_quadrat_s_observation_id_biomass_speci_fkey R
observed_plot_species_totals.observation_id observed_plot_species_totals_biomass_species_id_observatio_fkey C
observed_site_species_totals.observation_id observed_site_species_totals_biomass_species_id_observatio_fkey C
observed_stratum_species_totals.observation_id observed_stratum_species_tota_biomass_species_id_observati_fkey C
observed_substratum_species_totals.observation_id observed_substratum_species_t_biomass_species_id_observati_fkey C
recorded_trees.observation_id recorded_trees_observation_id_biomass_species_id_fkey R
observations.id observation_biomass_species_observation_id_fkey C
species_id int8 19 √ null
species.id observation_biomass_species_species_id_fkey R

The ID of the plant’s species, if known.

scientific_name text 2147483647 √ null

The user-supplied scientific name of the plant’s species. Must be provided if ID is null. Null if ID is known.

common_name text 2147483647 √ null

The user-supplied common name of the plant’s species. Null if ID is known.

is_invasive bool 1 null
is_threatened bool 1 null

Indexes

Constraint Name Type Sort Column(s)
observation_biomass_species_pkey Primary key Asc id
observation_biomass_species_id_observation_id_key Must be unique Asc/Asc id + observation_id
observation_biomass_species_observation_id_idx Performance Asc observation_id
observation_biomass_species_observation_id_scientific_name_idx Must be unique Asc/Asc observation_id + scientific_name
observation_biomass_species_observation_id_species_id_idx Must be unique Asc/Asc observation_id + species_id

Check Constraints

Constraint Name Constraint
species_identifier (((species_id IS NOT NULL) AND (scientific_name IS NULL)) OR ((species_id IS NULL) AND (scientific_name IS NOT NULL)))

Relationships