Ошибка 3734 mysql

SQLSTATE[HY000]: General error: 3734 Failed to add the foreign key constraint. Missing column 'id' for constraint 'posts_user_id_foreign' in the referenced table 'users' (SQL: alter table `posts` add constraint `posts_user_id_foreign` foreign key (`user_id`) references `users` (`id`))

  at D:multimedia-projects-main (1)multimedia-projects-mainjobsearchvendorlaravelframeworksrcIlluminateDatabaseConnection.php:761
    757▕         // If an exception occurs when attempting to run a query, we'll format the error
    758▕         // message to include the bindings with SQL, which will make this exception a
    759▕         // lot more helpful to the developer instead of just the database's errors.
    760▕         catch (Exception $e) {
  ➜ 761▕             throw new QueryException(
    762▕                 $query, $this->prepareBindings($bindings), $e
    763▕             );
    764▕         }
    765▕     }

  1   D:multimedia-projects-main (1)multimedia-projects-mainjobsearchvendorlaravelframeworksrcIlluminateDatabaseConnection.php:546
      PDOException::("SQLSTATE[HY000]: General error: 3734 Failed to add the foreign key constraint. Missing column 'id' for constraint 'posts_user_id_foreign' in the referenced table 'users'")

  2   D:multimedia-projects-main (1)multimedia-projects-mainjobsearchvendorlaravelframeworksrcIlluminateDatabaseConnection.php:546
      PDOStatement::execute()

my code look like this for the foreign
public function up()

    {
        Schema::create('posts', function (Blueprint $table) {
            $table->id('post_id')->unique()->nullable(false);
            $table->biginteger('user_id')->unasigned()->index();         
            $table->biginteger('company_id')->unasigned()->index();          
            $table->biginteger('job_id')->unasigned()->index();          
            $table->timestamps();
        });
        Schema::table('posts', function($table) {
            $table->foreign('user_id')->references('id')->on('users');
            $table->foreign('company_id')->references('id')->on('companies');
             $table->foreign('job_id')->references('id')->on('jobs');
        });
    }

this is for the user

    public function up()
    {
        Schema::create('users', function (Blueprint $table) {
            $table->id('user_id');
            $table->string('name');
            $table->string('email')->unique();
            $table->foreignid('companyid');
            $table->timestamp('email_verified_at')->nullable();
            $table->string('password');
            $table->rememberToken();
            $table->timestamps();
        });
    }

the rest is similar

already try to change the foreign key into big integer and to integer already try to change the name of the foreign reference but still not working

Я работаю над MySQL WorkBench и все время получаю код ошибки 3734: не удалось добавить ограничение внешнего ключа. Что означает эта ошибка и могу ли я исправить эту ошибку? Я все время получаю ошибку с таблицей бронирования вилл.

     create table Reservation
(
ReservationID char(5) primary key,
ReservationDate date,
CustomerID char(5),
foreign key (CustomerID) references Customer (CustomerID)
);

create table Villa
(
VillaID char(5) primary key,
VillaName varchar(40),
VillaCostPerDay int(3), 
VillaTypeID char(5),
foreign key (VillaTypeID) references VillaType (VillaTypeID)
);

``create table VillaReservation
    (
    VillaReservationID char(5),
    VillaID char(5),
    DateFrom datetime,
    DateTo datetime,
    primary key (VillaReservationID, VillaID),
    foreign key (VillaReservationID) references Reservation(VillaReservationID),
    foreign key (VillaID) references Villa(VillaID)
    );

Comments

* fix MySQL ENUM and SET bug #3734

* - ENUM integration test added for MySQL
- CommandUtil class created with different command methods to keep them in a single place

* - Generate changelog tests updated to make use of a command util class
- Command util refactoring with latest command step framework udpates

---------

Co-authored-by: Daniel Mallorga <dmallorga@liquibase.com>