Schema: microbiometer

Outline

The schema microbiometer only contains a single table, for recording the results of the Microbiometer^TM soil sampling kit.

The soil sampling, including extraction method, depth, classification, photos etc., are recorded in the schema samples. The landscape (above ground) characteristics and the cultivation methods and its history are covered in the sites, landscape and landsites schemas.

Microbiometer

The Microbiometer^TM is a commercial soil sampling kit for estimating the soil microbial biomass and fungal to bacterial ratio. The measurements takes about 20 minutes and requires a smartphone, and the Microbiometer soil test kit.

The procedure for estimating bacteria and fungi includes mixing a small soil sample with a reagent and then use a template colour chart for evaluation using an app that interpreters the colour change of your soil sample through the camera of a smartphone. The full procedure takes about 20 minutes. If you subscribe and register an account you can save the results in an online database. For use with AI4SH the results need to be accessible for use with other in-situ data, and the AI4SH in-situ database thus contains a schema for storing microbiometer data.

MicroBiometerTM expresses test results as a number between 0 and 100.

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 microbiometer measurements'
}

Table users.user {
  userid SERIAL
}

Table samples.sample_event {
  sampleid SERIAL
  siteid INTEGER [pk]
}

Table microbiometer {
  sampleid INTEGER [pk]
  topsoil Boolean [pk]
  userid INTEGER
  bacteria_ratio float
  fungi_ratio float
  extra_reagent_required BOOLEAN [DEFAULT false]
  description TEXT
}
// topsoil (true) represents 0-20 cm, subsoil (false) represents 20-50 cm.

REF: samples.sample_event.sampleid - microbiometer.sampleid
REF: users.user.userid - microbiometer.userid

Figure