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

<?php

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

class CreateMembersTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('members', function (Blueprint $table) {
            $table->increments('id');
            $table->tinyInteger('utype')->comment('用户类型');
            $table->string('username')->comment('会员名');
            $table->string('email')->comment('邮箱');
            $table->tinyInteger('email_audit')->comment('邮箱认证 1:认证通过 2:认证失败0未认证');
            $table->bigInteger('mobile')->comment('手机号码');
            $table->tinyInteger('mobile_audit')->comment('手机认证 1:认证通过 2:认证失败0未认证');
            $table->string('password')->comment('密码');
            $table->integer('reg_time')->comment('注册时间');
            $table->integer('reg_ip')->comment('注册ip');
            $table->string('reg_address')->comment('注册地址');
            $table->integer('last_login_time')->comment('最后登录时间');
            $table->integer('last_login_ip')->comment('最后登录ip');
            $table->tinyInteger('status')->default('1')->comment('会员状态 1:可用 0:禁用');
            $table->string('avatars')->comment('会员头像');
            $table->tinyInteger('robot')->comment('是否采集 0:人工注册 1:采集');
            $table->smallInteger('consultant');
            $table->integer('remind_email_time')->comment('下次邮件提醒时间');
            $table->string('imei');
            $table->integer('sms_num')->comment('短信数量');
            $table->tinyInteger('reg_type')->comment('注册方式(1:手机，2:邮箱，3:微信)');
            $table->integer('remind_email_ex_time')->comment('已经邮件提醒次数');
            $table->string('invitation_code');
            $table->integer('laiyuan')->comment('0本站，1代表聚财');
            $table->integer('qx_uid')->comment('表示侨乡注册的互通给聚财的用户的侨乡的uid，值默认0：自己网站注册的，1是侨乡网members表的uid');
            $table->string('talent_category')->comment('人才类别');
            $table->smallInteger('talent_category_audit')->comment('人才类别审核状态,0,未认证,1,认证通过,2等待认证,3认证未通过');
            $table->tinyInteger('member_status')->comment('会员状态，1需要找工作，2已找到工作,3来晋创业');
            $table->tinyInteger('reg_source')->default('1')->comment('注册来源 1:网页端 2:手机端 3:微信小程序');
            $table->string('reg_source_cn')->default('网页端')->comment('注册来源 1:网页端 2:手机端 3:微信小程序');
            $table->smallInteger('subsite_id')->comment('分站id:0为总站');
            $table->rememberToken();
            $table->timestamps();
            $table->softDeletes();
        });
    }

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