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 24662 in events
seq
Primary key.
INTEGER
id
evt_e3539d6b46d8
TEXT NOT NULL
kind
email_reply_drafted
TEXT NOT NULL
ts
2026-04-11T21:16:42.122278+00:00
TEXT NOT NULL
actor
email_answerer
TEXT
subject_entity_ids
[]
TEXT
payload
{"confidence":0.78,"created_at":"2026-04-11T21:16:42.122278+00:00","draft_id":"drf_email_ee785cb08ad3","draft_quality_score":0.96,"intent_summary":"notifying Omid that the order is ready for pickup","mailbox":"angela@yoosefi.org","message_id":"CAB1dmrc5J=7qdHY0qL_td-wj4ap4R=6qimKhkM8KeT46q=se_w@mail.gmail.com","model":"gpt-5.4-nano","needs_approval":true,"original_subject":"Order Ready","owner_context_summary":"Laurel&Lace Bridals (M. Monroe) asked to let Omid know that his order is ready for pickup.","policy_trace":{"channel":"email","content_hits":{"high_risk_terms":[],"medium_risk_terms":[]},"draft_quality_issues":[],"draft_quality_score":0.96,"identity":{"confidence":0.0,"matched_direct_alias":false,"min_confidence":0.72,"trusted":true},"model":{"confidence":0.78,"llm_needs_approval":false,"llm_risk_level":"low"},"needs_approval":true,"needs_owner_input":false,"policy_rationale":"email_policy: reasons=identity_low_confidence; quality=0.96; confidence=0.78","quality":{"char_count":109,"issues":[],"score":0.96,"word_count":19},"reason_codes":["identity_low_confidence"],"risk_level":"medium","risk_tag":"communication_medium_risk_requires_approval"},"rationale":"The email is a straightforward status update with no risk signals (no scam/spam indicators) and a safe, concise acknowledgment can be sent immediately.","reply_in_reply_to":null,"reply_mode":"existing_thread","reply_references":[],"reply_subject":"Re: Order Ready","risk_level":"medium","risk_tag":"communication_medium_risk_requires_approval","status":"drafted","subject":"Re: Order Ready","text_body":"Hi M. Monroe,\n\nThanks for the update\u2014Omid has been notified that his order is ready for pickup.\n\nBest,\nAngela","thread_key":"thr_ac74c16c08f24ae93e","to_email":"contact@laurelxlace.com"}
TEXT NOT NULL
source_ref
NULL
TEXT
confidence
REAL (default 0.0
dedupe_key
email_reply_drafted:CAB1dmrc5J=7qdHY0qL_td-wj4ap4R=6qimKhkM8KeT46q=se_w@mail.gmail.com
TEXT
episode_id
NULL
TEXT
created_at
2026-04-11T21:16:43.845791+00:00
TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')
Update
Cancel