daltare/pfas-database

Primary Keys

Opened this issue · 0 comments

daltare commented

Targeted Analysis (AOF / 533+):

  • Lab_Sample_ID
  • PS_Code
  • Batch
  • Analyte_Name (Example CK06046 533 (CLIP+) CA3310037.csv & Example CK33001 AOF (CLIP+) CA3310037.csv have records that are identical in the 3 fields above - is that expected?)
  • Collection_Date? (AOF Files have rows that are duplicates except for Collection_Date)

Well List:

  • PS_Code