jucai/database/migrations/2018_09_29_015225_create_jobs_table.php

<?php

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

class CreateJobsTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('jobs', function (Blueprint $table) {
            $table->increments('id');
            $table->integer('company_id')->index()->comment('企业ID');
            $table->tinyInteger('valid')->default('1')->comment('职位状态：0无效1有效');
            $table->string('jobs_name')->comment('职位名称');
            $table->string('company_name')->comment('企业名称');
            $table->integer('company_addtime')->comment('企业添加时间');
            $table->tinyInteger('company_audit')->comment('公司审核状态：1核通过；2待审核；3审核未通过');
            $table->tinyInteger('emergency')->comment('紧急招聘：0否；1是');
            $table->integer('stick')->comment('职位置顶：0否；1是');
            $table->integer('nature')->comment('工作性质');
            $table->tinyInteger('sex')->default('1')->comment('性别：1男；2女；0不限');
            $table->string('age')->comment('年龄');
            $table->smallInteger('amount')->comment('招聘人数');
            $table->smallInteger('topclass')->comment('职位一级分类');
            $table->smallInteger('category')->comment('职位二级分类');
            $table->smallInteger('subclass')->comment('职位三级分类');
            $table->smallInteger('trade')->comment('行业ID');
            $table->smallInteger('scale')->comment('企业规模');
            $table->string('district')->comment('地区分类');
            $table->string('tag')->comment('标签分类');
            $table->smallInteger('education')->comment('学历ID');
            $table->smallInteger('experience')->comment('工作经验ID');
            $table->integer('wage')->comment('薪资待遇');
            $table->integer('wage_max')->comment('最高薪资');
            $table->integer('wage_min')->comment('最低薪资');
            $table->tinyInteger('negotiable')->comment('面试：0否；1是');
            $table->text('jobs_cotent')->comment('职位描述');
            $table->integer('deadline')->comment('到期时间');
            $table->integer('refresh_time')->comment('刷新时间');
            $table->integer('stime')->comment('置顶时间');
            $table->integer('setmeal_deadline')->comment('套餐到期时间');
            $table->smallInteger('setmeal_id')->comment('套餐ID');
            $table->string('setmeal_name')->comment('套餐名称');
            $table->tinyInteger('audit')->comment('审核状态：1审核通过；2审核中；3审核未通过');
            $table->tinyInteger('display')->default('1')->comment('是否显示：1是0否');
            $table->integer('click')->default('0')->comment('点击量');
            $table->tinyInteger('robot')->comment('是否为采集信息：0人工；1采集');
            $table->decimal('map_x')->comment('地图X坐标');
            $table->decimal('map_y')->comment('地图Y坐标');
            $table->tinyInteger('map_zoom')->default('18')->comment('地图缩放级别');
            $table->tinyInteger('add_mode')->default('1')->comment('添加方式');
            $table->string('department')->comment('部门');
            $table->text('key_precise')->comment('精确搜索关键字');
            $table->text('key_full')->comment('全文搜索关键字');
            $table->smallInteger('subsite_id')->comment('分站ID：0总站');
            $table->timestamps();
            $table->softDeletes();
        });
    }

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