1#@!#!123s

ALWAYS HENGHENG888 1#@!#!123s

: / var / www / cdcdhaka.org / database / migrations /

Filename : 2024_07_10_011654_create_book_appointments_table.php

back

<?php

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

class CreateBookAppointmentsTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('book_appointments', function (Blueprint $table) {
            $table->bigIncrements('id');
            $table->uuid('uuid')->unique()->index();
            $table->string('name', 191)->index();
            $table->string('profession', 191);
            $table->string('phone', 16);
            $table->string('email', 191);
            $table->enum('preferred_day', ['sunday', 'monday', 'tuesday', 'wednesday', 'thursday', 'friday', 'saturday'])->index();
            $table->integer('user_id')->index()->nullable();
            $table->timestamps();
            $table->softDeletes();
        });

        // php artisan migrate:refresh --path='./database/migrations/2024_07_10_011654_create_book_appointments_table.php'
    }

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