samplekeywords

10737 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
keywordid int4 10 null
keywords.keywordid fk_samplekeywords_keywordsR
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