species

0 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_fkeyC
batches.species_id batches_species_id_fkeyR
species_ecosystem_types.species_id species_ecosystem_types_species_id_fkeyC
species_growth_forms.species_id species_growth_forms_species_id_fkeyC
species_plant_material_sourcing_methods.species_id species_plant_material_sourcing_methods_species_id_fkeyC
species_problems.species_id species_problems_species_id_fkeyC
species_successional_groups.species_id species_successional_groups_species_id_fkeyC
accessions.species_id accessions_species_id_fkeyR
observed_plot_species_totals.species_id observed_plot_species_totals_species_id_fkeyR
observed_site_species_totals.species_id observed_site_species_totals_species_id_fkeyR
observed_zone_species_totals.species_id observed_zone_species_totals_species_id_fkeyR
planting_site_populations.species_id planting_site_populations_species_id_fkeyC
planting_subzone_populations.species_id planting_subzone_populations_species_id_fkeyC
planting_zone_populations.species_id planting_zone_populations_species_id_fkeyC
plantings.species_id plantings_species_id_fkeyR
recorded_plants.species_id recorded_plants_species_id_fkeyR
organization_id int8 19 null
organizations.id species_organization_id_fkeyC
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
seed_storage_behaviors.id species_seed_storage_behavior_id_fkeyR
created_by int8 19 null
users.id species_created_by_fkeyR
created_time timestamptz 35,6 null
modified_by int8 19 null
users.id species_modified_by_fkeyR
modified_time timestamptz 35,6 null
deleted_by int8 19 √ null
users.id species_deleted_by_fkeyR
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_fkeyR
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 131089 √ null
height_at_maturity_value numeric 131089 √ null
dbh_value numeric 131089 √ null
wood_density_level_id int4 10 √ null
wood_density_levels.id species_wood_density_level_id_fkeyR

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