オリジナルアプリ作成中です。テーブルに外部キーが追加できなくて困っています。

Question

ターミナルにてテーブルに外部キーを作成しrails db:migrateすると以下のエラーが出てしまいます。原因が分からず途方に暮れています。　
ご教授頂けると助かります。

rails aborted!
StandardError: An error has occurred, all later migrations canceled:

Mysql2::Error: Table 'tomori_app_development.owners' doesn't exist
/Users/fumi/projects/tomori_app/db/migrate/20210129112855_create_shoppings.rb:3:in change' /Users/fumi/projects/tomori_app/bin/rails:9:in <top (required)>'
/Users/fumi/projects/tomori_app/bin/spring:15:in <top (required)>' bin/rails:3:in load'
bin/rails:3:in `<main>'

Caused by:
ActiveRecord::StatementInvalid: Mysql2::Error: Table 'tomori_app_development.owners' doesn't exist
/Users/fumi/projects/tomori_app/db/migrate/20210129112855_create_shoppings.rb:3:in change' /Users/fumi/projects/tomori_app/bin/rails:9:in <top (required)>'
/Users/fumi/projects/tomori_app/bin/spring:15:in <top (required)>' bin/rails:3:in load'
bin/rails:3:in `<main>'

Caused by:
Mysql2::Error: Table 'tomori_app_development.owners' doesn't exist
/Users/fumi/projects/tomori_app/db/migrate/20210129112855_create_shoppings.rb:3:in change' /Users/fumi/projects/tomori_app/bin/rails:9:in <top (required)>'
/Users/fumi/projects/tomori_app/bin/spring:15:in <top (required)>' bin/rails:3:in load'
bin/rails:3:in `<main>'

Caused by:
Mysql2::Error: Cannot add foreign key constraint
/Users/fumi/projects/tomori_app/db/migrate/20210129112855_create_shoppings.rb:3:in change' /Users/fumi/projects/tomori_app/bin/rails:9:in <top (required)>'
/Users/fumi/projects/tomori_app/bin/spring:15:in <top (required)>' bin/rails:3:in load'
bin/rails:3:in `<main>'
Tasks: TOP => db:migrate
(See full trace by running task with --trace)

説明が足りなくてすみません。追加記入です。
rails db:migrate：statusの結果

database: tomori_app_development

Status Migration ID Migration Name

up 20210126060600 Devise create users
up 20210126062512 Create active storage tablesactive storage
up 20210129112855 Create shoppings
up 20210131072013 Create orders
up 20210131143313 Devise create owners

モデルの記入内容
class Shopping < ApplicationRecord
belongs_to :owner, optional: true, foreign_key: :owner_id
has_one :order
has_one_attached :image

extend ActiveHash::Associations::ActiveRecordExtensions

with_options presence: true do
validates :product_name
validates :price
validates :image
end
end

データベース
class CreateShoppings < ActiveRecord::Migration[6.0]
def change
create_table :shoppings do |t|
t.string :product_name, null: false
t.integer :price, null: false
#t.references :owner, foreign_key: true

  t.timestamps
end

end
end

Answer 1

多分、20210129112855_create_shoppings.rb の前に table owners が作られて居ないのでしょう。
rails db:migrate:status の結果と
20210129112855_create_shoppings.rb とを
載せてください。

Comments

[Fumi_Kazu5]

ご回答ありがとう御座います。助かります。
追加で画像を送ります。

rails db:migrate:statusの結果。
https://gyazo.com/308c92a9656c7b824e29f7a1a88ca362

create_shoppings.rb関係。
https://gyazo.com/c3c197f7265ec40cdd7a1a187a1ab86b
https://gyazo.com/11da8c636ad2bddb7892d68d065aaa23

[winterboum]

画像でなくtextで載せて
コメントではなく質問欄を編集して

[Fumi_Kazu5]

すみません。投稿内容を訂正します。

[winterboum]

20210129112855_create_shoppings.rb　は？