<?php

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

class CreateInvoicesTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('invoices', function (Blueprint $table) {
            $table->increments('id');
            $table->integer('oid')->comment('订单ID');
            $table->string('order_num')->comment('订单编号');
            $table->integer('uid')->comment('会员ID');
            $table->tinyInteger('title')->comment('订单标题1：企业；2:个人');
            $table->tinyInteger('cid')->comment('类型编号(1=>资询费,2=>资询服务费,3=>服务费)');
            $table->string('organization')->comment('组织/单位名称');
            $table->string('deposit_bank')->comment('开户行');
            $table->string('account')->comment('账号');
            $table->string('addressee')->comment('收件人');
            $table->bigInteger('mobile')->comment('手机号');
            $table->string('address')->comment('地址');
            $table->mediumInteger('postcode')->comment('邮编');
            $table->tinyInteger('audit')->comment('审核（0:未开票 1:已开票 2:取消）');
            $table->text('reason')->comment('取消原因');
            $table->timestamps();
        });
    }

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