Table: taxon

Comment: One row per taxon studied. For now, this is a very simplified taxon model with no identification of the taxonomy being used, and there can be only two names, one scientific and one common.

ColumnTypeComment
taxonidinteger Auto Increment [nextval('taxon_taxonid_seq')]Unique row identifier. The value of this column is automatically assigned by the system; the normal practice, which results in a system generated id, is to omit this column when inserting new rows or to supply a NULL value. The value of this column cannot be NULL.
scientific_namecharacter varying(128)The scientific name for the taxon, using for example the NCBI or the ITIS taxonomies.
common_namecharacter varying(64) NULLThe common name for the taxon. This need not be the most common or generally accepted name, but the common name used within the study.

Indexes

PRIMARYtaxonid
UNIQUEcommon_name
UNIQUEscientific_name

Foreign keys

Triggers

Language: