SQLite Web: event

id

Primary key. TEXT

type

TEXT NOT NULL

text

TEXT NOT NULL

normalized_text

TEXT

status

TEXT NOT NULL

tags

TEXT

links

{"dedupe_key":"opportunity_case_memory:case_4862a18a2c6d80ef:digest:2026-04-03T15","evidence_event_ids":["evt_7b7990b81775","evt_85ae61f3366f","evt_2292508410a3","evt_fca6ad816b53","evt_e10a83e9426b","evt_fb406f4d8256","evt_d42d3d00152c","evt_a707fa8c771a"],"reason_trace":{"_evidence_event_ids":["evt_85ae61f3366f","evt_2292508410a3","evt_fca6ad816b53","evt_e10a83e9426b","evt_fb406f4d8256","evt_d42d3d00152c","evt_a707fa8c771a"],"case_id":"case_4862a18a2c6d80ef","decision":"digest","entity_key":"commodity:silver","memory_only":true,"theme_key":"entity_development"},"severity":"low","signal_id":"sig_bbfa0e633f8a","signal_type":"opportunity_case_memory","source":"opportunity_finder","topic_key":"signal:opportunity_case_memory:efbf3229de766839","triage":{"action_hints":["schedule review"],"confidence":0.0,"disposition":"park","entity_ids":[],"headline":"Market dynamics shift detected","prior":{"family":"general","importance_band":"background","suggested_disposition":"park","suggested_route":"review","suggested_urgency":"low"},"priority_score":10.0,"rationale":"Strong indicators suggest a significant shift in market dynamics that warrants future review.","review_in_days":30,"route":"review","urgency":"low"},"user_visible":false}

TEXT

ts

TEXT NOT NULL

route

TEXT

urgency

TEXT

next_touch_at_iso

TEXT

created_at

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

updated_at

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

event_store.db — inbox_items

Update row sig:b78ce9dc1777f89a in inbox_items