Contents

class CreateEducodeSalesSalesTargetHistories < ActiveRecord::Migration[5.2]
  def change
    create_table :educode_sales_sales_target_histories do |t|
      t.references :staff
      t.string :target_clazz, comment: '目标类别'
      t.integer :school_tag_id, comment: '客户类别'
      t.integer :num, comment: '序号'
      t.string :state, comment: '审核状态'
      t.float :year_target, comment: '年度目标', :limit => 53
      t.float :year_finish, comment: '年度完成', :limit => 53
      t.string :year, comment: '年份'
      t.float :year_diff, comment: '年度差额', :limit => 53
      t.references :reviewer, comment: '审核人员'
      t.integer :creator_id, comment: '创建者'
      t.boolean :is_use, default: false, comment: '采用'
      t.string :comment, comment: '评论'
      t.float :target_1, comment: '1月目标', :limit => 53
      t.float :m_target_1, comment: '修改的1月目标', :limit => 53
      t.float :target_2, comment: '2月目标', :limit => 53
      t.float :m_target_2, comment: '修改的2月目标', :limit => 53
      t.float :target_3, :limit => 53
      t.float :m_target_3, :limit => 53
      t.float :target_4, :limit => 53
      t.float :m_target_4, :limit => 53
      t.float :target_5, :limit => 53
      t.float :m_target_5, :limit => 53
      t.float :target_6, :limit => 53
      t.float :m_target_6, :limit => 53
      t.float :target_7, :limit => 53
      t.float :m_target_7, :limit => 53i
      t.float :target_8, :limit => 53
      t.float :m_target_8, :limit => 53
      t.float :target_9, :limit => 53
      t.float :m_target_9, :limit => 53
      t.float :target_10, :limit => 53
      t.float :m_target_10, :limit => 53
      t.float :target_11, :limit => 53
      t.float :m_target_11, :limit => 53
      t.float :target_12, :limit => 53
      t.float :m_target_12, :limit => 53

      t.timestamps
    end
  end
end

Version data entries

5 entries across 5 versions & 1 rubygems

Version	Path
educode_sales-1.10.74	db/migrate/20230729085359_create_educode_sales_sales_target_histories.rb
educode_sales-1.10.73	db/migrate/20230729085359_create_educode_sales_sales_target_histories.rb
educode_sales-1.10.72	db/migrate/20230729085359_create_educode_sales_sales_target_histories.rb
educode_sales-1.10.71	db/migrate/20230729085359_create_educode_sales_sales_target_histories.rb
educode_sales-1.10.70	db/migrate/20230729085359_create_educode_sales_sales_target_histories.rb