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.6,"key":"user_name","source":"owner_display_name in provided context","value":"Omid"},{"confidence":0.9,"key":"recipient_name","source":"user_text","value":"Marian"},{"confidence":0.8,"key":"joke_text","source":"thread_focus_latest","value":"I tried to organize my sock drawer by color\u2026 Turns out I\u2019m not a \u201cfashion person.\u201d I\u2019m a \u201cpair-onomics\u201d person. \ud83e\udde6\ud83d\udca5"}],"last_intent_summary":"User wants to email the (previous) joke to their girlfriend Marian.","last_reasoning_mode":"conversation","notes":["User\u2019s name/identity is not present in thread context, so it is unknown.","User\u2019s name is not present in provided thread context; assistant must ask for it.","Thread still had no explicit user name in-chat, but the provided context lists owner_display_name as Omid.","No further missing details needed to tell a joke.","User requested an original joke (previous joke was already given).","Email sending requires Marian\u2019s email address, which is not provided."],"recent_tool_calls":[],"updated_at":"2026-04-08T21:09:10.123109+00:00"},"followup_pending":{"pend_69af741fe6":"What\u2019s Marian\u2019s email address, and should I send the exact joke as-is or with changes?"},"intents":["followup","question"],"last_event_kind":"conversation_turn_recorded","last_source_event_id":"evt_3de90b9e26c8","last_user_text":"okay that's funny, email this joke to my girlfriend Marian","open_loop_count":1,"resolver_semantic_capture":{"capture_event_id":"idlecap_75ca0217b30470e4","captured_at":"2026-04-08T21:09:09.080587+00:00","last_capture_mode":"thread_idle","last_idle_source_event_ids":["evt_7902baf4e792","evt_ef86aa1b9d10","evt_2012b2ddb4b9","evt_e3e6c107dec1","evt_ccf5dfe93109","evt_c2e910660f95"],"last_idle_user_source_event_id":"evt_c2e910660f95","last_idle_user_turn_id":"turn_evt_c2e910660f95","last_inline_capture_event_id":"evt_c2e910660f95","last_inline_source_event_ids":["evt_c2e910660f95"],"last_inline_user_source_event_id":"evt_c2e910660f95","last_user_source_event_id":"evt_c2e910660f95","last_user_turn_id":"turn_evt_c2e910660f95","source_event_ids":["evt_7902baf4e792","evt_ef86aa1b9d10","evt_2012b2ddb4b9","evt_e3e6c107dec1","evt_ccf5dfe93109","evt_c2e910660f95"]}}

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