Contents

class CreateLogisticsCoreTruckRates < ActiveRecord::Migration[5.0]
  def change
    create_table :logistics_core_truck_rates do |t|
      t.references :transaction_type, index: { name: 'tr_on_tt_indx' }
      t.references :chargeable_service_unit_of_charge, index: { name: 'tr_on_csuoc_indx' }
      t.float :rate
      t.date :effective_date
      t.float :low
      t.float :medium
      t.float :high
      t.float :margin

      t.timestamps
    end

    add_foreign_key :logistics_core_truck_rates, :logistics_core_lookups, :column => :transaction_type_id
    add_foreign_key :logistics_core_truck_rates, :logistics_core_chargeable_service_unit_of_charges,
                    :column => :chargeable_service_unit_of_charge_id
  end
end

Version data entries

9 entries across 9 versions & 1 rubygems

Version	Path
logistics_core-21.11.2	db/migrate/20170107084652_create_logistics_core_truck_rates.rb
logistics_core-21.11.1	db/migrate/20170107084652_create_logistics_core_truck_rates.rb
logistics_core-21.08.1	db/migrate/20170107084652_create_logistics_core_truck_rates.rb
logistics_core-21.03.1	db/migrate/20170107084652_create_logistics_core_truck_rates.rb
logistics_core-20.10.3	db/migrate/20170107084652_create_logistics_core_truck_rates.rb
logistics_core-20.10.2	db/migrate/20170107084652_create_logistics_core_truck_rates.rb
logistics_core-20.10.1	db/migrate/20170107084652_create_logistics_core_truck_rates.rb
logistics_core-20.9.1	db/migrate/20170107084652_create_logistics_core_truck_rates.rb
logistics_core-20.8.1	db/migrate/20170107084652_create_logistics_core_truck_rates.rb