<?php use Illuminate\Support\Facades\Schema; use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; class CreateInventoriesTable extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::create('inventories', function (Blueprint $table) { $table->bigIncrements('id'); $table->integer('dealer_id'); $table->integer('warehouse_id'); $table->integer('product_id'); $table->integer('quantity'); $table->integer('unit_id'); $table->integer('stock_in_id')->nullable(); $table->integer('stock_out_id')->nullable(); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('inventories'); } }