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":171,"built_at":"2026-04-08T14:55:17.333527+00:00","context":{"active_state":{"approvals":{"latest_ids":[],"open_count":0},"current_turn":{"intent":"triage","resume_pending_root_id":"","resume_source":"","retrieval_mode":"spotlight","user_text":"what's my name?"},"episode":{"applied_types":[],"approval_ids":[],"router_intent":"triage","stage":"created","summary_headline":""},"followup":{"action_type":"","kind":"","pending_id":"","present":false,"question":"","source":""},"mission":{"case_id":"","headline":"","kind":"","recommended_action":"","why_now":""}},"approvals":[],"briefs":{"items":[]},"build_trace":["context_categories:profile","retrieval_mode:spotlight","trace_id:trace:slkthr_5eac97f29663143422:evt_95c6917b38d2","history_rows:0","thread_messages:1","thread_focus_messages:1","continuity_turns:2","transcript_authoritative:continuity:2","signals:0","constraints:0 commitments:0 decisions:0 inbox:0 tasks:0"],"clock":{"local_date":"2026-04-08","local_day_bucket":"2026-04-08","now_local":"2026-04-08T10:55:17.186722-04:00","now_utc":"2026-04-08T14:55:17.186722+00:00","tz":"America/New_York"},"commitments":[],"constraints":[],"context_categories":["profile"],"conversation_continuity":{"state":{"intents":["followup","question"],"open_loops":[],"rolling_summary":"U:Omid is good. What's your name? | A:I\u2019m Angela \u2014 the cognition layer of OPIA. (And yes, Omid is good.)","salience":0.54,"updated_at":"2026-04-08T14:54:57.426542+00:00"},"thread_id":"slkthr_5eac97f29663143422","transcript_block":"RECENT THREAD SUMMARY:\n- U:Omid is good. What's your name? | A:I\u2019m Angela \u2014 the cognition layer of OPIA. (And yes, Omid is good.)\nRECENT THREAD TRANSCRIPT:\n- user: Omid is good. What's your name?\n- assistant: I\u2019m Angela \u2014 the cognition layer of OPIA. (And yes, Omid is good.)","turn_count":2,"turns":[{"at":"2026-04-08T14:54:39.488195+00:00","id":"turn_evt_6fadf999dc61","role":"user","source":"slack","text":"Omid is good. What's your name?"},{"at":"2026-04-08T14:54:49.498185+00:00","id":"turn_evt_5aa9cced9389","role":"assistant","source":"slack","text":"I\u2019m Angela \u2014 the cognition layer of OPIA. (And yes, Omid is good.)"}]},"conversation_resume":{},"core_entities":[],"decisions":[],"episode_id":"ep_b4426097e1d8","facts":[],"followup":null,"history":[{"id":"evt_95c6917b38d2","kind":"event","payload":{"actor":"opia_engine","confidence":1.0,"kind":"user_interaction","payload":{"slack":{"channel_id":"C0A8Q869CNL","message_ts":"9b821b7c-7db2-46cb-b81d-ed0f4a1d04aa","request_id":"Ev0AREFJL4UT","request_ts":"1775660107.959879","scope":"slack_thread","team_id":"T080P2Q255E","text":"what's my name?","thread_ts":"1775601215.433909","thread_ts_present":true,"user_id":"U080CUSS45P","user_name":null},"source":"slack","text":"what's my name?","thread_id":"slkthr_5eac97f29663143422","ts":"2026-04-08T14:55:10.020157+00:00"},"seq":6876,"source_ref":"slack:T080P2Q255E:C0A8Q869CNL","ts":"2026-04-08T14:55:10.020608+00:00"},"title":"user_interaction","why":["trigger_event"]}],"inbox":[],"input_high_watermark":{"max_relevant_seq":6884},"intent":"triage","limits":{"context_categories":["profile"],"context_ttl_s":45,"history_days":3,"history_events":18,"local_day_bucket":"2026-04-08","max_core_entities":8,"max_facts":45,"max_inbox":12,"max_signals":15,"max_support_entities":0,"max_tasks":12,"payload_max_chars":1600,"retrieval_mode":"spotlight","tz":"America/New_York"},"memory":{},"plan":null,"profile":{},"signals":[],"supporting_entities":[],"tasks":[],"thread_focus":{"entities":[],"latest":{"artifact_id":"","at":"2026-04-08T14:54:49.487792+00:00","brief_artifact_id":"","case_id":"","delivery_fp":"slk_thread_reply:9e1e470a6f7295c7","dossier_artifact_id":"","event_id":"evt_a0139774929c","headline":"","message_kind":"thread_reply","mission":{},"named_entities":[],"recommendation":"","refs":[],"related_assets":[],"source":"","source_title":"","source_url":"","sources":[],"summary":"","text_preview":"I\u2019m Angela \u2014 the cognition layer of OPIA. (And yes, Omid is good.)","time_horizon":"","validation_steps":[],"why_now":"","why_you":""},"messages":[{"artifact_id":"","at":"2026-04-08T14:54:49.487792+00:00","brief_artifact_id":"","case_id":"","delivery_fp":"slk_thread_reply:9e1e470a6f7295c7","dossier_artifact_id":"","event_id":"evt_a0139774929c","headline":"","message_kind":"thread_reply","mission":{},"named_entities":[],"recommendation":"","refs":[],"related_assets":[],"source":"","source_title":"","source_url":"","sources":[],"summary":"","text_preview":"I\u2019m Angela \u2014 the cognition layer of OPIA. (And yes, Omid is good.)","time_horizon":"","validation_steps":[],"why_now":"","why_you":""}],"refs":[],"topic_hint":"I\u2019m Angela \u2014 the cognition layer of OPIA. (And yes, Omid is good.)"},"thread_id":"slkthr_5eac97f29663143422","thread_memory":{},"trace":{"build_trace":["context_categories:profile","retrieval_mode:spotlight","trace_id:trace:slkthr_5eac97f29663143422:evt_95c6917b38d2","history_rows:0","thread_messages:1","thread_focus_messages:1","continuity_turns:2","transcript_authoritative:continuity:2","signals:0","constraints:0 commitments:0 decisions:0 inbox:0 tasks:0"],"context_categories":["profile"],"freshness":"built_new","input_high_watermark_seq":6884,"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":""},"retrieval_mode":"spotlight","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":[],"sections_requested":["profile"],"slice_counts":{"approval_present":0,"brief_items":0,"commitments":0,"constraints":0,"continuity_turns":2,"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":2},"trace_id":"trace:slkthr_5eac97f29663143422:evt_95c6917b38d2","version":"v1"},"trace_id":"trace:slkthr_5eac97f29663143422:evt_95c6917b38d2","transcript":{"count":2,"entries":[{"at":"2026-04-08T14:54:39.488195+00:00","event_id":null,"message_id":null,"meta":{"source":"conversation_continuity","turn_id":"turn_evt_6fadf999dc61"},"role":"user","source":"slack","text":"Omid is good. What's your name?","user_id":null},{"at":"2026-04-08T14:54:49.498185+00:00","event_id":null,"message_id":null,"meta":{"source":"conversation_continuity","turn_id":"turn_evt_5aa9cced9389"},"role":"assistant","source":"slack","text":"I\u2019m Angela \u2014 the cognition layer of OPIA. (And yes, Omid is good.)","user_id":null}]},"trigger_event_id":"evt_95c6917b38d2","turn_id":"turn_evt_95c6917b38d2","user_text":"what's my name?"},"context_categories":["profile"],"context_contract_version":"v1","context_dedupe_key":"ctx:4002c48aaf7a","context_trace":{"build_trace":["context_categories:profile","retrieval_mode:spotlight","trace_id:trace:slkthr_5eac97f29663143422:evt_95c6917b38d2","history_rows:0","thread_messages:1","thread_focus_messages:1","continuity_turns:2","transcript_authoritative:continuity:2","signals:0","constraints:0 commitments:0 decisions:0 inbox:0 tasks:0"],"context_categories":["profile"],"freshness":"built_new","input_high_watermark_seq":6884,"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":""},"retrieval_mode":"spotlight","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":[],"sections_requested":["profile"],"slice_counts":{"approval_present":0,"brief_items":0,"commitments":0,"constraints":0,"continuity_turns":2,"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":2},"trace_id":"trace:slkthr_5eac97f29663143422:evt_95c6917b38d2","version":"v1"},"episode_id":"ep_b4426097e1d8","intent":"triage","retrieval_mode":"spotlight","thread_id":"slkthr_5eac97f29663143422","trace_id":"trace:slkthr_5eac97f29663143422:evt_95c6917b38d2","trigger_event_id":"evt_95c6917b38d2","turn_id":"turn_evt_95c6917b38d2"}

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 6885 in events