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

  def change do
    create table(:transactions) do
      add :patient_name, :string
      add :uhid, :string
      add :charge_rate, :decimal, precision: 10, scale: 2
      add :email, :string
      add :mobile_no, :string
      add :processing_id, :string
      add :uname, :string
      add :user_id, :string
      add :pay_mode, :string
      add :location_id, :string
      add :transaction_location, :string
      add :credentials_user, :string
      add :credentials_key, :string
      add :version, :string
      add :return_url, :string
      add :response_url, :string
      add :status, :string
      add :transaction_id, :string
      add :transaction_amount, :decimal, precision: 10, scale: 2
      add :transaction_ref_number, :string
      add :m_ref_num, :string
      add :name, :string
      add :provider_id, :integer
      add :device_id, :string
      add :merchant_id, :string
      add :additional_data, :map
      add :payment_reference_id, :string
      add :refund_reference_id, :string
      add :provider_name, :string
      add :payload, :map
      add :settlement_date_time, :utc_datetime
      add :batch_number, :string
      add :bank_user_id, :string
      add :merchant_tag, :string
      add :settlement_id, :string
      add :settlement_status, :string, default: "unmatched"

      timestamps(type: :utc_datetime)
    end

    create index(:transactions, [:transaction_id])
    create index(:transactions, [:device_id])
    create index(:transactions, [:merchant_id])
    create index(:transactions, [:status])
    create index(:transactions, [:settlement_status])
    create index(:transactions, [:payment_reference_id])
  end
end