Help
|
Portal
|
Español
English
The human knowledge database
Free search
By text
Guided
Frequent searches
SQL
Views
Library
Privacy & Cookies
We request your permission to obtain statistical data of your navigation in this web.
If you continue browsing we consider that you accept the use of cookies.
Review Cookies Policy
Accept
table taxonomy_species
General information
Table:
taxonomy_species
Description:
species (taxonomy)
Type:
Master
Rows:
248,212
columns:
17
Data:
3,614,141
columns
field
description
Type
Unit
associated date
foreign table
id
Unique identifier
Integer
common_name
common name
Text
name
name
Text
date_start
data start
Text
rank
rank
Text
common_name
Common name
Text
image
image
Text
id_parent
parent
foreign key
genus (taxonomy)
id_Author
Author
foreign key
person
id_conservation_status
conservation status
foreign key
Conservation status
id_empire
empire
foreign key
empire (taxonomy)
id_kingdom
kingdom
foreign key
kingdom (taxonomy)
id_phylum
phylum
foreign key
phylum (taxonomy)
id_Class
Class
foreign key
class (taxonomy)
id_order
order
foreign key
order (taxonomy)
id_family
family
foreign key
family (taxonomy)
id_genus
genus
foreign key
genus (taxonomy)
Relations
description
related table
relationship table
forest/species
forest
forest_Species
taxonomy_genus
cultivar/hybrid parentage
cultivar
cultivar_hybrid_parentage
Table in which FK is located
table
field
cultivar/hybrid parentage
id_taxonomy
forest/species
id_species