neo_keywords

0 rows


Description

Is a Neotoma lookup table of Keywords referenced by the SampleKeywords table. The table provides a means to identify samples sharing a common attribute. For example, the keyword «modern sample» identifies modern surface samples in the database. These samples include individual surface samples, as well as core tops. Although not implemented, a «pre-European settlement» keyword would be a means to identify samples just predating European settlement. (https://neotoma-manual.readthedocs.io/en/latest/tables_samples.html#keywords)

Columns

Column Type Size Nulls Auto Default Children Parents Comments
KEYWORDID int2 5 null
ippd_samplekeywords.KEYWORDID <--KEYWORDID_from_neo_keywords_fkey R

An arbitrary Keyword identification number (full sequence taken from Neotoma)

KEYWORD text 2147483647 null

A keyword for identifying samples sharing a common attribute (full sequence taken from Neotoma)

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)
neo_keywords_pkey Primary key Asc KEYWORDID

Relationships