Add Column
Current Schema
CREATE TABLE facts (
id TEXT PRIMARY KEY,
entity_id TEXT NOT NULL,
field TEXT NOT NULL,
value TEXT NOT NULL,
as_of TEXT NOT NULL,
derived_from_event_ids TEXT,
-- optional JSON array; normalized in fact_sources
confidence REAL DEFAULT 0.0,
updated_at TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now')),
FOREIGN KEY (entity_id) REFERENCES entities(id) ON DELETE RESTRICT DEFERRABLE INITIALLY DEFERRED
)