jucai/database/migrations/Person/2018_10_17_142647_create_resumes_table.php

<?php

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

class CreateResumesTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('resumes', function (Blueprint $table) {
            $table->increments('id');
            $table->integer('uid')->index()->comment('会员uid');
            $table->tinyInteger('display')->index()->default('1')->comment('是否显示(1:显示 0:不显示)')->nullable();
            $table->tinyInteger('display_name')->default('1')->comment('简历名称显示方式(1:公开 0:简历编号3:先生、女士)');
            $table->tinyInteger('audit')->index()->default('1')->comment('简历审核(0:审核不通过 1:待审核 2:审核通过)')->nullable();
            $table->tinyInteger('stick')->comment('是否置顶(0:否 1:是)')->nullable();
            $table->integer('strong_tag')->comment('醒目标签')->nullable();
            $table->string('title')->comment('简历标题');
            $table->string('fullname')->comment('真实姓名');
            $table->tinyInteger('sex')->comment('性别（1:男 2:女）');
            $table->string('sex_cn')->comment('性别');
            $table->integer('nature')->comment('工作性质id')->nullable();
            $table->string('nature_cn')->comment('工作性质')->nullable();
            $table->string('trade')->comment('行业id')->nullable();
            $table->string('trade_cn')->comment('行业')->nullable();
            $table->smallInteger('birthdate')->comment('生日');
            $table->string('residence')->comment('现居住地')->nullable();
            $table->smallInteger('height')->comment('身高(cm)')->nullable();
            $table->tinyInteger('marriage')->default('2')->comment('婚否（1:已婚 2:未婚）')->nullable();
            $table->string('marriage_cn')->comment('婚否')->nullable();
            $table->integer('experience')->comment('工作经验id');
            $table->string('experience_cn')->comment('工作经验');
            $table->string('district')->comment('地区ID');
            $table->string('district_cn')->comment('地区');
            $table->integer('wage')->comment('期望薪资id');
            $table->string('wage_cn')->comment('期望薪资');
            $table->string('householdaddress')->comment('户口所在地')->nullable();
            $table->integer('education')->comment('学历id');
            $table->string('education_cn')->comment('学历');
            $table->integer('major')->comment('专业id')->nullable();
            $table->string('major_cn')->comment('专业')->nullable();
            $table->string('tag')->comment('简历标签编号')->nullable();
            $table->string('tag_cn')->comment('简历标签')->nullable();
            $table->bigInteger('telephone')->index()->comment('手机号码');
            $table->string('email')->comment('邮箱');
            $table->tinyInteger('email_notify')->comment('邮件接收通知(1:接收 0:不接受)')->nullable();
            $table->string('intention_jobs_id')->comment('期望职位id');
            $table->string('intention_jobs')->comment('期望职位');
            $table->string('specialty')->comment('自我描述')->nullable();
            $table->tinyInteger('photo')->comment('是否为照片简历(0:否 1:是)')->nullable();
            $table->tinyInteger('photo_audit')->comment('照片审核(0:审核失败，1:待审核 2:审核成功)')->nullable();
            $table->string('qq')->comment('QQ')->nullable();
            $table->string('weixin')->comment('微信')->nullable();
            $table->tinyInteger('subsite_id')->default('0')->comment('站点')->nullable();
            $table->integer('stime')->comment('置顶时间')->nullable();
            $table->integer('entrust')->comment('简历委托（天）')->nullable();
            $table->string('talent')->comment('高级人才（0:否 1:是）')->nullable();
            $table->tinyInteger('level')->comment('简历等级（1:优,2:良 0:差）');
            $table->integer('complete_percent')->comment('简历完整度');
            $table->integer('current')->comment('求职状态编号')->nullable();
            $table->string('current_cn')->comment('求职状态')->nullable();
            $table->string('word_resume')->comment('word简历')->nullable();
            $table->string('word_resume_title')->comment('word简历标题')->nullable();
            $table->integer('word_resume_addtime')->comment('word简历添加时间')->nullable();
            $table->longText('key_full')->comment('全文搜索关键字')->nullable();
            $table->longText('key_precise')->comment('精确搜索关键字')->nullable();
            $table->integer('click')->comment('查看次数')->nullable();
            $table->string('tpl')->comment('简历模板')->nullable();
            $table->tinyInteger('resume_from_pc')->default('1')->comment('简历来自PC(1->是 0->否)')->nullable();
            $table->tinyInteger('def')->default('1')->comment('是否为默认简历(1:是 0:否)')->nullable();
            $table->tinyInteger('mobile_audit')->comment('手机是否认证(1:是 0:否)')->nullable();
            $table->string('comment_content')->comment('简历评论内容')->nullable();
            $table->tinyInteger('is_quick')->comment('快速创建简历（0:否 1:是）')->nullable();
            $table->string('idcard')->comment('身份证')->nullable();
            $table->timestamps();
            $table->softDeletes();
        });
    }

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