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