taxon

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
frontend_draftspeciesupload.taxon_id frontend_draftspeciesupload_taxon_id_1a354749_fk_taxon_idR
frontend_statisticalmodel.taxon_id frontend_statisticalmodel_taxon_id_6b219d54_fk_taxon_idR
owned_species.taxon_id owned_species_taxon_id_7f71855b_fk_taxon_idR
species_taxonsurveymethod.taxon_id species_taxonsurveymethod_taxon_id_11dc866f_fk_taxon_idR
taxon.parent_id taxon_parent_id_4645e052_fk_taxon_idR
scientific_name varchar 250 null
common_name_varbatim varchar 250 √ null
colour_variant bool 1 √ null
infraspecific_epithet varchar 250 √ null
parent_id int8 19 √ null
taxon.id taxon_parent_id_4645e052_fk_taxon_idR
taxon_rank_id int8 19 √ null
taxon_rank.id taxon_taxon_rank_id_5c9c4c40_fk_taxon_rank_idR
colour varchar 20 √ null
front_page_order int4 10 null
is_selected bool 1 null
show_on_front_page bool 1 null
icon varchar 100 √ null
graph_icon varchar 100 √ null

Indexes

Constraint Name Type Sort Column(s)
taxon_pkey Primary key Asc id
taxon_infraspecific_epithet_9bd15358_like Performance Asc infraspecific_epithet
taxon_infraspecific_epithet_key Must be unique Asc infraspecific_epithet
taxon_parent_id_4645e052 Performance Asc parent_id
taxon_scientific_name_791e8bcf_like Performance Asc scientific_name
taxon_scientific_name_key Must be unique Asc scientific_name
taxon_taxon_rank_id_5c9c4c40 Performance Asc taxon_rank_id

Check Constraints

Constraint Name Constraint
taxon_front_page_order_check ((front_page_order >= 0))

Relationships

Close relationships within degrees of separation