Version history

{
  "query_kind": "sql",
  "query_body": "SELECT DISTINCT a.id::text AS ref, a.title\nFROM artifacts a\nWHERE a.epistemic_tier = 'T5'\n  AND a.is_latest = 1\n  AND EXISTS (\n    SELECT 1\n    FROM substrate_artifact_links sal\n    JOIN artifacts a2\n      ON a2.artifact_type = sal.source_artifact_type\n      AND a2.id::text = sal.source_artifact_id\n      AND a2.epistemic_tier = 'T4'\n      AND a2.is_latest = 1\n    WHERE sal.predicate = 'contradicts'\n      AND sal.target_artifact_type = a.artifact_type\n      AND sal.target_artifact_id = a.id::text\n  )\n",
  "query_params": {},
  "threshold": {
    "warning_at": 1,
    "critical_at": 1
  },
  "severity_default": "critical",
  "recommended_action_template": "{n} T5 canonical artifact(s) are contradicted by T4 newcomers —\nEpistemic Ratchet at risk. Open a senate_proposal to resolve or\ndemote the canonical. First items: {refs[:5]}.\n",
  "state": "active",
  "proposer_id": "system-senate"
}