ReviewsMigration.inc.php

<?php
 
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Builder;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Capsule\Manager as Capsule;
 
class ReviewsMigration extends Migration {
        public function up() {
      // Reviewing assignments.
      Capsule::schema()->create('review_assignments', function (Blueprint $table) {
         $table->bigInteger('review_id')->autoIncrement();
         $table->bigInteger('submission_id');
         $table->bigInteger('reviewer_id');
         $table->text('competing_interests')->nullable();
         $table->tinyInteger('recommendation')->nullable();
         $table->datetime('date_assigned')->nullable();
         $table->datetime('date_notified')->nullable();
         $table->datetime('date_confirmed')->nullable();
         $table->datetime('date_completed')->nullable();
         $table->datetime('date_acknowledged')->nullable();
         $table->datetime('date_due')->nullable();
         $table->datetime('date_response_due')->nullable();
         $table->datetime('last_modified')->nullable();
         $table->tinyInteger('reminder_was_automatic')->default(0);
         $table->tinyInteger('declined')->default(0);
         $table->tinyInteger('cancelled')->default(0);
         $table->bigInteger('reviewer_file_id')->nullable();
         $table->datetime('date_rated')->nullable();
         $table->datetime('date_reminded')->nullable();
         $table->tinyInteger('quality')->nullable();
         $table->bigInteger('review_round_id');
         $table->tinyInteger('stage_id')->default(1);
         $table->tinyInteger('review_method')->default(1);
         $table->tinyInteger('round')->default(1);
         $table->tinyInteger('step')->default(1);
         $table->bigInteger('review_form_id')->nullable();
         $table->tinyInteger('unconsidered')->nullable();
         $table->index(['submission_id'], 'review_assignments_submission_id');
         $table->index(['reviewer_id'], 'review_assignments_reviewer_id');
         $table->index(['review_form_id'], 'review_assignments_form_id');
         $table->index(['reviewer_id', 'review_id'], 'review_assignments_reviewer_review');
      });
 
      // Review rounds.
      Capsule::schema()->create('review_rounds', function (Blueprint $table) {
         $table->bigInteger('review_round_id')->autoIncrement();
         $table->bigInteger('submission_id');
         $table->bigInteger('stage_id')->nullable();
         $table->tinyInteger('round');
         $table->bigInteger('review_revision')->nullable();
         $table->bigInteger('status')->nullable();
         $table->index(['submission_id'], 'review_rounds_submission_id');
         $table->unique(['submission_id', 'stage_id', 'round'], 'review_rounds_submission_id_stage_id_round_pkey');
      });
 
      // Submission Files for each review round
      Capsule::schema()->create('review_round_files', function (Blueprint $table) {
         $table->bigInteger('submission_id');
         $table->bigInteger('review_round_id');
         $table->tinyInteger('stage_id');
         $table->bigInteger('file_id');
         $table->bigInteger('revision')->default(1);
         $table->index(['submission_id'], 'review_round_files_submission_id');
         $table->unique(['submission_id', 'review_round_id', 'file_id', 'revision'], 'review_round_files_pkey');
      });
 
      // Associates reviewable submission files with reviews
      Capsule::schema()->create('review_files', function (Blueprint $table) {
         $table->bigInteger('review_id');
         $table->bigInteger('file_id');
         $table->index(['review_id'], 'review_files_review_id');
         $table->unique(['review_id', 'file_id'], 'review_files_pkey');
      });
   }
 
   public function down() {
      Capsule::schema()->drop('review_files');
      Capsule::schema()->drop('review_round_files');
      Capsule::schema()->drop('review_rounds');
      Capsule::schema()->drop('review_assignments');
   }
}