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_d365a73253c42ef4:digest:2026-04-06T09","evidence_event_ids":["evt_18e421c7aff9","evt_3f2fc1172c22","evt_96a269acbe66","evt_05c2ecc1ca0b","evt_a9565348f490","evt_c6a4857b7895","evt_3d33e1ad4df4","evt_f7eaa9f707f7","evt_c2f76dd6b051","evt_499ce6d8a0db"],"reason_trace":{"_evidence_event_ids":["evt_3f2fc1172c22","evt_96a269acbe66","evt_05c2ecc1ca0b","evt_a9565348f490","evt_c6a4857b7895","evt_3d33e1ad4df4","evt_f7eaa9f707f7","evt_c2f76dd6b051","evt_499ce6d8a0db"],"case_id":"case_d365a73253c42ef4","decision":"digest","entity_key":"commodity:brent","memory_only":true,"theme_key":"entity_development"},"severity":"low","signal_id":"sig_44cc20d9c29f","signal_type":"opportunity_case_memory","source":"opportunity_finder","topic_key":"signal:opportunity_case_memory:f3f11a61c14ab8da","triage":{"action_hints":[],"confidence":0.0,"disposition":"dismiss","entity_ids":[],"headline":"Real estate market recovery signal","prior":{"family":"general","importance_band":"background","suggested_disposition":"park","suggested_route":"review","suggested_urgency":"low"},"priority_score":-40.0,"rationale":"This signal about the real estate market is low priority and not immediately relevant to current plans.","review_in_days":365,"route":"ignore","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:456aaabe53663d92 in inbox_items