cabah_ecolgroupID

194 rows


Description

Is Neotoma-derived lookup table for compilations dealing with taxa, e.g. IPPD. This table, according Neotoma db (https://neotoma-manual.readthedocs.io/en/latest/tables_taxa.html#ecolgroups), stores ecological groups that facilitate subsequent data handling … Taxa are assigned to Sets of Ecological Groups. A taxon may be assigned to more than one Set of Ecological Groups, representing different schemes for organizing taxa …

Columns

Column Type Size Nulls Auto Default Children Parents Comments
ECOGROUPID serial 10 √ nextval('"cabah_ecolgroupID_ECOGROUPID_seq"'::regclass)
ECOLGROUP text 2147483647 null
ECOGRPHNDL varchar 4 null
ECOGRPSRC 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_ecolgroupID_pkey Primary key Asc ECOGROUPID
cabah_ecolgroupID_ECOGRPHNDL_key Must be unique Asc ECOGRPHNDL

Relationships

Close relationships within degrees of separation