<?php

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

class CreateCreditReportTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('credit_report', function (Blueprint $table) {
            $table->increments('id');
            $table->integer('application_id')->nullable();
            $table->integer('Score')->nullable();
            $table->integer('NoOfActiveAccounts')->nullable();
            $table->integer('activeCreditCardLimit')->nullable();
            $table->integer('sanctionAmount')->nullable();
            $table->integer('TotalPastDue')->nullable();
            $table->integer('Past12Months')->nullable();
            $table->integer('Past24Months')->nullable();
            $table->integer('TotalEnquiry')->nullable();
            $table->integer('zeroBalanceAccount')->nullable();
            $table->integer('pastDueAccount')->nullable();
            $table->string('finalCategory',4)->nullable();
            $table->text('VoterID')->nullable();
            $table->text('contactInfoList')->nullable();
            $table->text('PANIdsList')->nullable();
            $table->text('AddressInfoList')->nullable();
            $table->tinyInteger('applicant_type')->nullable();
            $table->softDeletes()->nullable();
            $table->timestamps();
        });
    }

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