Runtime State Plane

The runtime state plane is the SQLite-backed RuntimeStore. The schema is created by runtime_store.py's migrate() step and consists of the following tables.

Tables

Table	Purpose
goals	Goal rows; goal_id is the primary key.
phases	Phase rows, one per declared phase.
tasks	Task rows, one per declared task.
next_actions	Computed next-action record per goal.
evidence_records	Evidence pointers and SHA-256 digests.
owner_gates	Gate rows; gate_id is the primary key.
worktrees	Worktree bookkeeping.
pull_requests	PR rows with head SHA and status.
agent_sessions	Agent session bookkeeping.
runs	Run rows with role, adapter, status.
task_dependencies	Task graph edges.
state_transitions	History of state transitions.
repair_attempts	Bounded repair attempts.
findings	Audit findings.
ci_runs	CI run bookkeeping.
commits	Commit bookkeeping.
processes	Process supervisor records.
quota_events	Quota consumption.
role_runs	Per-role run records.
locks	Concurrency locks.
schema_migrations	Schema version table.

Open vs read-only modes

program-status.ps1 opens the SQLite in mode=ro via uri=...mode=ro. The orchestrator opens it for write through RuntimeStore. There is no "shared" mode; the two modes are explicit and the CLI rejects operations that require write access when only read access is granted.