document_id
doc.database-schema
last_verified
2026-02-18
tokens_estimate
900
tags
anchors
id
summary
tables
project, workflow, card, planning_action, context_artifact, memory_unit
id
summary
migrations
lib/db/migrate.ts; 001-005; _migrations table
ttl_expires_on
Database Schema Reference Source of truth : lib/db/migrate.ts and lib/db/sqlite-migrations/
Anchors : domains/data-contracts-reference.md
INVARIANT: Migrations run in order; tracked in _migrations
INVARIANT: SQLite for self-deploy; Postgres for future hosted
INVARIANT: DbAdapter is single seam; no direct DB access from business logic
Table
Purpose
project
Projects; name, repo_url, default_branch, action_sequence
workflow
Workflows per project; position-ordered
workflow_activity
Activities per workflow; color, position
step
(Migration 005: removed)
card
Cards per activity; status, priority, build_state
planning_action
Action log; idempotency_key for dedup
context_artifact
Project-level context; type, content, uri, integration_ref
card_context_artifact
Card ↔ artifact many-to-many
card_requirement, card_known_fact, card_assumption, card_question
Knowledge items
card_planned_file
Planned files per card; artifact_kind, action, status
system_policy_profile
Project policy; required_checks, paths
orchestration_run
Build runs; scope, snapshots
card_assignment
Per-card assignments; feature_branch, allowed_paths
agent_execution, agent_commit
Execution records
run_check
Quality gates
pull_request_candidate
Draft PR tracking
approval_request
PR approval lifecycle
event_log
Audit
memory_unit
Content + embedding_ref
memory_unit_relation
Scope mapping
memory_retrieval_log
Retrieval observability
Name
Purpose
001_schema.sql
Core planning + context + knowledge
002_orchestration.sql
Runs, assignments, checks, approvals
003_memory.sql
memory_unit, memory_unit_relation, memory_retrieval_log
004_project_description.sql
Add project.description
005_remove_steps.sql
Remove step table; cards direct to activity
context_artifact: at least one of content, uri, integration_reforchestration_run: scope=workflow → workflow_id required; scope=card → card_id requiredplanning_action: idempotency unique per (project_id, idempotency_key)