SQL

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
)

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ read-only
audio_chunk_id INTEGER read-only
mode TEXT read-only
provider TEXT read-only
model TEXT ✓ read-only
status TEXT read-only
created_at DATETIME ✓ read-only
metadata JSON ✓ read-only

Foreign Keys

Column Destination
audio_chunk_id audio_chunks.id

Indexes

Name Columns Unique SQL Drop?