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.95,"key":"assistant_name","source":"assistant_frame","value":"Angela"},{"confidence":0.9,"key":"owner_display_name","source":"user message","value":"Omid"},{"confidence":0.9,"key":"recipient_name","source":"prior_cognition_state","value":"Marian"},{"confidence":0.9,"key":"sender_name","source":"prior_cognition_state","value":"Omid"},{"confidence":0.95,"key":"recipient_email","source":"user_text","value":"mare0987@gmail.com"},{"confidence":0.95,"key":"last_email_recipient","source":"thread evidence (email send confirmation)","value":"mare0987@gmail.com"},{"confidence":0.8,"key":"last_email_summary","source":"thread evidence (email send confirmation)","value":"\u201cA little smile from Omid\u201d"}],"last_intent_summary":"User asks what exact email content was sent to Marian.","last_reasoning_mode":"conversation","notes":["User name not present in provided thread context.","User\u2019s name was previously unknown in-thread; thread context suggests Omid, but user hasn\u2019t explicitly confirmed.","No additional internal facts needed to generate an original joke.","User requested: 'put this in an email message to my girlfriend Marian saying that I thought of her and I wanted her to smile'. Missing: Marian\u2019s email address and preferred subject line.","Subject line preference is still missing; email sending is blocked until subject is confirmed.","User confirmed \u201cpick one,\u201d so subject line can be selected automatically and email sending can proceed.","Available evidence confirms an email was sent and provides only a short summary (\u201cA little smile from Omid\u201d), not the full subject/body text."],"recent_tool_calls":[],"updated_at":"2026-04-08T22:14:55.714663+00:00"},"followup_pending":{},"intents":["followup","question","approval"],"last_event_kind":"conversation_turn_recorded","last_source_event_id":"evt_3b02db29a22a","last_user_text":"what exactly did you send her in the email?","open_loop_count":0,"resolver_semantic_capture":{"capture_event_id":"idlecap_3e96935c01a970f8","captured_at":"2026-04-08T22:14:53.361561+00:00","last_capture_mode":"thread_idle","last_idle_source_event_ids":["evt_afb9a2134503","evt_cfdf0e7afc40","evt_7cb7a9ffb73e","evt_badee0e89d43","evt_a602dd8f2383","evt_680353590205","evt_7b2af2a9eb37","evt_d0a2a0d8df97"],"last_idle_user_source_event_id":"evt_d0a2a0d8df97","last_idle_user_turn_id":"turn_evt_d0a2a0d8df97","last_inline_capture_event_id":"evt_d0a2a0d8df97","last_inline_source_event_ids":["evt_d0a2a0d8df97"],"last_inline_user_source_event_id":"evt_d0a2a0d8df97","last_user_source_event_id":"evt_d0a2a0d8df97","last_user_turn_id":"turn_evt_d0a2a0d8df97","source_event_ids":["evt_afb9a2134503","evt_cfdf0e7afc40","evt_7cb7a9ffb73e","evt_badee0e89d43","evt_a602dd8f2383","evt_680353590205","evt_7b2af2a9eb37","evt_d0a2a0d8df97"]}}

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_a323a945dfd434d4fa in conversation_state