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

{"at":"2026-04-17T23:00:59.044058+00:00","queue":{"cutoff_iso":"2026-04-17T22:50:59.049708+00:00","dead_letters_in_window":0,"dead_letters_total":0,"failed_in_window":0,"requeued_expired":0,"requeued_failed":0,"status_counts":{"done":220,"leased":1,"queued":1}},"reducers":{"max_seq":99232,"stale":[],"stale_minutes":10,"top":[{"cursor":98637,"lag":595,"max_pos":99232,"reducer":"commitment_checkin_answers_v1","stream":"events","updated_at":"2026-04-17T22:59:03.937Z"},{"cursor":98643,"lag":589,"max_pos":99232,"reducer":"memory_ingest:default","stream":"events","updated_at":"2026-04-17T23:00:03.036Z"},{"cursor":99125,"lag":107,"max_pos":99232,"reducer":"resolver_v3","stream":"events","updated_at":"2026-04-17T22:59:29.196Z"},{"cursor":99225,"lag":7,"max_pos":99232,"reducer":"email_sender_verification_v2","stream":"events","updated_at":"2026-04-17T23:00:37.316Z"},{"cursor":99229,"lag":3,"max_pos":99232,"reducer":"sms_sender_verification_v1","stream":"events","updated_at":"2026-04-17T23:00:38.496Z"},{"cursor":99229,"lag":3,"max_pos":99232,"reducer":"portfolio_resolver_v3","stream":"events","updated_at":"2026-04-17T23:00:39.220Z"},{"cursor":99231,"lag":1,"max_pos":99232,"reducer":"entity_reducer_v2_deterministic","stream":"events","updated_at":"2026-04-17T23:00:55.082Z"},{"cursor":99231,"lag":1,"max_pos":99232,"reducer":"entity_alias_reducer_v2","stream":"events","updated_at":"2026-04-17T23:00:55.100Z"},{"cursor":99231,"lag":1,"max_pos":99232,"reducer":"event_subjects_reducer_v2","stream":"events","updated_at":"2026-04-17T23:00:55.124Z"},{"cursor":99231,"lag":1,"max_pos":99232,"reducer":"fact_reducer_v2_deterministic","stream":"events","updated_at":"2026-04-17T23:00:55.170Z"}],"worst_lag":595,"worst_reducer":"commitment_checkin_answers_v1"},"subsystem":"housekeeping"}

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 99233 in events