observation_biomass_quadrat_species

-1 rows


Description

Herbaceous species at each quadrat of a monitoring plot of a biomass observation

Columns

Column Type Size Nulls Auto Default Children Parents Comments
observation_id int8 19 null
observation_biomass_quadrat_details.observation_id quadrat_species_requires_quadrat_details C
observations.id observation_biomass_quadrat_species_observation_id_fkey C
observation_biomass_species.observation_id observation_biomass_quadrat_s_observation_id_monitoring_pl_fkey C
monitoring_plot_id int8 19 null
observation_biomass_quadrat_details.monitoring_plot_id quadrat_species_requires_quadrat_details C
observation_biomass_species.monitoring_plot_id observation_biomass_quadrat_s_observation_id_monitoring_pl_fkey C
monitoring_plots.id observation_biomass_quadrat_species_monitoring_plot_id_fkey C
position_id int4 10 null
observation_plot_positions.id observation_biomass_quadrat_species_position_id_fkey R
observation_biomass_quadrat_details.position_id quadrat_species_requires_quadrat_details C
biomass_species_id int8 19 null
observation_biomass_species.id observation_biomass_quadrat_species_biomass_species_id_fkey C
abundance_percent int4 10 null

Indexes

Constraint Name Type Sort Column(s)
observation_biomass_quadrat_species_pkey Primary key Asc/Asc/Asc/Asc observation_id + monitoring_plot_id + position_id + biomass_species_id
observation_biomass_quadrat_species_monitoring_plot_id_idx Performance Asc monitoring_plot_id

Check Constraints

Constraint Name Constraint
observation_biomass_quadrat_species_abundance_percent_check ((abundance_percent >= 0) AND (abundance_percent <= 100))

Relationships

Close relationships within degrees of separation