Create
Query
event_store.db
—
inbox_items
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 sig:a1aff83e0de7c1c7 in inbox_items
id
sig:a1aff83e0de7c1c7
Primary key.
TEXT
type
signal
TEXT NOT NULL
text
The energy sector is experiencing a pullback, influenced by recent developments and Federal Reserve news.
TEXT NOT NULL
normalized_text
the energy sector is experiencing a pullback, influenced by recent developments and federal reserve news.
TEXT
status
open
TEXT NOT NULL
tags
["family:general","priority:low","route:ignore","severity:low","signal","signal:opportunity_case_memory","source:opportunity_finder","triage:dismiss","urgency:low"]
TEXT
links
{"dedupe_key":"opportunity_case_memory:case_11c2f28a44862b00:digest:2026-04-03T19","evidence_event_ids":["evt_f462d39d4a62","evt_001eea4a88bb","evt_e94a4f70b913","evt_362cdd795306","evt_2b0602be162b","evt_41045779ee62","evt_edc8bbcfb1b6","evt_feb95e9982f9","evt_1be7f9beeded","evt_601e25343546","evt_0bb6419fb48d","evt_e48ca46b8af3","evt_29f9deb7d4b8","evt_c482b3694d13","evt_b9c4f6ce13de","evt_070d46e77dce","evt_e283adc71d26","evt_fa28bcce594c","evt_8a18667dd17c","evt_be1f9a2bb530","evt_c3bac2fb4e60","evt_d58aa7072112","evt_cad751bc81bf","evt_3312d1fa59d6","evt_36fda3645a3f","evt_282ff52e2355","evt_a3f215c45eca","evt_5842863b776f","evt_f2b3629e9d0f","evt_4cf74687be5d","evt_af187233c05a","evt_04e281a380bf","evt_2e00da746176","evt_356eb2f2bdd4","evt_58a7e4dc7969","evt_0d2b41e11926","evt_8f8b7d3890ae","evt_c8393ac8fc54","evt_c5dfc852e158","evt_63323d8e6c15","evt_250780b52270","evt_913ec9cbe1af","evt_85ae61f3366f","evt_80375aea4e05","evt_e6d62463685d","evt_2292508410a3","evt_836394a27f3f","evt_2452a684a1ca","evt_559366d93d08","evt_3ddc70a87b81","evt_0074dbd52832","evt_e7717625091a","evt_9e01a2de90ac","evt_d510df9f7662","evt_f19284613c1d","evt_5fa51bed2092","evt_91dfdbf3d748","evt_26a23dd407ce","evt_1c62e928d973","evt_c67144804799","evt_4b14f74635a9"],"reason_trace":{"_evidence_event_ids":["evt_001eea4a88bb","evt_e94a4f70b913","evt_362cdd795306","evt_2b0602be162b","evt_41045779ee62","evt_edc8bbcfb1b6","evt_feb95e9982f9","evt_1be7f9beeded","evt_601e25343546","evt_0bb6419fb48d","evt_e48ca46b8af3","evt_29f9deb7d4b8","evt_c482b3694d13","evt_b9c4f6ce13de","evt_070d46e77dce","evt_e283adc71d26","evt_fa28bcce594c","evt_8a18667dd17c","evt_be1f9a2bb530","evt_c3bac2fb4e60","evt_d58aa7072112","evt_cad751bc81bf","evt_3312d1fa59d6","evt_36fda3645a3f","evt_282ff52e2355","evt_a3f215c45eca","evt_5842863b776f","evt_f2b3629e9d0f","evt_4cf74687be5d","evt_af187233c05a","evt_04e281a380bf","evt_2e00da746176","evt_356eb2f2bdd4","evt_58a7e4dc7969","evt_0d2b41e11926","evt_8f8b7d3890ae","evt_c8393ac8fc54","evt_c5dfc852e158","evt_63323d8e6c15","evt_250780b52270","evt_913ec9cbe1af","evt_85ae61f3366f","evt_80375aea4e05","evt_e6d62463685d","evt_2292508410a3","evt_836394a27f3f","evt_2452a684a1ca","evt_559366d93d08","evt_3ddc70a87b81","evt_0074dbd52832","evt_e7717625091a","evt_9e01a2de90ac","evt_d510df9f7662","evt_f19284613c1d","evt_5fa51bed2092","evt_91dfdbf3d748","evt_26a23dd407ce","evt_1c62e928d973","evt_c67144804799","evt_4b14f74635a9"],"case_id":"case_11c2f28a44862b00","decision":"digest","entity_key":"commodity:us_oil_wti","memory_only":true,"theme_key":"entity_development"},"severity":"low","signal_id":"sig_6f7c04703c42","signal_type":"opportunity_case_memory","source":"opportunity_finder","topic_key":"signal:opportunity_case_memory:fd7a1a64541833ef","triage":{"action_hints":[],"confidence":0.2,"disposition":"dismiss","entity_ids":[],"headline":"Low severity opportunity case memory","prior":{"family":"general","importance_band":"background","suggested_disposition":"park","suggested_route":"review","suggested_urgency":"low"},"priority_score":-36.0,"rationale":"This event has low severity and does not require immediate attention.","review_in_days":1,"route":"ignore","urgency":"low"},"user_visible":false}
TEXT
ts
2026-04-03T19:04:37.705245+00:00
TEXT NOT NULL
route
ignore
TEXT
urgency
low
TEXT
next_touch_at_iso
NULL
TEXT
created_at
2026-04-03T19:04:37.705245+00:00
TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')
updated_at
2026-04-03T19:05:48.890107+00:00
TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')
Update
Cancel