<?php

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

class CreateNewjoineesTable extends Migration
{
    /*
     * Run the migrations.
     *
     * @return void
     */

    public function up()
    {

        /*
         * Table: newjoinees
         */
        Schema::create('newjoinees', function ($table) {
            $table->increments('id');
            $table->string('ref', 50)->nullable();
            $table->integer('user_id')->nullable();
            $table->integer('org_id')->nullable();
            $table->integer('branch_id')->nullable();
            $table->integer('division_id')->nullable();
            $table->integer('department_id')->nullable();
            $table->integer('manager_id')->nullable();
            $table->string('first_name', 80)->nullable();
            $table->string('last_name', 80)->nullable();
            $table->date('dob')->nullable();
            $table->string('place_of_birth', 200)->nullable();
            $table->enum('gender', ['Male','Female',''])->nullable();
            $table->enum('martial_status', ['Single','Married','Divorced','Widowed',''])->nullable();
            $table->tinyInteger('driving_license')->nullable();
            $table->string('religion', 50)->nullable();
            $table->string('designation', 50)->nullable();
            $table->text('languages')->nullable();
            $table->string('nationality', 60)->nullable();
            $table->integer('coo_id')->nullable();
            $table->string('mother_name', 200)->nullable();
            $table->text('social')->nullable();
            $table->text('contact_home_address')->nullable();
            $table->string('contact_home_mobile', 20)->nullable();
            $table->string('contact_home_phone', 30)->nullable();
            $table->string('contact_home_email', 100)->nullable();
            $table->text('contact_work_address')->nullable();
            $table->string('contact_work_phone', 30)->nullable();
            $table->string('contact_work_email', 100)->nullable();
            $table->string('contact_work_mobile', 30)->nullable();
            $table->string('contact_emergency_name', 80)->nullable();
            $table->text('contact_emergency_address')->nullable();
            $table->string('contact_emergency_mobile', 20)->nullable();
            $table->string('contact_emergency_email', 100)->nullable();
            $table->string('contact_emergency_phone', 30)->nullable();
            $table->string('contact_emergency_relation', 30)->nullable();
            $table->string('employment_job_title', 50)->nullable();
            $table->string('employment_user_role', 100)->nullable();
            $table->date('employment_start_date')->nullable();
            $table->date('employment_end_date')->nullable();
            $table->string('account_bank_name', 50)->nullable();
            $table->text('account_bank_address')->nullable();
            $table->string('account_routing_code', 30)->nullable();
            $table->string('account_number', 30)->nullable();
            $table->string('account_iban_number', 30)->nullable();
            $table->string('account_name', 50)->nullable();
            $table->string('contract_business_licence', 50)->nullable();
            $table->enum('contract_type', ['Full Time','Part Time','Contract','Other',''])->nullable();
            $table->string('contract_number', 50)->nullable();
            $table->date('contract_start_date')->nullable();
            $table->date('contract_end_date')->nullable();
            $table->text('contract_copy')->nullable();
            $table->integer('current_salary')->nullable();
            $table->dateTime('current_salary_date')->nullable();
            $table->integer('prev_salary')->nullable();
            $table->tinyInteger('probation_period')->nullable();
            $table->text('passport')->nullable();
            $table->text('visa')->nullable();
            $table->text('ref_pre_emp')->nullable();
            $table->text('ref_uae')->nullable();
            $table->text('ref_home')->nullable();
            $table->text('notes')->nullable();
            $table->enum('status', ['Active','Inactive',''])->nullable();
            $table->tinyInteger('notifications')->nullable();
            $table->string('upload_folder', 50)->nullable();
            $table->string('user_type', 30)->nullable();
            $table->integer('created_id')->nullable();
            $table->softDeletes();
            $table->nullableTimestamps();
        });
    }

    /*
    * Reverse the migrations.
    *
    * @return void
    */

    public function down()
    {
        Schema::drop('newjoinees');
    }
}