<?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; class CreateCollegesTable extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::create('colleges', function (Blueprint $table) { $table->id(); $table->string('name')->nullable(); $table->bigInteger('country_id')->unsigned()->index()->nullable(); $table->foreign('country_id')->references('id')->on('countries')->onUpdate('cascade')->onDelete('cascade'); $table->bigInteger('state_id')->unsigned()->index()->nullable(); $table->foreign('state_id')->references('id')->on('states')->onUpdate('cascade')->onDelete('cascade'); $table->enum('status',['Active','Inactive'])->default('Active'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('colleges'); } }