Untitled

<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateIncomingDocumentsInitialTable extends Migration
{
    public function up()
    {
        Schema::connection('pgsql_third')->create('tbl_incoming_documents_initial', function (Blueprint $table) {
            $table->id('incoming_initial_id');
            $table->string('document_no')->unique();
            $table->string('receiving_office');
            $table->date('date_received')->nullable();
            $table->time('time_received')->nullable();
            $table->date('document_deadline')->nullable();
            $table->string('arta_deadline')->nullable();
            $table->string('document_classification')->nullable();
            $table->text('subject');
            $table->text('name_of_sender_and_address_or_office');
            $table->date('date_received_by_ored_or_hea')->nullable();
            $table->time('time_received_by_ored_or_hea')->nullable();
            $table->text('remarks_from_ored_or_hea')->nullable();
            $table->jsonb('referred_office')->nullable();
            $table->date('date_released_to_bureaus')->nullable();
            $table->time('time_released_to_bureaus')->nullable();
            $table->jsonb('red_instructions_type')->nullable();
            $table->text('red_instructions_remarks')->nullable();
            $table->text('original_document')->nullable();
            $table->timestamps();
        });
    }

    public function down()
    {
        Schema::connection('pgsql_third')->dropIfExists('tbl_incoming_documents_initial');
    }
}








<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateIncomingDocumentsOardTable extends Migration
{
    public function up()
    {
        Schema::connection('pgsql_third')->create('tbl_incoming_documents_oard', function (Blueprint $table) {
            $table->id('incoming_oard_id');

            $table->foreignId('fk_incoming_initial_id')
                  ->references('incoming_initial_id')
                  ->on('tbl_incoming_documents_initial')
                  ->onDelete('cascade');

            $table->date('date_received_by_oard')->nullable();
            $table->time('time_received_by_oard')->nullable();
            $table->jsonb('final_action_office')->nullable();

            $table->text('ard_instructions')->nullable();
            $table->timestamps();
        });
    }

    public function down()
    {
        Schema::connection('pgsql_third')->dropIfExists('tbl_incoming_documents_oard');
    }
}














<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateIncomingDocumentsFinalActionTable extends Migration
{
    public function up()
    {
        Schema::connection('pgsql_third')->create('tbl_incoming_documents_final_action', function (Blueprint $table) {
            $table->id('incoming_fa_id');

            $table->foreignId('fk_incoming_initial_id')
                  ->references('incoming_initial_id')
                  ->on('tbl_incoming_documents_initial')
                  ->onDelete('cascade');

            $table->date('date_received_by_final_action_office')->nullable();
            $table->time('time_received_by_final_action_office')->nullable();

            $table->boolean('no_compliance')->default(false);
            $table->text('instructions_for_final_action')->nullable();
            $table->string('document_type')->nullable();

            $table->timestamps();
        });
    }

    public function down()
    {
        Schema::connection('pgsql_third')->dropIfExists('tbl_incoming_documents_final_action');
    }
}











<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateIncomingDocumentsReroutedTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::connection('pgsql_third')->create('tbl_incoming_documents_rerouted', function (Blueprint $table) {
            $table->id('incoming_rerouted_id');
            $table->foreignId('fk_incoming_initial_id')
                  ->constrained('tbl_incoming_documents_initial', 'incoming_initial_id')
                  ->onDelete('cascade');

            $table->date('date_rerouted')->nullable();
            $table->time('time_rerouted')->nullable();
            $table->jsonb('office_rerouted')->nullable();
            $table->date('date_received_by_rerouted_office')->nullable();
            $table->time('time_received_by_rerouted_office')->nullable();

            $table->timestamps();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::connection('pgsql_third')->dropIfExists('tbl_incoming_documents_rerouted');
    }
}












<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateIncomingDocumentsUploadingOfFinalActionTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::connection('pgsql_third')->create('tbl_incoming_documents_uploading_of_final_action', function (Blueprint $table) {
            $table->id('incoming_ufa_id');
            $table->foreignId('fk_incoming_initial_id')
                  ->constrained('tbl_incoming_documents_initial', 'incoming_initial_id')
                  ->onDelete('cascade');

            $table->date('date_released')->nullable();
            $table->jsonb('mode_of_release')->nullable();
            $table->jsonb('final_action_document')->nullable();

            $table->timestamps();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::connection('pgsql_third')->dropIfExists('tbl_incoming_documents_uploading_of_final_action');
    }
}




<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateIncomingDocumentsDocumentApprovalTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::connection('pgsql_third')->create('tbl_incoming_documents_document_approval', function (Blueprint $table) {
            $table->id('incoming_approval_id');
            $table->foreignId('fk_incoming_initial_id')
                ->constrained('tbl_incoming_documents_initial', 'incoming_initial_id')
                ->onDelete('cascade');

            // OARD
            $table->date('date_received_by_oard_approval')->nullable();
            $table->time('time_received_by_oard_approval')->nullable();
            $table->date('oard_date_returned_to_action_office_for_revision')->nullable();
            $table->date('date_received_by_oard_after_revision')->nullable();

            // ORED
            $table->date('date_received_by_ored')->nullable();
            $table->time('time_received_by_ored')->nullable();
            $table->date('ored_date_returned_to_action_office_for_revision')->nullable();
            $table->date('date_received_by_ored_after_revision')->nullable();

            // Release
            $table->date('date_released_to_action_office')->nullable();
            $table->time('time_released_to_action_office')->nullable();

            $table->timestamps();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::connection('pgsql_third')->dropIfExists('tbl_incoming_documents_document_approval');
    }
}