Relationship tables laravel

You have the wrong column that your FOREIGN KEY refers to

currently it's like this

$table->unsignedInteger('client_id');
$table->foreign('client_id')->references('company_id')->on('clients');

But it should be like this

$table->unsignedInteger('client_id');
$table->foreign('client_id')->references('client_id')->on('clients');

  

Since the foreign key in your table companies is pointing to   the table clients then there the relationship did not have it correct and   As you have it in your question, your foreign key is wrong because it points   to the primary key but of the same table that is containing it

Documentation reference Foreign keys

Discuss how it went

Dear.

To solve this problem in Laravel can be done as follows.

• First, you must create a migration where you only create table fields.
• Second, a new migration must be created to add foreign keys to that table.

In this case this way:

Migration Clients Keep the same. Create a Migration called "create_companies_table"

public function up()
    {
        Schema::create('companies', function (Blueprint $table) {
            $table->increments('company_id')->unsigned();
            $table->integer('name')->nullable();
            $table->string('business_name')->nullable();
            $table->string('douments')->nullable();
            $table->timestamps();

            //campo con el index para la relacion
            $table->integer('client_id')->unsigned()-index('client_id_foreign');


        });
    }

A second migration called "add_fk_to_companies_table"

public function up()
{
    Schema::table('companies', function(Blueprint $table)
    {
       //crea la clave foranea hacia la tabla clients
        $table->foreign('client_id')->references('id')->on('clients')->onUpdate('RESTRICT')->onDelete('RESTRICT');

    });
}

I hope it's useful !!!

Be sure to respect the chronological order of migrations, first create the table, then create the relationship.

Welcome Daniel Lopez, the error is that you are linking your foreign key with an element that does not exist in the clients table. Another thing is that your primary key of the clients table has the same name as the foreign key of the companies table, so the solution would be this:

 $table->foreign('client_id')->references('client_id')->on('clients');