SQL

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
)

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ read-only
speaker_id INTEGER read-only
diarization_segment_id INTEGER ✓ read-only
audio_chunk_id INTEGER ✓ read-only
start_time REAL ✓ read-only
end_time REAL ✓ read-only
source TEXT read-only
confidence REAL ✓ read-only
approved BOOLEAN read-only
created_at DATETIME ✓ read-only
metadata JSON ✓ read-only

Foreign Keys

Column Destination
audio_chunk_id audio_chunks.id
diarization_segment_id diarization_segments.id
speaker_id speakers.id

Indexes

Name Columns Unique SQL Drop?