Data Storage, Searching, and Manipulation - Design and Use of Relational Databases in Chemistry - page 51

checkout

registry

alocation

FK sample_id * INTEGER

PK sample_id *

SERIAL

PK location_id *

INTEGER

FK location_id * INTEGER

registered TIMESTAMP

aname

TEXT

FK chemist_id * INTEGER

FK parent_sample_id INTEGER

atype

TEXT

checked_out TIMESTAMP

composition

PF sample_id * INTEGER
PF compound_id * INTEGER

chemist

PK chemist_id * INTEGER

aname TEXT

structure

PK compound_id * INTEGER

smiles
mw

TEXT
NUMERIC

Figure 6.1 Entity relationship diagram for a chemical sample tracking schema.