Orphaned knowledge edges

Content

query_kind

sql

query_body

SELECT k.id::text AS ref, k.relation AS title FROM knowledge_edges k WHERE k.analysis_id IS NOT NULL AND NOT EXISTS ( SELECT 1 FROM analyses a WHERE a.id = k.analysis_id )

query_params

{}

threshold

{
  "warning_at": 1,
  "critical_at": 10
}

severity_default

critical

recommended_action_template

Re-link or delete {n} orphaned knowledge_edges with invalid analysis_id FK.

state

active

proposer_id

system-senate