AI4SH postgreSQL database
This blog contains a draft outline of a PostgreSQL database (schemas and tables) for the AI for Soil Health (AI4SH) work package (WP) on in-situ data. Each post, except the first, contains a different schema, with all the tables and columns defined using Database Markup Language (DBML). The first post is an overview of all the schemas.
All posts (schemas) were updated on 3 September 2024.
Schemas AI4SH database schemas. Schema: users AI4SH database schema users, only a sketch to indicate that it is required. Schema: sites AI4SH schema sites contains hierarchical information on i) pilot sites, divided into ii) fields/farms and iii) individual sample points. Schema: landscape AI4SH schema landscape contains tables for recording the landscape and the sample point topographic setting. The registered properties are considered permanent over the AI4SH project duration. Schema: sample_event AI4SH schema sample_event Schema: fieldobs AI4SH schema fieldobs Schema: landstate AI4SH schema landstate for recording the land use/management and crop conditions both historically and at the time of each sampling event. Schema: weather AI4SH schema for weather conditions just before and during sample events. Schema: macrofauna AI4SH schema macrofauna Schema: microbiometer AI4SH schema microbiometer Schema: moulder AI4SH schema moulder Schema: eDNA AI4SH schema eDNA Schema: spectra AI4SH schema spectra Schema: wetlab AI4SH schema wetlab laboratory data Schema: penetrometer AI4SH schema penetrometer data Schema: enzymes AI4SH schema enzyme activity data Schema: ise AI4SH schema Ion Selective Electrode (ise) Schema: infiltration AI4SH schema infiltration rate