<?php

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

class CreateApprovalStatusLogTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('approval_status_log', function (Blueprint $table) {
            $table->increments('id');
            $table->integer('rule_id'); // rule id
            $table->integer('application_id'); // application id
            $table->string('failed_condition')->nullable(); // rule condition the approval failed on; else null
            $table->string('reason')->nullable(); // reason for failure; else null
            $table->string('request_batch_id')->nullable(); // request batch id to group the rules that ran together
            $table->tinyInteger('status')->default(0); // 0 in case of approval failure; else 1
            $table->timestamps();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('approval_status_log');
    }
}