Contents

class CreateLogisticsCoreContainerStorageRates < ActiveRecord::Migration[5.0]
  def change
    create_table :logistics_core_container_storage_rates do |t|
      t.references :container_size, index: { name: 'csr_on_cs_indx' }
      t.references :transaction_type, index: { name: 'csr_on_tt_indx' }
      t.references :warehouse_rate_period, index: { name: 'csr_on_wrp_indx' }
      t.references :container_type, index: { name: 'csr_on_ct_indx' }
      t.references :content_type, index: { name: 'csr_on_cnt_indx' }
      t.float :rate
      t.date :effective_date

      t.timestamps
    end

    add_foreign_key :logistics_core_container_storage_rates, :logistics_core_lookups, :column => :container_size_id
    add_foreign_key :logistics_core_container_storage_rates, :logistics_core_lookups, :column => :transaction_type_id
    add_foreign_key :logistics_core_container_storage_rates, :logistics_core_warehouse_rate_periods,
                    :column => :warehouse_rate_period_id
    add_foreign_key :logistics_core_container_storage_rates, :logistics_core_lookups, :column => :container_type_id
    add_foreign_key :logistics_core_container_storage_rates, :logistics_core_lookups, :column => :content_type_id
  end
end

Version data entries

9 entries across 9 versions & 1 rubygems

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