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_ae17ae5ada56","kind":"signal"}],"channel":"C0A8Q869CNL","cta":["review","ignore"],"delivery_fp":"attn:C0A8Q869CNL:8392c4e5d12f9d59cb01:2026-04-08T20","next_eligible_at":null,"nudge_kind":"alert","reason_trace":{"age_min":3.3,"dedupe_key":"ta:technical_indicator_signal:bigMoveUp:big_move:XPOF:1d:2026-04-07T00:00:00Z:2026-04-08","incident_state_fp":null,"personalization":{"fields_sample":[],"mode":"bootstrap","owner_fact_count":0},"reason_trace":{"cutoff_iso":"2026-04-05T20:30:06Z","eligible_timeframes":["1d"],"market_now":"2026-04-08T16:30:06.903144-04:00","period_key":"2026-04-08","recent_signal_hours":72,"severity":"high","signal_timestamp":"2026-04-07T00: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":119.68046745133333,"score_breakdown":{"age_min":3.3,"base":12,"freshness":116.72,"severity_weight":75},"suppression_rules_applied":[],"thread_id":null,"title":"Technical Indicator Signal","topic_key":"signal:technical_indicator_signal:bd2fec1581883538","why_now":"severity=high; 3m ago"}

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