CREATE TABLE intel_narratives (
narrative_id TEXT PRIMARY KEY,
title TEXT NOT NULL,
thesis TEXT NOT NULL,
state TEXT NOT NULL DEFAULT 'emerging',
last_confidence REAL,
last_uncertainty TEXT,
last_update_worthy INTEGER NOT NULL DEFAULT 0,
last_update_worthy_reason TEXT,
last_published_artifact_id TEXT,
last_publish_at TEXT,
degraded INTEGER NOT NULL DEFAULT 0,
degraded_reason TEXT,
created_at TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now')),
last_updated_at TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now')),
last_signal_seen_at TEXT,
first_signal_id TEXT,
domains_json TEXT NOT NULL DEFAULT '[]',
variant_labels_json TEXT NOT NULL DEFAULT '[]',
provenance_json TEXT,
evidence_log_json TEXT NOT NULL DEFAULT '[]'
)