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":"conversation_mode","source":"user_text","value":"fun, non-work life/existence/personal conversations (one question at a time)"},{"confidence":0.95,"key":"signature_detail","source":"user_text","value":"pickle sauce"}],"last_intent_summary":"User is reacting humorously that the assistant is focusing too much on the lamb burger/pickle sauce detail; they likely want to pivot away from that topic while keeping the one-question-at-a-time, non-work vibe.","last_reasoning_mode":"conversation","notes":["No actionable tasks or missing internal facts identified; this is a social check-in.","User requested one question at a time.","User requested one question at a time; continue with a single follow-up question.","User asked for one question at a time; continue with a single follow-up.","User previously asked for one question at a time; continue with a single targeted question about the lamb burger.","User is discussing Marian\u2019s lamb burgers; next step is to elicit the specific signature detail.","User requested one question at a time; keep response to a single follow-up question.","User said: \"you're focusing too much on this lol\" indicating a desire to move on from the pickle sauce detail."],"recent_tool_calls":[],"updated_at":"2026-04-11T21:45:38.634342+00:00"},"followup_pending":{},"intents":["followup","question"],"last_event_kind":"conversation_turn_recorded","last_source_event_id":"evt_c7e6cb96b809","last_user_text":"you're focusing too much on this lol","open_loop_count":0,"resolver_semantic_capture":{"capture_event_id":"idlecap_c98956cc25541e99","captured_at":"2026-04-11T21:45:34.954310+00:00","last_capture_mode":"thread_idle","last_idle_source_event_ids":["evt_21348867f32e","evt_c22d642a1b28","evt_81d549ecdf57","evt_f04cf848aca6","evt_e58e1518b26f","evt_fe558de13383","evt_e24a8371b065","evt_774ac2bcf851"],"last_idle_user_source_event_id":"evt_774ac2bcf851","last_idle_user_turn_id":"turn_evt_774ac2bcf851","last_inline_capture_event_id":"evt_774ac2bcf851","last_inline_source_event_ids":["evt_774ac2bcf851"],"last_inline_user_source_event_id":"evt_774ac2bcf851","last_user_source_event_id":"evt_774ac2bcf851","last_user_turn_id":"turn_evt_774ac2bcf851","source_event_ids":["evt_21348867f32e","evt_c22d642a1b28","evt_81d549ecdf57","evt_f04cf848aca6","evt_e58e1518b26f","evt_fe558de13383","evt_e24a8371b065","evt_774ac2bcf851"]}}

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