Specialist roster
0derived 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
0 activescenarios/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
0 totalactive_tasks_by_workspace WHERE (workspace_id, time_bucket) — single partition scan, priority DESC
Activity stream
task_events partitions (tenant_id, task_id) fanned out across active + recently-active (~10m). Append-only; event_id is a v1 timeuuid (chronological).