5 rows


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.


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

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


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