Create
Query
event_store.db
—
events
actions
approvals
artifacts
commitments
constraints
conversation_state
conversation_turns
dead_letters
decisions
deliveries
effects
email_messages
email_reply_drafts
email_threads
entities
entity_aliases
entity_tags
episode_context_index
episodes
event_subjects
events
events_archive
fact_sources
facts
inbox_items
inbox_links
jobs
leader_leases
links
memory_candidates
memory_embeddings
memory_items
memory_items_fts
(v)
memory_items_fts_config
memory_items_fts_data
memory_items_fts_idx
opportunity_memory
pending_interactions
proposal_sources
proposals
reminders
schedules
schema_migrations
signal_candidates
signal_fps
signals
sms_conversations
sms_messages
sms_reply_drafts
source_cursors
sources
sqlite_sequence
sqlite_stat1
stream_cursors
threads
watchers
Toggle helper tables
memory_items_fts_content
memory_items_fts_docsize
memory_items_fts_segdir
memory_items_fts_segments
memory_items_fts_stat
Structure
Content
Query
Insert
Drop
Import
Export
Update row 29 in events
seq
Primary key.
INTEGER
id
evt_5965257a6d01
TEXT NOT NULL
kind
episode_context_built
TEXT NOT NULL
ts
2026-04-03T10:42:09.526914+00:00
TEXT NOT NULL
actor
context_builder
TEXT
subject_entity_ids
[]
TEXT
payload
{"build_ms":166,"built_at":"2026-04-03T10:42:09.526129+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":"hey how are you angela?"},"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:personal","retrieval_mode:spotlight","trace_id:trace:slkthr_a58340c08bcc950f94:evt_895716b3e647","history_rows:0","thread_messages:1","thread_focus_messages:1","continuity_turns:0","seed_fallback:+0","core_entities_seeded:0","support_entities_seeded:0","facts:0","signals:0","constraints:0 commitments:0 decisions:0 inbox:0 tasks:0"],"clock":{"local_date":"2026-04-03","local_day_bucket":"2026-04-03","now_local":"2026-04-03T06:42:09.373861-04:00","now_utc":"2026-04-03T10:42:09.373861+00:00","tz":"America/New_York"},"commitments":[],"constraints":[],"context_categories":["personal"],"conversation_continuity":{"state":{},"thread_id":"slkthr_a58340c08bcc950f94","transcript_block":"","turn_count":0,"turns":[]},"conversation_resume":{},"core_entities":[],"decisions":[],"episode_id":"ep_ebe265c65a33","facts":[],"followup":null,"history":[{"id":"evt_895716b3e647","kind":"event","payload":{"actor":"opia_engine","confidence":1.0,"kind":"user_interaction","payload":{"slack":{"channel_id":"C0A8Q869CNL","message_ts":"5A61F120-F2DD-4C33-8B32-1A1C9E9C496C","request_id":"Ev0AQU8630DA","request_ts":"1775212914.813239","scope":"slack_thread","team_id":"T080P2Q255E","text":"hey how are you angela?","thread_ts":"1775212914.813239","thread_ts_present":false,"user_id":"U080CUSS45P","user_name":null},"source":"slack","text":"hey how are you angela?","thread_id":"slkthr_a58340c08bcc950f94","ts":"2026-04-03T10:41:57.419164+00:00"},"seq":18,"source_ref":"slack:T080P2Q255E:C0A8Q869CNL","ts":"2026-04-03T10:41:57.419605+00:00"},"title":"user_interaction","why":["trigger_event"]}],"inbox":[],"input_high_watermark":{"max_relevant_seq":28},"intent":"triage","limits":{"context_categories":["personal"],"context_ttl_s":45,"history_days":3,"history_events":18,"local_day_bucket":"2026-04-03","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":{"conversation_continuity":"","conversation_turns":0,"items":[],"memory_context":"","memory_evidence":{"primary":[]},"memory_pinned":"","memory_profile":{},"memory_retrieval_details":{"primary":[]},"memory_snapshot":{},"memory_stats":{},"retrieved_count":0},"plan":null,"profile":{},"signals":[],"supporting_entities":[],"tasks":[],"thread_focus":{"entities":[],"latest":{"artifact_id":"","at":"2026-04-03T10:42:01.210964+00:00","brief_artifact_id":"","case_id":"","delivery_fp":"ack:slkthr_a58340c08bcc950f94:evt_895716b3e647","dossier_artifact_id":"","event_id":"evt_514a23b27f19","headline":"","message_kind":"thread_reply","mission":{},"named_entities":[],"recommendation":"","refs":[],"related_assets":[],"source":"","source_title":"","source_url":"","sources":[],"summary":"","text_preview":"Got it \u2014 moving on this now.","time_horizon":"","validation_steps":[],"why_now":"","why_you":""},"messages":[{"artifact_id":"","at":"2026-04-03T10:42:01.210964+00:00","brief_artifact_id":"","case_id":"","delivery_fp":"ack:slkthr_a58340c08bcc950f94:evt_895716b3e647","dossier_artifact_id":"","event_id":"evt_514a23b27f19","headline":"","message_kind":"thread_reply","mission":{},"named_entities":[],"recommendation":"","refs":[],"related_assets":[],"source":"","source_title":"","source_url":"","sources":[],"summary":"","text_preview":"Got it \u2014 moving on this now.","time_horizon":"","validation_steps":[],"why_now":"","why_you":""}],"refs":[],"topic_hint":"Got it \u2014 moving on this now."},"thread_id":"slkthr_a58340c08bcc950f94","thread_memory":{},"trace":{"build_trace":["context_categories:personal","retrieval_mode:spotlight","trace_id:trace:slkthr_a58340c08bcc950f94:evt_895716b3e647","history_rows:0","thread_messages:1","thread_focus_messages:1","continuity_turns:0","seed_fallback:+0","core_entities_seeded:0","support_entities_seeded:0","facts:0","signals:0","constraints:0 commitments:0 decisions:0 inbox:0 tasks:0"],"context_categories":["personal"],"freshness":"built_new","input_high_watermark_seq":28,"local_day_bucket":"2026-04-03","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":true,"plan":false,"profile":false,"signals":false,"tasks":false},"sections_populated":["memory"],"sections_requested":["entities","facts","constraints","commitments","decisions","inbox","tasks","memory","profile","briefs"],"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:slkthr_a58340c08bcc950f94:evt_895716b3e647","version":"v1"},"trace_id":"trace:slkthr_a58340c08bcc950f94:evt_895716b3e647","transcript":{"count":0,"entries":[]},"trigger_event_id":"evt_895716b3e647","turn_id":"turn_evt_895716b3e647","user_text":"hey how are you angela?"},"context_categories":["personal"],"context_contract_version":"v1","context_dedupe_key":"ctx:ed24e8da2603","context_trace":{"build_trace":["context_categories:personal","retrieval_mode:spotlight","trace_id:trace:slkthr_a58340c08bcc950f94:evt_895716b3e647","history_rows:0","thread_messages:1","thread_focus_messages:1","continuity_turns:0","seed_fallback:+0","core_entities_seeded:0","support_entities_seeded:0","facts:0","signals:0","constraints:0 commitments:0 decisions:0 inbox:0 tasks:0"],"context_categories":["personal"],"freshness":"built_new","input_high_watermark_seq":28,"local_day_bucket":"2026-04-03","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":true,"plan":false,"profile":false,"signals":false,"tasks":false},"sections_populated":["memory"],"sections_requested":["entities","facts","constraints","commitments","decisions","inbox","tasks","memory","profile","briefs"],"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:slkthr_a58340c08bcc950f94:evt_895716b3e647","version":"v1"},"episode_id":"ep_ebe265c65a33","intent":"triage","retrieval_mode":"spotlight","thread_id":"slkthr_a58340c08bcc950f94","trace_id":"trace:slkthr_a58340c08bcc950f94:evt_895716b3e647","trigger_event_id":"evt_895716b3e647","turn_id":"turn_evt_895716b3e647"}
TEXT NOT NULL
source_ref
NULL
TEXT
confidence
REAL (default 0.0
dedupe_key
ctx:ed24e8da2603
TEXT
episode_id
ep_ebe265c65a33
TEXT
created_at
2026-04-03T10:42:09.526922+00:00
TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')
Update
Cancel