SQL

CREATE TABLE speaker_embeddings  (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  embedding FLOAT[512] NOT NULL
    check(
      typeof(embedding) == 'blob'
      and vec_length(embedding) == 512
    ),
  speaker_id INTEGER REFERENCES speakers(id)
)

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ read-only
embedding FLOAT[512] read-only
speaker_id INTEGER ✓ read-only

Foreign Keys

Column Destination
speaker_id speakers.id

Indexes

Name Columns Unique SQL Drop?
idx_speaker_embeddings_speaker_id speaker_id SQL 
CREATE INDEX idx_speaker_embeddings_speaker_id
ON speaker_embeddings(speaker_id)
read-only