<?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 $GocOS) { $GocOS->increments('id'); $GocOS->timestamps(); $GocOS->tinyInteger('status')->nullable()->comment('订单状态'); $GocOS->string('biz', 20)->nullable()->comment('业务:通常表示在当前系统的支付类型,如 购买订单,用户充值'); $GocOS->integer('bizId')->nullable()->comment('业务ID:在当前业务下的ID标识'); $GocOS->string('payType', 20)->nullable()->comment('支付方式'); $GocOS->string('payOrderId', 64)->nullable()->comment('支付订单ID,通常由支付系统返回'); $GocOS->decimal('feeTotal', 20, 2)->nullable()->comment('支付金额'); $GocOS->timestamp('timePayCreated')->nullable()->comment('时间:支付订单创建'); $GocOS->timestamp('timePay')->nullable()->comment('时间:支付'); $GocOS->decimal('feeRefund', 20, 2)->nullable()->comment('退款金额'); $GocOS->timestamp('timeRefundCreated')->nullable()->comment('时间:退款申请'); $GocOS->timestamp('timeRefundSuccess')->nullable()->comment('时间:退款成功'); $GocOS->timestamp('timeClosed')->nullable()->comment('时间:订单关闭(未支付)'); $GocOS->string('param', 400)->nullable()->comment(''); $GocOS->unique(array('biz', 'bizId')); }); } public function down() { } }