dbrax / income-expense

use Illuminate\Database\Schema\Blueprint;

use Illuminate\Database\Migrations\Migration;

class CreateExpenseTable extends Migration

{

    /**

     * Run the migrations.

     *

     * @return void

     */

    public function up()

    {

        Schema::create('expense', function (Blueprint $table) {

            $table->bigIncrements('id');

            $table->integer('expense_category');

            $table->string('expense_title')->nullable();

            $table->integer('amount')->nullable();

            $table->text('notes')->nullable();

            $table->date('date');

            $table->timestamps();

        });

    }

    /**

     * Reverse the migrations.

     *

     * @return void

     */

    public function down()

    {

        Schema::dropIfExists('expense');

    }

}

use Illuminate\Database\Schema\Blueprint;

use Illuminate\Database\Migrations\Migration;

class CreateIncomeTable extends Migration

{

    /**

     * Run the migrations.

     *

     * @return void

     */

    public function up()

    {

        Schema::create('income', function (Blueprint $table) {

            $table->bigIncrements('id');

            $table->integer('incomecategory');

            $table->string('income_title')->nullable();

            $table->integer('amount')->nullable();

            $table->text('notes')->nullable();

            $table->date('date');

            $table->timestamps();

        });

    }

    /**

     * Reverse the migrations.

     *

     * @return void

     */

    public function down()

    {

        Schema::dropIfExists('income');

    }

}

use Illuminate\Database\Schema\Blueprint;

use Illuminate\Database\Migrations\Migration;

class CreateLedgerTable extends Migration

{

    /**

     * Run the migrations.

     *

     * @return void

     */

    public function up()

    {

        Schema::create('ledger', function (Blueprint $table) {

            $table->bigIncrements('id');

            $table->string('transaction_id');

            $table->string('transaction_type'); // exp or inc

            $table->string('transaction_type_category');

            $table->integer('amount');

            $table->integer('balance')->default(); // always gets deducted when expense is added optinal

            $table->timestamps();

        });

    }

    /**

     * Reverse the migrations.

     *

     * @return void

     */

    public function down()

    {

        Schema::dropIfExists('ledger');

    }

}