foreign key is not working when I migrate

Question

Foreign key is not working.

This is my migration file

Schema::create('course_prospect', function (Blueprint $table) {
      $table->bigIncrements('id');

      $table->integer('prospect_id')->length(11)->unsigned();
      $table->foreign('prospect_id')->references('id')->on('prospect');

      $table->integer('course_id')->length(11)->unsigned();
      $table->foreign('course_id')->references('course_id')->on('course');

      $table->timestamps();
    });

I'm getting this error

 Illuminate\Database\QueryException  : SQLSTATE[HY000]: General error: 
1005 Can't create table `customerinquirydb`.`#sql-104c_e9` (errno: 150 
"Foreign key constraint is incorrectly formed") (SQL: alter table 
`course_prospect` add constraint `course_prospect_prospect_id_foreign` 
foreign key (`prospect_id`) references `prospect` (`id`))

Possible duplicate of [laravel errno 150 foreign key constraint is incorrectly formed](https://stackoverflow.com/questions/40863517/laravel-errno-150-foreign-key-constraint-is-incorrectly-formed) — CapaNif, Apr 01 '19 at 10:38
i think here in this line `id` should be replaced by `prospect_id` `$table->foreign('prospect_id')->references('id')->on('prospect');` — Ash-b, Apr 01 '19 at 10:40

score 2 · Accepted Answer · answered Apr 01 '19 at 10:44

2

When migrating a table with a foreign key in Laravel. The table where that foreign key is, MUST be created first (must exist)! So please make sure that is the case.

answered Apr 01 '19 at 10:44

lewis4u

14,256
18
107
148

foreign key is not working when I migrate

1 Answers1