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