<?php
/**
 * ------------------------ 
 *  版权所有  www.tecmz.com
 *  商业版本请购买正版授权使用
 * ------------------------
*/ use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; class CreatePayOrder extends Migration { public function up() { Schema::create('pay_order', function (Blueprint $onV5E) { $onV5E->increments('id'); $onV5E->timestamps(); $onV5E->tinyInteger('status')->nullable()->comment('订单状态'); $onV5E->string('biz', 20)->nullable()->comment('业务:通常表示在当前系统的支付类型,如 购买订单,用户充值'); $onV5E->integer('bizId')->nullable()->comment('业务ID:在当前业务下的ID标识'); $onV5E->string('payType', 20)->nullable()->comment('支付方式'); $onV5E->string('payOrderId', 64)->nullable()->comment('支付订单ID,通常由支付系统返回'); $onV5E->decimal('feeTotal', 20, 2)->nullable()->comment('支付金额'); $onV5E->timestamp('timePayCreated')->nullable()->comment('时间:支付订单创建'); $onV5E->timestamp('timePay')->nullable()->comment('时间:支付'); $onV5E->decimal('feeRefund', 20, 2)->nullable()->comment('退款金额'); $onV5E->timestamp('timeRefundCreated')->nullable()->comment('时间:退款申请'); $onV5E->timestamp('timeRefundSuccess')->nullable()->comment('时间:退款成功'); $onV5E->timestamp('timeClosed')->nullable()->comment('时间:订单关闭(未支付)'); $onV5E->string('param', 400)->nullable()->comment(''); $onV5E->unique(array('biz', 'bizId')); }); } public function down() { } }