Table: taxon
Select data Show structure Alter table New item
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.
| Column | Type | Comment |
|---|---|---|
| taxonid | integer 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_name | character varying(128) | The scientific name for the taxon, using for example the NCBI or the ITIS taxonomies. |
| common_name | character varying(64) NULL | The 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
| PRIMARY | taxonid |
|---|---|
| UNIQUE | common_name |
| UNIQUE | scientific_name |