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 6860 in events
seq
Primary key.
INTEGER
id
evt_46202a921dee
TEXT NOT NULL
kind
episode_context_built
TEXT NOT NULL
ts
2026-04-08T14:54:41.537308+00:00
TEXT NOT NULL
actor
context_builder
TEXT
subject_entity_ids
[]
TEXT
payload
{"build_ms":128,"built_at":"2026-04-08T14:54:41.536252+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":"Omid is good. What's your 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_6fadf999dc61","history_rows:0","continuity_turns:0","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:54:41.432298-04:00","now_utc":"2026-04-08T14:54:41.432298+00:00","tz":"America/New_York"},"commitments":[],"constraints":[],"context_categories":["profile"],"conversation_continuity":{"state":{},"thread_id":"slkthr_5eac97f29663143422","transcript_block":"","turn_count":0,"turns":[]},"conversation_resume":{},"core_entities":[],"decisions":[],"episode_id":"ep_cf633a9bba3b","facts":[],"followup":null,"history":[{"id":"evt_6fadf999dc61","kind":"event","payload":{"actor":"opia_engine","confidence":1.0,"kind":"user_interaction","payload":{"slack":{"channel_id":"C0A8Q869CNL","message_ts":"9dd628fa-f822-4ada-8656-6674278c4bb5","request_id":"Ev0ARJQPJG1L","request_ts":"1775660069.589419","scope":"slack_thread","team_id":"T080P2Q255E","text":"Omid is good. What's your name?","thread_ts":"1775601215.433909","thread_ts_present":true,"user_id":"U080CUSS45P","user_name":null},"source":"slack","text":"Omid is good. What's your name?","thread_id":"slkthr_5eac97f29663143422","ts":"2026-04-08T14:54:31.500703+00:00"},"seq":6851,"source_ref":"slack:T080P2Q255E:C0A8Q869CNL","ts":"2026-04-08T14:54:31.502178+00:00"},"title":"user_interaction","why":["trigger_event"]}],"inbox":[],"input_high_watermark":{"max_relevant_seq":6859},"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":{},"thread_id":"slkthr_5eac97f29663143422","thread_memory":{},"trace":{"build_trace":["context_categories:profile","retrieval_mode:spotlight","trace_id:trace:slkthr_5eac97f29663143422:evt_6fadf999dc61","history_rows:0","continuity_turns:0","signals:0","constraints:0 commitments:0 decisions:0 inbox:0 tasks:0"],"context_categories":["profile"],"freshness":"built_new","input_high_watermark_seq":6859,"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":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":0,"thread_memory_present":0,"transcript_entries":0},"trace_id":"trace:slkthr_5eac97f29663143422:evt_6fadf999dc61","version":"v1"},"trace_id":"trace:slkthr_5eac97f29663143422:evt_6fadf999dc61","transcript":{"count":0,"entries":[]},"trigger_event_id":"evt_6fadf999dc61","turn_id":"turn_evt_6fadf999dc61","user_text":"Omid is good. What's your name?"},"context_categories":["profile"],"context_contract_version":"v1","context_dedupe_key":"ctx:dadc2a7aded4","context_trace":{"build_trace":["context_categories:profile","retrieval_mode:spotlight","trace_id:trace:slkthr_5eac97f29663143422:evt_6fadf999dc61","history_rows:0","continuity_turns:0","signals:0","constraints:0 commitments:0 decisions:0 inbox:0 tasks:0"],"context_categories":["profile"],"freshness":"built_new","input_high_watermark_seq":6859,"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":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":0,"thread_memory_present":0,"transcript_entries":0},"trace_id":"trace:slkthr_5eac97f29663143422:evt_6fadf999dc61","version":"v1"},"episode_id":"ep_cf633a9bba3b","intent":"triage","retrieval_mode":"spotlight","thread_id":"slkthr_5eac97f29663143422","trace_id":"trace:slkthr_5eac97f29663143422:evt_6fadf999dc61","trigger_event_id":"evt_6fadf999dc61","turn_id":"turn_evt_6fadf999dc61"}
TEXT NOT NULL
source_ref
NULL
TEXT
confidence
REAL (default 0.0
dedupe_key
ctx:dadc2a7aded4
TEXT
episode_id
ep_cf633a9bba3b
TEXT
created_at
2026-04-08T14:54:41.537664+00:00
TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')
Update
Cancel