Create
Query
event_store.db
—
events
actions
approvals
artifacts
commitments
constraints
conversation_compaction
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 1821 in events
seq
Primary key.
INTEGER
id
evt_76e4967fcedb
TEXT NOT NULL
kind
planner_plan_built
TEXT NOT NULL
ts
2026-04-08T21:34:49.978429+00:00
TEXT NOT NULL
actor
planner
TEXT
subject_entity_ids
[]
TEXT
payload
{"day":"2026-04-08","plan":{"day":"2026-04-08","do_now":[{"actionable":true,"blocked_reason":null,"deadline_at_iso":null,"entity_ref":null,"headline":"What\u2019s Marian\u2019s email address, and should I send the exact joke as-is or with changes?","id":"pend_69af741fe6","kind":"followup","links":{"action_id":null,"action_type":"email_send","approval_id":null,"choices":[],"event_id":"evt_5dbea6a4b598","pending_kind":"missing_detail","source":"proposal_materializer","thread_id":"thr_3cb85089cf8d9aec18"},"next_touch_at_iso":null,"route":"today","score":60.0,"score_hint":6.0,"source_kind":"pending","tags":["missing_detail"],"ts":"2026-04-08T21:09:18.188900+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":"Technical indicator signal flagged as high severity (TVTX, 1d)","id":"sig:10706db12f1c9589","kind":"inbox","links":{"dedupe_key":"ta:technical_indicator_signal:bigMoveUp:big_move:TVTX:1d:2026-04-06T00:00:00Z:2026-04-08","evidence_event_ids":["evt_718def9d1fe2"],"reason_trace":{"cutoff_iso":"2026-04-05T20:35:04Z","eligible_timeframes":["1d"],"market_now":"2026-04-08T16:35:04.790359-04:00","period_key":"2026-04-08","recent_signal_hours":72,"signal_timestamp":"2026-04-06T00:00:00Z","strategy":"big_move"},"severity":"high","signal_id":"sig_8266541bced0","signal_type":"technical_indicator_signal","source":"technical_analyzer","topic_key":"signal:technical_indicator_signal:ec9e77491915df5d","triage":{"action_hints":["schedule review","verify signal context and whether it aligns with any active constraints or plans"],"confidence":0.62,"disposition":"park","entity_ids":[],"headline":"Technical indicator signal flagged as high severity (TVTX, 1d)","prior":{"family":"general","importance_band":"background","suggested_disposition":"park","suggested_route":"review","suggested_urgency":"low"},"priority_score":28.7,"rationale":"This is a non-user-visible technical signal with elevated tags but no clear immediate action or deadline, so it can be reviewed later for confirmation and context.","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:high","route:review","severity:high","signal","signal:technical_indicator_signal","source:technical_analyzer","triage:park","urgency:low"],"ts":"2026-04-08T20:35:04.790339+00:00","urgency":"low","user_visible":true,"waiting_on":null,"why_it_matters":"This is a non-user-visible technical signal with elevated tags but no clear immediate action or deadline, so it can be reviewed later for confirmation and context."},{"actionable":true,"blocked_reason":null,"deadline_at_iso":null,"entity_ref":null,"headline":"Technical indicator signal flagged high (big move up, 1d)","id":"sig:316f1079555a570e","kind":"inbox","links":{"dedupe_key":"ta:technical_indicator_signal:bigMoveUp:big_move:SSSS:1d:2026-04-08T00:00:00Z:2026-04-08","evidence_event_ids":["evt_479db44a8ea0"],"reason_trace":{"cutoff_iso":"2026-04-05T20:40:08Z","eligible_timeframes":["1d"],"market_now":"2026-04-08T16:40:08.728352-04:00","period_key":"2026-04-08","recent_signal_hours":72,"signal_timestamp":"2026-04-08T00:00:00Z","strategy":"big_move"},"severity":"high","signal_id":"sig_25924f783726","signal_type":"technical_indicator_signal","source":"technical_analyzer","topic_key":"signal:technical_indicator_signal:cadbf1c1d410acf9","triage":{"action_hints":["schedule review"],"confidence":0.62,"disposition":"park","entity_ids":[],"headline":"Technical indicator signal flagged high (big move up, 1d)","prior":{"family":"general","importance_band":"background","suggested_disposition":"park","suggested_route":"review","suggested_urgency":"low"},"priority_score":28.7,"rationale":"This is a non-user-visible technical signal with no grounded action details, so it can be reviewed later rather than acted on immediately.","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:high","route:review","severity:high","signal","signal:technical_indicator_signal","source:technical_analyzer","triage:park","urgency:low"],"ts":"2026-04-08T20:40:08.728332+00:00","urgency":"low","user_visible":true,"waiting_on":null,"why_it_matters":"This is a non-user-visible technical signal with no grounded action details, so it can be reviewed later rather than acted on immediately."}],"do_today":[],"meta":{"built_at":"2026-04-08T21:34:49.978429+00:00","daily_synthesis_source":"fallback","day":"2026-04-08","filters":{"deduped":1,"internal_shadow":0,"noise_signal":0,"stale":0,"stale_question":0,"stale_workflow":0},"fingerprint":"f6a967d7dc6aedbfe9910adc8c35ea57025428fb","intelligence_directives":[{"action_type":null,"confidence":0.55,"evidence_event_id":null,"headline":"What\u2019s Marian\u2019s email address, and should I send the exact joke as-is or with changes?","implication":"This item is currently one of the highest-leverage moves for trajectory control.","recommended_action":"Do this next: What\u2019s Marian\u2019s email address, and should I send the exact joke as-is or with changes?","source":"heuristic","urgency":"high"},{"action_type":null,"confidence":0.55,"evidence_event_id":null,"headline":"Technical indicator signal flagged as high severity (TVTX, 1d)","implication":"This item is currently one of the highest-leverage moves for trajectory control.","recommended_action":"Do this next: Technical indicator signal flagged as high severity (TVTX, 1d)","source":"heuristic","urgency":"low"},{"action_type":null,"confidence":0.55,"evidence_event_id":null,"headline":"Technical indicator signal flagged high (big move up, 1d)","implication":"This item is currently one of the highest-leverage moves for trajectory control.","recommended_action":"Do this next: Technical indicator signal flagged high (big move up, 1d)","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-5.4-nano","source":"planner","timezone":"America/New_York","week_start":"2026-04-06"},"must_do":[{"actionable":true,"blocked_reason":null,"deadline_at_iso":null,"entity_ref":null,"headline":"What\u2019s Marian\u2019s email address, and should I send the exact joke as-is or with changes?","id":"pend_69af741fe6","kind":"followup","links":{"action_id":null,"action_type":"email_send","approval_id":null,"choices":[],"event_id":"evt_5dbea6a4b598","pending_kind":"missing_detail","source":"proposal_materializer","thread_id":"thr_3cb85089cf8d9aec18"},"next_touch_at_iso":null,"route":"today","score":60.0,"score_hint":6.0,"source_kind":"pending","tags":["missing_detail"],"ts":"2026-04-08T21:09:18.188900+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":"Technical indicator signal flagged as high severity (TVTX, 1d)","id":"sig:10706db12f1c9589","kind":"inbox","links":{"dedupe_key":"ta:technical_indicator_signal:bigMoveUp:big_move:TVTX:1d:2026-04-06T00:00:00Z:2026-04-08","evidence_event_ids":["evt_718def9d1fe2"],"reason_trace":{"cutoff_iso":"2026-04-05T20:35:04Z","eligible_timeframes":["1d"],"market_now":"2026-04-08T16:35:04.790359-04:00","period_key":"2026-04-08","recent_signal_hours":72,"signal_timestamp":"2026-04-06T00:00:00Z","strategy":"big_move"},"severity":"high","signal_id":"sig_8266541bced0","signal_type":"technical_indicator_signal","source":"technical_analyzer","topic_key":"signal:technical_indicator_signal:ec9e77491915df5d","triage":{"action_hints":["schedule review","verify signal context and whether it aligns with any active constraints or plans"],"confidence":0.62,"disposition":"park","entity_ids":[],"headline":"Technical indicator signal flagged as high severity (TVTX, 1d)","prior":{"family":"general","importance_band":"background","suggested_disposition":"park","suggested_route":"review","suggested_urgency":"low"},"priority_score":28.7,"rationale":"This is a non-user-visible technical signal with elevated tags but no clear immediate action or deadline, so it can be reviewed later for confirmation and context.","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:high","route:review","severity:high","signal","signal:technical_indicator_signal","source:technical_analyzer","triage:park","urgency:low"],"ts":"2026-04-08T20:35:04.790339+00:00","urgency":"low","user_visible":true,"waiting_on":null,"why_it_matters":"This is a non-user-visible technical signal with elevated tags but no clear immediate action or deadline, so it can be reviewed later for confirmation and context."},{"actionable":true,"blocked_reason":null,"deadline_at_iso":null,"entity_ref":null,"headline":"Technical indicator signal flagged high (big move up, 1d)","id":"sig:316f1079555a570e","kind":"inbox","links":{"dedupe_key":"ta:technical_indicator_signal:bigMoveUp:big_move:SSSS:1d:2026-04-08T00:00:00Z:2026-04-08","evidence_event_ids":["evt_479db44a8ea0"],"reason_trace":{"cutoff_iso":"2026-04-05T20:40:08Z","eligible_timeframes":["1d"],"market_now":"2026-04-08T16:40:08.728352-04:00","period_key":"2026-04-08","recent_signal_hours":72,"signal_timestamp":"2026-04-08T00:00:00Z","strategy":"big_move"},"severity":"high","signal_id":"sig_25924f783726","signal_type":"technical_indicator_signal","source":"technical_analyzer","topic_key":"signal:technical_indicator_signal:cadbf1c1d410acf9","triage":{"action_hints":["schedule review"],"confidence":0.62,"disposition":"park","entity_ids":[],"headline":"Technical indicator signal flagged high (big move up, 1d)","prior":{"family":"general","importance_band":"background","suggested_disposition":"park","suggested_route":"review","suggested_urgency":"low"},"priority_score":28.7,"rationale":"This is a non-user-visible technical signal with no grounded action details, so it can be reviewed later rather than acted on immediately.","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:high","route:review","severity:high","signal","signal:technical_indicator_signal","source:technical_analyzer","triage:park","urgency:low"],"ts":"2026-04-08T20:40:08.728332+00:00","urgency":"low","user_visible":true,"waiting_on":null,"why_it_matters":"This is a non-user-visible technical signal with no grounded action details, so it can be reviewed later rather than acted on immediately."}],"notes":[],"one_thing":{"actionable":true,"blocked_reason":null,"deadline_at_iso":null,"entity_ref":null,"headline":"What\u2019s Marian\u2019s email address, and should I send the exact joke as-is or with changes?","id":"pend_69af741fe6","kind":"followup","links":{"action_id":null,"action_type":"email_send","approval_id":null,"choices":[],"event_id":"evt_5dbea6a4b598","pending_kind":"missing_detail","source":"proposal_materializer","thread_id":"thr_3cb85089cf8d9aec18"},"next_touch_at_iso":null,"route":"today","score":60.0,"score_hint":6.0,"source_kind":"pending","tags":["missing_detail"],"ts":"2026-04-08T21:09:18.188900+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":"f6a967d7dc6aedbfe9910adc8c35ea57025428fb","planner_model":"gpt-5.4-nano"}}
TEXT NOT NULL
source_ref
NULL
TEXT
confidence
REAL (default 0.0
dedupe_key
planner_plan_built:2026-04-08:914b68407138c7ca7b9c4e5b150848183a5dfb72
TEXT
episode_id
NULL
TEXT
created_at
2026-04-08T21:34:50.059636+00:00
TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')
Update
Cancel