oxbir
2 weeks ago

How to create tabel?

Posted 2 weeks ago by oxbir

users tavel

public function up()
{
    Schema::create('users', function (Blueprint $table) {
        $table->bigIncrements('id');
        $table->string('name');
        $table->string('email')->unique();
        $table->timestamp('email_verified_at')->nullable();
        $table->string('password');
        $table->string('image')->nullable();
        $table->string('first_name')->nullable();
        $table->string('last_name')->nullable();
        $table->string('job_title')->nullable();
        $table->boolean('gender')->nullable();
        $table->boolean('marital')->nullable();
        $table->bigInteger('soldier_id')->unsigned()->nullable();
        $table->foreign('soldier_id')->references('id')->on('soldiers')->onDelete('cascade');

        $table->integer('birth_date_day')->nullable();
        $table->bigInteger('month_id')->unsigned()->nullable();
        $table->foreign('month_id')->references('id')->on('months')->onDelete('cascade');
        $table->integer('birth_date_year')->nullable();

        $table->string('mobile')->nullable();
        $table->string('telephone')->nullable();
        $table->string('website')->nullable();
        $table->string('state_name')->nullable();
        $table->string('city_name')->nullable();

        $table->bigInteger('country_id')->unsigned()->nullable();
        $table->foreign('country_id')->references('id')->on('countries')->onDelete('cascade');
        $table->bigInteger('state_id')->unsigned()->nullable();
        $table->foreign('state_id')->references('id')->on('states')->onDelete('cascade');
        $table->bigInteger('city_id')->unsigned()->nullable();
        $table->foreign('city_id')->references('id')->on('cities')->onDelete('cascade');
        $table->text('address')->nullable();
        $table->text('description')->nullable();
        $table->rememberToken();
        $table->timestamps();
    });
}

When I am saving I get this error

[![error][1]][1]

Please sign in or create an account to participate in this conversation.