Query
CREATE TABLE diarization_runs (
id INTEGER PRIMARY KEY AUTOINCREMENT,
audio_chunk_id INTEGER NOT NULL REFERENCES audio_chunks(id) ON DELETE CASCADE,
mode TEXT NOT NULL CHECK (mode IN ('live', 'background')),
provider TEXT NOT NULL,
model TEXT,
status TEXT NOT NULL DEFAULT 'completed',
created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
metadata JSON
)