<?php

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

class CreateDisbursementScheduleTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('disbursement_schedule', function (Blueprint $table) {
            $table->increments('id');
            $table->integer('application_id');
            $table->integer('disbursement_summary_id');
            $table->integer('offer_id');
            $table->integer('emi_id');
            $table->string('emi_date');
            $table->integer('amount');
            $table->integer('moratorium_amount');
            $table->string('interest');
            $table->string('principal');
            $table->string('subvention');
            $table->string('subvention_amount_balance');
            $table->string('principal_outstanding');
            $table->string('principal_outstanding_subvention');
            $table->string('fore_closure_amount');
            $table->string('payment_status');
            $table->string('bounce_charges');
            $table->string('delay_penalty');
            $table->string('charges_waived');
            $table->softDeletes();
            $table->timestamps();
        });
    }

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