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

{"action":{"bcc":null,"cc":null,"client_ref":null,"contact_entity_id":"contact_12345","format_hint":"both","from_name":"Omid","html_body":"<p>Hey Love! \ud83c\udf1f Just a quick note to say I love you more than pizza (and you know how much I love pizza!). I\u2019ll be back before you can say \u2018I miss you\u2019 three times fast. Try not to have too much fun without me, or I might get jealous! Can\u2019t wait to see you soon! \ud83d\udc96</p>","mailbox":null,"recipient_name":"Marian","relationship":"girlfriend","reply_in_reply_to":null,"reply_message_id":null,"reply_mode":"new_outbound","reply_original_subject":null,"reply_references":null,"reply_thread_key":null,"reply_to":null,"subject":"Missing You Already!","tags":null,"text_body":"Hey Love! \ud83c\udf1f Just a quick note to say I love you more than pizza (and you know how much I love pizza!). I\u2019ll be back before you can say \u2018I miss you\u2019 three times fast. Try not to have too much fun without me, or I might get jealous! Can\u2019t wait to see you soon! \ud83d\udc96","to_email":"marian@example.com","type":"email_send"},"action_fp":"a9f580e59400a03777bc83470bfee7dc","action_id":"act_3e8eb40178b0","approval_id":"appr_039a361253","created_at":"2026-04-03T11:31:10.942581+00:00","event_id":"evt_b5aa573998c8","rationale":"User wants to send a letter to brighten Marian's day.; autonomy_policy: reasons=approval_required_by_tier_policy; decision=needs_approval:T2","risk":"tier_requires_approval","source":"proposal_materializer","status":"open","summary":"email send","thread_id":"slkthr_776445451af92b39e8","tier":"T2"}

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