priv/repo/migrations/20240209203409_create_transcription_chunk_code_vectors.exs

defmodule Medicode.Repo.Migrations.CreateTranscriptionChunkCodeVectors do
  use Ecto.Migration

  def change do
    create table(:transcription_chunk_code_vectors, primary_key: false) do
      add :id, :binary_id, primary_key: true
      add :cosine_similarity, :float
      add :weighting, {:array, :string}

      add :transcription_chunk_id,
          references(:transcription_chunks, type: :binary_id, on_delete: :delete_all),
          null: false

      add :code_vector_id,
          references(:code_vectors, type: :binary_id, on_delete: :delete_all),
          null: false

      timestamps(type: :utc_datetime)
    end
  end
end