You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

60 lines
1.9 KiB

2 years ago
<?php
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
return new class extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('enquiries', function (Blueprint $table) {
$table->id();
$table->string('first_name');
$table->string('middle_name')->nullable();
2 years ago
$table->string('last_name');
$table->date('dob');
$table->string('cob');
2 years ago
$table->string('gender');
$table->string('email');
$table->string('phone');
$table->string('address');
$table->string('highest_qualification');
$table->string('stream')->nullable();
2 years ago
$table->string('gpa');
$table->string('graduate_year');
$table->string('gap')->nullable();
$table->string('current_status')->nullable();
2 years ago
$table->string('work_experience');
$table->text('work_experience_details')->nullable();
$table->string('salary_mode')->nullable();
$table->string('test_score')->nullable();
2 years ago
$table->string('marital_status');
$table->string('married_date')->nullable();
$table->string('spouse_academics')->nullable();
$table->string('spouse_work_experience')->nullable();
$table->string('spouse_salary_mode')->nullable();
$table->string('immigration_history')->nullable();
$table->string('desired_study_field')->nullable();
$table->string('desired_location')->nullable();
2 years ago
$table->boolean('status')->default(true);
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('enquiries');
}
};