<?php

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

class CreateTableConsumerApplication extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('consumer_application', function (Blueprint $table) {

            $table->increments('id');
            $table->integer('user_id')->nullable();
            $table->integer('merchant_id')->nullable();
            $table->integer('merchant_location_id')->nullable();
            $table->string('name')->nullable();
            $table->string('email')->nullable();
            $table->string('mobile_number')->nullable();
            $table->integer('tenure')->nullable();
            $table->string('purpose')->nullable();
            $table->string('loan_amount')->nullable();

            $table->string('creditfair_src')->nullable();
            $table->string('lead_src_email')->nullable();
            $table->string('lead_src_phone')->nullable();
            $table->string('long_link')->nullable();

            $table->string('pan_card')->nullable();
            $table->string('aadhaar_card')->nullable();
            $table->date('dob')->nullable();
            $table->enum('marital_status', ['MARRIED', 'SINGLE'])->nullable(); //enum

            //address current
            $table->string('current_address_line_1')->nullable();
            $table->string('current_address_state')->nullable();
            $table->string('current_address_city')->nullable();
            $table->string('current_address_pincode')->nullable();
            $table->string('current_address_landmark')->nullable();
            $table->enum('current_address_status', ['RENTED', 'OWNED', "PARENTS HOUSE"])->nullable();

            //address permanent
            $table->string('permanent_address_line_1')->nullable();
            $table->string('permanent_address_state')->nullable();
            $table->string('permanent_address_city')->nullable();
            $table->string('permanent_address_pincode')->nullable();
            $table->string('permanent_address_landmark')->nullable();
            $table->enum('permanent_address_status', ['RENTED', 'OWNED', "PARENTS HOUSE"])->nullable();

            $table->enum('employee_status', ['UNEMPLOYED', 'SALARIED', 'BUSINESS'])->nullable(); //enum
            $table->integer('monthly_income')->nullable();
            $table->string('company_name')->nullable();
            $table->string('company_number')->nullable();
            $table->integer('experience')->nullable();
            $table->string('contact_address')->nullable();

            //Co applicant info
            $table->string('co_applicant_name')->nullable();
            $table->string('co_applicant_pan_card')->nullable();
            $table->string('co_applicant_aadhaar_card')->nullable();
            $table->string('co_applicant_email')->nullable();
            $table->string('co_applicant_mobile_number')->nullable();
            $table->string('co_applicant_address_line_1')->nullable();
            $table->string('co_applicant_address_state')->nullable();
            $table->string('co_applicant_address_pincode')->nullable();
            $table->string('co_applicant_address_city')->nullable();
            $table->string('co_applicant_address_landmark')->nullable();

            //derived
            $table->boolean('co_applicant_required')->nullable();
            $table->string('state')->nullable();
            $table->integer('completed_stage')->nullable();

            //backend Ops
            $table->string('credit_score')->nullable();
            $table->string('rejection_reason')->nullable();
            $table->string('misc_info')->nullable();
            $table->string('updated_by')->nullable()->default('app');

            $table->rememberToken();
            $table->softDeletes();
            $table->timestamps();
        });
    }

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