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 3312 in events
seq
Primary key.
INTEGER
id
evt_eb7a62893d4b
TEXT NOT NULL
kind
planner_plan_built
TEXT NOT NULL
ts
2026-04-03T16:14:18.523856+00:00
TEXT NOT NULL
actor
planner
TEXT
subject_entity_ids
[]
TEXT
payload
{"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":60.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":"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":28.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."},{"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."}],"do_today":[],"meta":{"built_at":"2026-04-03T16:14:18.523856+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":"cf8112f9019c26ac37ac25f4930148c6c0acdb88","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":"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"},{"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"}],"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":60.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":"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":28.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."},{"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."}],"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":60.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":3,"do_now":3,"do_today":0,"inbox_in":2,"must_do":3,"parked":0,"pending_in":1,"should_do":0,"visible":3,"waiting":0},"daily_synthesis_source":"fallback","fingerprint":"cf8112f9019c26ac37ac25f4930148c6c0acdb88","planner_model":"gpt-4o-mini"}}
TEXT NOT NULL
source_ref
NULL
TEXT
confidence
REAL (default 0.0
dedupe_key
planner_plan_built:2026-04-03:1e2aec1ce230e096075c6e93a51a8fb7bb5555f6
TEXT
episode_id
NULL
TEXT
created_at
2026-04-03T16:14:18.995578+00:00
TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')
Update
Cancel