商城系统-订单表

-- 数据库大全：商城系统-订单表
-- 来源：YesApi.cn
CREATE TABLE `yesapi_yshopmall_yx_store_order` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `order_id` varchar(32) NOT NULL COMMENT '订单号',
    `extend_order_id` varchar(32) NOT NULL COMMENT '额外订单号',
    `uid` bigint(20) NOT NULL COMMENT '用户id',
    `real_name` varchar(32) NOT NULL COMMENT '用户姓名',
    `user_phone` varchar(18) NOT NULL COMMENT '用户电话',
    `user_address` varchar(100) NOT NULL COMMENT '详细地址',
    `cart_id` varchar(256) NOT NULL DEFAULT '[]' COMMENT '购物车id',
    `freight_price` decimal(8,2) NOT NULL DEFAULT '0.00' COMMENT '运费金额',
    `total_num` int(10) NOT NULL DEFAULT '0' COMMENT '订单商品总数',
    `total_price` decimal(8,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '订单总价',
    `total_postage` decimal(8,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '邮费',
    `pay_price` decimal(8,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '实际支付金额',
    `pay_postage` decimal(8,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '支付邮费',
    `deduction_price` decimal(8,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '抵扣金额',
    `coupon_id` int(10) NOT NULL DEFAULT '0' COMMENT '优惠券id',
    `coupon_price` decimal(8,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '优惠券金额',
    `paid` tinyint(3) NOT NULL DEFAULT '0' COMMENT '支付状态',
    `pay_time` datetime NOT NULL COMMENT '支付时间',
    `pay_type` varchar(32) NOT NULL COMMENT '支付方式',
    `create_time` datetime NOT NULL COMMENT '创建时间',
    `yesapi_yshopmall_yx_store_order_status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '订单状态（-1 : 申请退款 -2 : 退货成功 0：待发货；1：待收货；2：已收货；3：已完成；-1：已退款）',
    `refund_status` tinyint(3) NOT NULL DEFAULT '0' COMMENT '0 未退款 1 申请中 2 已退款',
    `refund_reason_wap_img` varchar(255) NOT NULL COMMENT '退款图片',
    `refund_reason_wap_explain` varchar(255) NOT NULL COMMENT '退款用户说明',
    `refund_reason_time` datetime NOT NULL COMMENT '退款时间',
    `refund_reason_wap` varchar(255) NOT NULL COMMENT '前台退款原因',
    `refund_reason` varchar(255) NOT NULL COMMENT '不退款的理由',
    `refund_price` decimal(8,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '退款金额',
    `delivery_sn` varchar(100) NOT NULL COMMENT '快递公司编号',
    `delivery_name` varchar(64) NOT NULL COMMENT '快递名称/送货人姓名',
    `delivery_type` varchar(32) NOT NULL COMMENT '发货类型',
    `delivery_id` varchar(64) NOT NULL COMMENT '快递单号/手机号',
    `gain_integral` decimal(8,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '消费赚取积分',
    `use_integral` decimal(8,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '使用积分',
    `back_integral` decimal(8,2) unsigned NOT NULL COMMENT '给用户退了多少积分',
    `mark` varchar(512) NOT NULL COMMENT '备注',
    `is_del` tinyint(3) NOT NULL DEFAULT '0' COMMENT '是否删除',
    `yesapi_yshopmall_yx_store_order_unique` char(32) NOT NULL COMMENT '唯一id(md5加密)类似id',
    `remark` varchar(512) NOT NULL COMMENT '管理员备注',
    `combination_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '拼团产品id0一般产品',
    `pink_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '拼团id 0没有拼团',
    `cost` decimal(8,2) unsigned NOT NULL COMMENT '成本价',
    `seckill_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '秒杀产品ID',
    `bargain_id` int(10) NOT NULL DEFAULT '0' COMMENT '砍价id',
    `verify_code` varchar(50) NOT NULL COMMENT '核销码',
    `store_id` int(11) NOT NULL DEFAULT '0' COMMENT '门店id',
    `shipping_type` tinyint(1) NOT NULL DEFAULT '1' COMMENT '配送方式 1=快递 ，2=门店自提',
    KEY `order_id` (`order_id`),
    KEY `uid` (`uid`),
    KEY `pay_price` (`pay_price`),
    KEY `coupon_id` (`coupon_id`),
    KEY `paid` (`paid`),
    KEY `pay_time` (`pay_time`),
    KEY `pay_type` (`pay_type`),
    KEY `create_time` (`create_time`),
    KEY `yesapi_yshopmall_yx_store_order_status` (`yesapi_yshopmall_yx_store_order_status`),
    KEY `is_del` (`is_del`),
    UNIQUE KEY `yesapi_yshopmall_yx_store_order_unique` (`yesapi_yshopmall_yx_store_order_unique`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT '商城系统-订单表';

复制后，到数据库执行，即可创建此数据库表。