Could not fetch row with primary-key 421402.
Could not fetch row with primary-key 368832.
Could not fetch row with primary-key 407280.
Could not fetch row with primary-key 68628.
Could not fetch row with primary-key 391421.
Add Column
Current Schema
CREATE TABLE attention_candidates (
id TEXT PRIMARY KEY,
status TEXT NOT NULL DEFAULT 'pending' CHECK (status IN (
'pending','gated','dispatched','superseded','expired'
)),
kind TEXT NOT NULL,
reason TEXT NOT NULL,
score REAL NOT NULL DEFAULT 0.0,
target_entity TEXT,
urgency_hint TEXT,
ttl TEXT,
source_daemon TEXT NOT NULL,
source_ref_kind TEXT NOT NULL,
source_ref_id TEXT NOT NULL,
dedupe_key TEXT NOT NULL,
title TEXT,
body TEXT,
why_now TEXT,
cta_json TEXT,
delivery_channel_hint TEXT,
thread_id TEXT,
reason_trace_json TEXT,
score_breakdown_json TEXT,
source_event_id TEXT NOT NULL,
gated_reason TEXT,
gated_rules_json TEXT,
next_eligible_at TEXT,
dispatched_event_id TEXT,
dispatched_at TEXT,
superseded_by TEXT,
created_at TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now')),
updated_at TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now'))
)