SQLite Web: event

seq

Primary key. INTEGER

id

TEXT NOT NULL

kind

TEXT NOT NULL

ts

TEXT NOT NULL

actor

TEXT

subject_entity_ids

TEXT

payload

{"build_ms":85,"built_at":"2026-04-08T22:07:11.558426+00:00","context":{"build_trace":["trace_id:trace:thr_a323a945dfd434d4fa:evt_afb9a2134503","thread_messages:1","thread_focus_latest:1"],"clock":{"local_date":"2026-04-08","local_day_bucket":"2026-04-08","now_local":"2026-04-08T18:07:11.540270-04:00","now_utc":"2026-04-08T22:07:11.540270+00:00","tz":"America/New_York"},"conversation_resume":{},"episode_id":"ep_f2b58de197c1","identity":{"assistant_name":"Angela","assistant_persona":"A calm, sharp LifeOS operator who is proactive, kind, and brutally clear.","assistant_tone":"Concise, warm, and decisive with a great sense of humor","owner_display_name":"Omid"},"input_high_watermark":{"max_relevant_seq":1993},"limits":{"context_ttl_s":45,"history_events":30,"local_day_bucket":"2026-04-08","payload_max_chars":1600,"thin_context":true,"tz":"America/New_York"},"thread_focus":{"latest":{"headline":"","summary":"Okay. I\u2019m taking care of it.","why_now":""}},"thread_id":"thr_a323a945dfd434d4fa","trace":{"build_trace":["trace_id:trace:thr_a323a945dfd434d4fa:evt_afb9a2134503","thread_messages:1","thread_focus_latest:1"],"freshness":"built_new","input_high_watermark_seq":1993,"local_day_bucket":"2026-04-08","resume_context":{"lineage_complete":false,"lineage_id":"","pending_id":"","pending_root_id":"","present":false,"reask_count":0,"reroute_count":0,"source":""},"section_presence":{"briefs":false,"commitments":false,"constraints":false,"decisions":false,"entities":false,"facts":false,"history":true,"inbox":false,"memory":false,"plan":false,"profile":false,"signals":false,"tasks":false},"sections_populated":["history"],"sections_requested":["history"],"slice_counts":{"approval_present":0,"brief_items":0,"commitments":0,"constraints":0,"continuity_turns":0,"core_entities":0,"decisions":0,"facts":0,"followup_present":0,"history":1,"inbox":0,"memory_items":0,"plan_items":0,"profile_present":0,"signals":0,"supporting_entities":0,"tasks":0,"thread_focus_messages":1,"thread_memory_present":0,"transcript_entries":0},"trace_id":"trace:thr_a323a945dfd434d4fa:evt_afb9a2134503","version":"v1"},"trace_id":"trace:thr_a323a945dfd434d4fa:evt_afb9a2134503","trigger_event_id":"evt_afb9a2134503","turn_id":"turn_evt_afb9a2134503","user_text":"hey how are you? what's your name? do you know mine?"},"context_contract_version":"v1","context_dedupe_key":"ctx:d0d1babe28c8","context_trace":{"build_trace":["trace_id:trace:thr_a323a945dfd434d4fa:evt_afb9a2134503","thread_messages:1","thread_focus_latest:1"],"freshness":"built_new","input_high_watermark_seq":1993,"local_day_bucket":"2026-04-08","resume_context":{"lineage_complete":false,"lineage_id":"","pending_id":"","pending_root_id":"","present":false,"reask_count":0,"reroute_count":0,"source":""},"section_presence":{"briefs":false,"commitments":false,"constraints":false,"decisions":false,"entities":false,"facts":false,"history":true,"inbox":false,"memory":false,"plan":false,"profile":false,"signals":false,"tasks":false},"sections_populated":["history"],"sections_requested":["history"],"slice_counts":{"approval_present":0,"brief_items":0,"commitments":0,"constraints":0,"continuity_turns":0,"core_entities":0,"decisions":0,"facts":0,"followup_present":0,"history":1,"inbox":0,"memory_items":0,"plan_items":0,"profile_present":0,"signals":0,"supporting_entities":0,"tasks":0,"thread_focus_messages":1,"thread_memory_present":0,"transcript_entries":0},"trace_id":"trace:thr_a323a945dfd434d4fa:evt_afb9a2134503","version":"v1"},"episode_id":"ep_f2b58de197c1","thread_id":"thr_a323a945dfd434d4fa","trace_id":"trace:thr_a323a945dfd434d4fa:evt_afb9a2134503","trigger_event_id":"evt_afb9a2134503","turn_id":"turn_evt_afb9a2134503"}

TEXT NOT NULL

source_ref

TEXT

confidence

REAL (default 0.0

dedupe_key

TEXT

episode_id

TEXT

created_at

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

event_store.db — events

Update row 1994 in events