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('audits', function (Blueprint $table) {
17              $table->id();
18  
19              $table->string('address');
20              $table->timestamp('date');
21  
22              //laboratory
23              $table->foreignId('entity_id')->constrained('entities')->cascadeOnUpdate()->cascadeOnDelete();
24  
25              $table->foreignId('dossier_id')->constrained('dossiers')->cascadeOnUpdate()->cascadeOnDelete();
26              $table->foreignId('meet_id')->constrained('meets')->cascadeOnUpdate()->cascadeOnDelete();
27  
28              $table->timestamps();
29          });
30      }
31  
32      /**
33       * Reverse the migrations.
34       *
35       * @return void
36       */
37      public function down()
38      {
39          Schema::dropIfExists('audits');
40      }
41  };