Contents

class CreateComeeCoreProducts < ActiveRecord::Migration[7.0]
  def change
    create_table :comee_core_products do |t|
      t.string :code, null: false
      t.string :name, null: false
      t.string :description
      t.jsonb :metadata
      t.references :product_type,
                   null: false,
                   index: {name: "ccpt_on_ccp_indx"},
                   foreign_key: {to_table: :comee_core_product_types}
      t.references :unit,
                   null: false,
                   index: {name: "unit_on_ccp_indx"},
                   foreign_key: {to_table: :comee_core_units}
      t.string "ancestry", collation: "C"
      t.index "ancestry"

      t.timestamps
    end
    add_index :comee_core_products, :code, unique: true
  end
end

Version data entries

4 entries across 4 versions & 1 rubygems

Version	Path
comee_core-0.1.40	db/migrate/20230728014322_create_comee_core_products.rb
comee_core-0.1.39	db/migrate/20230728014322_create_comee_core_products.rb
comee_core-0.1.38	db/migrate/20230728014322_create_comee_core_products.rb
comee_core-0.1.37	db/migrate/20230728014322_create_comee_core_products.rb