externaltaxa

3333 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
taxonid int4 10 null
taxa.taxonid fk_externaltaxa_taxaC
extdatabaseid int4 10 null
externaldatabases.extdatabaseid fk_externaltaxa_externaldatabasesC
exttaxonid varchar 64 null
url varchar 128 null
recdatecreated timestamp 22 timezone('UTC'::text, now())
recdatemodified timestamp 22 null

Indexes

Constraint Name Type Sort Column(s)
externaltaxa_pkey Primary key Asc/Asc taxonid + extdatabaseid
ix_extdatabaseid_exttaxonid_externaltaxa Performance Asc/Asc extdatabaseid + exttaxonid

Relationships