<?php

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

class CreateRbiDataTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('rbi_data', function (Blueprint $table) {
            $table->increments('id');
            $table->string('application_id')->nullable();
            $table->string('Customer_ID_UCIC')->nullable();
            $table->string('C_KYC_NO')->nullable();
            $table->string('Name_of_customer')->nullable();
            $table->string('Customer_Type')->nullable();
            $table->string('PAN_No')->nullable();
            $table->string('Date_of_Birth')->nullable();
            $table->string('Risk_Category')->nullable();
            $table->string('Date_of_Risk_Review')->nullable();
            $table->string('Type_of_OVD')->nullable();
            $table->string('OVD_No_masked_details_to_be_submitted')->nullable();
            $table->string('type_of_Address_Proof_ID')->comment('Type of Address Proof ID (in case if it is different from OVD)')->nullable();
            $table->string('address_Proof_ID_No_enter_masked_details')->nullable();
            $table->string('City')->nullable();
            $table->string('District')->nullable();
            $table->string('State')->nullable();
            $table->string('Pin_Code')->nullable();
            $table->string('kyc_documents_collected_digitally')->comment('whether KYC documents were collected digitally (Y/N)')->nullable();
            $table->string('If_yes_indicate_name_of_application')->nullable();
            $table->string('application_owned_by_nbfc_or_outsourced')->comment('Whether application is owned by NBFC or outsourced?')->nullable();
            $table->string('Latitude')->nullable();
            $table->string('Longitude')->nullable();
            $table->string('IP_Address')->nullable();
            $table->string('If_KYC_collection_agent')->comment('If KYC collection is done through a third party, provide name of the Agent')->nullable();
            $table->string('kyc_verificaton_by')->comment('Indicate KYC Verificaton done by (employee/ straight through process)')->nullable();
            $table->string('kyc_verification_done_by_employee_name')->comment('If KYC verification is done by employee, provide name of employee')->nullable();
            $table->string('PAN_verified_with')->comment('PAN verified with (original / database [if yes, name of database])')->nullable();
            $table->string('Procedure_of_verification_api')->comment('Procedure of verification (physically / through third party, API etc)')->nullable();
            $table->string('OVD_verified_with_original_database')->comment('OVD verified with (original / database [if yes, name of database])')->nullable();
            $table->string('Procedure_of_verification_physically')->comment('Procedure of verification (physically / through third party, API etc)')->nullable();
            $table->string('Employee_ID')->nullable();
            $table->string('Date_and_Time')->nullable();
            $table->string('Loan_Account_No')->nullable();
            $table->string('Loan_Amount')->nullable();
            $table->string('Sanction_Date')->nullable();
            $table->string('Loan_tenure')->nullable();
            $table->string('Date_of_Disbursement')->nullable();
            $table->string('Loan_Status_Open_Closed')->nullable();
            $table->string('If_closed_date_of_closure')->nullable();
            $table->softDeletes();
            $table->timestamps();
        });
    }

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