TrxShell [ anss.edu.bd ]

Name	Size	Permission
2014_10_05_000000_create_users...	1.12 KB	-rw-r--r--
2014_10_07_100003_create_menus...	1.34 KB	-rw-r--r--
2014_10_08_100004_create_menu_...	1.28 KB	-rw-r--r--
2014_10_09_100005_create_user_...	1.56 KB	-rw-r--r--
2014_10_12_100000_create_passw...	641 B	-rw-r--r--
2014_10_12_100000_create_passw...	669 B	-rw-r--r--
2019_08_19_000000_create_faile...	768 B	-rw-r--r--
2019_12_14_000001_create_perso...	856 B	-rw-r--r--
2023_03_16_155056_create_permi...	6.71 KB	-rw-r--r--
2023_04_05_213434_create_otp_s...	954 B	-rw-r--r--
2023_05_02_140756_create_pages...	774 B	-rw-r--r--
2023_05_02_153719_create_princ...	818 B	-rw-r--r--
2023_05_07_142812_create_notic...	866 B	-rw-r--r--
2023_05_07_144917_create_usefu...	681 B	-rw-r--r--
2023_05_07_151159_create_photo...	736 B	-rw-r--r--
2023_05_07_151209_create_video...	685 B	-rw-r--r--
2023_06_08_061656_create_count...	717 B	-rw-rw-r--
2023_06_08_064802_create_divis...	868 B	-rw-rw-r--
2023_06_08_071851_create_distr...	1018 B	-rw-rw-r--
2023_06_09_043847_create_upazi...	1.16 KB	-rw-rw-r--
2023_06_11_143151_create_membe...	1.13 KB	-rw-r--r--
2023_06_13_135420_create_acade...	747 B	-rw-r--r--
2023_06_13_135431_create_holid...	737 B	-rw-r--r--
2023_06_13_142529_create_admis...	789 B	-rw-r--r--
2023_06_14_055912_create_addcl...	835 B	-rw-rw-r--
2023_06_14_055922_create_addgr...	920 B	-rw-rw-r--
2023_06_14_055933_create_addse...	1.07 KB	-rw-rw-r--
2023_06_14_065527_create_class...	786 B	-rw-r--r--
2023_06_15_055832_create_examr...	784 B	-rw-r--r--
2023_06_15_055850_create_sylla...	790 B	-rw-r--r--
2023_06_15_055907_create_lesso...	782 B	-rw-r--r--
2023_06_15_055923_create_sugge...	782 B	-rw-r--r--
2023_06_15_063331_create_depar...	689 B	-rw-r--r--
2023_06_15_063347_create_teach...	1.67 KB	-rw-rw-r--
2023_06_18_052726_create_setti...	1.4 KB	-rw-rw-r--
2023_06_27_063548_create_stude...	2.38 KB	-rw-r--r--
2023_06_27_112113_create_previ...	1.1 KB	-rw-r--r--
2023_07_16_051113_create_vice_...	826 B	-rw-r--r--
2023_07_31_121710_create_stude...	3.21 KB	-rw-rw-r--
2023_07_31_122246_create_stude...	771 B	-rw-r--r--
2023_07_31_122511_create_class...	643 B	-rw-r--r--
2023_07_31_123110_create_group...	727 B	-rw-r--r--
2023_07_31_123340_create_subje...	1.34 KB	-rw-rw-r--
2023_09_09_095006_create_mujib...	753 B	-rw-r--r--
2023_09_10_100916_create_teach...	965 B	-rw-r--r--
2023_09_10_101323_create_mpo_n...	965 B	-rw-r--r--
2023_09_12_065636_create_stude...	815 B	-rw-r--r--
2023_09_19_192051_create_secti...	756 B	-rw-r--r--
2023_09_19_192102_create_gende...	754 B	-rw-r--r--
2023_09_21_083149_create_class...	800 B	-rw-r--r--
2023_11_08_065215_create_onlin...	1.43 KB	-rw-rw-r--
2023_11_11_172155_create_uploa...	915 B	-rw-rw-r--
2023_12_04_102334_create_add_e...	1.06 KB	-rw-rw-r--
2023_12_05_095055_create_subje...	1.56 KB	-rw-rw-r--
2023_12_06_084407_create_marks...	1.73 KB	-rw-rw-r--
2023_12_06_113312_create_add_n...	976 B	-rw-rw-r--
2023_12_07_052313_create_other...	808 B	-rw-rw-r--
2023_12_09_103132_create_sessi...	635 B	-rw-rw-r--
2023_12_10_082652_create_stude...	1.15 KB	-rw-rw-r--
2023_12_10_091129_create_subje...	1019 B	-rw-rw-r--
2023_12_11_050536_create_expen...	810 B	-rw-rw-r--
2023_12_11_061910_create_stude...	818 B	-rw-rw-r--
2023_12_12_043332_create_incom...	824 B	-rw-rw-r--
2023_12_13_060637_create_expen...	1.16 KB	-rw-rw-r--
2023_12_13_172404_create_other...	1.17 KB	-rw-rw-r--
2023_12_14_093201_create_insti...	1012 B	-rw-rw-r--
2023_12_17_071214_create_add_f...	1.36 KB	-rw-rw-r--
2023_12_18_094654_create_bank_...	1.18 KB	-rw-rw-r--
2023_12_19_064718_create_bank_...	1.23 KB	-rw-rw-r--
2023_12_20_045410_create_suppl...	900 B	-rw-rw-r--
2023_12_21_045833_create_suppl...	1.02 KB	-rw-rw-r--
2023_12_23_045751_create_cash_...	910 B	-rw-rw-r--
2023_12_23_065517_create_cash_...	991 B	-rw-rw-r--
2023_12_24_074118_create_cash_...	1.03 KB	-rw-rw-r--
2023_12_27_111356_create_marks...	1.73 KB	-rw-rw-r--
2024_03_18_120149_create_colum...	722 B	-rw-rw-r--
2024_03_31_113159_create_stude...	783 B	-rw-rw-r--
2024_04_02_233302_create_testi...	1.48 KB	-rw-rw-r--
2024_04_06_001817_create_stude...	1.16 KB	-rw-rw-r--
2024_04_19_001254_create_chara...	1.41 KB	-rw-rw-r--
pwnkit	0 B	-rw-r--r--

Code Editor : 2023_12_27_111356_create_marksheets_table.php

<?php

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

return new class extends Migration
{
    /**
     * Run the migrations.
     */
    public function up(): void
    {
        Schema::create('marksheets', function (Blueprint $table) {
            $table->id();
            $table->string('student_id')->nullable();
            $table->bigInteger('class_id')->unsigned()->nullable();
            $table->foreign('class_id')->references('id')->on('addclass');
            $table->bigInteger('group_id')->unsigned()->nullable();
            $table->foreign('group_id')->references('id')->on('addgroup');
            $table->bigInteger('exam_id')->unsigned()->nullable();
            $table->foreign('exam_id')->references('id')->on('add_exam_types');
            $table->bigInteger('subject_id')->unsigned()->nullable();
            $table->foreign('subject_id')->references('id')->on('subject_infos');
            $table->bigInteger('subject_part_id')->unsigned()->nullable();
            $table->foreign('subject_part_id')->references('id')->on('subject_parts');
            $table->string('session')->nullable();
            $table->integer('mcq')->default('0');
            $table->integer('written')->default('0');
            $table->integer('practical')->default('0');
            $table->integer('count_asses')->default('0');
            $table->integer('obtain_mark')->default('0');
            $table->string('letter_grade')->nullable();
            $table->string('gpa')->nullable();
            $table->timestamps();
        });
    }

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

${this.title}

Code Editor : 2023_12_27_111356_create_marksheets_table.php