Jens
faeb58ef6d
GeoIntel release gates / Compile, test, contracts and builds (push) Successful in 1m49s
GeoIntel release gates / Python and npm vulnerability policy (push) Successful in 21s
GeoIntel release gates / Production AI image, SBOM and container scan (push) Successful in 5m39s
GeoIntel release gates / Deploy exact gated revision to Unraid (push) Failing after 58m43s
32 lines
723 B
Markdown
32 lines
723 B
Markdown
# Codex Pass 02 — Database and Models
|
|
|
|
## Goal
|
|
|
|
Add SQLAlchemy/Alembic/PostGIS-ready database foundation.
|
|
|
|
## Must implement
|
|
|
|
- database session management;
|
|
- base model conventions;
|
|
- models for Project, Area, Dataset, AnalysisRun, Metric, Export, Job;
|
|
- migration scaffold;
|
|
- geometry field strategy documented in code comments or docs;
|
|
- indexes for FK and future geometry operations;
|
|
- tests for model imports.
|
|
|
|
## Must preserve
|
|
|
|
- PostGIS as spatial database;
|
|
- additive migration approach;
|
|
- UUID or chosen ID strategy consistently.
|
|
|
|
## Must not implement
|
|
|
|
- destructive migrations;
|
|
- live GRB/OSM fetch;
|
|
- AI tables beyond V1 scaffold unless already specified.
|
|
|
|
## Output
|
|
|
|
Use `docs/M6_FINAL_HANDOFF_TEMPLATE.md`.
|