| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| TAXONID | int4 | 10 | null |
|
|
Is original Neotoma taxonid |
|||||||||||
| TAXONCODE | text | 2147483647 | null |
|
|
A code for the Taxon. These codes are useful for other software or output for which the complete name is too long. Because of the very large number of taxa, codes can be duplicated for different Taxa Groups. In general, these various Taxa Groups are analyzed separately, and no duplication will occur within a dataset. However, if Taxa Groups are combined, unique codes can be generated by prefixing with the TaxaGroupID, For example, VPL:Cle (Clethra) and MAM:Cle (Clethrionomys). …(Neotoma. For more detail refer to https://neotoma-manual.readthedocs.io/en/latest/tables_taxa.html#taxa) |
|||||||||||
| TAXONNAME | text | 2147483647 | null |
|
|
Name of the taxon. Most TaxonNames are biological taxa; however, some are biometric measures and some are physical parameters. In addition, some biological taxa may have parenthetic non-Latin modifers, e.g. «Betula (>20 µm)» for Betula pollen grains >20 µm in diameter. In general, the names used in Neotoma are those used by the original investigator. In particular, identifications are not changed, although Dataset notes can be added to the database regarding particular identifications. However, some corrections and synonymizations are made. …(Neotoma. For more detail refer to https://neotoma-manual.readthedocs.io/en/latest/tables_taxa.html#taxa) |
|||||||||||
| AUTHOR | text | 2147483647 | √ | null |
|
|
Taxon name author(s) |
||||||||||
| TAXONVALID | bool | 1 | null |
|
|
Boolean (True/False) variable |
|||||||||||
| PARENTID | int4 | 10 | √ | null |
|
|
Is fkey. Refers to ordinal higher ranking TAXONID |
||||||||||
| TAXEXTINCT | bool | 1 | null |
|
|
Boolean (True/False) variable. The value is True if the taxon is extinct, False if extant. (Neotoma) |
|||||||||||
| TAXAGRPID | int4 | 10 | null |
|
|
Is fkey. For avaiable values refer to :ref: |
|||||||||||
| NEOTXPUBID | int4 | 10 | √ | null |
|
|
Neotoma publication identification number. In Neotoma, this field links to the publications table. In OCTOPUS, however, it does NOT. |
||||||||||
| NEOVALORID | int4 | 10 | √ | null |
|
|
Is fkey. For avaiable values refer to :ref: |