Contents

class CreateEcomCoreTaskTemplates < ActiveRecord::Migration[6.0]
  def change
    create_table :ecom_core_task_templates do |t|
      t.string :code, null: false
      t.string :name, null: false
      t.string :description
      t.references :task_template_type,
                   null: false,
                   index: { name: 'tt_on_ttt_indx' },
                   foreign_key: { to_table: :ecom_core_task_template_types }
      t.references :unit_of_measure,
                   null: false,
                   index: { name: 'tt_on_uof_indx' },
                   foreign_key: { to_table: :ecom_core_unit_of_measures }
      t.string :ancestry, index: true
      t.boolean :has_takeoff_fields, null:false, default: false
      t.jsonb :takeoff_fields, null: false, default: {}
      t.integer :percentage_contribution
      t.integer :task_sequence
      t.boolean :has_inspection, null: false, default: false
      t.boolean :discipline, null: false, default: false
      t.jsonb :task_completion_detail, null: false, default: {}

      t.timestamps
    end
  end
end

Version data entries

4 entries across 4 versions & 1 rubygems

Version	Path
ecom_core-1.3.2	db/migrate/20191119012030_create_ecom_core_task_templates.rb
ecom_core-1.3.1	db/migrate/20191119012030_create_ecom_core_task_templates.rb
ecom_core-1.3.0	db/migrate/20191119012030_create_ecom_core_task_templates.rb
ecom_core-1.2.36	db/migrate/20191119012030_create_ecom_core_task_templates.rb