<?php

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

class CreateConsumerVerificationTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('consumer_verification', function (Blueprint $table) {
            $table->increments('id');
            $table->integer('cibil_score')->nullable();
            $table->integer('complete_name')->nullable();
            $table->integer('complete_address')->nullable();
            $table->integer('complete_phone_number')->nullable();
            $table->integer('current_address')->nullable();
            $table->integer('identity_number')->nullable();
            $table->integer('id_expiry_date')->nullable();
            $table->integer('birth_date')->nullable();
            $table->integer('employment_information')->nullable();
            $table->integer('no_dpd')->nullable();
            $table->integer('crossed_credit_limit')->nullable();
            $table->integer('having_larger_monthly_outflows')->nullable();
            $table->integer('no_negative_factor')->nullable();
            $table->integer('maximum_number_of_enquiries')->nullable();
            $table->integer('age')->nullable();
            $table->integer('linkedin')->nullable();
            $table->integer('facebook')->nullable();
            $table->integer('no_of_dependent')->nullable();
            $table->integer('collected_bank_account')->nullable();
            $table->integer('salary')->nullable();
            $table->integer('no_minimum_balance')->nullable();
            $table->integer('no_debit_chq_esc_bounce')->nullable();
            $table->integer('transaction_entries')->nullable();
            $table->integer('regular_high_value_transaction')->nullable();
            $table->integer('average_balance')->nullable();
            $table->integer('mca')->nullable();
            $table->integer('prode')->nullable();
            $table->integer('joining_date')->nullable();
            $table->integer('designation')->nullable();
            $table->integer('verify_professional_certificates')->nullable();
            $table->integer('official_email_id')->nullable();
            $table->integer('official_address')->nullable();
            $table->integer('itr_certificate_by_ca')->nullable();
            $table->integer('nature_of_business')->nullable();
            $table->integer('type_of_business')->nullable();
            $table->integer('itr_salary')->nullable();
            $table->integer('view_utilities_bill_online')->nullable();
            $table->integer('residing_in_negative_area')->nullable();
            $table->integer('valid_of_rental_agreement')->nullable();
            $table->integer('residence_visit_cpv_report')->nullable();
            $table->softDeletes();
            $table->timestamps();
        });
    }

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