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_keywordsR
keyword varchar 64 null
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