如何在Rails5中添加参考键

我想在receipt_id表中添加hospitalization作为外键

我尝试了以下命令。

rails g migration AddReceiptToHospitalizations receipt:references

迁移文件就是这样。

class AddReceiptToHospitalizations < activeRecord::Migration[5.0]
  def change
    add_reference :hospitalizations,:receipt,foreign_key: true
  end
end

当我尝试rails db:migrate时遇到以下错误。

== 20191116102056 AddReceiptRefToHospitalizations: migrating ==================
-- add_reference(:hospitalizations,{:foreign_key=>true})
rails aborted!
StandardError: An error has occurred,all later migrations canceled:

Mysql2::Error: Can't create table 'calendar_test_development.#sql-fa0_1c' (errno: 150): ALTER TABLE `hospitalizations` ADD CONSTRAINT `fk_rails_325b2e6b31`
FOREIGN KEY (`receipt_id`)
  REFERENCES `receipts` (`id`)

如果有人已经遇到这种错误,请让我知道如何解决。 谢谢。

bcp123 回答:如何在Rails5中添加参考键

暂时没有好的解决方案,如果你有好的解决方案,请发邮件至:iooj@foxmail.com
本文链接:https://www.f2er.com/3090635.html

大家都在问