Sha256: 26ee5e4b367aabd59c4761d1f60b8561ec8b3e6e15a22888c0548890edc221d6
Contents?: true
Size: 1.61 KB
Versions: 2
Compression:
Stored size: 1.61 KB
Contents
class CreateComeeCoreMasterPrices < ActiveRecord::Migration[7.0] def change create_table :comee_core_master_prices do |t| t.float :purchase_price, null: false t.float :selling_price, null: false t.date :valid_from, null: false t.date :valid_to, null: false t.float :status, null: false, default: 0 t.boolean :primary, null: false, default: false t.integer :margin, null: false t.references :product, null: false, index: {name: "product_on_ccmp_indx"}, foreign_key: {to_table: :comee_core_products} t.references :supplier, null: false, index: {name: "supplier_on_ccmp_indx"}, foreign_key: {to_table: :comee_core_suppliers} t.references :unit, null: false, index: {name: "unit_on_ccmp_indx"}, foreign_key: {to_table: :comee_core_units} t.references :previous_price, null: true, index: {name: "previous_price_on_ccsp_indx"}, foreign_key: {to_table: :comee_core_master_prices} t.references :next_price, null: true, index: {name: "next_price_on_ccsp_indx"}, foreign_key: {to_table: :comee_core_master_prices} t.boolean :propagated_to_client, null: false, default: false t.timestamps end add_index :comee_core_master_prices, %i[product_id supplier_id previous_price_id], unique: true, name: "pi_si_ppi_on_ccmp_indx" end end
Version data entries
2 entries across 2 versions & 1 rubygems
Version | Path |
---|---|
comee_core-0.1.39 | db/migrate/20230813235946_create_comee_core_master_prices.rb |
comee_core-0.1.38 | db/migrate/20230813235946_create_comee_core_master_prices.rb |