class CreateEducodeSalesSaleReports < ActiveRecord::Migration[5.2]
  def change
    create_table :educode_sales_sale_reports do |t|
      t.references :staff
      t.date :month, comment: '月份'
      t.integer :weekly, comment: '周'
      t.integer :finish_rate, comment: '完成率'
      t.integer :client, comment: '覆盖客户数'
      t.float :amount, comment: '项目金额'
      t.text :content, comment: '个人总结'
      t.text :level1_opinion, comment: '大区意见'
      t.float :level1_score, comment: '大区评分'
      t.text :level2_opinion, comment: '总监意见'
      t.float :level2_score, comment: '总监评分'
      t.text :level3_opinion, comment: '副总意见'
      t.float :level3_score, comment: '副总评分'

      t.timestamps
    end
  end
end