Luca Sacchi Ricciardi
|
6f03c33ab5
|
feat(database): setup alembic and create scenarios table
- Install alembic and asyncpg for database migrations
- Configure alembic for async SQLAlchemy 2.0
- Create initial migration for scenarios table:
* UUID primary key with auto-generation
* Status enum (draft, running, completed, archived)
* JSONB tags with GIN index
* Timestamps with auto-update trigger
* Check constraints for name/region validation
* Indexes on status, region, created_at
- Test database connection and migration
Task: DB-001, DB-002 complete
|
2026-04-07 13:48:05 +02:00 |
|