How to make Foreign Keys using Migrations Laravel

Question

How to make Foreign Keys using Migrations Laravel

Navigation

#1 by (0 votes)

0

I'm trying to relate one field to another using migrations this way:

Butwhendoingtheforeignkeyinmigrationsthisway:

MigrationPermission:

Schema::create('permissions',function(Blueprint$table){$table->increments('id');$table->index('user_id');$table->timestamps();});

MigrationUser:

Schema::create('users',function(Blueprint$table){$table->string('id',100)->primary();//CódigoOmitido...});Schema::table('permissions',function($table){$table->foreign('user_id')->references('id')->on('users');});

Errorgettingterminal:

Illuminate\Database\QueryException:SQLSTATE[42000]:Syntaxerrororaccessviolation:1072Keycolumn'user_id'doesn'texistintable(SQL:altertablepermissionsaddindexpermissions_user_id_index(user_id))1PDOException::("SQLSTATE[42000]: Syntax error or access violation: 1072 Key column 'user_id' doesn't exist in table") D:\Infinity\vendor\laravel\framework\src\Illuminate\Database\Connection.php : 458 2 PDOStatement::execute() D:\Infinity\vendor\laravel\framework\src\Illuminate\Database\Connection.php : 458

migrations laravel-5

asked by anonymous 13.03.2018 / 21:09

1 answer

Why is not my javascript working in the _Layout.cshtml file? npm ERR! peer dep missing: pdfjs-dist@^1.6.0, required by [email protected]

score 0 · Answer 1

You forgot to set the user_id column.

Note that you just set user_id to index, but did not create the column before that.

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

          $table->index('user_id');

          $table->timestamps();
    });

Make the following substitution:

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

          $table->integer('user_id');
          $table->index('user_id');

          $table->timestamps();
    });