class CreateIdeaFollows < ActiveRecord::Migration[5.2]
  def change
    # 序号、最新进展、所属商机、单位、预算、状态、团队建议、销售经理、方案经理、跟进人、跟进时间、操作（详情、团队建议））
    create_table :educode_sales_idea_follows do |t|
      t.text :content
      t.references :idea
      t.references :school
      t.float :money
      t.integer :status
      t.text :advise
      t.references :sale_staff
      t.references :idea_staff
      t.references :staff
      t.text :comment

      t.timestamps
    end
    add_column :educode_sales_ideas, :idea_type, :integer
    add_column :educode_sales_ideas, :other_staff_ids, :text
    add_column :educode_sales_ideas, :idea_follows_count, :integer, default: 0
    add_column :educode_sales_ideas, :last_idea_follow_id, :integer
    add_column :educode_sales_ideas, :advise, :text
    add_column :educode_sales_ideas, :business_id, :integer
  end
end