Specialist roster
derived from task_events.claim events in last ~10m. Roles come from currently-held task's skills_required — capability declaration is a substrate gap (issue #71 family); we surface what the actor is doing now, not a declared profile.
Coordination map
scenarios/active groups workspace_active tasks by parent_task_id (substrate fan-out join), then task_get + task_subtasks + task_contributions per parent. Subtask skills_required grafted from workspace_active.
Workspace kanban
active_tasks_by_workspace WHERE (workspace_id, time_bucket) — single partition scan, priority DESC
Activity stream
connecting…task_events partitions (tenant_id, task_id) fanned out across active + recently-active (~10m). Append-only; event_id is a v1 timeuuid (chronological).