SQL

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
)

Columns

Column Data type Allow null Primary key Actions
id INT ✓ read-only
file_path TEXT ✓ read-only
timestamp NUM ✓ read-only
sync_id TEXT ✓ read-only
machine_id TEXT ✓ read-only
synced_at NUM ✓ read-only
evicted_at NUM ✓ read-only
transcription_status TEXT read-only
transcription_attempts INTEGER read-only
last_transcription_attempt_at TIMESTAMP ✓ read-only
transcription_failure_reason TEXT ✓ read-only

Indexes

Name Columns Unique SQL Drop?
idx_audio_chunks_timestamp timestamp SQL 
CREATE INDEX idx_audio_chunks_timestamp
ON audio_chunks(timestamp)
read-only