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

{"body":"Signal emitted.","candidate_refs":[{"id":"sig_62e50719985a","kind":"signal"}],"channel":"C0A8Q869CNL","cta":["review","ignore"],"delivery_fp":"attn:C0A8Q869CNL:5dd52455d7c0bf50af6d:2026-04-03T20","next_eligible_at":null,"nudge_kind":"alert","reason_trace":{"age_min":0.9,"dedupe_key":"ta:technical_indicator_signal:bigMoveUp:big_move:TVTX:1d:2026-04-01T00:00:00Z:2026-04-03","personalization":{"fields_sample":[],"mode":"bootstrap","owner_fact_count":0},"reason_trace":{"cutoff_iso":"2026-03-31T20:11:02Z","eligible_timeframes":["1d","1wk"],"market_now":"2026-04-03T16:11:02.047044-04:00","period_key":"2026-04-03","recent_signal_hours":72,"severity":"high","signal_timestamp":"2026-04-01T00:00:00Z","signal_type":"technical_indicator_signal","source":"technical_analyzer","strategy":"big_move"},"severity":"high","signal_type":"technical_indicator_signal","source":"technical_analyzer","throttle_s":0},"score":120.34775104266666,"score_breakdown":{"age_min":0.9,"base":12,"freshness":119.1,"severity_weight":75},"suppression_rules_applied":[],"thread_id":null,"title":"Technical Indicator Signal","topic_key":"signal:ta:technical_indicator_signal:bigMoveUp:big_move:TVTX:1d:2026-04-01T00:00:00Z:2026-04-03","why_now":"severity=high; just now"}

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