CREATE TABLE artifacts (
id TEXT PRIMARY KEY,
kind TEXT NOT NULL,
status TEXT NOT NULL CHECK (status IN ('queued','building','ready','failed','discarded')),
title TEXT,
summary TEXT,
meta TEXT,
-- JSON (intent, topic, tags, etc.)
output_json TEXT,
-- JSON (structured payload)
output_mrkdwn TEXT,
-- rendered markdown
evidence_event_ids TEXT,
-- JSON array
confidence REAL,
episode_id TEXT,
thread_id TEXT,
error TEXT,
attempt_count INTEGER DEFAULT 0,
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')),
claimed_at TEXT,
claim_id TEXT,
ready_at TEXT,
discarded_at TEXT,
FOREIGN KEY (episode_id) REFERENCES episodes(id) ON DELETE SET NULL DEFERRABLE INITIALLY DEFERRED
)