Query
CREATE TABLE audio_chunks (
id INT,
file_path TEXT,
timestamp NUM,
sync_id TEXT,
machine_id TEXT,
synced_at NUM,
evicted_at NUM,
transcription_status TEXT NOT NULL DEFAULT 'pending'
CHECK (transcription_status IN ('pending', 'transcribed', 'silent', 'failed')),
transcription_attempts INTEGER NOT NULL DEFAULT 0,
last_transcription_attempt_at TIMESTAMP,
transcription_failure_reason TEXT
)