AI4SoilHealth Database
AI4SoilHealth database is a PostgreSQL database with PostGIS extension storing all relevant project data.
Client app AI4SoilHealth app communicates with the database usin Rest API calls in AI4SoilHealth backend.
It is divided into following schemas:
auth - Authorization related objects
catalog - Tables containing simple catalogs
data - Specialized AI4SoilHealth data related objects
general - General objects, reusable outside the AI4SoilHealth context
log - Logging objects
meta - Metadata related objects (application design)
utils - Utilities and auxiliary routines
zzglc - CRUF backoffice routines
zzgll - Lookup routines
zzhistory - History tables (recorded changes)