rails migration添加数据库字段备注

最后添加上comment即可！环境：Rails 6
代码：

class CreatePlanManagers < ActiveRecord::Migration[6.0]
  def change
    create_table :plan_managers do |t|
      t.integer :user_id, null: false
      t.integer :object_id, null: false, comment: 'model_id'
      t.string :object_name, null: false, comment: 'model名称，如PthSentence'
      t.datetime :plan_make_time, comment: '计划生成时间'
      t.integer :circletime, default: 0, comment: '计划循环次数'

      t.timestamps
    end
  end
end

数据库中对应表：

如果是后期想添加备注，可以使用change_column_comment，比如：

def change
  change_column_comment(:posts, :state, from: "old_comment", to: "new_comment")
end

或者使用change_column

class AddCommentsToReferences < ActiveRecord::Migration[5.2]
  def up
    change_column :references, :achievement_id, :integer, comment: 'Achievement'
    change_column :references, :object_id, :integer, comment: 'Achievement object id'
  end
end

这个感觉才最方便。