class CreateCardSaleTrans < ActiveRecord::Migration[5.1]
  def change
    create_table :card_sale_trans do |t|
    	t.string :sale_id, :index=>true
    	t.date   :req_date
		t.time   :req_time
		t.float  :req_amt, :limit=>50 
		t.string :req_inv_no
		t.string :req_cmd 
		t.string :req_type 
		t.date   :res_date 
		t.time   :res_time
		t.float  :res_amt, :limit=>50
		t.string :res_inv_no
		t.string :res_cmd
		t.string :res_type
		t.string :status, :limit=>50
		t.string :resp
		t.string :trace
		t.string :app_code
		t.string :pan
		t.string :exp_date
		t.string :tips
		t.string :entry_mode
		t.string :terminal_id
		t.string :merchant_id
		t.string :card_holder
		t.string :batch_no
		t.string :ref_no
		t.string :app
		t.string :emv_app_id
		t.string :emv_cyptrogram
		t.string :curr_code
		t.string :fx_rate
		t.float  :foreign_amt, :limit=>50
		t.string :dcc_msg
		t.string :tender
		t.string :print_text_part1_type
		t.string :print_text_part1_value
		t.string :print_text_part2_type
		t.string :print_text_part2_value
		t.string :print_text_part3_type
		t.string :print_text_part3_value
		t.string :print_text_part4_type
		t.string :print_text_part4_value
    end
  end

  def down
  	drop_table :card_sale_trans
  end
end
