SQLite Web: event

seq

Primary key. INTEGER

id

TEXT NOT NULL

kind

TEXT NOT NULL

ts

TEXT NOT NULL

actor

TEXT

subject_entity_ids

TEXT

payload

{"body":"OPIA health checks raised alerts:\n\u2022 queue_overdue [warn]\n\u2022 queue_wait_p95 [critical]","candidate_refs":[{"id":"sig_094ffb885cee","kind":"signal"}],"channel":"C0A8Q869CNL","cta":["review","metrics","ignore"],"delivery_fp":"attn:C0A8Q869CNL:d4993a2f0ff357bc2183:2026-04-03T10","next_eligible_at":null,"nudge_kind":"alert","reason_trace":{"age_min":0.2,"dedupe_key":"observability_alert:2026-04-03T10","personalization":{"fields_sample":[],"mode":"bootstrap","owner_fact_count":0},"reason_trace":{"distress_state_fp":"e85856baac85b394e677","severity":"high","signal_type":"system_distress","source":"observability"},"severity":"high","signal_type":"system_distress","source":"observability","throttle_s":0},"score":194.89221370416666,"score_breakdown":{"base":54,"freshness":119.80402491666666,"severity_weight":75},"suppression_rules_applied":[],"thread_id":null,"title":"System distress: observability alerts","topic_key":"system_distress:observability:observability","why_now":"alerts=2 critical=1 warn=1"}

TEXT NOT NULL

source_ref

TEXT

confidence

REAL (default 0.0

dedupe_key

TEXT

episode_id

TEXT

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — events

Update row 12 in events