herokuでDBの情報を反映させたい

Question

引用テキスト# 解決したいこと

herokuにDBの情報を反映させたい

環境

rails 5.2.3
ruby 2.5.1

状況

現在、アプリが完成しherokuでデプロイしようとしました。
そこで下記手順で行いましたがデプロイは完了していますがDB情報が反映されておらず正常にページが作動していませんでした。「target_category」がない的なエラーが出ていると思いますが、「target_category」というカラムは名前変更しているため「category_id」になっており今はありません。
どのようにすれば正常に作動しますか？

手順

1.heroku login

2.Gemfileを以下のように編集する
gem 'sqlite3' をgroup :development do ~ end の中に入れる。

group :production do ~end の作成し中に、gem 'pg'　を入れる。

3.bundle --without production

4.git init

5.heroku create アプリ名

6.git add *

7.git commit -m “initial commit”

8.git push heroku master

9.heroku run rails db:migrate

10.heroku run rails db:seed

11.heroku open

コード記述

Gemfile

source 'https://rubygems.org'
git_source(:github) { |repo| "https://github.com/#{repo}.git" }

ruby '2.5.1'

# Bundle edge Rails instead: gem 'rails', github: 'rails/rails'
gem 'rails', '~> 5.2.3'
# Use sqlite3 as the database for Active Record
# Use Puma as the app server
gem 'puma', '~> 3.11'
# Use SCSS for stylesheets
gem 'sass-rails', '~> 5.0'
# Use Uglifier as compressor for JavaScript assets
gem 'uglifier', '>= 1.3.0'
# See https://github.com/rails/execjs#readme for more supported runtimes
# gem 'mini_racer', platforms: :ruby

# Use CoffeeScript for .coffee assets and views
gem 'coffee-rails', '~> 4.2'
# Turbolinks makes navigating your web application faster. Read more: https://github.com/turbolinks/turbolinks
gem 'turbolinks', '~> 5'
# Build JSON APIs with ease. Read more: https://github.com/rails/jbuilder
gem 'jbuilder', '~> 2.5'
# Use Redis adapter to run Action Cable in production
# gem 'redis', '~> 4.0'
# Use ActiveModel has_secure_password
# gem 'bcrypt', '~> 3.1.7'

# Use ActiveStorage variant
# gem 'mini_magick', '~> 4.8'

# Use Capistrano for deployment
# gem 'capistrano-rails', group: :development

# Reduces boot times through caching; required in config/boot.rb
gem 'bootsnap', '>= 1.1.0', require: false

group :development, :test do
  # Call 'byebug' anywhere in the code to stop execution and get a debugger console
  gem 'byebug', platforms: [:mri, :mingw, :x64_mingw]
  gem 'rspec-rails'
  gem 'factory_bot_rails'
end

group :production do
  gem 'pg'
end

group :development do
  gem 'sqlite3'
  # Access an interactive console on exception pages or by calling 'console' anywhere in the code.
  gem 'web-console', '>= 3.3.0'
  gem 'listen', '>= 3.0.5', '< 3.2'
  # Spring speeds up development by keeping your application running in the background. Read more: https://github.com/rails/spring
  gem 'spring'
  gem 'spring-watcher-listen', '~> 2.0.0'
end

group :test do
  # Adds support for Capybara system testing and selenium driver
  gem 'capybara', '>= 2.15'
  gem 'selenium-webdriver'
  # Easy installation and use of chromedriver to run system tests with Chrome
  gem 'chromedriver-helper'
end

# Windows does not include zoneinfo files, so bundle the tzinfo-data gem
gem 'tzinfo-data', platforms: [:mingw, :mswin, :x64_mingw, :jruby]

gem "sass-rails","~>5.0"
gem "bootstrap-sass","~>3.3.6"
gem "jquery-rails"
gem "jquery-ui-rails"

gem "font-awesome-sass"

gem 'autonumeric-rails'

gem 'pry-rails'

マイグレーションファイルは以下の通りです。

class CreateTargets < ActiveRecord::Migration[5.2]
  def change
    create_table :targets do |t|
      t.string "title"
      t.text "memo"
      t.date "date"
      t.integer "targets_category"
      t.integer "priority_category"
      t.timestamps
    end
  end
end

class CreateCategories < ActiveRecord::Migration[5.2]
  def change
    create_table :categories do |t|
      t.string "name"
      t.timestamps
    end
  end
end

class AddPriceToTargets < ActiveRecord::Migration[5.2]
  def change
    add_column :targets, :price, :integer
  end
end

class RenameTargetsCategoryColumnToTargets < ActiveRecord::Migration[5.2]
  def change
    rename_column :targets, :targets_category, :category_id
  end
end

class RenamePriorityCategoryColumnToTargets < ActiveRecord::Migration[5.2]
  def change
    rename_column :targets, :priority_category, :priority
  end
end

class RenamePriorityCategoriesToPriorities < ActiveRecord::Migration[5.2]
  def change
    rename_table :priority_categories, :priorities
  end
end

class RenamePriorityColumnToTargets < ActiveRecord::Migration[5.2]
  def change
    rename_column :targets, :priority, :priority_id
  end
end

class AddPositionToTargets < ActiveRecord::Migration[5.2]
  def change
    add_column :targets, :position, :integer
  end
end

seeds.rb

Category.find_or_create_by(name:"旅行")
Category.find_or_create_by(name:"なりたい自分")
Category.find_or_create_by(name:"アクティビティ")
Category.find_or_create_by(name:"仕事")
Category.find_or_create_by(name:"健康美容")
Category.find_or_create_by(name:"ライフスタイル")
Category.find_or_create_by(name:"家族")
Category.find_or_create_by(name:"恋人")
Category.find_or_create_by(name:"欲しいもの")
Priority.find_or_create_by(name:"★")
Priority.find_or_create_by(name:"★★")
Priority.find_or_create_by(name:"★★★")
Priority.find_or_create_by(name:"★★★★")
Priority.find_or_create_by(name:"★★★★★")

エラー文

※文字超過のためエラー文を抜粋してます。
必要であれば追記します。

Running rails db:migrate on ⬢ ren-target-app-0416... up, run.7460 (Free)
D, [2020-04-16T12:54:01.410763 #4] DEBUG -- :    (0.9ms)  SELECT pg_try_advisory_lock(3101651796077205420)
D, [2020-04-16T12:54:01.427252 #4] DEBUG -- :    (1.7ms)  SELECT "schema_migrations"."version" FROM "schema_migrations" ORDER BY "schema_migrations"."version" ASC
I, [2020-04-16T12:54:01.428938 #4]  INFO -- : Migrating to RenameTargetsCategoryColumnToTargets (20200414031534)
D, [2020-04-16T12:54:01.432758 #4] DEBUG -- :    (0.8ms)  BEGIN
== 20200414031534 RenameTargetsCategoryColumnToTargets: migrating =============
-- rename_column(:targets, :targets_category, :category_id)
D, [2020-04-16T12:54:01.434678 #4] DEBUG -- :    (1.5ms)  ALTER TABLE "targets" RENAME COLUMN "targets_category" TO "category_id"
D, [2020-04-16T12:54:01.435645 #4] DEBUG -- :    (0.8ms)  ROLLBACK
D, [2020-04-16T12:54:01.436821 #4] DEBUG -- :    (0.9ms)  SELECT pg_advisory_unlock(3101651796077205420)
rails aborted!
StandardError: An error has occurred, this and all later migrations canceled:

PG::UndefinedColumn: ERROR:  column "targets_category" does not exist
: ALTER TABLE "targets" RENAME COLUMN "targets_category" TO "category_id"
（中略）
Caused by:
ActiveRecord::StatementInvalid: PG::UndefinedColumn: ERROR:  column "targets_category" does not exist
: ALTER TABLE "targets" RENAME COLUMN "targets_category" TO "category_id"
（中略）
Caused by:
PG::UndefinedColumn: ERROR:  column "targets_category" does not exist
（中略）
Tasks: TOP => db:migrate
(See full trace by running task with --trace)

Answer 1

カラム名を適切な書き方で設定し、テーブル作成したらどうなりますか？

例：t.string "title"⇒ t.string :title

class CreateTargets < ActiveRecord::Migration[5.2]
  def change
    create_table :targets do |t|
      t.string :title
      t.text :memo
      t.date :date
      t.integer :targets_category
      t.integer :priority_category
      t.timestamps
    end
  end
end


class CreateCategories < ActiveRecord::Migration[5.2]
  def change
    create_table :categories do |t|
      t.string :name
      t.timestamps
    end
  end
end

https://railsguides.jp/active_record_migrations.html