check_col_big_int.rb

Rails.application.eager_load!

ActiveRecord::Base.descendants.each do |model|
  next unless model.table_exists?
  
  model.columns.each do |col|
    next unless col.name =~ /_?id\Z/

    if col.type == :integer && col.sql_type != "bigint"
      puts "#{model.table_name} #{col.name} is of type #{col.sql_type} but should be bigint"
    end
  end
end; nil