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 2321 in events
seq
Primary key.
INTEGER
id
evt_f7293d16db00
TEXT NOT NULL
kind
artifact_upsert
TEXT NOT NULL
ts
2026-04-08T23:05:13.758965+00:00
TEXT NOT NULL
actor
memory_curation
TEXT
subject_entity_ids
[]
TEXT
payload
{"artifact_id":"art_owner_knowledge_pack_2026-04-08","confidence":0.84,"created_at":"2026-04-08T23:05:13.758965+00:00","evidence_event_ids":[],"kind":"owner_knowledge_pack","meta":{"day":"2026-04-08","fingerprint":"fb8cb6ad8e02","generated_at":"2026-04-08T23:05:13.755335+00:00","source":"memory_curation","version":"v2"},"output_json":{"generated_at":"2026-04-08T23:05:13.755335+00:00","memory_domains":{"commitments":[],"constraints":[],"decisions":[],"open_threads":[{"headline":null,"pending_id":null,"source":"slack_bot","stage":"resolved","thread_id":"thr_a323a945dfd434d4fa","updated_at":"2026-04-08T22:16:57.669253+00:00"},{"headline":null,"pending_id":null,"source":"slack_bot","stage":"resolved","thread_id":"thr_3cb85089cf8d9aec18","updated_at":"2026-04-08T21:10:03.862112+00:00"}],"preferences":[],"projects":[],"recent_events":[{"actor":"observability","event_id":"evt_34a9f7723a4b","headline":"system_distress","kind":"signal_emitted","ts":"2026-04-08T23:04:57.483795+00:00"},{"actor":"slack_compose","event_id":"evt_b57d0682fe76","headline":null,"kind":"thread_message_recorded","ts":"2026-04-08T22:15:30.692702+00:00"},{"actor":"slack_compose","event_id":"evt_63b6f6ceb5f7","headline":null,"kind":"thread_message_recorded","ts":"2026-04-08T22:15:04.457733+00:00"},{"actor":"proposal_materializer","event_id":"evt_7025fb61e48d","headline":null,"kind":"proposal_materialized","ts":"2026-04-08T22:15:03.583570+00:00"},{"actor":"opia_engine","event_id":"evt_d0a2a0d8df97","headline":null,"kind":"user_interaction","ts":"2026-04-08T22:14:48.991631+00:00"},{"actor":"slack_compose","event_id":"evt_d1f8d74710cb","headline":null,"kind":"thread_message_recorded","ts":"2026-04-08T22:14:10.712246+00:00"},{"actor":"executor","event_id":"evt_a06e33bf2082","headline":"email_send","kind":"action_applied","ts":"2026-04-08T22:14:08.782388+00:00"},{"actor":"opia_engine","event_id":"evt_7b2af2a9eb37","headline":null,"kind":"user_interaction","ts":"2026-04-08T22:14:05.727852+00:00"},{"actor":"slack_compose","event_id":"evt_0ce2d55de3c6","headline":null,"kind":"thread_message_recorded","ts":"2026-04-08T22:13:49.256153+00:00"},{"actor":"slack_compose","event_id":"evt_c2b7ed79a1c3","headline":null,"kind":"thread_message_recorded","ts":"2026-04-08T22:12:18.214671+00:00"},{"actor":"proposal_materializer","event_id":"evt_323fc16bd939","headline":null,"kind":"proposal_materialized","ts":"2026-04-08T22:12:17.767621+00:00"},{"actor":"proposal_materializer","event_id":"evt_3d42d61e8f2e","headline":"autonomy_policy_evaluated","kind":"signal_emitted","ts":"2026-04-08T22:12:17.767621+00:00"},{"actor":"opia_engine","event_id":"evt_680353590205","headline":null,"kind":"user_interaction","ts":"2026-04-08T22:12:04.411604+00:00"},{"actor":"slack_compose","event_id":"evt_074188981fe7","headline":null,"kind":"thread_message_recorded","ts":"2026-04-08T22:11:51.598140+00:00"},{"actor":"proposal_materializer","event_id":"evt_0ab5853c6350","headline":null,"kind":"proposal_materialized","ts":"2026-04-08T22:11:50.208227+00:00"},{"actor":"opia_engine","event_id":"evt_a602dd8f2383","headline":null,"kind":"user_interaction","ts":"2026-04-08T22:11:32.950370+00:00"},{"actor":"slack_compose","event_id":"evt_8a77b630413c","headline":null,"kind":"thread_message_recorded","ts":"2026-04-08T22:11:15.401487+00:00"},{"actor":"proposal_materializer","event_id":"evt_a4639037db18","headline":null,"kind":"proposal_materialized","ts":"2026-04-08T22:11:13.830303+00:00"},{"actor":"opia_engine","event_id":"evt_badee0e89d43","headline":null,"kind":"user_interaction","ts":"2026-04-08T22:10:54.620814+00:00"},{"actor":"slack_compose","event_id":"evt_9c282ab94031","headline":null,"kind":"thread_message_recorded","ts":"2026-04-08T22:09:03.371712+00:00"},{"actor":"proposal_materializer","event_id":"evt_a2e1aaf7dd61","headline":null,"kind":"proposal_materialized","ts":"2026-04-08T22:09:01.528170+00:00"},{"actor":"opia_engine","event_id":"evt_7cb7a9ffb73e","headline":null,"kind":"user_interaction","ts":"2026-04-08T22:08:47.240287+00:00"},{"actor":"slack_compose","event_id":"evt_38b07b888c1b","headline":null,"kind":"thread_message_recorded","ts":"2026-04-08T22:08:25.538055+00:00"},{"actor":"proposal_materializer","event_id":"evt_3b713171f5c0","headline":null,"kind":"proposal_materialized","ts":"2026-04-08T22:08:23.297685+00:00"},{"actor":"opia_engine","event_id":"evt_cfdf0e7afc40","headline":null,"kind":"user_interaction","ts":"2026-04-08T22:08:11.644178+00:00"},{"actor":"slack_compose","event_id":"evt_e227bcdeddcd","headline":null,"kind":"thread_message_recorded","ts":"2026-04-08T22:07:28.545281+00:00"},{"actor":"proposal_materializer","event_id":"evt_b3e32c809c7b","headline":null,"kind":"proposal_materialized","ts":"2026-04-08T22:07:27.177700+00:00"},{"actor":"slack_compose","event_id":"evt_928626cea359","headline":null,"kind":"thread_message_recorded","ts":"2026-04-08T22:06:55.854290+00:00"},{"actor":"opia_engine","event_id":"evt_afb9a2134503","headline":null,"kind":"user_interaction","ts":"2026-04-08T22:06:55.156209+00:00"},{"actor":"observability","event_id":"evt_fe8010fa2cfb","headline":"system_distress","kind":"signal_emitted","ts":"2026-04-08T22:04:49.625424+00:00"},{"actor":"slack_compose","event_id":"evt_499053e132a4","headline":null,"kind":"thread_message_recorded","ts":"2026-04-08T21:09:18.376927+00:00"},{"actor":"proposal_materializer","event_id":"evt_f0d9debe37ae","headline":null,"kind":"proposal_materialized","ts":"2026-04-08T21:09:18.177451+00:00"},{"actor":"opia_engine","event_id":"evt_c2e910660f95","headline":null,"kind":"user_interaction","ts":"2026-04-08T21:09:07.594766+00:00"},{"actor":"slack_compose","event_id":"evt_ee8a023ef15d","headline":null,"kind":"thread_message_recorded","ts":"2026-04-08T21:08:22.474204+00:00"},{"actor":"proposal_materializer","event_id":"evt_8cd04b6e342b","headline":null,"kind":"proposal_materialized","ts":"2026-04-08T21:08:21.238863+00:00"},{"actor":"opia_engine","event_id":"evt_ccf5dfe93109","headline":null,"kind":"user_interaction","ts":"2026-04-08T21:08:10.365732+00:00"},{"actor":"slack_compose","event_id":"evt_68f82633dc17","headline":null,"kind":"thread_message_recorded","ts":"2026-04-08T21:07:52.113449+00:00"},{"actor":"proposal_materializer","event_id":"evt_19956c5b1170","headline":null,"kind":"proposal_materialized","ts":"2026-04-08T21:07:51.559029+00:00"},{"actor":"episode_route","event_id":"evt_dcc7567a578e","headline":"conversation_followup_escalated","kind":"signal_emitted","ts":"2026-04-08T21:07:45.086492+00:00"},{"actor":"opia_engine","event_id":"evt_e3e6c107dec1","headline":null,"kind":"user_interaction","ts":"2026-04-08T21:07:37.896942+00:00"}],"relationships":[],"signals":[{"created_at":"2026-04-08T23:04:57.483795+00:00","event_id":"evt_34a9f7723a4b","reason_trace":null,"severity":"medium","signal_type":"system_distress","source":"observability","value":{"alerts":[{"count":2,"level":"warn","remediation":"Connected sources are degraded or unauthenticated; repair credentials and reduce dependency blast radius.","type":"sources_error"}],"metrics_window_h":24,"type":"observability"}},{"created_at":"2026-04-08T22:12:17.767621+00:00","event_id":"evt_3d42d61e8f2e","reason_trace":{"policy_trace":{"action_type":"email_send","auto_execute_tiers":["T0","T1"],"base_tier":"T2","decision":"needs_approval","evaluated_tier":"T2","flags":{"force_auto_approve_applied":false,"force_auto_approve_requested":false,"hard_constraint_present":false,"owner_input_required":false},"policy":"autonomy_policy_v2","policy_rationale":"autonomy_policy: reasons=approval_required_by_tier_policy; decision=needs_approval:T2","reason_codes":["approval_required_by_tier_policy"],"require_approval_tiers":["T2","T3"],"risk_dimensions":{"communication":{},"constraints":[],"financial":{"max_concentration_pct":0.0,"max_money_amount":0.0,"reason":null,"required_tier":null}},"risk_tag":"tier_requires_approval","source":"proposal_materializer","tier_override":null},"rationale":"autonomy_policy: reasons=approval_required_by_tier_policy; decision=needs_approval:T2"},"severity":"medium","signal_type":"autonomy_policy_evaluated","source":"proposal_materializer","value":{"action_type":"email_send","episode_id":"ep_f340eb0bbfe7","risk_tag":"tier_requires_approval","status":"needs_approval","tier":"T2"}},{"created_at":"2026-04-08T22:04:49.625424+00:00","event_id":"evt_fe8010fa2cfb","reason_trace":null,"severity":"medium","signal_type":"system_distress","source":"observability","value":{"alerts":[{"count":2,"level":"warn","remediation":"Connected sources are degraded or unauthenticated; repair credentials and reduce dependency blast radius.","type":"sources_error"}],"metrics_window_h":24,"type":"observability"}},{"created_at":"2026-04-08T21:07:45.086492+00:00","event_id":"evt_dcc7567a578e","reason_trace":{"action_type":null,"episode_id":"ep_e4c80e5b351f","pending_id":"pend_b0bd3b426e","pending_root_id":"pend_b0bd3b426e","reask_count":0,"thread_id":"thr_3cb85089cf8d9aec18","unresolved_reason":"pending_answer_captured"},"severity":null,"signal_type":"conversation_followup_escalated","source":"episode_router","value":1.0},{"created_at":"2026-04-08T21:04:43.565435+00:00","event_id":"evt_0b1edf62d9b3","reason_trace":null,"severity":"medium","signal_type":"system_distress","source":"observability","value":{"alerts":[{"count":2,"level":"warn","remediation":"Connected sources are degraded or unauthenticated; repair credentials and reduce dependency blast radius.","type":"sources_error"}],"metrics_window_h":24,"type":"observability"}},{"created_at":"2026-04-08T21:04:31.986830+00:00","event_id":"evt_1e3addc446d8","reason_trace":{"action_type":null,"episode_id":"ep_e4c80e5b351f","pending_id":"pend_570ec40775","pending_root_id":"pend_570ec40775","reask_count":0,"thread_id":"thr_3cb85089cf8d9aec18","unresolved_reason":"pending_answer_captured"},"severity":null,"signal_type":"conversation_followup_escalated","source":"episode_router","value":1.0},{"created_at":"2026-04-08T21:02:39.238409+00:00","event_id":"evt_a8290612d1b0","reason_trace":{"action_type":null,"episode_id":"ep_e4c80e5b351f","pending_id":"pend_932e65d1bd","pending_root_id":"pend_932e65d1bd","reask_count":0,"thread_id":"thr_3cb85089cf8d9aec18","unresolved_reason":"pending_answer_captured"},"severity":null,"signal_type":"conversation_followup_escalated","source":"episode_router","value":1.0},{"created_at":"2026-04-08T20:40:08.728332+00:00","event_id":"evt_b8f40a9ee48f","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-07T00:00:00Z","strategy":"ema_signals"},"severity":"medium","signal_type":"technical_indicator_signal","source":"technical_analyzer","value":{"bars":600,"confidence":0.5794378678053078,"details":{"bars":600,"ema_fast":39.24308831101532,"ema_price":39.24308831101532,"ema_slow":39.136009936835976,"fast_length":12,"fast_slope":0.006514,"price_ema_length":12,"recent_matches":[{"close":35.54999923706055,"ema_fast":34.529372658766874,"ema_price":34.529372658766874,"ema_slow":34.44503104809475,"timestamp":"2025-08-14T00:00:00+00:00","volume":41800.0},{"close":35.81999969482422,"ema_fast":35.34459115247727,"ema_price":35.34459115247727,"ema_slow":35.31696344439654,"timestamp":"2025-11-10T00:00:00+00:00","volume":48400.0},{"close":36.5,"ema_fast":35.47192316630361,"ema_price":35.47192316630361,"ema_slow":35.401748088428604,"timestamp":"2025-11-25T00:00:00+00:00","volume":88900.0},{"close":38.060001373291016,"ema_fast":37.54990468555272,"ema_price":37.54990468555272,"ema_slow":37.507814830194384,"timestamp":"2026-01-08T00:00:00+00:00","volume":52900.0},{"close":40.63999938964844,"ema_fast":39.24308831101532,"ema_price":39.24308831101532,"ema_slow":39.136009936835976,"timestamp":"2026-04-07T00:00:00+00:00","volume":50100.0}],"rel_gap":0.002736,"rel_price_gap":0.035596,"signal":{"close":40.63999938964844,"timestamp":"2026-04-07T00:00:00Z"},"slow_length":26},"direction":"up","last_buy":null,"last_sell":null,"magnitude":0.1423854379209,"price":40.63999938964844,"recent_buys":[],"recent_sells":[],"signal":{"close":40.63999938964844,"timestamp":"2026-04-07T00:00:00Z"},"signal_kind":"emaCrossUp","strategy":"ema_signals","ticker":"SMBK","timeframe":"1d","timeframe_bucket":"daily"}},{"created_at":"2026-04-08T20:35:04.790339+00:00","event_id":"evt_79def640bc90","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-08T00:00:00Z","strategy":"ema_signals"},"severity":"medium","signal_type":"technical_indicator_signal","source":"technical_analyzer","value":{"bars":600,"confidence":0.7092939599727361,"details":{"bars":600,"ema_fast":1.1506577113213063,"ema_price":1.1506577113213063,"ema_slow":1.221400471316628,"fast_length":12,"fast_slope":-0.026258,"price_ema_length":12,"recent_matches":[{"close":1.4459999799728394,"ema_fast":1.4758646185113395,"ema_price":1.4758646185113395,"ema_slow":1.4483797368373788,"timestamp":"2026-02-19T00:00:00+00:00","volume":1100.0},{"close":1.399999976158142,"ema_fast":1.4347034385090245,"ema_price":1.4347034385090245,"ema_slow":1.433618438129697,"timestamp":"2026-02-27T00:00:00+00:00","volume":3200.0},{"close":1.2999999523162842,"ema_fast":1.4358048327500332,"ema_price":1.4358048327500332,"ema_slow":1.4349128857974884,"timestamp":"2026-03-09T00:00:00+00:00","volume":600.0},{"close":1.0299999713897705,"ema_fast":1.3425695836023723,"ema_price":1.3425695836023723,"ema_slow":1.3800635674870052,"timestamp":"2026-03-19T00:00:00+00:00","volume":3000.0},{"close":0.9800000190734863,"ema_fast":1.1506577113213063,"ema_price":1.1506577113213063,"ema_slow":1.221400471316628,"timestamp":"2026-04-08T00:00:00+00:00","volume":1100.0}],"rel_gap":0.057919,"rel_price_gap":0.148313,"signal":{"close":0.9800000190734863,"timestamp":"2026-04-08T00:00:00Z"},"slow_length":26},"direction":"down","last_buy":null,"last_sell":null,"magnitude":0.5932526782507819,"price":0.9800000190734863,"recent_buys":[],"recent_sells":[],"signal":{"close":0.9800000190734863,"timestamp":"2026-04-08T00:00:00Z"},"signal_kind":"priceBelowEma12","strategy":"ema_signals","ticker":"TLSIW","timeframe":"1d","timeframe_bucket":"daily"}}],"watchlists":[]},"owner":{"entity_id":"person:owner","missing_profile_fields":["top_focus","relationship_priorities","watchlist_tickers","active_projects","commitments","work_focus","checkin_style","preferred_contact_windows","avoidances","seed_objective"],"name":null,"profile":{}},"stats":{"commitments":0,"constraints":0,"decisions":0,"missing_profile_fields":10,"open_threads":2,"preferences":0,"projects":0,"recent_events":40,"relationships":0,"signals":9,"watchlists":0},"timezone":"America/New_York","version":"v2"},"output_mrkdwn":"Knowledge Pack: Owner\nCoverage \u2014 people 0, projects 0, commitments 0, watchlists 0, signals 9, threads 2\nRecent signals: system_distress, autonomy_policy_evaluated, system_distress, conversation_followup_escalated","ready_at":"2026-04-08T23:05:13.758965+00:00","status":"ready","summary":"Knowledge Pack: Owner\nCoverage \u2014 people 0, projects 0, commitments 0, watchlists 0, signals 9, threads 2\nRecent signals: system_distress, autonomy_policy_evaluated, system_distress, conversation_followup_escalated","title":"Owner knowledge pack 2026-04-08","updated_at":"2026-04-08T23:05:13.758965+00:00"}
TEXT NOT NULL
source_ref
NULL
TEXT
confidence
REAL (default 0.0
dedupe_key
artifact_upsert:owner_knowledge_pack:fb8cb6ad8e02
TEXT
episode_id
NULL
TEXT
created_at
2026-04-08T23:05:13.765181+00:00
TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')
Update
Cancel