observation_biomass_quadrat_species

0 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
observations.id observation_biomass_quadrat_species_observation_id_fkeyC
observation_biomass_species.observation_id observation_biomass_quadrat_s_observation_id_monitoring_pl_fkeyC
monitoring_plot_id int8 19 null
observation_biomass_species.monitoring_plot_id observation_biomass_quadrat_s_observation_id_monitoring_pl_fkeyC
monitoring_plots.id observation_biomass_quadrat_species_monitoring_plot_id_fkeyC
position_id int4 10 null
observation_plot_positions.id observation_biomass_quadrat_species_position_id_fkeyR
biomass_species_id int8 19 null
observation_biomass_species.id observation_biomass_quadrat_species_biomass_species_id_fkeyC
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