jucai/database/migrations/Jobfair/2019_01_17_145309_create_jobfairs_table.php

<?php

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

class CreateJobfairsTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('jobfairs', function (Blueprint $table) {
            $table->increments('id');
            $table->string('title')->comment('招聘会标题');
            $table->string('industry')->comment('行业主题')->nullable();
            $table->integer('holddate_start')->index()->comment('举办开始时间');
            $table->integer('holddate_end')->index()->comment('举办结束时间');
            $table->integer('areaid')->comment('举办场地');
            $table->tinyInteger('jobfair_type')->comment('招聘会属性(1:现场招聘会,2:赴外招聘,3:高校专场)');
            $table->integer('showendtime')->comment('显示截止时间')->nullable();
            $table->string('address')->comment('举办地址');
            $table->string('bus')->comment('乘车路线');
            $table->string('contact')->comment('联系人');
            $table->string('phone')->comment('联系电话');
            $table->text('predetermined_lock')->comment('预留展位')->nullable();
            $table->tinyInteger('display')->comment('显示状态(1:正常,2:暂停)')->nullable();
            $table->tinyInteger('is_commonweal')->comment('公益招聘会(1:是,2:否)')->nullable();
            $table->integer('predetermined_point')->comment('预定消耗积分')->nullable();
            $table->integer('jobsfair_num')->comment('预定消耗场次')->nullable();
            $table->integer('nosign_point')->comment('未签到扣减积分')->nullable();
            $table->integer('late_point')->comment('迟到早退扣减积分')->nullable();
            $table->integer('ordid')->comment('排序')->nullable();
            $table->text('jobfair_introduction')->comment('招聘会简介');
            $table->string('map_x')->comment('地图坐标');
            $table->string('map_y')->comment('地图坐标');
            $table->integer('subsite_id')->comment('站点')->nullable();
            $table->string('predetermined_status')->comment('预定状态(1:允许预订,2:停止预订)')->nullable();
            $table->integer('predetermined_start')->comment('预订开始时间');
            $table->integer('predetermined_end')->comment('预订结束时间');
            $table->tinyInteger('more_stand')->comment('预定多个展位（1：可以，0：不可以）')->nullable();
            $table->timestamps();
            $table->softDeletes();
        });
    }

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