我想在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`)
如果有人已经遇到这种错误,请让我知道如何解决。 谢谢。