sampleanalysts

263953 rows


Description

This table lists the Sample Analysts.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
analystid serial 10 nextval('ndb.seq_sampleanalysts_analystid'::regclass)

An arbitrary Sample Analyst identification number.

sampleid int4 10 null
samples.sampleid fk_sampleanalysts_samplesC

Sample identification number. Field links to the Samples table.

contactid int4 10 null
contacts.contactid fk_sampleanalysts_contactsR

Contact identification number. Field links to the Contacts table.

analystorder int4 10 null

Order in which Sample Analysts are listed if more than one (rare).

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

Indexes

Constraint Name Type Sort Column(s)
sampleanalysts_pkey Primary key Asc analystid
ix_contactid_sampleanalysts Performance Asc contactid
ix_sampleid_sampleanalysts Performance Asc sampleid

Relationships