taxa

39096 rows


Description

This table lists all taxa in the database. Most taxa are biological taxa; however, some are biometric measures and some are physical parameters.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
taxonid serial 10 nextval('ndb.seq_taxa_taxonid'::regclass)
datasettaxonnotes.taxonid fk_datasettaxonnotes_taxaC
ecolgroups.taxonid fk_ecolgroups_taxaC
externaltaxa.taxonid fk_externaltaxa_taxaC
formtaxa.affinityid fk_formtaxa_taxa1C
formtaxa.taxonid fk_formtaxa_taxaR
isostratdata.taxonid fk_isostratdata_taxaR
samples.taxonid fk_samples_taxaR
specimendates.taxonid sd_txidR
synonyms.invalidtaxonid fk_synonyms_invalidtaxaC
synonyms.validtaxonid fk_synonyms_validtaxaR
synonymy.reftaxonid fk_synonymy_taxa2R
synonymy.taxonid fk_synonymy_taxa1C
taxa.highertaxonid fk_highertaxonidR
taxaalthierarchy.highertaxonid fk_taxaalthierarchy_taxa1R
taxaalthierarchy.taxonid fk_taxaalthierarchy_taxaC
taxonpaths.taxonid taxonpaths_taxonid_fkeyR
variables.taxonid fk_variables_taxaC
taxoncode varchar 64 null

Taxon code

taxonname varchar 80 null
author varchar 128 null
valid bool 1 null
highertaxonid int4 10 null
taxa.taxonid fk_highertaxonidR
extinct bool 1 null
taxagroupid varchar 3 null
taxagrouptypes.taxagroupid fk_taxagroupidR
publicationid int4 10 null
publications.publicationid fk_publicationidR
validatorid int4 10 null
contacts.contactid fk_validatoridR
validatedate date 13 null
notes text 2147483647 null
recdatecreated timestamp 22 timezone('UTC'::text, now())
recdatemodified timestamp 22 null

Indexes

Constraint Name Type Sort Column(s)
taxa_pkey Primary key Asc taxonid
ix_taxagroupid_taxa Performance Asc taxagroupid
ix_taxonname_taxa Performance Asc taxonname
taxonames_idx Performance Asc taxonname
taxonname_btree Performance Asc taxonname

Relationships