1  <?php
 2  
 3  use Illuminate\Database\Migrations\Migration;
 4  use Illuminate\Database\Schema\Blueprint;
 5  use Illuminate\Support\Facades\Schema;
 6  
 7  class CreateDossierDossierTable extends Migration
 8  {
 9      /**
10       * Run the migrations.
11       *
12       * @return void
13       */
14      public function up()
15      {
16          Schema::create('dossier_dossier', function (Blueprint $table) {
17              $table->id();
18  
19              $table->foreignId('related_dossier_id')->nullable()->constrained('dossiers')->cascadeOnUpdate()->cascadeOnDelete();
20              $table->foreignId('dossier_id')->nullable()->constrained('dossiers')->cascadeOnUpdate()->cascadeOnDelete();
21              $table->string('reason')->nullable();
22  
23              $table->unique(['related_dossier_id', 'dossier_id']);
24  
25              $table->timestamps();
26          });
27      }
28  
29      /**
30       * Reverse the migrations.
31       *
32       * @return void
33       */
34      public function down()
35      {
36          Schema::dropIfExists('dossier_dossier');
37      }
38  }