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":"Signal emitted.","candidate_refs":[{"id":"sig_06020cae8fd8","kind":"signal"}],"channel":"C0A8Q869CNL","cta":["review","ignore"],"delivery_fp":"attn:C0A8Q869CNL:8b13d9cdfad5890707ae:2026-04-03T20","next_eligible_at":null,"nudge_kind":"alert","reason_trace":{"age_min":6.0,"dedupe_key":"opportunity_case_memory:case_d53c248ebd0caad0:monitor:2026-04-03T19","personalization":{"fields_sample":[],"mode":"bootstrap","owner_fact_count":0},"reason_trace":{"_evidence_event_ids":["evt_4de3dd17f42e","evt_3312d1fa59d6","evt_c8393ac8fc54","evt_0074dbd52832","evt_4b14f74635a9","evt_5e777c0dd9d3"],"case_id":"case_d53c248ebd0caad0","decision":"monitor","entity_key":"equity:EIA","memory_only":true,"severity":"low","signal_type":"opportunity_case_memory","source":"opportunity_finder","theme_key":"entity_development"},"severity":"low","signal_type":"opportunity_case_memory","source":"opportunity_finder","throttle_s":3600},"score":63.90834716533334,"score_breakdown":{"age_min":6.0,"base":12,"freshness":113.96,"severity_weight":20},"suppression_rules_applied":[],"thread_id":null,"title":"Opportunity Case Memory","topic_key":"signal:opportunity_case_memory:case_d53c248ebd0caad0:monitor:2026-04-03T19","why_now":"severity=low; 6m ago"}

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 4681 in events