+/- table definition

Query 

CREATE TABLE speaker_identity_evidence  (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  speaker_id INTEGER NOT NULL REFERENCES speakers(id) ON DELETE CASCADE,
  diarization_segment_id INTEGER REFERENCES diarization_segments(id) ON DELETE SET NULL,
  audio_chunk_id INTEGER REFERENCES audio_chunks(id) ON DELETE CASCADE,
  start_time REAL,
  end_time REAL,
  source TEXT NOT NULL,
  confidence REAL,
  approved BOOLEAN NOT NULL DEFAULT FALSE,
  created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
  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