<?php

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

class CreateAvanseFinanceDetailTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('avanse_finance_detail', function (Blueprint $table) {
            $table->increments('id');
            $table->integer('finance_id');
            $table->string('applicationNo');
            $table->integer('cif');
            $table->string('finType');
            $table->string('finCcy');
            $table->string('finBranch');
            $table->string('profitDaysBasis');
            $table->string('finAmount');
            $table->string('finAssetValue');
            $table->string('downPayBank');
            $table->string('downPaySupl');
            $table->string('finRepayMethod');
            $table->string('finStartDate');
            $table->string('allowGrcPeriod');
            $table->string('tdsApplicable');
            $table->string('manualSchedule');
            $table->string('planDeferCount');
            $table->string('stepFinance');
            $table->string('alwManualSteps');
            $table->string('grcTerms');
            $table->string('grcPeriodEndDate');
            $table->string('grcRateBasis');
            $table->string('grcPftRate');
            $table->string('grcMargin');
            $table->string('grcProfitDaysBasis');
            $table->string('nextGrcPftRvwDate');
            $table->string('nextGrcCpzDate');
            $table->string('allowGrcRepay');
            $table->string('grcSchdMthd');
            $table->string('grcMinRate');
            $table->string('grcMaxRate');
            $table->string('grcMaxAmount');
            $table->string('grcAdvPftRate');
            $table->string('grcAdvMargin');
            $table->string('numberOfTerms');
            $table->string('reqRepayAmount');
            $table->string('repayRateBasis');
            $table->string('repayPftRate');
            $table->string('repayMargin');
            $table->string('scheduleMethod');
            $table->string('repayFrq');
            $table->string('nextRepayDate');
            $table->string('repayPftFrq');
            $table->string('nextRepayPftDate');
            $table->string('repayRvwFrq');
            $table->string('nextRepayRvwDate');
            $table->string('nextRepayCpzDate');
            $table->string('maturityDate');
            $table->string('finRepayPftOnFrq');
            $table->string('repayMinRate');
            $table->string('repayMaxRate');
            $table->string('repayAdvPftRate');
            $table->string('repayAdvMargin');
            $table->string('supplementRent');
            $table->string('increasedCost');
            $table->string('dsaCode');
            $table->string('accountsOfficer');
            $table->string('dmaCode');
            $table->string('quickDisb');
            $table->string('unPlanEMIHLockPeriod');
            $table->string('unPlanEMICpz');
            $table->string('reAgeCpz');
            $table->string('maxUnplannedEmi');
            $table->string('maxReAgeHolidays');
            $table->string('alwBpiTreatment');
            $table->string('dftBpiTreatment');
            $table->string('planEMIHAlw');
            $table->string('planEMIHMethod');
            $table->string('planEMIHMaxPerYear');
            $table->string('planEMIHMax');
            $table->string('planEMIHLockPeriod');
            $table->string('planEMICpz');
            $table->string('grcAdvTerms');
            $table->string('advTerms');
            $table->string('advType');
            $table->string('advStage');
            $table->string('fixedRateTenor');
            $table->string('fixedTenorRate');
            $table->string('finCurrAssetValue');
            $table->timestamps();
            $table->softDeletes();
        });
    }

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