+/- table definition

Query 

CREATE TABLE diarization_segments  (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  diarization_run_id INTEGER NOT NULL REFERENCES diarization_runs(id) ON DELETE CASCADE,
  audio_chunk_id INTEGER NOT NULL REFERENCES audio_chunks(id) ON DELETE CASCADE,
  provider_speaker_label TEXT NOT NULL,
  speaker_id INTEGER REFERENCES speakers(id) ON DELETE SET NULL,
  source TEXT NOT NULL DEFAULT 'provider',
  start_time REAL NOT NULL,
  end_time REAL NOT NULL,
  confidence REAL,
  overlap BOOLEAN NOT NULL DEFAULT FALSE,
  metadata JSON
)
Use Shift + Up/Down to navigate recently-executed queries
delete expression index : create index : drop insert select : advanced select table : alter table : create table : drop trigger : create trigger : drop update view : create view : drop