Database
SPN uses PostgreSQL with Alembic for migrations.Migrations
Generate Migration
Apply Migrations
Rollback
View History
Schema
Core Tables
Full-Text Search
Thecompanies table includes a search_vector column for fast search:
Connecting to Database
From Host
From Container
Common Tasks
Add a Column
- Update model in
backend/app/models/domain.py - Generate migration:
alembic revision --autogenerate - Review the migration file
- Apply:
alembic upgrade head
Reset Database
Warning: This deletes all data!