keywords

5 rows


Description

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.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
keywordid serial 10 √ nextval('ndb.seq_keywords_keywordid'::regclass)
samplekeywords.keywordid fk_samplekeywords_keywords R

An arbitrary Keyword identification number.
keyword varchar 64 null

A keyword for identifying samples sharing a common attribute.
recdatecreated timestamp 22 timezone('UTC'::text, now())
recdatemodified timestamp 22 null

Indexes

Constraint Name Type Sort Column(s)
keywords_pkey Primary key Asc keywordid

Relationships

Close relationships within degrees of separation