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('schedulers', function (Blueprint $table) {
17              $table->id();
18  
19              // Subsanacion
20              $table->integer('frequency_verification_rectify')->nullable();
21              $table->integer('day_verification_rectify')->nullable();
22              $table->string('time_verification_rectify')->nullable();
23              $table->integer('amount_of_days')->nullable();
24  
25              // Evaluation request
26              $table->integer('frequency_evaluation_request_check')->nullable();
27              $table->integer('day_evaluation_request_check')->nullable();
28              $table->string('time_evaluation_request_check')->nullable();
29              $table->integer('month_verification')->nullable();
30  
31              // Certification report
32              $table->integer('frequency_certification_report_check')->nullable();
33              $table->integer('day_certification_report_check')->nullable();
34              $table->string('time_certification_report_check')->nullable();
35              $table->integer('amount_of_days_certification_report')->nullable();
36  
37              $table->foreignId('setting_id')->nullable()->constrained('settings')->cascadeOnUpdate()->nullOnDelete();
38              $table->foreignId('dossier_type_id')->nullable()->constrained('dossier_types')->cascadeOnUpdate()->nullOnDelete();
39  
40              $table->timestamps();
41          });
42      }
43  
44      /**
45       * Reverse the migrations.
46       *
47       * @return void
48       */
49      public function down()
50      {
51          Schema::dropIfExists('schedulers');
52      }
53  };