Schema: ise

Outline

The schema ise contains tables for in-field/in-kitchen/in-lab Ion Selective Electrode (ISE) analysis. For AI4SH, only pH will be analysed using ISE, but can be done both in-field and in-kitchen. As the ISE instruments used with AI4SH is an extension of one of the spectrometers to be tested, the ISE can be done using any of the three sample preparations also used for spectral analysis (schema.table: spectra.samplescan):

• NO (no prep = in field analysis),
• MX (mixed = in kitchen analysis of wet mixed subsamples), or
• DS (dried & sieved = in kitchen/laboratory analysis).

The schema ise is built along the same principles as the other schemas for laboratory derived soil properties, wetlab and edna. The sampleid and userid are derived from other schemas and registered together with other metadata for each ISE analysis in the table isemeta. Each ISE analysis is given a unique (SERIAL) id, that is then used for linking to the results (table: ise).

The actual ISE results are thus stored in the table ise.

DBML

// Use DBML to define your database structure
// Docs: https://dbml.dbdiagram.io/docs
// Tool: https://dbdiagram.io/d

Project project_name {
  database_type: 'PostgreSQL'
  Note: 'AI4SH schema for infiltration test'
}

Table users.user {
  userid SERIAL
}

Table samples.sample_event {
  sampleid SERIAL
}

TABLE isemeta {
  iseeid INTEGER [pk]
  sampleid INTEGER [pk]
  prepcode CHAR[2] [pk]
  userid INTEGER
  topsoil Boolean [pk, DEFAULT: TRUE]
  repetition SMALLINT [pk, DEFAULT:1]
  analysistimestamp timestamp
  isecalib integer
  iseanalysisid SERIAL
}

Table iseprobe {
  brand TEXT [pk]
  model TEXT [pk]
  quantity REAL [pk]
  unit TEXT
  iseid SERIAL
}

Table isecalibration {
  iseid INTEGER [pk]
  dt TIMESTAMP [pk]
  refvalue REAL
  obsvalue REAL
  isecalib SERIAL
}

Table iseanalysisresults {
  iseanalysisid INTEGER [pk]
  quantity TEXT
  value REAL
}

Figure