MyApp.Repo.Migrations.AddTableUserProject.ex

defmodule MyApp.Repo.Migrations.AddTableUserProject do
  use Ecto.Migration

  def change do
    create table(:user_project, primary_key: false) do
      add(:project_id, references(:project, on_delete: :delete_all), primary_key: true)
      add(:user_id, references(:user, on_delete: :delete_all), primary_key: true)
      timestamps()
    end

    create(index(:user_project, [:project_id]))
    create(index(:user_project, [:user_id]))
  end
end