samplekeywords

12731 rows


Description

This table lists the Sample Analysts.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
sampleid int4 10 null
samples.sampleid fk_samplekeywords_samplesC

Sample identification number. Field links to the Samples table.

keywordid int4 10 null
keywords.keywordid fk_samplekeywords_keywordsR

Keyword identification number. Field links to the Keywords lookup table.

recdatecreated timestamp 22 timezone('UTC'::text, now())
recdatemodified timestamp 22 null

Indexes

Constraint Name Type Sort Column(s)
samplekeywords_pkey Primary key Asc/Asc sampleid + keywordid
ix_keywordid_samplekeywords Performance Asc keywordid
ix_sampleid_samplekeywords Performance Asc sampleid

Relationships