headquarter/openspec/changes/archive/2026-06-14-completed-specs-archive/database-models/.pi-map.md

openspec/changes/archive/2026-06-14-completed-specs-archive/database-models

dir: openspec/changes/archive/2026-06-14-completed-specs-archive/database-models

index: openspec/changes/archive/2026-06-14-completed-specs-archive/database-models/.pi-map.index.md

role

Defines the database schema and SQLAlchemy 2.0 async ORM models for the Headquarter platform's core entities including users, projects, git repositories, SSH keys, and user configuration, with Alembic migration and seeding support.

files

• spec.md | Define database schema and SQLAlchemy 2.0 async models for the Headquarter platform including users, projects, git repositories, SSH keys, and user configuration with Alembic migrations and seeding. | dep: SQLAlchemy 2.0, asyncpg, Alembic, PostgreSQL, Fernet cryptography, pytest, mypy, ruff

arch

Async SQLAlchemy 2.0 declarative ORM with Alembic migrations, seeding utilities, and comprehensive entity relationship modeling for a multi-tenant platform with git integration and SSH key management.

tags

alembic, spec, define, database, schema, sqlalchemy, async, models

symbols

workflows

dirty