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

  def change do
    create table(:pos_transaction) do
      add :pan, :string, size: 45
      add :proc_code, :string, size: 45
      add :amount, :string, size: 45
      add :stan, :string, size: 45
      add :date_time, :string, size: 45
      add :settlement_date, :string, size: 45
      add :mcc, :string, size: 45
      add :terminal_id, :string, size: 45
      add :merchant_id, :string, size: 45
      add :reference_id, :string, size: 45
      add :auth_code, :string, size: 45
      add :response_code, :string, size: 45
      add :upi_url, :string, size: 511
      add :upi_info, :string, size: 1023
      add :meta_data, :string, size: 45

      timestamps(updated_at: false, inserted_at: :date_added)
    end
  end
end