Orphaned debate rounds

Content

query_kind

sql

query_body

SELECT dr.id::text AS ref, dr.action AS title FROM debate_rounds dr WHERE NOT EXISTS ( SELECT 1 FROM debate_sessions ds WHERE ds.id = dr.session_id )

query_params

{}

threshold

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

severity_default

critical

recommended_action_template

Delete {n} orphaned debate_rounds with invalid session_id FK.

state

active

proposer_id

system-senate