商品-订单表

<ul> <li>admin_order 商品订单表</li> </ul> <table> <thead> <tr> <th>字段</th> <th>类型</th> <th>允许空</th> <th>默认</th> <th>说明</th> </tr> </thead> <tbody> <tr> <td>id</td> <td>mediumint (8)</td> <td>否</td> <td></td> <td>自增id</td> </tr> <tr> <td>key</td> <td>char (6)</td> <td>否</td> <td></td> <td>唯一标识符</td> </tr> <tr> <td>merchant_id</td> <td>int (11)</td> <td>否</td> <td></td> <td>商户id</td> </tr> <tr> <td>user_id</td> <td>int (11)</td> <td>否</td> <td></td> <td>用户id</td> </tr> <tr> <td>order_group_sn</td> <td>varchar (24)</td> <td>否</td> <td></td> <td>订单主表sn号</td> </tr> <tr> <td>name</td> <td>varchar (256)</td> <td>否</td> <td></td> <td>商品名称</td> </tr> <tr> <td>pic_url</td> <td>varchar (256)</td> <td>否</td> <td></td> <td>商品图片</td> </tr> <tr> <td>goods_id</td> <td>int (10)</td> <td>否</td> <td></td> <td>商品id</td> </tr> <tr> <td>is_flash_sale</td> <td>tinyint (1)</td> <td>是</td> <td>0</td> <td>是否秒杀 0不是 1=是</td> </tr> <tr> <td>is_assemble</td> <td>tinyint (1)</td> <td>是</td> <td>0</td> <td>是否拼团 0=否 1=是</td> </tr> <tr> <td>estimated_time</td> <td>int (10)</td> <td>否</td> <td>0</td> <td>预约时间</td> </tr> <tr> <td>property1_name</td> <td>varchar (256)</td> <td>是</td> <td></td> <td>第一个属性名称</td> </tr> <tr> <td>property2_name</td> <td>varchar (256)</td> <td>是</td> <td></td> <td>第二个属性名称</td> </tr> <tr> <td>stock_id</td> <td>varchar (256)</td> <td>否</td> <td></td> <td>库存id</td> </tr> <tr> <td>number</td> <td>int (10)</td> <td>否</td> <td></td> <td>商品数量</td> </tr> <tr> <td>total_price</td> <td>decimal (8)</td> <td>是</td> <td></td> <td>子订单总额</td> </tr> <tr> <td>price</td> <td>decimal (8)</td> <td>是</td> <td></td> <td>商品单价</td> </tr> <tr> <td>express_price</td> <td>decimal (8)</td> <td>是</td> <td></td> <td>运费价格</td> </tr> <tr> <td>confirm_time</td> <td>int (10)</td> <td>是</td> <td>0</td> <td>确认时间</td> </tr> <tr> <td>finish_time</td> <td>int (10)</td> <td>是</td> <td>0</td> <td>完成时间</td> </tr> <tr> <td>send_out_time</td> <td>int (10)</td> <td>是</td> <td>0</td> <td>发货时间</td> </tr> <tr> <td>payment_money</td> <td>decimal (8)</td> <td>是</td> <td></td> <td>子付款总额(减去优惠)</td> </tr> <tr> <td>express_id</td> <td>int (10)</td> <td>是</td> <td></td> <td>快递id</td> </tr> <tr> <td>express_number</td> <td>varchar (52)</td> <td>是</td> <td></td> <td>快递单号</td> </tr> <tr> <td>remark</td> <td>varchar (255)</td> <td>是</td> <td></td> <td>备注</td> </tr> <tr> <td>status</td> <td>tinyint (1)</td> <td>是</td> <td>0</td> <td>0=未发货 1=已发货 2=已退款 3=售后中 4=已完成</td> </tr> <tr> <td>admin_remark</td> <td>varchar (255)</td> <td>是</td> <td></td> <td>管理员备注</td> </tr> <tr> <td>created_at</td> <td>timestamp</td> <td>否</td> <td></td> <td>创建时间</td> </tr> <tr> <td>updated_at</td> <td>timestamp</td> <td>是</td> <td></td> <td>更新时间</td> </tr> <tr> <td>deleted_at</td> <td>timestamp</td> <td>是</td> <td></td> <td>删除时间</td> </tr> </tbody> </table>