species

-1 rows


Description

Per-organization information about species.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
participant_project_species.species_id participant_project_species_species_id_fkey C
batches.species_id batches_species_id_fkey R
species_ecosystem_types.species_id species_ecosystem_types_species_id_fkey C
species_growth_forms.species_id species_growth_forms_species_id_fkey C
species_plant_material_sourcing_methods.species_id species_plant_material_sourcing_methods_species_id_fkey C
species_problems.species_id species_problems_species_id_fkey C
species_successional_groups.species_id species_successional_groups_species_id_fkey C
accessions.species_id accessions_species_id_fkey R
observation_biomass_species.species_id observation_biomass_species_species_id_fkey R
observed_plot_species_totals.species_id observed_plot_species_totals_species_id_fkey R
observed_site_species_totals.species_id observed_site_species_totals_species_id_fkey R
observed_subzone_species_totals.species_id observed_subzone_species_totals_species_id_fkey R
observed_zone_species_totals.species_id observed_zone_species_totals_species_id_fkey R
planting_site_populations.species_id planting_site_populations_species_id_fkey C
planting_subzone_populations.species_id planting_subzone_populations_species_id_fkey C
planting_zone_populations.species_id planting_zone_populations_species_id_fkey C
plantings.species_id plantings_species_id_fkey R
recorded_plants.species_id recorded_plants_species_id_fkey R
organization_id int8 19 null
organizations.id species_organization_id_fkey C
scientific_name text 2147483647 null
common_name text 2147483647 √ null
family_name text 2147483647 √ null
rare bool 1 √ null
seed_storage_behavior_id int4 10 √ null
created_by int8 19 null
created_time timestamptz 35,6 null
modified_by int8 19 null
modified_time timestamptz 35,6 null
deleted_by int8 19 √ null
deleted_time timestamptz 35,6 √ null
checked_time timestamptz 35,6 √ null

If non-null, when the species was checked for possible suggested edits. If null, the species has not been checked yet.
initial_scientific_name text 2147483647 null
conservation_category_id text 2147483647 √ null
conservation_categories.id species_conservation_category_id_fkey R
ecological_role_known text 2147483647 √ null
dbh_source text 2147483647 √ null
height_at_maturity_source text 2147483647 √ null
local_uses_known text 2147483647 √ null
native_ecosystem text 2147483647 √ null
other_facts text 2147483647 √ null
average_wood_density numeric 0 √ null
height_at_maturity_value numeric 0 √ null
dbh_value numeric 0 √ null
wood_density_level_id int4 10 √ null
wood_density_levels.id species_wood_density_level_id_fkey R

Indexes

Constraint Name Type Sort Column(s)
species_pkey1 Primary key Asc id
species__not_checked_ix Performance Asc id
species_organization_id_initial_scientific_name_idx Performance Asc/Asc organization_id + initial_scientific_name
species_organization_id_scientific_name_key Must be unique Asc/Asc organization_id + scientific_name

Check Constraints

Constraint Name Constraint
species_common_name_check (common_name !~ similar_to_escape(' *'::text))
species_family_name_check (family_name !~ similar_to_escape(' *'::text))

Relationships

Close relationships within degrees of separation