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 4088 in events
seq
Primary key.
INTEGER
id
evt_c9f9244a563c
TEXT NOT NULL
kind
artifact_upsert
TEXT NOT NULL
ts
2026-04-03T18:34:33.231041+00:00
TEXT NOT NULL
actor
planner
TEXT
subject_entity_ids
[]
TEXT
payload
{"artifact_id":"art_daily_plan_2026-04-03","confidence":0.95,"created_at":"2026-04-03T18:34:33.231041+00:00","evidence_event_ids":[],"kind":"daily_plan","meta":{"day":"2026-04-03","fingerprint":"15f65675c3e064463afa56629c7ef8b6b777a3b4","plan_fingerprint":"aea87866b09b9eb644ab2114e8b4a858110d0004","source":"planner"},"output_json":{"day":"2026-04-03","plan":{"day":"2026-04-03","do_now":[{"actionable":true,"blocked_reason":null,"deadline_at_iso":null,"entity_ref":null,"headline":"What should the subject and body of the email be?","id":"pend_d733ac1aa3","kind":"followup","links":{"action_id":null,"action_type":null,"approval_id":null,"choices":[],"event_id":"evt_de327c9699d4","pending_kind":"missing_detail","source":"proposal_materializer","thread_id":"slkthr_776445451af92b39e8"},"next_touch_at_iso":null,"route":"today","score":57.0,"score_hint":6.0,"source_kind":"pending","tags":["missing_detail"],"ts":"2026-04-03T11:49:25.005404+00:00","urgency":"high","user_visible":true,"waiting_on":null,"why_it_matters":"The workflow cannot continue until the missing message details are provided."},{"actionable":true,"blocked_reason":null,"deadline_at_iso":null,"entity_ref":null,"headline":"What time should I set the reminder for?","id":"pend_f28953ab97","kind":"followup","links":{"action_id":null,"action_type":null,"approval_id":null,"choices":[],"event_id":"evt_e5895b10c1f4","pending_kind":"missing_detail","source":"proposal_materializer","thread_id":"slkthr_3595c4fe869b7e7b4a"},"next_touch_at_iso":null,"route":"today","score":44.0,"score_hint":0.0,"source_kind":"pending","tags":["missing_detail"],"ts":"2026-04-03T18:24:11.344252+00:00","urgency":"medium","user_visible":true,"waiting_on":null,"why_it_matters":"This workflow is waiting on information only you can provide."},{"actionable":true,"blocked_reason":null,"deadline_at_iso":null,"entity_ref":null,"headline":"Market dynamics shift detected","id":"sig:b78ce9dc1777f89a","kind":"inbox","links":{"dedupe_key":"opportunity_case_memory:case_4862a18a2c6d80ef:digest:2026-04-03T15","evidence_event_ids":["evt_7b7990b81775","evt_85ae61f3366f","evt_2292508410a3","evt_fca6ad816b53","evt_e10a83e9426b","evt_fb406f4d8256","evt_d42d3d00152c","evt_a707fa8c771a"],"reason_trace":{"_evidence_event_ids":["evt_85ae61f3366f","evt_2292508410a3","evt_fca6ad816b53","evt_e10a83e9426b","evt_fb406f4d8256","evt_d42d3d00152c","evt_a707fa8c771a"],"case_id":"case_4862a18a2c6d80ef","decision":"digest","entity_key":"commodity:silver","memory_only":true,"theme_key":"entity_development"},"severity":"low","signal_id":"sig_bbfa0e633f8a","signal_type":"opportunity_case_memory","source":"opportunity_finder","topic_key":"signal:opportunity_case_memory:efbf3229de766839","triage":{"action_hints":["schedule review"],"confidence":0.0,"disposition":"park","entity_ids":[],"headline":"Market dynamics shift detected","prior":{"family":"general","importance_band":"background","suggested_disposition":"park","suggested_route":"review","suggested_urgency":"low"},"priority_score":10.0,"rationale":"Strong indicators suggest a significant shift in market dynamics that warrants future review.","review_in_days":30,"route":"review","urgency":"low"},"user_visible":false},"next_touch_at_iso":null,"route":"review","score":28.0,"score_hint":0.0,"source_kind":"signal","tags":["family:general","priority:low","route:review","severity:low","signal","signal:opportunity_case_memory","source:opportunity_finder","triage:park","urgency:low"],"ts":"2026-04-03T15:19:13.881689+00:00","urgency":"low","user_visible":true,"waiting_on":null,"why_it_matters":"Strong indicators suggest a significant shift in market dynamics that warrants future review."},{"actionable":true,"blocked_reason":null,"deadline_at_iso":null,"entity_ref":null,"headline":"Opportunity digest highlights emerging market trends.","id":"sig:2cdee0c67c08c91a","kind":"inbox","links":{"dedupe_key":"opportunity_digest:2026-04-03","evidence_event_ids":["evt_a136b8c5f102","evt_11f03d958176"],"reason_trace":{"_evidence_event_ids":["evt_11f03d958176"]},"severity":"low","signal_id":"sig_0bdc74365c6c","signal_type":"opportunity_digest","source":"opportunity_finder","topic_key":"signal:opportunity_digest:21893b6e58093d4c","triage":{"action_hints":["schedule review"],"confidence":0.65,"disposition":"park","entity_ids":[],"headline":"Opportunity digest highlights emerging market trends.","prior":{"family":"digest","importance_band":"informational","suggested_disposition":"park","suggested_route":"review","suggested_urgency":"low"},"priority_score":17.7,"rationale":"The digest indicates potential market shifts that may require further analysis later.","review_in_days":30,"route":"review","urgency":"low"},"user_visible":false},"next_touch_at_iso":null,"route":"review","score":25.0,"score_hint":0.0,"source_kind":"signal","tags":["family:digest","priority:medium","route:review","severity:low","signal","signal:opportunity_digest","source:opportunity_finder","triage:park","urgency:low"],"ts":"2026-04-03T10:53:43.507470+00:00","urgency":"low","user_visible":true,"waiting_on":null,"why_it_matters":"The digest indicates potential market shifts that may require further analysis later."}],"do_today":[],"meta":{"built_at":"2026-04-03T18:34:33.231041+00:00","daily_synthesis_source":"fallback","day":"2026-04-03","filters":{"deduped":0,"internal_shadow":0,"noise_signal":1,"stale":0,"stale_question":0,"stale_workflow":0},"fingerprint":"46fddef83e93ebf7c2bee733da45bf49c173b39c","intelligence_directives":[{"action_type":null,"confidence":0.55,"evidence_event_id":null,"headline":"What should the subject and body of the email be?","implication":"This item is currently one of the highest-leverage moves for trajectory control.","recommended_action":"Do this next: What should the subject and body of the email be?","source":"heuristic","urgency":"high"},{"action_type":null,"confidence":0.55,"evidence_event_id":null,"headline":"What time should I set the reminder for?","implication":"This item is currently one of the highest-leverage moves for trajectory control.","recommended_action":"Do this next: What time should I set the reminder for?","source":"heuristic","urgency":"medium"},{"action_type":null,"confidence":0.55,"evidence_event_id":null,"headline":"Market dynamics shift detected","implication":"This item is currently one of the highest-leverage moves for trajectory control.","recommended_action":"Do this next: Market dynamics shift detected","source":"heuristic","urgency":"low"},{"action_type":null,"confidence":0.55,"evidence_event_id":null,"headline":"Opportunity digest highlights emerging market trends.","implication":"This item is currently one of the highest-leverage moves for trajectory control.","recommended_action":"Do this next: Opportunity digest highlights emerging market trends.","source":"heuristic","urgency":"low"}],"limits":{"limit_inbox":250,"limit_pending":50,"max_do_now":5,"max_do_today":7,"max_must_do":5,"max_park":25,"max_should_do":7,"max_waiting":5},"owner_context":{"active_projects":[],"commitments":[],"top_focus":null,"work_focus":null},"planner_model":"gpt-4o-mini","source":"planner","timezone":"America/New_York","week_start":"2026-03-30"},"must_do":[{"actionable":true,"blocked_reason":null,"deadline_at_iso":null,"entity_ref":null,"headline":"What should the subject and body of the email be?","id":"pend_d733ac1aa3","kind":"followup","links":{"action_id":null,"action_type":null,"approval_id":null,"choices":[],"event_id":"evt_de327c9699d4","pending_kind":"missing_detail","source":"proposal_materializer","thread_id":"slkthr_776445451af92b39e8"},"next_touch_at_iso":null,"route":"today","score":57.0,"score_hint":6.0,"source_kind":"pending","tags":["missing_detail"],"ts":"2026-04-03T11:49:25.005404+00:00","urgency":"high","user_visible":true,"waiting_on":null,"why_it_matters":"The workflow cannot continue until the missing message details are provided."},{"actionable":true,"blocked_reason":null,"deadline_at_iso":null,"entity_ref":null,"headline":"What time should I set the reminder for?","id":"pend_f28953ab97","kind":"followup","links":{"action_id":null,"action_type":null,"approval_id":null,"choices":[],"event_id":"evt_e5895b10c1f4","pending_kind":"missing_detail","source":"proposal_materializer","thread_id":"slkthr_3595c4fe869b7e7b4a"},"next_touch_at_iso":null,"route":"today","score":44.0,"score_hint":0.0,"source_kind":"pending","tags":["missing_detail"],"ts":"2026-04-03T18:24:11.344252+00:00","urgency":"medium","user_visible":true,"waiting_on":null,"why_it_matters":"This workflow is waiting on information only you can provide."},{"actionable":true,"blocked_reason":null,"deadline_at_iso":null,"entity_ref":null,"headline":"Market dynamics shift detected","id":"sig:b78ce9dc1777f89a","kind":"inbox","links":{"dedupe_key":"opportunity_case_memory:case_4862a18a2c6d80ef:digest:2026-04-03T15","evidence_event_ids":["evt_7b7990b81775","evt_85ae61f3366f","evt_2292508410a3","evt_fca6ad816b53","evt_e10a83e9426b","evt_fb406f4d8256","evt_d42d3d00152c","evt_a707fa8c771a"],"reason_trace":{"_evidence_event_ids":["evt_85ae61f3366f","evt_2292508410a3","evt_fca6ad816b53","evt_e10a83e9426b","evt_fb406f4d8256","evt_d42d3d00152c","evt_a707fa8c771a"],"case_id":"case_4862a18a2c6d80ef","decision":"digest","entity_key":"commodity:silver","memory_only":true,"theme_key":"entity_development"},"severity":"low","signal_id":"sig_bbfa0e633f8a","signal_type":"opportunity_case_memory","source":"opportunity_finder","topic_key":"signal:opportunity_case_memory:efbf3229de766839","triage":{"action_hints":["schedule review"],"confidence":0.0,"disposition":"park","entity_ids":[],"headline":"Market dynamics shift detected","prior":{"family":"general","importance_band":"background","suggested_disposition":"park","suggested_route":"review","suggested_urgency":"low"},"priority_score":10.0,"rationale":"Strong indicators suggest a significant shift in market dynamics that warrants future review.","review_in_days":30,"route":"review","urgency":"low"},"user_visible":false},"next_touch_at_iso":null,"route":"review","score":28.0,"score_hint":0.0,"source_kind":"signal","tags":["family:general","priority:low","route:review","severity:low","signal","signal:opportunity_case_memory","source:opportunity_finder","triage:park","urgency:low"],"ts":"2026-04-03T15:19:13.881689+00:00","urgency":"low","user_visible":true,"waiting_on":null,"why_it_matters":"Strong indicators suggest a significant shift in market dynamics that warrants future review."},{"actionable":true,"blocked_reason":null,"deadline_at_iso":null,"entity_ref":null,"headline":"Opportunity digest highlights emerging market trends.","id":"sig:2cdee0c67c08c91a","kind":"inbox","links":{"dedupe_key":"opportunity_digest:2026-04-03","evidence_event_ids":["evt_a136b8c5f102","evt_11f03d958176"],"reason_trace":{"_evidence_event_ids":["evt_11f03d958176"]},"severity":"low","signal_id":"sig_0bdc74365c6c","signal_type":"opportunity_digest","source":"opportunity_finder","topic_key":"signal:opportunity_digest:21893b6e58093d4c","triage":{"action_hints":["schedule review"],"confidence":0.65,"disposition":"park","entity_ids":[],"headline":"Opportunity digest highlights emerging market trends.","prior":{"family":"digest","importance_band":"informational","suggested_disposition":"park","suggested_route":"review","suggested_urgency":"low"},"priority_score":17.7,"rationale":"The digest indicates potential market shifts that may require further analysis later.","review_in_days":30,"route":"review","urgency":"low"},"user_visible":false},"next_touch_at_iso":null,"route":"review","score":25.0,"score_hint":0.0,"source_kind":"signal","tags":["family:digest","priority:medium","route:review","severity:low","signal","signal:opportunity_digest","source:opportunity_finder","triage:park","urgency:low"],"ts":"2026-04-03T10:53:43.507470+00:00","urgency":"low","user_visible":true,"waiting_on":null,"why_it_matters":"The digest indicates potential market shifts that may require further analysis later."}],"notes":[],"one_thing":{"actionable":true,"blocked_reason":null,"deadline_at_iso":null,"entity_ref":null,"headline":"What should the subject and body of the email be?","id":"pend_d733ac1aa3","kind":"followup","links":{"action_id":null,"action_type":null,"approval_id":null,"choices":[],"event_id":"evt_de327c9699d4","pending_kind":"missing_detail","source":"proposal_materializer","thread_id":"slkthr_776445451af92b39e8"},"next_touch_at_iso":null,"route":"today","score":57.0,"score_hint":6.0,"source_kind":"pending","tags":["missing_detail"],"ts":"2026-04-03T11:49:25.005404+00:00","urgency":"high","user_visible":true,"waiting_on":null,"why_it_matters":"The workflow cannot continue until the missing message details are provided."},"parked":[],"should_do":[],"version":"planner_v3_hybrid","waiting":[]},"stats":{"builder":"deterministic_v2","counts":{"actionable":4,"do_now":4,"do_today":0,"inbox_in":2,"must_do":4,"parked":0,"pending_in":2,"should_do":0,"visible":4,"waiting":0},"daily_synthesis_source":"fallback","fingerprint":"46fddef83e93ebf7c2bee733da45bf49c173b39c","planner_model":"gpt-4o-mini"}},"output_mrkdwn":"*Daily Plan* \u2014 2026-04-03\n\n*One thing:* What should the subject and body of the email be?\nWhy: The workflow cannot continue until the missing message details are provided.\n\n*Do now:*\n\u2022 What should the subject and body of the email be? \u2014 The workflow cannot continue until the missing message details are provided.\n\u2022 What time should I set the reminder for? \u2014 This workflow is waiting on information only you can provide.\n\u2022 Market dynamics shift detected \u2014 Strong indicators suggest a significant shift in market dynamics that warrants future review.\n\u2022 Opportunity digest highlights emerging market trends. \u2014 The digest indicates potential market shifts that may require further analysis later.\n\n*Intelligence:*\n\u2022 Do this next: What should the subject and body of the email be? \u2014 This item is currently one of the highest-leverage moves for trajectory control.\n\u2022 Do this next: What time should I set the reminder for? \u2014 This item is currently one of the highest-leverage moves for trajectory control.\n\u2022 Do this next: Market dynamics shift detected \u2014 This item is currently one of the highest-leverage moves for trajectory control.","ready_at":"2026-04-03T18:34:33.231041+00:00","status":"ready","summary":"What should the subject and body of the email be?","title":"Daily Plan 2026-04-03","updated_at":"2026-04-03T18:34:33.231041+00:00"}
TEXT NOT NULL
source_ref
NULL
TEXT
confidence
REAL (default 0.0
dedupe_key
artifact_upsert:daily_plan:2026-04-03:15f65675c3e064463afa56629c7ef8b6b777a3b4
TEXT
episode_id
NULL
TEXT
created_at
2026-04-03T18:34:33.322155+00:00
TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')
Update
Cancel