mirror of
https://github.com/saltbo/agent-kanban.git
synced 2026-09-19 09:01:47 +08:00
jarvis
a2fa54a729
Replace the v1 Agent/Machine runtime and CLI architecture with the v2 Resource Server, AMA-backed projections, task lifecycle, session observation, BDD specifications, and a single-package layered codebase. BREAKING CHANGE: remove the v1 CLI, internal Agent/Machine runtime entities, workspace layout, and legacy runtime coordination APIs.
17 lines
654 B
SQL
17 lines
654 B
SQL
CREATE TABLE task_session_bindings (
|
|
task_id TEXT PRIMARY KEY REFERENCES tasks(id) ON DELETE CASCADE,
|
|
claim_action_id TEXT NOT NULL UNIQUE,
|
|
agent_actor_id TEXT NOT NULL,
|
|
runtime TEXT NOT NULL,
|
|
runtime_session_id TEXT NOT NULL,
|
|
bound_at TEXT NOT NULL,
|
|
CHECK(length(agent_actor_id) > 0),
|
|
CHECK(length(runtime) BETWEEN 1 AND 64),
|
|
CHECK(length(runtime_session_id) BETWEEN 1 AND 1024),
|
|
FOREIGN KEY (claim_action_id, task_id)
|
|
REFERENCES task_actions(id, task_id) ON DELETE CASCADE
|
|
);
|
|
|
|
CREATE INDEX idx_task_session_bindings_runtime_session
|
|
ON task_session_bindings(runtime, runtime_session_id);
|