SQLite Web: event

seq

Primary key. INTEGER

id

TEXT NOT NULL

kind

TEXT NOT NULL

ts

TEXT NOT NULL

actor

TEXT

subject_entity_ids

TEXT

payload

{"meta":{"action":"tick"},"stats":{"analyze":{"hours_since":4.22,"last_at":"2026-04-03T10:34:37.317000+00:00","ran":false,"reason":"not_due"},"archived":{"events":0,"events_by_kind":{}},"backup":null,"db_sizes_after":{"db_bytes":18784256,"db_path":"/etc/opia/event_store.db","shm_bytes":0,"total_bytes":18784256,"wal_bytes":0},"db_sizes_before":{"db_bytes":18784256,"db_path":"/etc/opia/event_store.db","shm_bytes":0,"total_bytes":18784256,"wal_bytes":0},"deleted":{"artifacts":0,"dead_letters":0,"deliveries":0,"events":0,"events_archive":0,"events_by_kind":{},"inbox_items":0,"opportunity_memory":0,"pending_interactions":0,"reminders":0,"signal_fps":0,"signals":0},"events_catalog":{"categories":{"audit":29,"ephemeral":14,"state_transition":72,"user_history":4},"prunable_kinds":14,"prune_rules":[{"kind":"episode_context_built","retention_days":30},{"kind":"llm_usage","retention_days":90},{"kind":"notification_sent","retention_days":180},{"kind":"nudge_proposed","retention_days":30},{"kind":"nudge_sent","retention_days":180},{"kind":"nudge_suppressed","retention_days":30},{"kind":"planner_tick","retention_days":7},{"kind":"router_routed","retention_days":30},{"kind":"signal_emitted","retention_days":14},{"kind":"signal_ingest","retention_days":1},{"kind":"system","retention_days":30},{"kind":"watcher_eval","retention_days":1},{"kind":"watcher_fired","retention_days":30},{"kind":"web_search_performed","retention_days":30}],"total_kinds":119},"events_prune_control":{"batch_per_kind":500,"loops_by_kind":{},"max_batches_per_kind":8,"max_total_archives":15000,"max_total_deletes":15000,"remaining_archive_budget":15000,"remaining_delete_budget":15000},"rollups":{},"row_counts_after_prune":{"actions":7,"approvals":3,"deliveries":36,"episodes":10,"events":2829,"events_archive":0,"inbox_items":8,"jobs":126,"opportunity_memory":0,"pending_interactions":4,"reminders":2,"signal_fps":808,"signals":808},"row_counts_before":{"actions":7,"approvals":3,"deliveries":36,"episodes":10,"events":2829,"events_archive":0,"inbox_items":8,"jobs":126,"opportunity_memory":0,"pending_interactions":4,"reminders":2,"signal_fps":808,"signals":808},"row_counts_final":{"actions":7,"approvals":3,"deliveries":36,"episodes":10,"events":2829,"events_archive":0,"inbox_items":8,"jobs":126,"opportunity_memory":0,"pending_interactions":4,"reminders":2,"signal_fps":808,"signals":808},"size_delta_bytes":0,"sqlite_pages_after_prune":{"db_estimated_bytes":18784256,"free_estimated_bytes":0,"free_ratio":0.0,"freelist_count":0,"page_count":4586,"page_size":4096,"used_pages":4586},"sqlite_pages_before":{"db_estimated_bytes":18784256,"free_estimated_bytes":0,"free_ratio":0.0,"freelist_count":0,"page_count":4586,"page_size":4096,"used_pages":4586},"sqlite_pages_final":{"db_estimated_bytes":18784256,"free_estimated_bytes":0,"free_ratio":0.0,"freelist_count":0,"page_count":4586,"page_size":4096,"used_pages":4586},"vacuum":{"page_stats":{"db_estimated_bytes":18784256,"free_estimated_bytes":0,"free_ratio":0.0,"freelist_count":0,"page_count":4586,"page_size":4096,"used_pages":4586},"ran":false,"reason":"not_worth_it"},"wal_checkpoint":{"hours_since":4.22,"last_at":"2026-04-03T10:34:37.229574+00:00","ok":true,"skipped":true}},"subsystem":"data_lifecycle","ts":"2026-04-03T14:47:49.860895+00:00"}

TEXT NOT NULL

source_ref

TEXT

confidence

REAL (default 0.0

dedupe_key

TEXT

episode_id

TEXT

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — events

Update row 2830 in events