Question:
How to use string as foreign key in laravel 7 migrations ?
Example not working:
$table->string('categorie_id');
$table->foreign('categorie_id')->references('id')->on('categories');
Solution:
The problem is: categorie_id is a string and id is an integer.
to solve this you must have exactly the same definition, so they must be the same type.
Example:
in countries table:
$table->string('code')->primary();
in users table:
$table->string('country_code');
$table->foreign('country_code')->references('code')->on('countries');
