1  <?php
 2  
 3  use App\Models\ValidationRequirementResponse;
 4  use Illuminate\Database\Migrations\Migration;
 5  use Illuminate\Database\Schema\Blueprint;
 6  use Illuminate\Support\Facades\Schema;
 7  
 8  class CreateValidationRequirementResponsesTable extends Migration
 9  {
10      /**
11       * Run the migrations.
12       *
13       * @return void
14       */
15      public function up()
16      {
17          Schema::create('validation_requirement_responses', function (Blueprint $table) {
18              $table->id();
19              $table->string('code');
20              $table->longText('description');
21              $table->datetime('closure_date')->nullable()->default(null);
22              $table->foreignId('validation_requirement_id')->constrained('workbook_requirement_validation')->cascadeOnDelete()->cascadeOnUpdate()->index('val_req_responses_val_req_id_foreign');
23              $table->foreignId('validation_requirement_response_type_id')->nullable()->constrained('validation_requirement_response_types')->cascadeOnUpdate()->nullOnDelete()->index('val_req_responses_val_req_res_type_id_foreign');
24              $table->foreignIdFor(ValidationRequirementResponse::class, 'parent_id')->nullable()->constrained('validation_requirement_responses')->cascadeOnUpdate()->nullOnDelete()->index('val_req_responses_parent_id_foreign');
25              $table->softDeletes();
26              $table->timestamps();
27          });
28      }
29  
30      /**
31       * Reverse the migrations.
32       *
33       * @return void
34       */
35      public function down()
36      {
37          Schema::dropIfExists('validation_requirement_responses');
38      }
39  }