priv/repo/migrations/20240208193759_create_transcription_chunks.exs

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

  def change do
    create table(:transcription_chunks, primary_key: false) do
      add :id, :binary_id, primary_key: true
      add :text, :string
      add :start_mark, :string
      add :end_mark, :string

      add :transcription_id,
          references(:transcriptions, type: :binary_id, on_delete: :delete_all),
          null: false

      timestamps(type: :utc_datetime)
    end
  end
end