defmodule DaProductApp.Repo.Migrations.CreateDisputes do
  use Ecto.Migration

  def change do
    create table(:disputes, primary_key: false) do
      add :id, :binary_id, primary_key: true
      add :dispute_id, :string, null: false
      add :txn_id, :string, null: false
      add :reason, :string, null: false
      add :merchant_comment, :string
      add :ops_response, :string
      add :contact_email, :string, null: false
      add :status, :string, default: "open", null: false
      add :bank_user_id, :string

      timestamps(type: :utc_datetime)
    end

    create unique_index(:disputes, [:dispute_id])
    create index(:disputes, [:txn_id])
    create index(:disputes, [:status])
    create index(:disputes, [:bank_user_id])
  end
end