# openspec/changes/archive/2026-05-17-database-models
dir: openspec/changes/archive/2026-05-17-database-models

index: openspec/changes/archive/2026-05-17-database-models/.pi-map.index.md

## role
Defines database ORM models and migration infrastructure for a PostgreSQL-backed async SQLAlchemy layer with UUID primary keys and Alembic version control.
## files
- .openspec.yaml | Defines an OpenSpec configuration file with schema type and creation date metadata
- README.md | Documents a project component responsible for implementing SQLAlchemy ORM models and Alembic database migration infrastructure for core business entities. | dep: SQLAlchemy, Alembic
- design.md | Defines the database schema design, technology choices, and architecture for an async SQLAlchemy-based PostgreSQL ORM layer with UUID primary keys, relationships, and migration strategy | dep: SQLAlchemy 2.0, asyncpg, Alembic, PostgreSQL, pydantic-settings, pytest, mypy, ruff
- proposal.md | Proposes implementing SQLAlchemy 2.0 async database models and Alembic migrations for core entities in a platform called Headquarter. | dep: SQLAlchemy 2.0, Alembic, asyncpg, pytest, mypy, ruff
- tasks.md | Tracks completed implementation tasks for building SQLAlchemy database models with async PostgreSQL support, Alembic migrations, and testing infrastructure | dep: SQLAlchemy, Alembic, pydantic-settings, PostgreSQL, pytest, mypy, ruff
## arch
Specification-driven architecture using OpenSpec format with phased implementation tracking (design → proposal → tasks → archive), employing SQLAlchemy 2.0 async patterns, UUID-based entity relationships, and Alembic migration strategy for a platform called Headquarter.
## tags
alembic, sqlalchemy, database, postgresql, models, design, async, pytest
## symbols
-
## workflows
-
## dirty
-