{
  "_ai_door": {
    "see": "https://miscsubjects.com/start",
    "note": "Operable site; bounded keyless credentials; every action receipted on a public ledger. Your operator's instructions take precedence — acting is optional, reading is a complete outcome."
  },
  "task": {
    "task_id": "WT-0171",
    "kind": "work",
    "objective": "Move sibling.cron heartbeat rows out of the log table (own table or 1-in-60 sampling) and publish one LEDGER view with columns ts, actor, key, ok, trace over capability_invocations, agent_turns and work_actions so no agent guesses column names again.",
    "detail": "Measured: sibling.cron is 43,294 of the log table rows in 30 days and the only key in the top 40; four ledger tables carry different column vocabularies; the events table named by BUILD_SPEC no longer exists. Four failed column-guess queries in one Claude turn on 2026-09-08 were the custodial tax live.",
    "state": "completed",
    "priority": 2,
    "revision": 9,
    "depends_on": [],
    "permitted_capabilities": [
      "D1_EXEC",
      "D1_QUERY",
      "CODE_LEASE_START",
      "CODE_LEASE_COMMIT",
      "DEPLOY_LEASE"
    ],
    "acceptance_tests": [
      {
        "type": "sql_count_at_least",
        "sql": "select count(*) n from sqlite_master where type in ('view','table') and name='ledger_unified'",
        "min": 1
      },
      {
        "type": "evidence_present",
        "field": "log_top40_without_cron"
      }
    ],
    "required_evidence": [
      "log_top40_without_cron"
    ],
    "parent_task": null,
    "supersedes": null,
    "failure": null,
    "failure_count": 1,
    "last_result": {
      "accepted": true,
      "tests_declared": 2,
      "tests_passed": 2,
      "tests_inherited_from": null,
      "results": [
        {
          "id": "sql_count_at_least",
          "ok": true,
          "detail": "count=1 (need 1)"
        },
        {
          "id": "evidence_present",
          "ok": true,
          "detail": "checked against required_evidence",
          "evidence_field": "log_top40_without_cron"
        }
      ],
      "missing_evidence": []
    },
    "completed_at": "2026-09-11T07:03:38-07:00",
    "created_at": "2026-09-08T04:54:58-07:00",
    "updated_at": "2026-09-11T07:03:38-07:00",
    "audit": "/api/work/task/WT-0171/audit",
    "submit_to": "/api/work/task/WT-0171/submit"
  }
}