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:case_eb4818945adbf2af:2026-04-04","evidence_event_ids":["evt_bb0c2ed0b3d6","evt_797b64a40209","evt_8677dc4cad90","evt_69d0591d84cf","evt_1bb4682c7bd2","evt_a0f759030cce","evt_aea884ee02ec","evt_d87c82c78606","evt_89152778c2a6","evt_4a5ce093cd2d"],"reason_trace":{"_evidence_event_ids":["evt_797b64a40209","evt_8677dc4cad90","evt_69d0591d84cf","evt_1bb4682c7bd2","evt_a0f759030cce","evt_aea884ee02ec","evt_d87c82c78606","evt_89152778c2a6","evt_4a5ce093cd2d"],"case_id":"case_eb4818945adbf2af","decision":"surface","entity_key":"equity:IR","theme_key":"entity_development"},"severity":"medium","signal_id":"sig_d4c451953f8c","signal_type":"opportunity_signal","source":"opportunity_finder","topic_key":"signal:opportunity_signal:a0374fb47798296d","triage":{"action_hints":["schedule review"],"confidence":0.12,"disposition":"park","entity_ids":[],"headline":"Rising energy prices due to supply issues identified.","prior":{"family":"opportunity","importance_band":"meaningful","suggested_disposition":"promote","suggested_route":"review","suggested_urgency":"medium"},"priority_score":58.96,"rationale":"This opportunity signal indicates a potential impact on costs that may need monitoring.","review_in_days":7,"route":"watch","urgency":"medium"},"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:b818109c37bd105c in inbox_items