<?php

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

class CreateInhouseRequisition extends Migration {

	/**
	 * Run the migrations.
	 *
	 * @return void
	 */
	public function up()
	{
		Schema::create('inhouse_requisition', function(Blueprint $table)
		{
			$table->increments('id');
			$table->integer('commodity_id')->unsigned();
			$table->string('department');
			$table->integer('quantity');
			$table->string('issue_unit');
			$table->string('incharge_mail');
			$table->string('requestor_email');
			$table->string('folio_number');
			$table->integer('approved_by')->unsigned()->nullable();
			$table->integer('issued_by')->unsigned()->nullable();
			$table->integer('rejected_by')->unsigned()->nullable();
			$table->integer('received_by')->unsigned()->nullable();
			$table->integer('incharge_id')->unsigned()->nullable();
			$table->integer('request_status_id')->unsigned()->nullable();

			$table->foreign('incharge_id')->references('id')->on('department_heads');
			$table->foreign('issued_by')->references('id')->on('users');
			$table->foreign('rejected_by')->references('id')->on('users');
			$table->foreign('approved_by')->references('id')->on('users');
			$table->foreign('received_by')->references('id')->on('users');
			$table->softDeletes();
			$table->timestamps();
		});
	}


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

}