<?php

   use Illuminate\Database\Migrations\Migration;
   use Illuminate\Database\Schema\Blueprint;
   use Illuminate\Support\Facades\Schema;

   return new class extends Migration {
      /**
       * Run the migrations.
       */
      public function up(): void {
         Schema::create('user_lembagas', function(Blueprint $table) {
            $table->id();
            $table->foreignId('user_id')->constrained()->onDelete('cascade');
            $table->string('user_npsn');
            $table->foreign('user_npsn')->references('npsn')->on('lembagas')->onUpdate('cascade')  // ini penting
               ->onDelete('cascade');
            $table->timestamps();
         });
      }

      /**
       * Reverse the migrations.
       */
      public function down(): void {
         Schema::dropIfExists('user_lembagas');
      }
   };
