synonymy

37992 rows


Description

The synonymy table links dataset-level synonymies to particular publications or contacts. This allows users to maintain the original taxonomic information within a table, but tie it to newer and more authoritative taxonomic information.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
synonymyid serial 10 √ nextval('ndb.seq_synonymy_synonymyid'::regclass)
datasetid int4 10 null
datasets.datasetid fk_synonymy_datasetsC

DatasetID from the Datasets table
taxonid int4 10 null
taxa.taxonid fk_synonymy_taxa1C
reftaxonid int4 10 null
taxa.taxonid fk_synonymy_taxa2R
fromcontributor bool 1 √ null
publicationid int4 10 √ null
publications.publicationid fk_synonymy_publicationsC
notes text 2147483647 √ null
contactid int4 10 √ null
contacts.contactid fk_synonymy_contactsR
datesynonymized date 13 √ null
recdatecreated timestamp 22 timezone('UTC'::text, now())
recdatemodified timestamp 22 null

Indexes

Constraint Name Type Sort Column(s)
synonymy_pkey Primary key Asc synonymyid

Relationships

Close relationships within degrees of separation