PostgreSQL/PostGIS
Users/consent, farms/fields, crop cycles/treatments, cases/turns/snapshots, observations/hypotheses/evidence, officer assignments/decisions, document versions/metadata, rules, model/prompt registry, research records, outbox and audit references.
Search
Pilot: PostgreSQL full-text + pgvector + hierarchy/metadata tables. Scale: Qdrant and/or OpenSearch when benchmarks justify.
Object storage
Media, source files, extracted figures, evaluation data, model artifacts and snapshots. Store content hash, classification, owner, encryption, retention, malware scan and derivative relationships.
Audit
Operational state is mutable; audit is append-only and may export to WORM/immutable storage.
Analytics
A transactional outbox feeds de-identified dashboards and the human-reviewed outbreak pipeline. Raw model diagnoses never directly alert.
Retention
Separate policies for raw audio, transcript, image, video, diagnosis, model traces, reviewer records, audit and anonymized analytics.