cabah_taxagroupID

56 rows


Description

Is Neotoma-derived lookup 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 groups … The TaxaGroupID facilitates rapid extraction of taxa groups that are typically grouped together for analysis. Some of these groups contain taxa in different classes or phyla.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
TAXAGRPID serial 10 √ nextval('"cabah_taxagroupID_TAXAGRPID_seq"'::regclass)
cabah_taxaID.TAXAGRPID <--TAXAGRPID_from_cabah_taxagroupID_table R
TAXAGROUP text 2147483647 null
TXAGRPHDLE varchar 3 null
TXAGRPSRC int2 5 √ null
cabah_datasourceID.DATASRCID <--DATASRCID_from_cabah_datasourceID_fkey R
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_taxagroupID_pkey Primary key Asc TAXAGRPID
cabah_taxagroupID_TXAGRPHDLE_key Must be unique Asc TXAGRPHDLE

Relationships

Close relationships within degrees of separation