Gecko [ www.8jobspot.com ]

/ home / comfsblg / gtts-api / database / migrations / [ HOME SHELL ]

Name	Size	Permission
0001_01_01_000000_create_users...	1.63 KB	-rw-r--r--
0001_01_01_000001_create_cache...	849 B	-rw-r--r--
0001_01_01_000002_create_jobs_...	1.77 KB	-rw-r--r--
2025_01_29_083422_create_stude...	1.12 KB	-rw-r--r--
2025_01_29_083441_create_alumn...	709 B	-rw-r--r--
2025_01_29_083723_create_super...	717 B	-rw-r--r--
2025_02_04_063421_create_unive...	680 B	-rw-r--r--
2025_02_04_073714_create_durat...	591 B	-rw-r--r--
2025_02_04_073715_create_progr...	739 B	-rw-r--r--
2025_02_04_073716_create_progr...	753 B	-rw-r--r--
2025_02_04_073724_create_miles...	981 B	-rw-r--r--
2025_02_04_073725_create_progr...	1000 B	-rw-r--r--
2025_02_04_082156_create_acade...	1 KB	-rw-r--r--
2025_02_04_110607_create_assig...	636 B	-rw-r--r--
2025_02_28_125235_add_achievem...	610 B	-rw-r--r--
2025_03_03_084219_create__anno...	621 B	-rw-r--r--
2025_03_09_063000_create_activ...	677 B	-rw-r--r--
2025_03_09_090856_create_stude...	743 B	-rw-r--r--
2025_03_09_113920_add_startdat...	576 B	-rw-r--r--
2025_03_16_091804_student_mile...	814 B	-rw-r--r--
2025_03_16_115814_create_miles...	690 B	-rw-r--r--
2025_03_16_124534_create_oauth...	782 B	-rw-r--r--
2025_03_16_124535_create_oauth...	882 B	-rw-r--r--
2025_03_16_124536_create_oauth...	704 B	-rw-r--r--
2025_03_16_124537_create_oauth...	956 B	-rw-r--r--
2025_03_16_124538_create_oauth...	629 B	-rw-r--r--
2025_03_16_134240_create_spons...	688 B	-rw-r--r--
2025_03_16_143416_create_publi...	795 B	-rw-r--r--
2025_03_16_164826_create_permi...	6.43 KB	-rw-r--r--
2025_03_18_102312_add_columns_...	1.67 KB	-rw-r--r--
2025_03_24_080547_add_status_t...	683 B	-rw-r--r--
2025_03_28_100518_create_compl...	1.03 KB	-rw-r--r--
2025_05_05_080105_create_compl...	901 B	-rw-r--r--
2025_05_05_143702_create_submi...	1.05 KB	-rw-r--r--
2025_05_13_053659_create_exami...	727 B	-rw-r--r--
2025_05_13_054736_add_grade_to...	688 B	-rw-r--r--
2025_05_16_084654_create_resou...	1.01 KB	-rw-r--r--
2025_05_21_092227_create_meeti...	1020 B	-rw-r--r--
2025_05_21_151122_add_status_t...	649 B	-rw-r--r--
2025_08_11_064013_add_achievem...	733 B	-rw-r--r--
2025_08_14_095906_add_columns_...	742 B	-rw-r--r--
2025_08_14_165639_create_event...	1.28 KB	-rw-r--r--

Code Editor : 2025_03_28_100518_create_complaints_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('complaints', function (Blueprint $table) {
            $table->id();
            $table->foreignId('user_id')->constrained()->onDelete('cascade');
            $table->foreignId('supervisor_id')->constrained('users');
            $table->foreignId('registrar_id')->nullable()->constrained('users');
            $table->string('subject');
            $table->text('description');
            $table->text('response')->nullable();
            $table->enum('status', ['pending', 'in_progress', 'resolved', 'forwarded'])->default('pending');
            $table->timestamp('submitted_at');
            $table->timestamps();
        });
    }

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

${this.title}

Code Editor : 2025_03_28_100518_create_complaints_table.php