cabah_taxaID

47144 rows


Description

Is Neotoma-derived taxa table for compilations dealing with taxa, e.g. IPPD. This table, according to Neotoma db (https://neotoma-manual.readthedocs.io/en/latest/tables_taxa.html#taxa), stores taxa … IMPORTANT NOTE: Primary key (and, with the exception of “TAXAGRPID”, the other IDs too) have been migrated unaltered from Neotoma. Therefore, database relations will only work (and be updatable from the Neotoma source) if these IDs stay untouched.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
TAXONID int4 10 null
cabah_taxaID.PARENTID <--TAXONID_from_cabah_taxaID_fkey R
ippd_Sample.TAXONID <--TAXONID_from_cabah_taxaID_fkey R
ippd_variables.TAXONID <--TAXONID_from_cabah_taxaID_fkey R

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
cabah_taxaID.TAXONID <--TAXONID_from_cabah_taxaID_fkey R

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
cabah_taxagroupID.TAXAGRPID <--TAXAGRPID_from_cabah_taxagroupID_table R

Is fkey. For avaiable values refer to :ref:cabah_taxagroupID table
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
neo_contacts.CONTACTID <--CONTACTID_from_neo_contacts_fkey R

Is fkey. For avaiable values refer to :ref:neo_contacts table
VALIDDATE text 2147483647 √ null

Date of taxon validation
TAXONNOTE text 2147483647 √ null

Taxon notes
CREATED_AT timestamptz 35,6 timezone('UTC'::text, now())

Is record timestamp with timezone based on UTC
UPDATED_AT timestamptz 35,6 √ timezone('UTC'::text, now())

Is timestamp of record update with timezone based on UTC

Indexes

Constraint Name Type Sort Column(s)
cabah_taxaID_pkey Primary key Asc TAXONID

Relationships

Close relationships within degrees of separation