SQLite Web: event

thread_id

Primary key. TEXT

last_turn_id

TEXT

last_source_event_id

TEXT

open_loops

TEXT

intents

TEXT

state_blob

{"cognition_state_v1":{"known_slots":[{"confidence":0.9,"key":"ticker","source":"user_text","value":"AAOI"},{"confidence":0.85,"key":"analysis_scope","source":"user reply 'all of it'","value":"Up-to-date snapshot (price/valuation + latest news/earnings) + general fundamentals/catalysts checklist"}],"last_intent_summary":"User wants a complete AAOI analysis including the latest up-to-date numbers (price/valuation) and the most recent news/earnings, using web data.","last_reasoning_mode":"conversation","notes":["User requested: analyze ticker AAOI. Missing: whether they want up-to-date numbers/news and the timeframe.","Live market/news data is not present in provided context; must avoid quoting current figures without web retrieval.","Live market/news/earnings figures are not present in provided context; must fetch via web_search before quoting.","Live market/news/earnings data is not present in the provided context, so web retrieval is required before quoting figures."],"recent_tool_calls":[],"updated_at":"2026-04-08T23:23:41.255635+00:00"},"followup_pending":{},"intents":[],"last_event_kind":"conversation_turn_recorded","last_source_event_id":"evt_26b594a29646","last_user_text":"yes","open_loop_count":0,"resolver_semantic_capture":{"capture_event_id":"idlecap_ddb83c96625f10d1","captured_at":"2026-04-08T23:23:40.187759+00:00","last_capture_mode":"thread_idle","last_idle_source_event_ids":["evt_27172dd25449","evt_9343eb827cfa","evt_77631cfecc2d","evt_8a0d624cc69a"],"last_idle_user_source_event_id":"evt_8a0d624cc69a","last_idle_user_turn_id":"turn_evt_8a0d624cc69a","last_inline_capture_event_id":"evt_8a0d624cc69a","last_inline_source_event_ids":["evt_8a0d624cc69a"],"last_inline_user_source_event_id":"evt_8a0d624cc69a","last_user_source_event_id":"evt_8a0d624cc69a","last_user_turn_id":"turn_evt_8a0d624cc69a","source_event_ids":["evt_27172dd25449","evt_9343eb827cfa","evt_77631cfecc2d","evt_8a0d624cc69a"]}}

TEXT

salience

REAL (default 0.0

updated_at

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

event_store.db — conversation_state

Update row thr_0a6a7f6b2a53749c5a in conversation_state