<?php

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

class CreateTablePreEligibilityDecisionTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('pre_eligibility_decision_table', function (Blueprint $table) {
            $table->increments('id');
            $table->integer('application_id');
            $table->integer('offer_id');
            $table->string('cf_foir');
            $table->string('foir');
            $table->integer('tenure');
            $table->integer('status');
            $table->string('reason');
            $table->double('interest_rate')->nullable();
            $table->integer('payable')->nullable();
            $table->integer('emi')->nullable();
            $table->bigInteger('processing_fee')->nullable();
            $table->bigInteger('up_front_from_customer')->nullable();
            $table->unsignedBigInteger('eligible_amount')->nullable();
            $table->integer('bureau_surrogate_limit_emi')->nullable();
            $table->bigInteger('bureau_surrogate_limit_amount')->nullable();
            $table->softDeletes();
            $table->timestamps();
            $table->index(['application_id'], 'pre_elig_decision_app_idx');
        });
    }

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