priv/repo/migrations/20240209165222_create_transcription_chunk_keywords.exs

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

  def change do
    create table(:transcription_chunk_keywords, primary_key: false) do
      add :id, :binary_id, primary_key: true
      add :keyword, :string
      add :score, :float

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

      timestamps(type: :utc_datetime)
    end
  end
end