Gecko [ gandhischool.edu.np ]

Name	Size	Permission
2014_10_12_000000_create_users...	798 B	-rw-rw-r--
2014_10_12_100000_create_passw...	669 B	-rw-rw-r--
2019_08_19_000000_create_faile...	820 B	-rw-rw-r--
2019_12_14_000001_create_perso...	861 B	-rw-rw-r--
2022_06_19_073138_create_notic...	934 B	-rw-rw-r--
2022_06_19_091800_create_downl...	586 B	-rw-rw-r--
2022_06_23_102025_create_maste...	883 B	-rw-rw-r--
2022_06_27_081451_create_commi...	888 B	-rw-rw-r--
2022_06_28_072219_add_columns_...	849 B	-rw-rw-r--
2022_06_30_060604_create_a_lbu...	901 B	-rw-rw-r--
2022_06_30_092001_create_album...	813 B	-rw-rw-r--
2022_07_03_072702_create_news_...	929 B	-rw-rw-r--
2022_07_22_103838_create_about...	1023 B	-rw-rw-r--
2022_07_25_165037_create_carou...	859 B	-rw-rw-r--
2022_08_28_100430_create_publi...	1.24 KB	-rw-rw-r--
2022_09_09_093848_create_commi...	1.23 KB	-rw-rw-r--
2022_09_10_052152_add_status_t...	663 B	-rw-rw-r--
2022_09_13_064350_add_columns_...	675 B	-rw-rw-r--
2022_10_19_143223_create_membe...	829 B	-rw-rw-r--
2022_10_27_021553_create_membe...	992 B	-rw-rw-r--
2022_12_22_062349_create_setup...	1.26 KB	-rw-rw-r--
2023_01_03_063908_add_column_t...	660 B	-rw-rw-r--
2023_03_02_073301_create_video...	1.01 KB	-rw-rw-r--
2023_03_09_111504_create_conta...	1.1 KB	-rw-rw-r--
2023_04_28_050127_add_column_i...	680 B	-rw-rw-r--
2023_06_30_105724_add_column_t...	815 B	-rw-rw-r--
2023_06_30_120816_add_columns_...	682 B	-rw-rw-r--
2023_06_30_121031_add_columns_...	682 B	-rw-rw-r--
2023_07_10_064844_add_column_t...	689 B	-rw-rw-r--
2024_03_19_163249_add_member_d...	1.22 KB	-rw-rw-r--
2024_04_23_171814_create_execu...	911 B	-rw-rw-r--
2024_04_28_161724_add_columns_...	773 B	-rw-rw-r--
2024_05_03_152650_add_columns_...	695 B	-rw-rw-r--

Code Editor : 2022_09_09_093848_create_commitees_table.php

<?php

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

class CreateCommiteesTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('commitees', function (Blueprint $table) {
            $table->id();
            $table->biginteger('committee_types_id')->unsigned();
            $table->bigInteger('members_id')->unsigned();
            $table->bigInteger('master_committees_id')->unsigned();
            $table->foreign('committee_types_id')->references('id')->on('committee_types')->onDelete('cascade');
            $table->foreign('members_id')->references('id')->on('members')->onDelete('cascade');
            $table->foreign('master_committees_id')->references('id')->on('master_committees')->onDelete('cascade');
            $table->date('start_date')->nullable();
            $table->date('end_date')->nullable();
            $table->string('remarks')->nullable();
            $table->timestamps();
        });
    }

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

${this.title}

Code Editor : 2022_09_09_093848_create_commitees_table.php