/*
|
Navicat Premium Data Transfer
|
|
Source Server : 192.168.110.169
|
Source Server Type : MySQL
|
Source Server Version : 80036
|
Source Host : 192.168.110.169:3306
|
Source Schema : qijisheng_order
|
|
Target Server Type : MySQL
|
Target Server Version : 80036
|
File Encoding : 65001
|
|
Date: 25/11/2024 18:29:53
|
*/
|
|
SET NAMES utf8mb4;
|
SET FOREIGN_KEY_CHECKS = 0;
|
|
-- ----------------------------
|
-- Table structure for t_order_0
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_0`;
|
CREATE TABLE `t_order_0` (
|
`id` bigint NOT NULL,
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`order_type` int NULL DEFAULT NULL COMMENT '订单类型1服务单2商品',
|
`order_status` int NOT NULL COMMENT '1待发货2待收货3待使用4已完成5已取消6已退款7售后中',
|
`end_time` datetime(0) NULL DEFAULT NULL COMMENT '核销时间',
|
`technician_id` int NULL DEFAULT NULL COMMENT '技师id',
|
`order_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '订单编号',
|
`total_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '订单总金额',
|
`payment_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '实际支付价格',
|
`point` decimal(10, 2) NULL DEFAULT NULL COMMENT '使用积分',
|
`pay_method` int NULL DEFAULT NULL COMMENT '1wx2积分',
|
`coupon_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '使用的优惠劵json',
|
`express_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '运费',
|
`express_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '第三方快递信息',
|
`share_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '平台分佣',
|
`get_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '本单获取的积分',
|
`serial_number` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付号',
|
`pay_status` int NULL DEFAULT NULL COMMENT '1待支付2已支付',
|
`shop_id` int NULL DEFAULT NULL COMMENT '对应门店id',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_0
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_1
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_1`;
|
CREATE TABLE `t_order_1` (
|
`id` bigint NOT NULL,
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`order_type` int NULL DEFAULT NULL COMMENT '订单类型1服务单2商品',
|
`order_status` int NOT NULL COMMENT '1待发货2待收货3待使用4已完成5已取消6已退款7售后中',
|
`end_time` datetime(0) NULL DEFAULT NULL COMMENT '核销时间',
|
`technician_id` int NULL DEFAULT NULL COMMENT '技师id',
|
`order_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '订单编号',
|
`total_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '订单总金额',
|
`payment_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '实际支付价格',
|
`point` decimal(10, 2) NULL DEFAULT NULL COMMENT '使用积分',
|
`pay_method` int NULL DEFAULT NULL COMMENT '1wx2积分',
|
`coupon_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '使用的优惠劵json',
|
`express_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '运费',
|
`express_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '第三方快递信息',
|
`share_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '平台分佣',
|
`get_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '本单获取的积分',
|
`serial_number` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付号',
|
`pay_status` int NULL DEFAULT NULL COMMENT '1待支付2已支付',
|
`shop_id` int NULL DEFAULT NULL COMMENT '对应门店id',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_1
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_10
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_10`;
|
CREATE TABLE `t_order_10` (
|
`id` bigint NOT NULL,
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`order_type` int NULL DEFAULT NULL COMMENT '订单类型1服务单2商品',
|
`order_status` int NOT NULL COMMENT '1待发货2待收货3待使用4已完成5已取消6已退款7售后中',
|
`end_time` datetime(0) NULL DEFAULT NULL COMMENT '核销时间',
|
`technician_id` int NULL DEFAULT NULL COMMENT '技师id',
|
`order_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '订单编号',
|
`total_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '订单总金额',
|
`payment_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '实际支付价格',
|
`point` decimal(10, 2) NULL DEFAULT NULL COMMENT '使用积分',
|
`pay_method` int NULL DEFAULT NULL COMMENT '1wx2积分',
|
`coupon_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '使用的优惠劵json',
|
`express_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '运费',
|
`express_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '第三方快递信息',
|
`share_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '平台分佣',
|
`get_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '本单获取的积分',
|
`serial_number` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付号',
|
`pay_status` int NULL DEFAULT NULL COMMENT '1待支付2已支付',
|
`shop_id` int NULL DEFAULT NULL COMMENT '对应门店id',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_10
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_11
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_11`;
|
CREATE TABLE `t_order_11` (
|
`id` bigint NOT NULL,
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`order_type` int NULL DEFAULT NULL COMMENT '订单类型1服务单2商品',
|
`order_status` int NOT NULL COMMENT '1待发货2待收货3待使用4已完成5已取消6已退款7售后中',
|
`end_time` datetime(0) NULL DEFAULT NULL COMMENT '核销时间',
|
`technician_id` int NULL DEFAULT NULL COMMENT '技师id',
|
`order_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '订单编号',
|
`total_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '订单总金额',
|
`payment_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '实际支付价格',
|
`point` decimal(10, 2) NULL DEFAULT NULL COMMENT '使用积分',
|
`pay_method` int NULL DEFAULT NULL COMMENT '1wx2积分',
|
`coupon_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '使用的优惠劵json',
|
`express_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '运费',
|
`express_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '第三方快递信息',
|
`share_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '平台分佣',
|
`get_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '本单获取的积分',
|
`serial_number` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付号',
|
`pay_status` int NULL DEFAULT NULL COMMENT '1待支付2已支付',
|
`shop_id` int NULL DEFAULT NULL COMMENT '对应门店id',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_11
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_12
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_12`;
|
CREATE TABLE `t_order_12` (
|
`id` bigint NOT NULL,
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`order_type` int NULL DEFAULT NULL COMMENT '订单类型1服务单2商品',
|
`order_status` int NOT NULL COMMENT '1待发货2待收货3待使用4已完成5已取消6已退款7售后中',
|
`end_time` datetime(0) NULL DEFAULT NULL COMMENT '核销时间',
|
`technician_id` int NULL DEFAULT NULL COMMENT '技师id',
|
`order_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '订单编号',
|
`total_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '订单总金额',
|
`payment_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '实际支付价格',
|
`point` decimal(10, 2) NULL DEFAULT NULL COMMENT '使用积分',
|
`pay_method` int NULL DEFAULT NULL COMMENT '1wx2积分',
|
`coupon_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '使用的优惠劵json',
|
`express_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '运费',
|
`express_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '第三方快递信息',
|
`share_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '平台分佣',
|
`get_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '本单获取的积分',
|
`serial_number` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付号',
|
`pay_status` int NULL DEFAULT NULL COMMENT '1待支付2已支付',
|
`shop_id` int NULL DEFAULT NULL COMMENT '对应门店id',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_12
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_13
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_13`;
|
CREATE TABLE `t_order_13` (
|
`id` bigint NOT NULL,
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`order_type` int NULL DEFAULT NULL COMMENT '订单类型1服务单2商品',
|
`order_status` int NOT NULL COMMENT '1待发货2待收货3待使用4已完成5已取消6已退款7售后中',
|
`end_time` datetime(0) NULL DEFAULT NULL COMMENT '核销时间',
|
`technician_id` int NULL DEFAULT NULL COMMENT '技师id',
|
`order_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '订单编号',
|
`total_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '订单总金额',
|
`payment_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '实际支付价格',
|
`point` decimal(10, 2) NULL DEFAULT NULL COMMENT '使用积分',
|
`pay_method` int NULL DEFAULT NULL COMMENT '1wx2积分',
|
`coupon_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '使用的优惠劵json',
|
`express_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '运费',
|
`express_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '第三方快递信息',
|
`share_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '平台分佣',
|
`get_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '本单获取的积分',
|
`serial_number` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付号',
|
`pay_status` int NULL DEFAULT NULL COMMENT '1待支付2已支付',
|
`shop_id` int NULL DEFAULT NULL COMMENT '对应门店id',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_13
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_14
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_14`;
|
CREATE TABLE `t_order_14` (
|
`id` bigint NOT NULL,
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`order_type` int NULL DEFAULT NULL COMMENT '订单类型1服务单2商品',
|
`order_status` int NOT NULL COMMENT '1待发货2待收货3待使用4已完成5已取消6已退款7售后中',
|
`end_time` datetime(0) NULL DEFAULT NULL COMMENT '核销时间',
|
`technician_id` int NULL DEFAULT NULL COMMENT '技师id',
|
`order_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '订单编号',
|
`total_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '订单总金额',
|
`payment_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '实际支付价格',
|
`point` decimal(10, 2) NULL DEFAULT NULL COMMENT '使用积分',
|
`pay_method` int NULL DEFAULT NULL COMMENT '1wx2积分',
|
`coupon_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '使用的优惠劵json',
|
`express_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '运费',
|
`express_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '第三方快递信息',
|
`share_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '平台分佣',
|
`get_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '本单获取的积分',
|
`serial_number` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付号',
|
`pay_status` int NULL DEFAULT NULL COMMENT '1待支付2已支付',
|
`shop_id` int NULL DEFAULT NULL COMMENT '对应门店id',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_14
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_15
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_15`;
|
CREATE TABLE `t_order_15` (
|
`id` bigint NOT NULL,
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`order_type` int NULL DEFAULT NULL COMMENT '订单类型1服务单2商品',
|
`order_status` int NOT NULL COMMENT '1待发货2待收货3待使用4已完成5已取消6已退款7售后中',
|
`end_time` datetime(0) NULL DEFAULT NULL COMMENT '核销时间',
|
`technician_id` int NULL DEFAULT NULL COMMENT '技师id',
|
`order_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '订单编号',
|
`total_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '订单总金额',
|
`payment_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '实际支付价格',
|
`point` decimal(10, 2) NULL DEFAULT NULL COMMENT '使用积分',
|
`pay_method` int NULL DEFAULT NULL COMMENT '1wx2积分',
|
`coupon_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '使用的优惠劵json',
|
`express_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '运费',
|
`express_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '第三方快递信息',
|
`share_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '平台分佣',
|
`get_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '本单获取的积分',
|
`serial_number` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付号',
|
`pay_status` int NULL DEFAULT NULL COMMENT '1待支付2已支付',
|
`shop_id` int NULL DEFAULT NULL COMMENT '对应门店id',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_15
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_16
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_16`;
|
CREATE TABLE `t_order_16` (
|
`id` bigint NOT NULL,
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`order_type` int NULL DEFAULT NULL COMMENT '订单类型1服务单2商品',
|
`order_status` int NOT NULL COMMENT '1待发货2待收货3待使用4已完成5已取消6已退款7售后中',
|
`end_time` datetime(0) NULL DEFAULT NULL COMMENT '核销时间',
|
`technician_id` int NULL DEFAULT NULL COMMENT '技师id',
|
`order_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '订单编号',
|
`total_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '订单总金额',
|
`payment_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '实际支付价格',
|
`point` decimal(10, 2) NULL DEFAULT NULL COMMENT '使用积分',
|
`pay_method` int NULL DEFAULT NULL COMMENT '1wx2积分',
|
`coupon_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '使用的优惠劵json',
|
`express_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '运费',
|
`express_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '第三方快递信息',
|
`share_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '平台分佣',
|
`get_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '本单获取的积分',
|
`serial_number` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付号',
|
`pay_status` int NULL DEFAULT NULL COMMENT '1待支付2已支付',
|
`shop_id` int NULL DEFAULT NULL COMMENT '对应门店id',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_16
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_17
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_17`;
|
CREATE TABLE `t_order_17` (
|
`id` bigint NOT NULL,
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`order_type` int NULL DEFAULT NULL COMMENT '订单类型1服务单2商品',
|
`order_status` int NOT NULL COMMENT '1待发货2待收货3待使用4已完成5已取消6已退款7售后中',
|
`end_time` datetime(0) NULL DEFAULT NULL COMMENT '核销时间',
|
`technician_id` int NULL DEFAULT NULL COMMENT '技师id',
|
`order_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '订单编号',
|
`total_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '订单总金额',
|
`payment_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '实际支付价格',
|
`point` decimal(10, 2) NULL DEFAULT NULL COMMENT '使用积分',
|
`pay_method` int NULL DEFAULT NULL COMMENT '1wx2积分',
|
`coupon_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '使用的优惠劵json',
|
`express_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '运费',
|
`express_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '第三方快递信息',
|
`share_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '平台分佣',
|
`get_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '本单获取的积分',
|
`serial_number` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付号',
|
`pay_status` int NULL DEFAULT NULL COMMENT '1待支付2已支付',
|
`shop_id` int NULL DEFAULT NULL COMMENT '对应门店id',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_17
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_18
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_18`;
|
CREATE TABLE `t_order_18` (
|
`id` bigint NOT NULL,
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`order_type` int NULL DEFAULT NULL COMMENT '订单类型1服务单2商品',
|
`order_status` int NOT NULL COMMENT '1待发货2待收货3待使用4已完成5已取消6已退款7售后中',
|
`end_time` datetime(0) NULL DEFAULT NULL COMMENT '核销时间',
|
`technician_id` int NULL DEFAULT NULL COMMENT '技师id',
|
`order_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '订单编号',
|
`total_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '订单总金额',
|
`payment_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '实际支付价格',
|
`point` decimal(10, 2) NULL DEFAULT NULL COMMENT '使用积分',
|
`pay_method` int NULL DEFAULT NULL COMMENT '1wx2积分',
|
`coupon_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '使用的优惠劵json',
|
`express_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '运费',
|
`express_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '第三方快递信息',
|
`share_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '平台分佣',
|
`get_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '本单获取的积分',
|
`serial_number` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付号',
|
`pay_status` int NULL DEFAULT NULL COMMENT '1待支付2已支付',
|
`shop_id` int NULL DEFAULT NULL COMMENT '对应门店id',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_18
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_19
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_19`;
|
CREATE TABLE `t_order_19` (
|
`id` bigint NOT NULL,
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`order_type` int NULL DEFAULT NULL COMMENT '订单类型1服务单2商品',
|
`order_status` int NOT NULL COMMENT '1待发货2待收货3待使用4已完成5已取消6已退款7售后中',
|
`end_time` datetime(0) NULL DEFAULT NULL COMMENT '核销时间',
|
`technician_id` int NULL DEFAULT NULL COMMENT '技师id',
|
`order_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '订单编号',
|
`total_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '订单总金额',
|
`payment_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '实际支付价格',
|
`point` decimal(10, 2) NULL DEFAULT NULL COMMENT '使用积分',
|
`pay_method` int NULL DEFAULT NULL COMMENT '1wx2积分',
|
`coupon_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '使用的优惠劵json',
|
`express_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '运费',
|
`express_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '第三方快递信息',
|
`share_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '平台分佣',
|
`get_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '本单获取的积分',
|
`serial_number` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付号',
|
`pay_status` int NULL DEFAULT NULL COMMENT '1待支付2已支付',
|
`shop_id` int NULL DEFAULT NULL COMMENT '对应门店id',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_19
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_2
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_2`;
|
CREATE TABLE `t_order_2` (
|
`id` bigint NOT NULL,
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`order_type` int NULL DEFAULT NULL COMMENT '订单类型1服务单2商品',
|
`order_status` int NOT NULL COMMENT '1待发货2待收货3待使用4已完成5已取消6已退款7售后中',
|
`end_time` datetime(0) NULL DEFAULT NULL COMMENT '核销时间',
|
`technician_id` int NULL DEFAULT NULL COMMENT '技师id',
|
`order_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '订单编号',
|
`total_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '订单总金额',
|
`payment_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '实际支付价格',
|
`point` decimal(10, 2) NULL DEFAULT NULL COMMENT '使用积分',
|
`pay_method` int NULL DEFAULT NULL COMMENT '1wx2积分',
|
`coupon_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '使用的优惠劵json',
|
`express_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '运费',
|
`express_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '第三方快递信息',
|
`share_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '平台分佣',
|
`get_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '本单获取的积分',
|
`serial_number` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付号',
|
`pay_status` int NULL DEFAULT NULL COMMENT '1待支付2已支付',
|
`shop_id` int NULL DEFAULT NULL COMMENT '对应门店id',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_2
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_20
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_20`;
|
CREATE TABLE `t_order_20` (
|
`id` bigint NOT NULL,
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`order_type` int NULL DEFAULT NULL COMMENT '订单类型1服务单2商品',
|
`order_status` int NOT NULL COMMENT '1待发货2待收货3待使用4已完成5已取消6已退款7售后中',
|
`end_time` datetime(0) NULL DEFAULT NULL COMMENT '核销时间',
|
`technician_id` int NULL DEFAULT NULL COMMENT '技师id',
|
`order_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '订单编号',
|
`total_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '订单总金额',
|
`payment_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '实际支付价格',
|
`point` decimal(10, 2) NULL DEFAULT NULL COMMENT '使用积分',
|
`pay_method` int NULL DEFAULT NULL COMMENT '1wx2积分',
|
`coupon_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '使用的优惠劵json',
|
`express_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '运费',
|
`express_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '第三方快递信息',
|
`share_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '平台分佣',
|
`get_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '本单获取的积分',
|
`serial_number` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付号',
|
`pay_status` int NULL DEFAULT NULL COMMENT '1待支付2已支付',
|
`shop_id` int NULL DEFAULT NULL COMMENT '对应门店id',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_20
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_21
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_21`;
|
CREATE TABLE `t_order_21` (
|
`id` bigint NOT NULL,
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`order_type` int NULL DEFAULT NULL COMMENT '订单类型1服务单2商品',
|
`order_status` int NOT NULL COMMENT '1待发货2待收货3待使用4已完成5已取消6已退款7售后中',
|
`end_time` datetime(0) NULL DEFAULT NULL COMMENT '核销时间',
|
`technician_id` int NULL DEFAULT NULL COMMENT '技师id',
|
`order_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '订单编号',
|
`total_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '订单总金额',
|
`payment_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '实际支付价格',
|
`point` decimal(10, 2) NULL DEFAULT NULL COMMENT '使用积分',
|
`pay_method` int NULL DEFAULT NULL COMMENT '1wx2积分',
|
`coupon_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '使用的优惠劵json',
|
`express_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '运费',
|
`express_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '第三方快递信息',
|
`share_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '平台分佣',
|
`get_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '本单获取的积分',
|
`serial_number` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付号',
|
`pay_status` int NULL DEFAULT NULL COMMENT '1待支付2已支付',
|
`shop_id` int NULL DEFAULT NULL COMMENT '对应门店id',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_21
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_22
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_22`;
|
CREATE TABLE `t_order_22` (
|
`id` bigint NOT NULL,
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`order_type` int NULL DEFAULT NULL COMMENT '订单类型1服务单2商品',
|
`order_status` int NOT NULL COMMENT '1待发货2待收货3待使用4已完成5已取消6已退款7售后中',
|
`end_time` datetime(0) NULL DEFAULT NULL COMMENT '核销时间',
|
`technician_id` int NULL DEFAULT NULL COMMENT '技师id',
|
`order_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '订单编号',
|
`total_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '订单总金额',
|
`payment_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '实际支付价格',
|
`point` decimal(10, 2) NULL DEFAULT NULL COMMENT '使用积分',
|
`pay_method` int NULL DEFAULT NULL COMMENT '1wx2积分',
|
`coupon_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '使用的优惠劵json',
|
`express_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '运费',
|
`express_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '第三方快递信息',
|
`share_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '平台分佣',
|
`get_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '本单获取的积分',
|
`serial_number` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付号',
|
`pay_status` int NULL DEFAULT NULL COMMENT '1待支付2已支付',
|
`shop_id` int NULL DEFAULT NULL COMMENT '对应门店id',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_22
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_23
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_23`;
|
CREATE TABLE `t_order_23` (
|
`id` bigint NOT NULL,
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`order_type` int NULL DEFAULT NULL COMMENT '订单类型1服务单2商品',
|
`order_status` int NOT NULL COMMENT '1待发货2待收货3待使用4已完成5已取消6已退款7售后中',
|
`end_time` datetime(0) NULL DEFAULT NULL COMMENT '核销时间',
|
`technician_id` int NULL DEFAULT NULL COMMENT '技师id',
|
`order_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '订单编号',
|
`total_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '订单总金额',
|
`payment_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '实际支付价格',
|
`point` decimal(10, 2) NULL DEFAULT NULL COMMENT '使用积分',
|
`pay_method` int NULL DEFAULT NULL COMMENT '1wx2积分',
|
`coupon_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '使用的优惠劵json',
|
`express_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '运费',
|
`express_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '第三方快递信息',
|
`share_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '平台分佣',
|
`get_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '本单获取的积分',
|
`serial_number` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付号',
|
`pay_status` int NULL DEFAULT NULL COMMENT '1待支付2已支付',
|
`shop_id` int NULL DEFAULT NULL COMMENT '对应门店id',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_23
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_24
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_24`;
|
CREATE TABLE `t_order_24` (
|
`id` bigint NOT NULL,
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`order_type` int NULL DEFAULT NULL COMMENT '订单类型1服务单2商品',
|
`order_status` int NOT NULL COMMENT '1待发货2待收货3待使用4已完成5已取消6已退款7售后中',
|
`end_time` datetime(0) NULL DEFAULT NULL COMMENT '核销时间',
|
`technician_id` int NULL DEFAULT NULL COMMENT '技师id',
|
`order_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '订单编号',
|
`total_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '订单总金额',
|
`payment_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '实际支付价格',
|
`point` decimal(10, 2) NULL DEFAULT NULL COMMENT '使用积分',
|
`pay_method` int NULL DEFAULT NULL COMMENT '1wx2积分',
|
`coupon_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '使用的优惠劵json',
|
`express_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '运费',
|
`express_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '第三方快递信息',
|
`share_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '平台分佣',
|
`get_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '本单获取的积分',
|
`serial_number` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付号',
|
`pay_status` int NULL DEFAULT NULL COMMENT '1待支付2已支付',
|
`shop_id` int NULL DEFAULT NULL COMMENT '对应门店id',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_24
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_25
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_25`;
|
CREATE TABLE `t_order_25` (
|
`id` bigint NOT NULL,
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`order_type` int NULL DEFAULT NULL COMMENT '订单类型1服务单2商品',
|
`order_status` int NOT NULL COMMENT '1待发货2待收货3待使用4已完成5已取消6已退款7售后中',
|
`end_time` datetime(0) NULL DEFAULT NULL COMMENT '核销时间',
|
`technician_id` int NULL DEFAULT NULL COMMENT '技师id',
|
`order_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '订单编号',
|
`total_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '订单总金额',
|
`payment_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '实际支付价格',
|
`point` decimal(10, 2) NULL DEFAULT NULL COMMENT '使用积分',
|
`pay_method` int NULL DEFAULT NULL COMMENT '1wx2积分',
|
`coupon_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '使用的优惠劵json',
|
`express_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '运费',
|
`express_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '第三方快递信息',
|
`share_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '平台分佣',
|
`get_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '本单获取的积分',
|
`serial_number` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付号',
|
`pay_status` int NULL DEFAULT NULL COMMENT '1待支付2已支付',
|
`shop_id` int NULL DEFAULT NULL COMMENT '对应门店id',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_25
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_26
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_26`;
|
CREATE TABLE `t_order_26` (
|
`id` bigint NOT NULL,
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`order_type` int NULL DEFAULT NULL COMMENT '订单类型1服务单2商品',
|
`order_status` int NOT NULL COMMENT '1待发货2待收货3待使用4已完成5已取消6已退款7售后中',
|
`end_time` datetime(0) NULL DEFAULT NULL COMMENT '核销时间',
|
`technician_id` int NULL DEFAULT NULL COMMENT '技师id',
|
`order_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '订单编号',
|
`total_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '订单总金额',
|
`payment_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '实际支付价格',
|
`point` decimal(10, 2) NULL DEFAULT NULL COMMENT '使用积分',
|
`pay_method` int NULL DEFAULT NULL COMMENT '1wx2积分',
|
`coupon_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '使用的优惠劵json',
|
`express_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '运费',
|
`express_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '第三方快递信息',
|
`share_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '平台分佣',
|
`get_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '本单获取的积分',
|
`serial_number` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付号',
|
`pay_status` int NULL DEFAULT NULL COMMENT '1待支付2已支付',
|
`shop_id` int NULL DEFAULT NULL COMMENT '对应门店id',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_26
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_27
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_27`;
|
CREATE TABLE `t_order_27` (
|
`id` bigint NOT NULL,
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`order_type` int NULL DEFAULT NULL COMMENT '订单类型1服务单2商品',
|
`order_status` int NOT NULL COMMENT '1待发货2待收货3待使用4已完成5已取消6已退款7售后中',
|
`end_time` datetime(0) NULL DEFAULT NULL COMMENT '核销时间',
|
`technician_id` int NULL DEFAULT NULL COMMENT '技师id',
|
`order_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '订单编号',
|
`total_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '订单总金额',
|
`payment_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '实际支付价格',
|
`point` decimal(10, 2) NULL DEFAULT NULL COMMENT '使用积分',
|
`pay_method` int NULL DEFAULT NULL COMMENT '1wx2积分',
|
`coupon_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '使用的优惠劵json',
|
`express_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '运费',
|
`express_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '第三方快递信息',
|
`share_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '平台分佣',
|
`get_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '本单获取的积分',
|
`serial_number` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付号',
|
`pay_status` int NULL DEFAULT NULL COMMENT '1待支付2已支付',
|
`shop_id` int NULL DEFAULT NULL COMMENT '对应门店id',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_27
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_28
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_28`;
|
CREATE TABLE `t_order_28` (
|
`id` bigint NOT NULL,
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`order_type` int NULL DEFAULT NULL COMMENT '订单类型1服务单2商品',
|
`order_status` int NOT NULL COMMENT '1待发货2待收货3待使用4已完成5已取消6已退款7售后中',
|
`end_time` datetime(0) NULL DEFAULT NULL COMMENT '核销时间',
|
`technician_id` int NULL DEFAULT NULL COMMENT '技师id',
|
`order_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '订单编号',
|
`total_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '订单总金额',
|
`payment_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '实际支付价格',
|
`point` decimal(10, 2) NULL DEFAULT NULL COMMENT '使用积分',
|
`pay_method` int NULL DEFAULT NULL COMMENT '1wx2积分',
|
`coupon_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '使用的优惠劵json',
|
`express_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '运费',
|
`express_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '第三方快递信息',
|
`share_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '平台分佣',
|
`get_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '本单获取的积分',
|
`serial_number` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付号',
|
`pay_status` int NULL DEFAULT NULL COMMENT '1待支付2已支付',
|
`shop_id` int NULL DEFAULT NULL COMMENT '对应门店id',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_28
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_29
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_29`;
|
CREATE TABLE `t_order_29` (
|
`id` bigint NOT NULL,
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`order_type` int NULL DEFAULT NULL COMMENT '订单类型1服务单2商品',
|
`order_status` int NOT NULL COMMENT '1待发货2待收货3待使用4已完成5已取消6已退款7售后中',
|
`end_time` datetime(0) NULL DEFAULT NULL COMMENT '核销时间',
|
`technician_id` int NULL DEFAULT NULL COMMENT '技师id',
|
`order_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '订单编号',
|
`total_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '订单总金额',
|
`payment_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '实际支付价格',
|
`point` decimal(10, 2) NULL DEFAULT NULL COMMENT '使用积分',
|
`pay_method` int NULL DEFAULT NULL COMMENT '1wx2积分',
|
`coupon_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '使用的优惠劵json',
|
`express_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '运费',
|
`express_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '第三方快递信息',
|
`share_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '平台分佣',
|
`get_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '本单获取的积分',
|
`serial_number` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付号',
|
`pay_status` int NULL DEFAULT NULL COMMENT '1待支付2已支付',
|
`shop_id` int NULL DEFAULT NULL COMMENT '对应门店id',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_29
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_3
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_3`;
|
CREATE TABLE `t_order_3` (
|
`id` bigint NOT NULL,
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`order_type` int NULL DEFAULT NULL COMMENT '订单类型1服务单2商品',
|
`order_status` int NOT NULL COMMENT '1待发货2待收货3待使用4已完成5已取消6已退款7售后中',
|
`end_time` datetime(0) NULL DEFAULT NULL COMMENT '核销时间',
|
`technician_id` int NULL DEFAULT NULL COMMENT '技师id',
|
`order_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '订单编号',
|
`total_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '订单总金额',
|
`payment_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '实际支付价格',
|
`point` decimal(10, 2) NULL DEFAULT NULL COMMENT '使用积分',
|
`pay_method` int NULL DEFAULT NULL COMMENT '1wx2积分',
|
`coupon_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '使用的优惠劵json',
|
`express_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '运费',
|
`express_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '第三方快递信息',
|
`share_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '平台分佣',
|
`get_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '本单获取的积分',
|
`serial_number` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付号',
|
`pay_status` int NULL DEFAULT NULL COMMENT '1待支付2已支付',
|
`shop_id` int NULL DEFAULT NULL COMMENT '对应门店id',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_3
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_30
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_30`;
|
CREATE TABLE `t_order_30` (
|
`id` bigint NOT NULL,
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`order_type` int NULL DEFAULT NULL COMMENT '订单类型1服务单2商品',
|
`order_status` int NOT NULL COMMENT '1待发货2待收货3待使用4已完成5已取消6已退款7售后中',
|
`end_time` datetime(0) NULL DEFAULT NULL COMMENT '核销时间',
|
`technician_id` int NULL DEFAULT NULL COMMENT '技师id',
|
`order_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '订单编号',
|
`total_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '订单总金额',
|
`payment_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '实际支付价格',
|
`point` decimal(10, 2) NULL DEFAULT NULL COMMENT '使用积分',
|
`pay_method` int NULL DEFAULT NULL COMMENT '1wx2积分',
|
`coupon_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '使用的优惠劵json',
|
`express_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '运费',
|
`express_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '第三方快递信息',
|
`share_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '平台分佣',
|
`get_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '本单获取的积分',
|
`serial_number` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付号',
|
`pay_status` int NULL DEFAULT NULL COMMENT '1待支付2已支付',
|
`shop_id` int NULL DEFAULT NULL COMMENT '对应门店id',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_30
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_31
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_31`;
|
CREATE TABLE `t_order_31` (
|
`id` bigint NOT NULL,
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`order_type` int NULL DEFAULT NULL COMMENT '订单类型1服务单2商品',
|
`order_status` int NOT NULL COMMENT '1待发货2待收货3待使用4已完成5已取消6已退款7售后中',
|
`end_time` datetime(0) NULL DEFAULT NULL COMMENT '核销时间',
|
`technician_id` int NULL DEFAULT NULL COMMENT '技师id',
|
`order_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '订单编号',
|
`total_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '订单总金额',
|
`payment_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '实际支付价格',
|
`point` decimal(10, 2) NULL DEFAULT NULL COMMENT '使用积分',
|
`pay_method` int NULL DEFAULT NULL COMMENT '1wx2积分',
|
`coupon_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '使用的优惠劵json',
|
`express_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '运费',
|
`express_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '第三方快递信息',
|
`share_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '平台分佣',
|
`get_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '本单获取的积分',
|
`serial_number` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付号',
|
`pay_status` int NULL DEFAULT NULL COMMENT '1待支付2已支付',
|
`shop_id` int NULL DEFAULT NULL COMMENT '对应门店id',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_31
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_32
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_32`;
|
CREATE TABLE `t_order_32` (
|
`id` bigint NOT NULL,
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`order_type` int NULL DEFAULT NULL COMMENT '订单类型1服务单2商品',
|
`order_status` int NOT NULL COMMENT '1待发货2待收货3待使用4已完成5已取消6已退款7售后中',
|
`end_time` datetime(0) NULL DEFAULT NULL COMMENT '核销时间',
|
`technician_id` int NULL DEFAULT NULL COMMENT '技师id',
|
`order_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '订单编号',
|
`total_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '订单总金额',
|
`payment_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '实际支付价格',
|
`point` decimal(10, 2) NULL DEFAULT NULL COMMENT '使用积分',
|
`pay_method` int NULL DEFAULT NULL COMMENT '1wx2积分',
|
`coupon_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '使用的优惠劵json',
|
`express_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '运费',
|
`express_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '第三方快递信息',
|
`share_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '平台分佣',
|
`get_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '本单获取的积分',
|
`serial_number` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付号',
|
`pay_status` int NULL DEFAULT NULL COMMENT '1待支付2已支付',
|
`shop_id` int NULL DEFAULT NULL COMMENT '对应门店id',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_32
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_33
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_33`;
|
CREATE TABLE `t_order_33` (
|
`id` bigint NOT NULL,
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`order_type` int NULL DEFAULT NULL COMMENT '订单类型1服务单2商品',
|
`order_status` int NOT NULL COMMENT '1待发货2待收货3待使用4已完成5已取消6已退款7售后中',
|
`end_time` datetime(0) NULL DEFAULT NULL COMMENT '核销时间',
|
`technician_id` int NULL DEFAULT NULL COMMENT '技师id',
|
`order_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '订单编号',
|
`total_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '订单总金额',
|
`payment_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '实际支付价格',
|
`point` decimal(10, 2) NULL DEFAULT NULL COMMENT '使用积分',
|
`pay_method` int NULL DEFAULT NULL COMMENT '1wx2积分',
|
`coupon_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '使用的优惠劵json',
|
`express_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '运费',
|
`express_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '第三方快递信息',
|
`share_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '平台分佣',
|
`get_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '本单获取的积分',
|
`serial_number` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付号',
|
`pay_status` int NULL DEFAULT NULL COMMENT '1待支付2已支付',
|
`shop_id` int NULL DEFAULT NULL COMMENT '对应门店id',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_33
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_34
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_34`;
|
CREATE TABLE `t_order_34` (
|
`id` bigint NOT NULL,
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`order_type` int NULL DEFAULT NULL COMMENT '订单类型1服务单2商品',
|
`order_status` int NOT NULL COMMENT '1待发货2待收货3待使用4已完成5已取消6已退款7售后中',
|
`end_time` datetime(0) NULL DEFAULT NULL COMMENT '核销时间',
|
`technician_id` int NULL DEFAULT NULL COMMENT '技师id',
|
`order_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '订单编号',
|
`total_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '订单总金额',
|
`payment_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '实际支付价格',
|
`point` decimal(10, 2) NULL DEFAULT NULL COMMENT '使用积分',
|
`pay_method` int NULL DEFAULT NULL COMMENT '1wx2积分',
|
`coupon_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '使用的优惠劵json',
|
`express_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '运费',
|
`express_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '第三方快递信息',
|
`share_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '平台分佣',
|
`get_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '本单获取的积分',
|
`serial_number` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付号',
|
`pay_status` int NULL DEFAULT NULL COMMENT '1待支付2已支付',
|
`shop_id` int NULL DEFAULT NULL COMMENT '对应门店id',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_34
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_35
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_35`;
|
CREATE TABLE `t_order_35` (
|
`id` bigint NOT NULL,
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`order_type` int NULL DEFAULT NULL COMMENT '订单类型1服务单2商品',
|
`order_status` int NOT NULL COMMENT '1待发货2待收货3待使用4已完成5已取消6已退款7售后中',
|
`end_time` datetime(0) NULL DEFAULT NULL COMMENT '核销时间',
|
`technician_id` int NULL DEFAULT NULL COMMENT '技师id',
|
`order_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '订单编号',
|
`total_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '订单总金额',
|
`payment_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '实际支付价格',
|
`point` decimal(10, 2) NULL DEFAULT NULL COMMENT '使用积分',
|
`pay_method` int NULL DEFAULT NULL COMMENT '1wx2积分',
|
`coupon_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '使用的优惠劵json',
|
`express_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '运费',
|
`express_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '第三方快递信息',
|
`share_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '平台分佣',
|
`get_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '本单获取的积分',
|
`serial_number` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付号',
|
`pay_status` int NULL DEFAULT NULL COMMENT '1待支付2已支付',
|
`shop_id` int NULL DEFAULT NULL COMMENT '对应门店id',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_35
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_36
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_36`;
|
CREATE TABLE `t_order_36` (
|
`id` bigint NOT NULL,
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`order_type` int NULL DEFAULT NULL COMMENT '订单类型1服务单2商品',
|
`order_status` int NOT NULL COMMENT '1待发货2待收货3待使用4已完成5已取消6已退款7售后中',
|
`end_time` datetime(0) NULL DEFAULT NULL COMMENT '核销时间',
|
`technician_id` int NULL DEFAULT NULL COMMENT '技师id',
|
`order_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '订单编号',
|
`total_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '订单总金额',
|
`payment_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '实际支付价格',
|
`point` decimal(10, 2) NULL DEFAULT NULL COMMENT '使用积分',
|
`pay_method` int NULL DEFAULT NULL COMMENT '1wx2积分',
|
`coupon_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '使用的优惠劵json',
|
`express_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '运费',
|
`express_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '第三方快递信息',
|
`share_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '平台分佣',
|
`get_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '本单获取的积分',
|
`serial_number` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付号',
|
`pay_status` int NULL DEFAULT NULL COMMENT '1待支付2已支付',
|
`shop_id` int NULL DEFAULT NULL COMMENT '对应门店id',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_36
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_37
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_37`;
|
CREATE TABLE `t_order_37` (
|
`id` bigint NOT NULL,
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`order_type` int NULL DEFAULT NULL COMMENT '订单类型1服务单2商品',
|
`order_status` int NOT NULL COMMENT '1待发货2待收货3待使用4已完成5已取消6已退款7售后中',
|
`end_time` datetime(0) NULL DEFAULT NULL COMMENT '核销时间',
|
`technician_id` int NULL DEFAULT NULL COMMENT '技师id',
|
`order_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '订单编号',
|
`total_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '订单总金额',
|
`payment_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '实际支付价格',
|
`point` decimal(10, 2) NULL DEFAULT NULL COMMENT '使用积分',
|
`pay_method` int NULL DEFAULT NULL COMMENT '1wx2积分',
|
`coupon_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '使用的优惠劵json',
|
`express_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '运费',
|
`express_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '第三方快递信息',
|
`share_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '平台分佣',
|
`get_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '本单获取的积分',
|
`serial_number` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付号',
|
`pay_status` int NULL DEFAULT NULL COMMENT '1待支付2已支付',
|
`shop_id` int NULL DEFAULT NULL COMMENT '对应门店id',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_37
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_38
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_38`;
|
CREATE TABLE `t_order_38` (
|
`id` bigint NOT NULL,
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`order_type` int NULL DEFAULT NULL COMMENT '订单类型1服务单2商品',
|
`order_status` int NOT NULL COMMENT '1待发货2待收货3待使用4已完成5已取消6已退款7售后中',
|
`end_time` datetime(0) NULL DEFAULT NULL COMMENT '核销时间',
|
`technician_id` int NULL DEFAULT NULL COMMENT '技师id',
|
`order_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '订单编号',
|
`total_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '订单总金额',
|
`payment_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '实际支付价格',
|
`point` decimal(10, 2) NULL DEFAULT NULL COMMENT '使用积分',
|
`pay_method` int NULL DEFAULT NULL COMMENT '1wx2积分',
|
`coupon_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '使用的优惠劵json',
|
`express_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '运费',
|
`express_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '第三方快递信息',
|
`share_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '平台分佣',
|
`get_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '本单获取的积分',
|
`serial_number` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付号',
|
`pay_status` int NULL DEFAULT NULL COMMENT '1待支付2已支付',
|
`shop_id` int NULL DEFAULT NULL COMMENT '对应门店id',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_38
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_39
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_39`;
|
CREATE TABLE `t_order_39` (
|
`id` bigint NOT NULL,
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`order_type` int NULL DEFAULT NULL COMMENT '订单类型1服务单2商品',
|
`order_status` int NOT NULL COMMENT '1待发货2待收货3待使用4已完成5已取消6已退款7售后中',
|
`end_time` datetime(0) NULL DEFAULT NULL COMMENT '核销时间',
|
`technician_id` int NULL DEFAULT NULL COMMENT '技师id',
|
`order_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '订单编号',
|
`total_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '订单总金额',
|
`payment_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '实际支付价格',
|
`point` decimal(10, 2) NULL DEFAULT NULL COMMENT '使用积分',
|
`pay_method` int NULL DEFAULT NULL COMMENT '1wx2积分',
|
`coupon_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '使用的优惠劵json',
|
`express_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '运费',
|
`express_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '第三方快递信息',
|
`share_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '平台分佣',
|
`get_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '本单获取的积分',
|
`serial_number` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付号',
|
`pay_status` int NULL DEFAULT NULL COMMENT '1待支付2已支付',
|
`shop_id` int NULL DEFAULT NULL COMMENT '对应门店id',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_39
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_4
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_4`;
|
CREATE TABLE `t_order_4` (
|
`id` bigint NOT NULL,
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`order_type` int NULL DEFAULT NULL COMMENT '订单类型1服务单2商品',
|
`order_status` int NOT NULL COMMENT '1待发货2待收货3待使用4已完成5已取消6已退款7售后中',
|
`end_time` datetime(0) NULL DEFAULT NULL COMMENT '核销时间',
|
`technician_id` int NULL DEFAULT NULL COMMENT '技师id',
|
`order_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '订单编号',
|
`total_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '订单总金额',
|
`payment_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '实际支付价格',
|
`point` decimal(10, 2) NULL DEFAULT NULL COMMENT '使用积分',
|
`pay_method` int NULL DEFAULT NULL COMMENT '1wx2积分',
|
`coupon_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '使用的优惠劵json',
|
`express_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '运费',
|
`express_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '第三方快递信息',
|
`share_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '平台分佣',
|
`get_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '本单获取的积分',
|
`serial_number` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付号',
|
`pay_status` int NULL DEFAULT NULL COMMENT '1待支付2已支付',
|
`shop_id` int NULL DEFAULT NULL COMMENT '对应门店id',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_4
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_40
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_40`;
|
CREATE TABLE `t_order_40` (
|
`id` bigint NOT NULL,
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`order_type` int NULL DEFAULT NULL COMMENT '订单类型1服务单2商品',
|
`order_status` int NOT NULL COMMENT '1待发货2待收货3待使用4已完成5已取消6已退款7售后中',
|
`end_time` datetime(0) NULL DEFAULT NULL COMMENT '核销时间',
|
`technician_id` int NULL DEFAULT NULL COMMENT '技师id',
|
`order_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '订单编号',
|
`total_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '订单总金额',
|
`payment_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '实际支付价格',
|
`point` decimal(10, 2) NULL DEFAULT NULL COMMENT '使用积分',
|
`pay_method` int NULL DEFAULT NULL COMMENT '1wx2积分',
|
`coupon_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '使用的优惠劵json',
|
`express_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '运费',
|
`express_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '第三方快递信息',
|
`share_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '平台分佣',
|
`get_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '本单获取的积分',
|
`serial_number` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付号',
|
`pay_status` int NULL DEFAULT NULL COMMENT '1待支付2已支付',
|
`shop_id` int NULL DEFAULT NULL COMMENT '对应门店id',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_40
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_41
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_41`;
|
CREATE TABLE `t_order_41` (
|
`id` bigint NOT NULL,
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`order_type` int NULL DEFAULT NULL COMMENT '订单类型1服务单2商品',
|
`order_status` int NOT NULL COMMENT '1待发货2待收货3待使用4已完成5已取消6已退款7售后中',
|
`end_time` datetime(0) NULL DEFAULT NULL COMMENT '核销时间',
|
`technician_id` int NULL DEFAULT NULL COMMENT '技师id',
|
`order_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '订单编号',
|
`total_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '订单总金额',
|
`payment_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '实际支付价格',
|
`point` decimal(10, 2) NULL DEFAULT NULL COMMENT '使用积分',
|
`pay_method` int NULL DEFAULT NULL COMMENT '1wx2积分',
|
`coupon_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '使用的优惠劵json',
|
`express_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '运费',
|
`express_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '第三方快递信息',
|
`share_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '平台分佣',
|
`get_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '本单获取的积分',
|
`serial_number` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付号',
|
`pay_status` int NULL DEFAULT NULL COMMENT '1待支付2已支付',
|
`shop_id` int NULL DEFAULT NULL COMMENT '对应门店id',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_41
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_42
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_42`;
|
CREATE TABLE `t_order_42` (
|
`id` bigint NOT NULL,
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`order_type` int NULL DEFAULT NULL COMMENT '订单类型1服务单2商品',
|
`order_status` int NOT NULL COMMENT '1待发货2待收货3待使用4已完成5已取消6已退款7售后中',
|
`end_time` datetime(0) NULL DEFAULT NULL COMMENT '核销时间',
|
`technician_id` int NULL DEFAULT NULL COMMENT '技师id',
|
`order_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '订单编号',
|
`total_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '订单总金额',
|
`payment_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '实际支付价格',
|
`point` decimal(10, 2) NULL DEFAULT NULL COMMENT '使用积分',
|
`pay_method` int NULL DEFAULT NULL COMMENT '1wx2积分',
|
`coupon_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '使用的优惠劵json',
|
`express_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '运费',
|
`express_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '第三方快递信息',
|
`share_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '平台分佣',
|
`get_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '本单获取的积分',
|
`serial_number` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付号',
|
`pay_status` int NULL DEFAULT NULL COMMENT '1待支付2已支付',
|
`shop_id` int NULL DEFAULT NULL COMMENT '对应门店id',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_42
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_43
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_43`;
|
CREATE TABLE `t_order_43` (
|
`id` bigint NOT NULL,
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`order_type` int NULL DEFAULT NULL COMMENT '订单类型1服务单2商品',
|
`order_status` int NOT NULL COMMENT '1待发货2待收货3待使用4已完成5已取消6已退款7售后中',
|
`end_time` datetime(0) NULL DEFAULT NULL COMMENT '核销时间',
|
`technician_id` int NULL DEFAULT NULL COMMENT '技师id',
|
`order_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '订单编号',
|
`total_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '订单总金额',
|
`payment_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '实际支付价格',
|
`point` decimal(10, 2) NULL DEFAULT NULL COMMENT '使用积分',
|
`pay_method` int NULL DEFAULT NULL COMMENT '1wx2积分',
|
`coupon_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '使用的优惠劵json',
|
`express_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '运费',
|
`express_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '第三方快递信息',
|
`share_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '平台分佣',
|
`get_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '本单获取的积分',
|
`serial_number` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付号',
|
`pay_status` int NULL DEFAULT NULL COMMENT '1待支付2已支付',
|
`shop_id` int NULL DEFAULT NULL COMMENT '对应门店id',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_43
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_44
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_44`;
|
CREATE TABLE `t_order_44` (
|
`id` bigint NOT NULL,
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`order_type` int NULL DEFAULT NULL COMMENT '订单类型1服务单2商品',
|
`order_status` int NOT NULL COMMENT '1待发货2待收货3待使用4已完成5已取消6已退款7售后中',
|
`end_time` datetime(0) NULL DEFAULT NULL COMMENT '核销时间',
|
`technician_id` int NULL DEFAULT NULL COMMENT '技师id',
|
`order_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '订单编号',
|
`total_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '订单总金额',
|
`payment_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '实际支付价格',
|
`point` decimal(10, 2) NULL DEFAULT NULL COMMENT '使用积分',
|
`pay_method` int NULL DEFAULT NULL COMMENT '1wx2积分',
|
`coupon_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '使用的优惠劵json',
|
`express_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '运费',
|
`express_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '第三方快递信息',
|
`share_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '平台分佣',
|
`get_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '本单获取的积分',
|
`serial_number` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付号',
|
`pay_status` int NULL DEFAULT NULL COMMENT '1待支付2已支付',
|
`shop_id` int NULL DEFAULT NULL COMMENT '对应门店id',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_44
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_45
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_45`;
|
CREATE TABLE `t_order_45` (
|
`id` bigint NOT NULL,
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`order_type` int NULL DEFAULT NULL COMMENT '订单类型1服务单2商品',
|
`order_status` int NOT NULL COMMENT '1待发货2待收货3待使用4已完成5已取消6已退款7售后中',
|
`end_time` datetime(0) NULL DEFAULT NULL COMMENT '核销时间',
|
`technician_id` int NULL DEFAULT NULL COMMENT '技师id',
|
`order_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '订单编号',
|
`total_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '订单总金额',
|
`payment_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '实际支付价格',
|
`point` decimal(10, 2) NULL DEFAULT NULL COMMENT '使用积分',
|
`pay_method` int NULL DEFAULT NULL COMMENT '1wx2积分',
|
`coupon_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '使用的优惠劵json',
|
`express_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '运费',
|
`express_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '第三方快递信息',
|
`share_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '平台分佣',
|
`get_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '本单获取的积分',
|
`serial_number` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付号',
|
`pay_status` int NULL DEFAULT NULL COMMENT '1待支付2已支付',
|
`shop_id` int NULL DEFAULT NULL COMMENT '对应门店id',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_45
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_46
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_46`;
|
CREATE TABLE `t_order_46` (
|
`id` bigint NOT NULL,
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`order_type` int NULL DEFAULT NULL COMMENT '订单类型1服务单2商品',
|
`order_status` int NOT NULL COMMENT '1待发货2待收货3待使用4已完成5已取消6已退款7售后中',
|
`end_time` datetime(0) NULL DEFAULT NULL COMMENT '核销时间',
|
`technician_id` int NULL DEFAULT NULL COMMENT '技师id',
|
`order_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '订单编号',
|
`total_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '订单总金额',
|
`payment_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '实际支付价格',
|
`point` decimal(10, 2) NULL DEFAULT NULL COMMENT '使用积分',
|
`pay_method` int NULL DEFAULT NULL COMMENT '1wx2积分',
|
`coupon_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '使用的优惠劵json',
|
`express_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '运费',
|
`express_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '第三方快递信息',
|
`share_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '平台分佣',
|
`get_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '本单获取的积分',
|
`serial_number` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付号',
|
`pay_status` int NULL DEFAULT NULL COMMENT '1待支付2已支付',
|
`shop_id` int NULL DEFAULT NULL COMMENT '对应门店id',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_46
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_47
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_47`;
|
CREATE TABLE `t_order_47` (
|
`id` bigint NOT NULL,
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`order_type` int NULL DEFAULT NULL COMMENT '订单类型1服务单2商品',
|
`order_status` int NOT NULL COMMENT '1待发货2待收货3待使用4已完成5已取消6已退款7售后中',
|
`end_time` datetime(0) NULL DEFAULT NULL COMMENT '核销时间',
|
`technician_id` int NULL DEFAULT NULL COMMENT '技师id',
|
`order_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '订单编号',
|
`total_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '订单总金额',
|
`payment_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '实际支付价格',
|
`point` decimal(10, 2) NULL DEFAULT NULL COMMENT '使用积分',
|
`pay_method` int NULL DEFAULT NULL COMMENT '1wx2积分',
|
`coupon_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '使用的优惠劵json',
|
`express_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '运费',
|
`express_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '第三方快递信息',
|
`share_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '平台分佣',
|
`get_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '本单获取的积分',
|
`serial_number` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付号',
|
`pay_status` int NULL DEFAULT NULL COMMENT '1待支付2已支付',
|
`shop_id` int NULL DEFAULT NULL COMMENT '对应门店id',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_47
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_48
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_48`;
|
CREATE TABLE `t_order_48` (
|
`id` bigint NOT NULL,
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`order_type` int NULL DEFAULT NULL COMMENT '订单类型1服务单2商品',
|
`order_status` int NOT NULL COMMENT '1待发货2待收货3待使用4已完成5已取消6已退款7售后中',
|
`end_time` datetime(0) NULL DEFAULT NULL COMMENT '核销时间',
|
`technician_id` int NULL DEFAULT NULL COMMENT '技师id',
|
`order_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '订单编号',
|
`total_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '订单总金额',
|
`payment_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '实际支付价格',
|
`point` decimal(10, 2) NULL DEFAULT NULL COMMENT '使用积分',
|
`pay_method` int NULL DEFAULT NULL COMMENT '1wx2积分',
|
`coupon_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '使用的优惠劵json',
|
`express_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '运费',
|
`express_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '第三方快递信息',
|
`share_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '平台分佣',
|
`get_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '本单获取的积分',
|
`serial_number` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付号',
|
`pay_status` int NULL DEFAULT NULL COMMENT '1待支付2已支付',
|
`shop_id` int NULL DEFAULT NULL COMMENT '对应门店id',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_48
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_49
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_49`;
|
CREATE TABLE `t_order_49` (
|
`id` bigint NOT NULL,
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`order_type` int NULL DEFAULT NULL COMMENT '订单类型1服务单2商品',
|
`order_status` int NOT NULL COMMENT '1待发货2待收货3待使用4已完成5已取消6已退款7售后中',
|
`end_time` datetime(0) NULL DEFAULT NULL COMMENT '核销时间',
|
`technician_id` int NULL DEFAULT NULL COMMENT '技师id',
|
`order_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '订单编号',
|
`total_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '订单总金额',
|
`payment_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '实际支付价格',
|
`point` decimal(10, 2) NULL DEFAULT NULL COMMENT '使用积分',
|
`pay_method` int NULL DEFAULT NULL COMMENT '1wx2积分',
|
`coupon_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '使用的优惠劵json',
|
`express_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '运费',
|
`express_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '第三方快递信息',
|
`share_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '平台分佣',
|
`get_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '本单获取的积分',
|
`serial_number` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付号',
|
`pay_status` int NULL DEFAULT NULL COMMENT '1待支付2已支付',
|
`shop_id` int NULL DEFAULT NULL COMMENT '对应门店id',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_49
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_5
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_5`;
|
CREATE TABLE `t_order_5` (
|
`id` bigint NOT NULL,
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`order_type` int NULL DEFAULT NULL COMMENT '订单类型1服务单2商品',
|
`order_status` int NOT NULL COMMENT '1待发货2待收货3待使用4已完成5已取消6已退款7售后中',
|
`end_time` datetime(0) NULL DEFAULT NULL COMMENT '核销时间',
|
`technician_id` int NULL DEFAULT NULL COMMENT '技师id',
|
`order_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '订单编号',
|
`total_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '订单总金额',
|
`payment_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '实际支付价格',
|
`point` decimal(10, 2) NULL DEFAULT NULL COMMENT '使用积分',
|
`pay_method` int NULL DEFAULT NULL COMMENT '1wx2积分',
|
`coupon_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '使用的优惠劵json',
|
`express_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '运费',
|
`express_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '第三方快递信息',
|
`share_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '平台分佣',
|
`get_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '本单获取的积分',
|
`serial_number` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付号',
|
`pay_status` int NULL DEFAULT NULL COMMENT '1待支付2已支付',
|
`shop_id` int NULL DEFAULT NULL COMMENT '对应门店id',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_5
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_6
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_6`;
|
CREATE TABLE `t_order_6` (
|
`id` bigint NOT NULL,
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`order_type` int NULL DEFAULT NULL COMMENT '订单类型1服务单2商品',
|
`order_status` int NOT NULL COMMENT '1待发货2待收货3待使用4已完成5已取消6已退款7售后中',
|
`end_time` datetime(0) NULL DEFAULT NULL COMMENT '核销时间',
|
`technician_id` int NULL DEFAULT NULL COMMENT '技师id',
|
`order_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '订单编号',
|
`total_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '订单总金额',
|
`payment_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '实际支付价格',
|
`point` decimal(10, 2) NULL DEFAULT NULL COMMENT '使用积分',
|
`pay_method` int NULL DEFAULT NULL COMMENT '1wx2积分',
|
`coupon_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '使用的优惠劵json',
|
`express_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '运费',
|
`express_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '第三方快递信息',
|
`share_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '平台分佣',
|
`get_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '本单获取的积分',
|
`serial_number` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付号',
|
`pay_status` int NULL DEFAULT NULL COMMENT '1待支付2已支付',
|
`shop_id` int NULL DEFAULT NULL COMMENT '对应门店id',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_6
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_7
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_7`;
|
CREATE TABLE `t_order_7` (
|
`id` bigint NOT NULL,
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`order_type` int NULL DEFAULT NULL COMMENT '订单类型1服务单2商品',
|
`order_status` int NOT NULL COMMENT '1待发货2待收货3待使用4已完成5已取消6已退款7售后中',
|
`end_time` datetime(0) NULL DEFAULT NULL COMMENT '核销时间',
|
`technician_id` int NULL DEFAULT NULL COMMENT '技师id',
|
`order_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '订单编号',
|
`total_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '订单总金额',
|
`payment_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '实际支付价格',
|
`point` decimal(10, 2) NULL DEFAULT NULL COMMENT '使用积分',
|
`pay_method` int NULL DEFAULT NULL COMMENT '1wx2积分',
|
`coupon_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '使用的优惠劵json',
|
`express_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '运费',
|
`express_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '第三方快递信息',
|
`share_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '平台分佣',
|
`get_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '本单获取的积分',
|
`serial_number` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付号',
|
`pay_status` int NULL DEFAULT NULL COMMENT '1待支付2已支付',
|
`shop_id` int NULL DEFAULT NULL COMMENT '对应门店id',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_7
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_8
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_8`;
|
CREATE TABLE `t_order_8` (
|
`id` bigint NOT NULL,
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`order_type` int NULL DEFAULT NULL COMMENT '订单类型1服务单2商品',
|
`order_status` int NOT NULL COMMENT '1待发货2待收货3待使用4已完成5已取消6已退款7售后中',
|
`end_time` datetime(0) NULL DEFAULT NULL COMMENT '核销时间',
|
`technician_id` int NULL DEFAULT NULL COMMENT '技师id',
|
`order_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '订单编号',
|
`total_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '订单总金额',
|
`payment_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '实际支付价格',
|
`point` decimal(10, 2) NULL DEFAULT NULL COMMENT '使用积分',
|
`pay_method` int NULL DEFAULT NULL COMMENT '1wx2积分',
|
`coupon_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '使用的优惠劵json',
|
`express_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '运费',
|
`express_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '第三方快递信息',
|
`share_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '平台分佣',
|
`get_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '本单获取的积分',
|
`serial_number` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付号',
|
`pay_status` int NULL DEFAULT NULL COMMENT '1待支付2已支付',
|
`shop_id` int NULL DEFAULT NULL COMMENT '对应门店id',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_8
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_9
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_9`;
|
CREATE TABLE `t_order_9` (
|
`id` bigint NOT NULL,
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`order_type` int NULL DEFAULT NULL COMMENT '订单类型1服务单2商品',
|
`order_status` int NOT NULL COMMENT '1待发货2待收货3待使用4已完成5已取消6已退款7售后中',
|
`end_time` datetime(0) NULL DEFAULT NULL COMMENT '核销时间',
|
`technician_id` int NULL DEFAULT NULL COMMENT '技师id',
|
`order_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '订单编号',
|
`total_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '订单总金额',
|
`payment_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '实际支付价格',
|
`point` decimal(10, 2) NULL DEFAULT NULL COMMENT '使用积分',
|
`pay_method` int NULL DEFAULT NULL COMMENT '1wx2积分',
|
`coupon_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '使用的优惠劵json',
|
`express_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '运费',
|
`express_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '第三方快递信息',
|
`share_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '平台分佣',
|
`get_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '本单获取的积分',
|
`serial_number` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信支付号',
|
`pay_status` int NULL DEFAULT NULL COMMENT '1待支付2已支付',
|
`shop_id` int NULL DEFAULT NULL COMMENT '对应门店id',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_9
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_good_0
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_good_0`;
|
CREATE TABLE `t_order_good_0` (
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
`goods_id` bigint NULL DEFAULT NULL COMMENT '商品id',
|
`order_id` int NULL DEFAULT NULL COMMENT '订单id',
|
`good_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '购买商品的json快照',
|
`num` int NULL DEFAULT NULL COMMENT '数量',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表—关联商品信息' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_good_0
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_good_1
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_good_1`;
|
CREATE TABLE `t_order_good_1` (
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
`goods_id` bigint NULL DEFAULT NULL COMMENT '商品id',
|
`order_id` int NULL DEFAULT NULL COMMENT '订单id',
|
`good_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '购买商品的json快照',
|
`num` int NULL DEFAULT NULL COMMENT '数量',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表—关联商品信息' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_good_1
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_good_10
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_good_10`;
|
CREATE TABLE `t_order_good_10` (
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
`goods_id` bigint NULL DEFAULT NULL COMMENT '商品id',
|
`order_id` int NULL DEFAULT NULL COMMENT '订单id',
|
`good_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '购买商品的json快照',
|
`num` int NULL DEFAULT NULL COMMENT '数量',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表—关联商品信息' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_good_10
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_good_11
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_good_11`;
|
CREATE TABLE `t_order_good_11` (
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
`goods_id` bigint NULL DEFAULT NULL COMMENT '商品id',
|
`order_id` int NULL DEFAULT NULL COMMENT '订单id',
|
`good_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '购买商品的json快照',
|
`num` int NULL DEFAULT NULL COMMENT '数量',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表—关联商品信息' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_good_11
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_good_12
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_good_12`;
|
CREATE TABLE `t_order_good_12` (
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
`goods_id` bigint NULL DEFAULT NULL COMMENT '商品id',
|
`order_id` int NULL DEFAULT NULL COMMENT '订单id',
|
`good_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '购买商品的json快照',
|
`num` int NULL DEFAULT NULL COMMENT '数量',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表—关联商品信息' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_good_12
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_good_13
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_good_13`;
|
CREATE TABLE `t_order_good_13` (
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
`goods_id` bigint NULL DEFAULT NULL COMMENT '商品id',
|
`order_id` int NULL DEFAULT NULL COMMENT '订单id',
|
`good_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '购买商品的json快照',
|
`num` int NULL DEFAULT NULL COMMENT '数量',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表—关联商品信息' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_good_13
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_good_14
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_good_14`;
|
CREATE TABLE `t_order_good_14` (
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
`goods_id` bigint NULL DEFAULT NULL COMMENT '商品id',
|
`order_id` int NULL DEFAULT NULL COMMENT '订单id',
|
`good_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '购买商品的json快照',
|
`num` int NULL DEFAULT NULL COMMENT '数量',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表—关联商品信息' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_good_14
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_good_15
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_good_15`;
|
CREATE TABLE `t_order_good_15` (
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
`goods_id` bigint NULL DEFAULT NULL COMMENT '商品id',
|
`order_id` int NULL DEFAULT NULL COMMENT '订单id',
|
`good_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '购买商品的json快照',
|
`num` int NULL DEFAULT NULL COMMENT '数量',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表—关联商品信息' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_good_15
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_good_16
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_good_16`;
|
CREATE TABLE `t_order_good_16` (
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
`goods_id` bigint NULL DEFAULT NULL COMMENT '商品id',
|
`order_id` int NULL DEFAULT NULL COMMENT '订单id',
|
`good_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '购买商品的json快照',
|
`num` int NULL DEFAULT NULL COMMENT '数量',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表—关联商品信息' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_good_16
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_good_17
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_good_17`;
|
CREATE TABLE `t_order_good_17` (
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
`goods_id` bigint NULL DEFAULT NULL COMMENT '商品id',
|
`order_id` int NULL DEFAULT NULL COMMENT '订单id',
|
`good_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '购买商品的json快照',
|
`num` int NULL DEFAULT NULL COMMENT '数量',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表—关联商品信息' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_good_17
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_good_18
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_good_18`;
|
CREATE TABLE `t_order_good_18` (
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
`goods_id` bigint NULL DEFAULT NULL COMMENT '商品id',
|
`order_id` int NULL DEFAULT NULL COMMENT '订单id',
|
`good_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '购买商品的json快照',
|
`num` int NULL DEFAULT NULL COMMENT '数量',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表—关联商品信息' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_good_18
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_good_19
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_good_19`;
|
CREATE TABLE `t_order_good_19` (
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
`goods_id` bigint NULL DEFAULT NULL COMMENT '商品id',
|
`order_id` int NULL DEFAULT NULL COMMENT '订单id',
|
`good_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '购买商品的json快照',
|
`num` int NULL DEFAULT NULL COMMENT '数量',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表—关联商品信息' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_good_19
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_good_2
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_good_2`;
|
CREATE TABLE `t_order_good_2` (
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
`goods_id` bigint NULL DEFAULT NULL COMMENT '商品id',
|
`order_id` int NULL DEFAULT NULL COMMENT '订单id',
|
`good_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '购买商品的json快照',
|
`num` int NULL DEFAULT NULL COMMENT '数量',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表—关联商品信息' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_good_2
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_good_20
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_good_20`;
|
CREATE TABLE `t_order_good_20` (
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
`goods_id` bigint NULL DEFAULT NULL COMMENT '商品id',
|
`order_id` int NULL DEFAULT NULL COMMENT '订单id',
|
`good_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '购买商品的json快照',
|
`num` int NULL DEFAULT NULL COMMENT '数量',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表—关联商品信息' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_good_20
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_good_21
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_good_21`;
|
CREATE TABLE `t_order_good_21` (
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
`goods_id` bigint NULL DEFAULT NULL COMMENT '商品id',
|
`order_id` int NULL DEFAULT NULL COMMENT '订单id',
|
`good_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '购买商品的json快照',
|
`num` int NULL DEFAULT NULL COMMENT '数量',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表—关联商品信息' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_good_21
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_good_22
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_good_22`;
|
CREATE TABLE `t_order_good_22` (
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
`goods_id` bigint NULL DEFAULT NULL COMMENT '商品id',
|
`order_id` int NULL DEFAULT NULL COMMENT '订单id',
|
`good_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '购买商品的json快照',
|
`num` int NULL DEFAULT NULL COMMENT '数量',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表—关联商品信息' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_good_22
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_good_23
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_good_23`;
|
CREATE TABLE `t_order_good_23` (
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
`goods_id` bigint NULL DEFAULT NULL COMMENT '商品id',
|
`order_id` int NULL DEFAULT NULL COMMENT '订单id',
|
`good_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '购买商品的json快照',
|
`num` int NULL DEFAULT NULL COMMENT '数量',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表—关联商品信息' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_good_23
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_good_24
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_good_24`;
|
CREATE TABLE `t_order_good_24` (
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
`goods_id` bigint NULL DEFAULT NULL COMMENT '商品id',
|
`order_id` int NULL DEFAULT NULL COMMENT '订单id',
|
`good_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '购买商品的json快照',
|
`num` int NULL DEFAULT NULL COMMENT '数量',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表—关联商品信息' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_good_24
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_good_25
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_good_25`;
|
CREATE TABLE `t_order_good_25` (
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
`goods_id` bigint NULL DEFAULT NULL COMMENT '商品id',
|
`order_id` int NULL DEFAULT NULL COMMENT '订单id',
|
`good_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '购买商品的json快照',
|
`num` int NULL DEFAULT NULL COMMENT '数量',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表—关联商品信息' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_good_25
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_good_26
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_good_26`;
|
CREATE TABLE `t_order_good_26` (
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
`goods_id` bigint NULL DEFAULT NULL COMMENT '商品id',
|
`order_id` int NULL DEFAULT NULL COMMENT '订单id',
|
`good_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '购买商品的json快照',
|
`num` int NULL DEFAULT NULL COMMENT '数量',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表—关联商品信息' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_good_26
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_good_27
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_good_27`;
|
CREATE TABLE `t_order_good_27` (
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
`goods_id` bigint NULL DEFAULT NULL COMMENT '商品id',
|
`order_id` int NULL DEFAULT NULL COMMENT '订单id',
|
`good_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '购买商品的json快照',
|
`num` int NULL DEFAULT NULL COMMENT '数量',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表—关联商品信息' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_good_27
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_good_28
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_good_28`;
|
CREATE TABLE `t_order_good_28` (
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
`goods_id` bigint NULL DEFAULT NULL COMMENT '商品id',
|
`order_id` int NULL DEFAULT NULL COMMENT '订单id',
|
`good_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '购买商品的json快照',
|
`num` int NULL DEFAULT NULL COMMENT '数量',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表—关联商品信息' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_good_28
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_good_29
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_good_29`;
|
CREATE TABLE `t_order_good_29` (
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
`goods_id` bigint NULL DEFAULT NULL COMMENT '商品id',
|
`order_id` int NULL DEFAULT NULL COMMENT '订单id',
|
`good_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '购买商品的json快照',
|
`num` int NULL DEFAULT NULL COMMENT '数量',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表—关联商品信息' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_good_29
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_good_3
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_good_3`;
|
CREATE TABLE `t_order_good_3` (
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
`goods_id` bigint NULL DEFAULT NULL COMMENT '商品id',
|
`order_id` int NULL DEFAULT NULL COMMENT '订单id',
|
`good_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '购买商品的json快照',
|
`num` int NULL DEFAULT NULL COMMENT '数量',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表—关联商品信息' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_good_3
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_good_30
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_good_30`;
|
CREATE TABLE `t_order_good_30` (
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
`goods_id` bigint NULL DEFAULT NULL COMMENT '商品id',
|
`order_id` int NULL DEFAULT NULL COMMENT '订单id',
|
`good_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '购买商品的json快照',
|
`num` int NULL DEFAULT NULL COMMENT '数量',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表—关联商品信息' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_good_30
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_good_31
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_good_31`;
|
CREATE TABLE `t_order_good_31` (
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
`goods_id` bigint NULL DEFAULT NULL COMMENT '商品id',
|
`order_id` int NULL DEFAULT NULL COMMENT '订单id',
|
`good_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '购买商品的json快照',
|
`num` int NULL DEFAULT NULL COMMENT '数量',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表—关联商品信息' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_good_31
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_good_32
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_good_32`;
|
CREATE TABLE `t_order_good_32` (
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
`goods_id` bigint NULL DEFAULT NULL COMMENT '商品id',
|
`order_id` int NULL DEFAULT NULL COMMENT '订单id',
|
`good_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '购买商品的json快照',
|
`num` int NULL DEFAULT NULL COMMENT '数量',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表—关联商品信息' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_good_32
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_good_33
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_good_33`;
|
CREATE TABLE `t_order_good_33` (
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
`goods_id` bigint NULL DEFAULT NULL COMMENT '商品id',
|
`order_id` int NULL DEFAULT NULL COMMENT '订单id',
|
`good_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '购买商品的json快照',
|
`num` int NULL DEFAULT NULL COMMENT '数量',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表—关联商品信息' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_good_33
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_good_34
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_good_34`;
|
CREATE TABLE `t_order_good_34` (
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
`goods_id` bigint NULL DEFAULT NULL COMMENT '商品id',
|
`order_id` int NULL DEFAULT NULL COMMENT '订单id',
|
`good_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '购买商品的json快照',
|
`num` int NULL DEFAULT NULL COMMENT '数量',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表—关联商品信息' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_good_34
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_good_35
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_good_35`;
|
CREATE TABLE `t_order_good_35` (
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
`goods_id` bigint NULL DEFAULT NULL COMMENT '商品id',
|
`order_id` int NULL DEFAULT NULL COMMENT '订单id',
|
`good_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '购买商品的json快照',
|
`num` int NULL DEFAULT NULL COMMENT '数量',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表—关联商品信息' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_good_35
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_good_36
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_good_36`;
|
CREATE TABLE `t_order_good_36` (
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
`goods_id` bigint NULL DEFAULT NULL COMMENT '商品id',
|
`order_id` int NULL DEFAULT NULL COMMENT '订单id',
|
`good_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '购买商品的json快照',
|
`num` int NULL DEFAULT NULL COMMENT '数量',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表—关联商品信息' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_good_36
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_good_37
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_good_37`;
|
CREATE TABLE `t_order_good_37` (
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
`goods_id` bigint NULL DEFAULT NULL COMMENT '商品id',
|
`order_id` int NULL DEFAULT NULL COMMENT '订单id',
|
`good_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '购买商品的json快照',
|
`num` int NULL DEFAULT NULL COMMENT '数量',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表—关联商品信息' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_good_37
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_good_38
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_good_38`;
|
CREATE TABLE `t_order_good_38` (
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
`goods_id` bigint NULL DEFAULT NULL COMMENT '商品id',
|
`order_id` int NULL DEFAULT NULL COMMENT '订单id',
|
`good_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '购买商品的json快照',
|
`num` int NULL DEFAULT NULL COMMENT '数量',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表—关联商品信息' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_good_38
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_good_39
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_good_39`;
|
CREATE TABLE `t_order_good_39` (
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
`goods_id` bigint NULL DEFAULT NULL COMMENT '商品id',
|
`order_id` int NULL DEFAULT NULL COMMENT '订单id',
|
`good_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '购买商品的json快照',
|
`num` int NULL DEFAULT NULL COMMENT '数量',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表—关联商品信息' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_good_39
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_good_4
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_good_4`;
|
CREATE TABLE `t_order_good_4` (
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
`goods_id` bigint NULL DEFAULT NULL COMMENT '商品id',
|
`order_id` int NULL DEFAULT NULL COMMENT '订单id',
|
`good_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '购买商品的json快照',
|
`num` int NULL DEFAULT NULL COMMENT '数量',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表—关联商品信息' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_good_4
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_good_40
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_good_40`;
|
CREATE TABLE `t_order_good_40` (
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
`goods_id` bigint NULL DEFAULT NULL COMMENT '商品id',
|
`order_id` int NULL DEFAULT NULL COMMENT '订单id',
|
`good_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '购买商品的json快照',
|
`num` int NULL DEFAULT NULL COMMENT '数量',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表—关联商品信息' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_good_40
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_good_41
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_good_41`;
|
CREATE TABLE `t_order_good_41` (
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
`goods_id` bigint NULL DEFAULT NULL COMMENT '商品id',
|
`order_id` int NULL DEFAULT NULL COMMENT '订单id',
|
`good_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '购买商品的json快照',
|
`num` int NULL DEFAULT NULL COMMENT '数量',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表—关联商品信息' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_good_41
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_good_42
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_good_42`;
|
CREATE TABLE `t_order_good_42` (
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
`goods_id` bigint NULL DEFAULT NULL COMMENT '商品id',
|
`order_id` int NULL DEFAULT NULL COMMENT '订单id',
|
`good_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '购买商品的json快照',
|
`num` int NULL DEFAULT NULL COMMENT '数量',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表—关联商品信息' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_good_42
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_good_43
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_good_43`;
|
CREATE TABLE `t_order_good_43` (
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
`goods_id` bigint NULL DEFAULT NULL COMMENT '商品id',
|
`order_id` int NULL DEFAULT NULL COMMENT '订单id',
|
`good_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '购买商品的json快照',
|
`num` int NULL DEFAULT NULL COMMENT '数量',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表—关联商品信息' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_good_43
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_good_44
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_good_44`;
|
CREATE TABLE `t_order_good_44` (
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
`goods_id` bigint NULL DEFAULT NULL COMMENT '商品id',
|
`order_id` int NULL DEFAULT NULL COMMENT '订单id',
|
`good_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '购买商品的json快照',
|
`num` int NULL DEFAULT NULL COMMENT '数量',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表—关联商品信息' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_good_44
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_good_45
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_good_45`;
|
CREATE TABLE `t_order_good_45` (
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
`goods_id` bigint NULL DEFAULT NULL COMMENT '商品id',
|
`order_id` int NULL DEFAULT NULL COMMENT '订单id',
|
`good_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '购买商品的json快照',
|
`num` int NULL DEFAULT NULL COMMENT '数量',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表—关联商品信息' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_good_45
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_good_46
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_good_46`;
|
CREATE TABLE `t_order_good_46` (
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
`goods_id` bigint NULL DEFAULT NULL COMMENT '商品id',
|
`order_id` int NULL DEFAULT NULL COMMENT '订单id',
|
`good_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '购买商品的json快照',
|
`num` int NULL DEFAULT NULL COMMENT '数量',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表—关联商品信息' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_good_46
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_good_47
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_good_47`;
|
CREATE TABLE `t_order_good_47` (
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
`goods_id` bigint NULL DEFAULT NULL COMMENT '商品id',
|
`order_id` int NULL DEFAULT NULL COMMENT '订单id',
|
`good_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '购买商品的json快照',
|
`num` int NULL DEFAULT NULL COMMENT '数量',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表—关联商品信息' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_good_47
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_good_48
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_good_48`;
|
CREATE TABLE `t_order_good_48` (
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
`goods_id` bigint NULL DEFAULT NULL COMMENT '商品id',
|
`order_id` int NULL DEFAULT NULL COMMENT '订单id',
|
`good_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '购买商品的json快照',
|
`num` int NULL DEFAULT NULL COMMENT '数量',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表—关联商品信息' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_good_48
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_good_49
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_good_49`;
|
CREATE TABLE `t_order_good_49` (
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
`goods_id` bigint NULL DEFAULT NULL COMMENT '商品id',
|
`order_id` int NULL DEFAULT NULL COMMENT '订单id',
|
`good_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '购买商品的json快照',
|
`num` int NULL DEFAULT NULL COMMENT '数量',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表—关联商品信息' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_good_49
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_good_5
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_good_5`;
|
CREATE TABLE `t_order_good_5` (
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
`goods_id` bigint NULL DEFAULT NULL COMMENT '商品id',
|
`order_id` int NULL DEFAULT NULL COMMENT '订单id',
|
`good_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '购买商品的json快照',
|
`num` int NULL DEFAULT NULL COMMENT '数量',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表—关联商品信息' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_good_5
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_good_6
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_good_6`;
|
CREATE TABLE `t_order_good_6` (
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
`goods_id` bigint NULL DEFAULT NULL COMMENT '商品id',
|
`order_id` int NULL DEFAULT NULL COMMENT '订单id',
|
`good_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '购买商品的json快照',
|
`num` int NULL DEFAULT NULL COMMENT '数量',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表—关联商品信息' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_good_6
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_good_7
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_good_7`;
|
CREATE TABLE `t_order_good_7` (
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
`goods_id` bigint NULL DEFAULT NULL COMMENT '商品id',
|
`order_id` int NULL DEFAULT NULL COMMENT '订单id',
|
`good_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '购买商品的json快照',
|
`num` int NULL DEFAULT NULL COMMENT '数量',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表—关联商品信息' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_good_7
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_good_8
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_good_8`;
|
CREATE TABLE `t_order_good_8` (
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
`goods_id` bigint NULL DEFAULT NULL COMMENT '商品id',
|
`order_id` int NULL DEFAULT NULL COMMENT '订单id',
|
`good_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '购买商品的json快照',
|
`num` int NULL DEFAULT NULL COMMENT '数量',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表—关联商品信息' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_good_8
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_order_good_9
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order_good_9`;
|
CREATE TABLE `t_order_good_9` (
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
`goods_id` bigint NULL DEFAULT NULL COMMENT '商品id',
|
`order_id` int NULL DEFAULT NULL COMMENT '订单id',
|
`good_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '购买商品的json快照',
|
`num` int NULL DEFAULT NULL COMMENT '数量',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单表—关联商品信息' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_order_good_9
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_refund_pass_0
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_refund_pass_0`;
|
CREATE TABLE `t_refund_pass_0` (
|
`id` bigint NOT NULL,
|
`order_id` bigint NULL DEFAULT NULL COMMENT '订单id',
|
`status` int NULL DEFAULT NULL COMMENT '1待审核2已完成3已拒绝4待退货5待平台收货',
|
`refund_method` int NULL DEFAULT NULL COMMENT '1退货退款2仅退款',
|
`refund_reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '用户申请原因',
|
`user_remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '用户申请备注',
|
`pics` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '申请图片',
|
`pass_status` int NULL DEFAULT NULL COMMENT '1待审核2同意3拒绝',
|
`pass_remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '后台审核备注',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '售后管理' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_refund_pass_0
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_refund_pass_1
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_refund_pass_1`;
|
CREATE TABLE `t_refund_pass_1` (
|
`id` bigint NOT NULL,
|
`order_id` bigint NULL DEFAULT NULL COMMENT '订单id',
|
`status` int NULL DEFAULT NULL COMMENT '1待审核2已完成3已拒绝4待退货5待平台收货',
|
`refund_method` int NULL DEFAULT NULL COMMENT '1退货退款2仅退款',
|
`refund_reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '用户申请原因',
|
`user_remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '用户申请备注',
|
`pics` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '申请图片',
|
`pass_status` int NULL DEFAULT NULL COMMENT '1待审核2同意3拒绝',
|
`pass_remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '后台审核备注',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '售后管理' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_refund_pass_1
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_refund_pass_10
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_refund_pass_10`;
|
CREATE TABLE `t_refund_pass_10` (
|
`id` bigint NOT NULL,
|
`order_id` bigint NULL DEFAULT NULL COMMENT '订单id',
|
`status` int NULL DEFAULT NULL COMMENT '1待审核2已完成3已拒绝4待退货5待平台收货',
|
`refund_method` int NULL DEFAULT NULL COMMENT '1退货退款2仅退款',
|
`refund_reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '用户申请原因',
|
`user_remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '用户申请备注',
|
`pics` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '申请图片',
|
`pass_status` int NULL DEFAULT NULL COMMENT '1待审核2同意3拒绝',
|
`pass_remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '后台审核备注',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '售后管理' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_refund_pass_10
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_refund_pass_11
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_refund_pass_11`;
|
CREATE TABLE `t_refund_pass_11` (
|
`id` bigint NOT NULL,
|
`order_id` bigint NULL DEFAULT NULL COMMENT '订单id',
|
`status` int NULL DEFAULT NULL COMMENT '1待审核2已完成3已拒绝4待退货5待平台收货',
|
`refund_method` int NULL DEFAULT NULL COMMENT '1退货退款2仅退款',
|
`refund_reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '用户申请原因',
|
`user_remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '用户申请备注',
|
`pics` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '申请图片',
|
`pass_status` int NULL DEFAULT NULL COMMENT '1待审核2同意3拒绝',
|
`pass_remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '后台审核备注',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '售后管理' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_refund_pass_11
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_refund_pass_12
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_refund_pass_12`;
|
CREATE TABLE `t_refund_pass_12` (
|
`id` bigint NOT NULL,
|
`order_id` bigint NULL DEFAULT NULL COMMENT '订单id',
|
`status` int NULL DEFAULT NULL COMMENT '1待审核2已完成3已拒绝4待退货5待平台收货',
|
`refund_method` int NULL DEFAULT NULL COMMENT '1退货退款2仅退款',
|
`refund_reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '用户申请原因',
|
`user_remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '用户申请备注',
|
`pics` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '申请图片',
|
`pass_status` int NULL DEFAULT NULL COMMENT '1待审核2同意3拒绝',
|
`pass_remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '后台审核备注',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '售后管理' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_refund_pass_12
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_refund_pass_13
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_refund_pass_13`;
|
CREATE TABLE `t_refund_pass_13` (
|
`id` bigint NOT NULL,
|
`order_id` bigint NULL DEFAULT NULL COMMENT '订单id',
|
`status` int NULL DEFAULT NULL COMMENT '1待审核2已完成3已拒绝4待退货5待平台收货',
|
`refund_method` int NULL DEFAULT NULL COMMENT '1退货退款2仅退款',
|
`refund_reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '用户申请原因',
|
`user_remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '用户申请备注',
|
`pics` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '申请图片',
|
`pass_status` int NULL DEFAULT NULL COMMENT '1待审核2同意3拒绝',
|
`pass_remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '后台审核备注',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '售后管理' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_refund_pass_13
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_refund_pass_14
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_refund_pass_14`;
|
CREATE TABLE `t_refund_pass_14` (
|
`id` bigint NOT NULL,
|
`order_id` bigint NULL DEFAULT NULL COMMENT '订单id',
|
`status` int NULL DEFAULT NULL COMMENT '1待审核2已完成3已拒绝4待退货5待平台收货',
|
`refund_method` int NULL DEFAULT NULL COMMENT '1退货退款2仅退款',
|
`refund_reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '用户申请原因',
|
`user_remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '用户申请备注',
|
`pics` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '申请图片',
|
`pass_status` int NULL DEFAULT NULL COMMENT '1待审核2同意3拒绝',
|
`pass_remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '后台审核备注',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '售后管理' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_refund_pass_14
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_refund_pass_15
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_refund_pass_15`;
|
CREATE TABLE `t_refund_pass_15` (
|
`id` bigint NOT NULL,
|
`order_id` bigint NULL DEFAULT NULL COMMENT '订单id',
|
`status` int NULL DEFAULT NULL COMMENT '1待审核2已完成3已拒绝4待退货5待平台收货',
|
`refund_method` int NULL DEFAULT NULL COMMENT '1退货退款2仅退款',
|
`refund_reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '用户申请原因',
|
`user_remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '用户申请备注',
|
`pics` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '申请图片',
|
`pass_status` int NULL DEFAULT NULL COMMENT '1待审核2同意3拒绝',
|
`pass_remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '后台审核备注',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '售后管理' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_refund_pass_15
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_refund_pass_16
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_refund_pass_16`;
|
CREATE TABLE `t_refund_pass_16` (
|
`id` bigint NOT NULL,
|
`order_id` bigint NULL DEFAULT NULL COMMENT '订单id',
|
`status` int NULL DEFAULT NULL COMMENT '1待审核2已完成3已拒绝4待退货5待平台收货',
|
`refund_method` int NULL DEFAULT NULL COMMENT '1退货退款2仅退款',
|
`refund_reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '用户申请原因',
|
`user_remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '用户申请备注',
|
`pics` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '申请图片',
|
`pass_status` int NULL DEFAULT NULL COMMENT '1待审核2同意3拒绝',
|
`pass_remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '后台审核备注',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '售后管理' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_refund_pass_16
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_refund_pass_17
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_refund_pass_17`;
|
CREATE TABLE `t_refund_pass_17` (
|
`id` bigint NOT NULL,
|
`order_id` bigint NULL DEFAULT NULL COMMENT '订单id',
|
`status` int NULL DEFAULT NULL COMMENT '1待审核2已完成3已拒绝4待退货5待平台收货',
|
`refund_method` int NULL DEFAULT NULL COMMENT '1退货退款2仅退款',
|
`refund_reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '用户申请原因',
|
`user_remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '用户申请备注',
|
`pics` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '申请图片',
|
`pass_status` int NULL DEFAULT NULL COMMENT '1待审核2同意3拒绝',
|
`pass_remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '后台审核备注',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '售后管理' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_refund_pass_17
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_refund_pass_18
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_refund_pass_18`;
|
CREATE TABLE `t_refund_pass_18` (
|
`id` bigint NOT NULL,
|
`order_id` bigint NULL DEFAULT NULL COMMENT '订单id',
|
`status` int NULL DEFAULT NULL COMMENT '1待审核2已完成3已拒绝4待退货5待平台收货',
|
`refund_method` int NULL DEFAULT NULL COMMENT '1退货退款2仅退款',
|
`refund_reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '用户申请原因',
|
`user_remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '用户申请备注',
|
`pics` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '申请图片',
|
`pass_status` int NULL DEFAULT NULL COMMENT '1待审核2同意3拒绝',
|
`pass_remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '后台审核备注',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '售后管理' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_refund_pass_18
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_refund_pass_19
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_refund_pass_19`;
|
CREATE TABLE `t_refund_pass_19` (
|
`id` bigint NOT NULL,
|
`order_id` bigint NULL DEFAULT NULL COMMENT '订单id',
|
`status` int NULL DEFAULT NULL COMMENT '1待审核2已完成3已拒绝4待退货5待平台收货',
|
`refund_method` int NULL DEFAULT NULL COMMENT '1退货退款2仅退款',
|
`refund_reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '用户申请原因',
|
`user_remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '用户申请备注',
|
`pics` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '申请图片',
|
`pass_status` int NULL DEFAULT NULL COMMENT '1待审核2同意3拒绝',
|
`pass_remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '后台审核备注',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '售后管理' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_refund_pass_19
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_refund_pass_2
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_refund_pass_2`;
|
CREATE TABLE `t_refund_pass_2` (
|
`id` bigint NOT NULL,
|
`order_id` bigint NULL DEFAULT NULL COMMENT '订单id',
|
`status` int NULL DEFAULT NULL COMMENT '1待审核2已完成3已拒绝4待退货5待平台收货',
|
`refund_method` int NULL DEFAULT NULL COMMENT '1退货退款2仅退款',
|
`refund_reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '用户申请原因',
|
`user_remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '用户申请备注',
|
`pics` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '申请图片',
|
`pass_status` int NULL DEFAULT NULL COMMENT '1待审核2同意3拒绝',
|
`pass_remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '后台审核备注',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '售后管理' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_refund_pass_2
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_refund_pass_3
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_refund_pass_3`;
|
CREATE TABLE `t_refund_pass_3` (
|
`id` bigint NOT NULL,
|
`order_id` bigint NULL DEFAULT NULL COMMENT '订单id',
|
`status` int NULL DEFAULT NULL COMMENT '1待审核2已完成3已拒绝4待退货5待平台收货',
|
`refund_method` int NULL DEFAULT NULL COMMENT '1退货退款2仅退款',
|
`refund_reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '用户申请原因',
|
`user_remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '用户申请备注',
|
`pics` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '申请图片',
|
`pass_status` int NULL DEFAULT NULL COMMENT '1待审核2同意3拒绝',
|
`pass_remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '后台审核备注',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '售后管理' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_refund_pass_3
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_refund_pass_4
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_refund_pass_4`;
|
CREATE TABLE `t_refund_pass_4` (
|
`id` bigint NOT NULL,
|
`order_id` bigint NULL DEFAULT NULL COMMENT '订单id',
|
`status` int NULL DEFAULT NULL COMMENT '1待审核2已完成3已拒绝4待退货5待平台收货',
|
`refund_method` int NULL DEFAULT NULL COMMENT '1退货退款2仅退款',
|
`refund_reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '用户申请原因',
|
`user_remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '用户申请备注',
|
`pics` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '申请图片',
|
`pass_status` int NULL DEFAULT NULL COMMENT '1待审核2同意3拒绝',
|
`pass_remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '后台审核备注',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '售后管理' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_refund_pass_4
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_refund_pass_5
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_refund_pass_5`;
|
CREATE TABLE `t_refund_pass_5` (
|
`id` bigint NOT NULL,
|
`order_id` bigint NULL DEFAULT NULL COMMENT '订单id',
|
`status` int NULL DEFAULT NULL COMMENT '1待审核2已完成3已拒绝4待退货5待平台收货',
|
`refund_method` int NULL DEFAULT NULL COMMENT '1退货退款2仅退款',
|
`refund_reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '用户申请原因',
|
`user_remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '用户申请备注',
|
`pics` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '申请图片',
|
`pass_status` int NULL DEFAULT NULL COMMENT '1待审核2同意3拒绝',
|
`pass_remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '后台审核备注',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '售后管理' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_refund_pass_5
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_refund_pass_6
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_refund_pass_6`;
|
CREATE TABLE `t_refund_pass_6` (
|
`id` bigint NOT NULL,
|
`order_id` bigint NULL DEFAULT NULL COMMENT '订单id',
|
`status` int NULL DEFAULT NULL COMMENT '1待审核2已完成3已拒绝4待退货5待平台收货',
|
`refund_method` int NULL DEFAULT NULL COMMENT '1退货退款2仅退款',
|
`refund_reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '用户申请原因',
|
`user_remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '用户申请备注',
|
`pics` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '申请图片',
|
`pass_status` int NULL DEFAULT NULL COMMENT '1待审核2同意3拒绝',
|
`pass_remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '后台审核备注',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '售后管理' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_refund_pass_6
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_refund_pass_7
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_refund_pass_7`;
|
CREATE TABLE `t_refund_pass_7` (
|
`id` bigint NOT NULL,
|
`order_id` bigint NULL DEFAULT NULL COMMENT '订单id',
|
`status` int NULL DEFAULT NULL COMMENT '1待审核2已完成3已拒绝4待退货5待平台收货',
|
`refund_method` int NULL DEFAULT NULL COMMENT '1退货退款2仅退款',
|
`refund_reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '用户申请原因',
|
`user_remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '用户申请备注',
|
`pics` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '申请图片',
|
`pass_status` int NULL DEFAULT NULL COMMENT '1待审核2同意3拒绝',
|
`pass_remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '后台审核备注',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '售后管理' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_refund_pass_7
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_refund_pass_8
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_refund_pass_8`;
|
CREATE TABLE `t_refund_pass_8` (
|
`id` bigint NOT NULL,
|
`order_id` bigint NULL DEFAULT NULL COMMENT '订单id',
|
`status` int NULL DEFAULT NULL COMMENT '1待审核2已完成3已拒绝4待退货5待平台收货',
|
`refund_method` int NULL DEFAULT NULL COMMENT '1退货退款2仅退款',
|
`refund_reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '用户申请原因',
|
`user_remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '用户申请备注',
|
`pics` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '申请图片',
|
`pass_status` int NULL DEFAULT NULL COMMENT '1待审核2同意3拒绝',
|
`pass_remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '后台审核备注',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '售后管理' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_refund_pass_8
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_refund_pass_9
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_refund_pass_9`;
|
CREATE TABLE `t_refund_pass_9` (
|
`id` bigint NOT NULL,
|
`order_id` bigint NULL DEFAULT NULL COMMENT '订单id',
|
`status` int NULL DEFAULT NULL COMMENT '1待审核2已完成3已拒绝4待退货5待平台收货',
|
`refund_method` int NULL DEFAULT NULL COMMENT '1退货退款2仅退款',
|
`refund_reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '用户申请原因',
|
`user_remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '用户申请备注',
|
`pics` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '申请图片',
|
`pass_status` int NULL DEFAULT NULL COMMENT '1待审核2同意3拒绝',
|
`pass_remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '后台审核备注',
|
`del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '售后管理' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_refund_pass_9
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shopping_cart_0
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shopping_cart_0`;
|
CREATE TABLE `t_shopping_cart_0` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`number` int NULL DEFAULT 1 COMMENT '数量',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '购物车' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shopping_cart_0
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shopping_cart_1
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shopping_cart_1`;
|
CREATE TABLE `t_shopping_cart_1` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`number` int NULL DEFAULT 1 COMMENT '数量',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '购物车' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shopping_cart_1
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shopping_cart_10
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shopping_cart_10`;
|
CREATE TABLE `t_shopping_cart_10` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`number` int NULL DEFAULT 1 COMMENT '数量',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '购物车' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shopping_cart_10
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shopping_cart_11
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shopping_cart_11`;
|
CREATE TABLE `t_shopping_cart_11` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`number` int NULL DEFAULT 1 COMMENT '数量',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '购物车' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shopping_cart_11
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shopping_cart_12
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shopping_cart_12`;
|
CREATE TABLE `t_shopping_cart_12` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`number` int NULL DEFAULT 1 COMMENT '数量',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '购物车' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shopping_cart_12
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shopping_cart_13
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shopping_cart_13`;
|
CREATE TABLE `t_shopping_cart_13` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`number` int NULL DEFAULT 1 COMMENT '数量',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '购物车' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shopping_cart_13
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shopping_cart_14
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shopping_cart_14`;
|
CREATE TABLE `t_shopping_cart_14` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`number` int NULL DEFAULT 1 COMMENT '数量',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '购物车' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shopping_cart_14
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shopping_cart_15
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shopping_cart_15`;
|
CREATE TABLE `t_shopping_cart_15` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`number` int NULL DEFAULT 1 COMMENT '数量',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '购物车' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shopping_cart_15
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shopping_cart_16
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shopping_cart_16`;
|
CREATE TABLE `t_shopping_cart_16` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`number` int NULL DEFAULT 1 COMMENT '数量',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '购物车' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shopping_cart_16
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shopping_cart_17
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shopping_cart_17`;
|
CREATE TABLE `t_shopping_cart_17` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`number` int NULL DEFAULT 1 COMMENT '数量',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '购物车' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shopping_cart_17
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shopping_cart_18
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shopping_cart_18`;
|
CREATE TABLE `t_shopping_cart_18` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`number` int NULL DEFAULT 1 COMMENT '数量',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '购物车' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shopping_cart_18
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shopping_cart_19
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shopping_cart_19`;
|
CREATE TABLE `t_shopping_cart_19` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`number` int NULL DEFAULT 1 COMMENT '数量',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '购物车' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shopping_cart_19
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shopping_cart_2
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shopping_cart_2`;
|
CREATE TABLE `t_shopping_cart_2` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`number` int NULL DEFAULT 1 COMMENT '数量',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '购物车' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shopping_cart_2
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shopping_cart_20
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shopping_cart_20`;
|
CREATE TABLE `t_shopping_cart_20` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`number` int NULL DEFAULT 1 COMMENT '数量',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '购物车' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shopping_cart_20
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shopping_cart_21
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shopping_cart_21`;
|
CREATE TABLE `t_shopping_cart_21` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`number` int NULL DEFAULT 1 COMMENT '数量',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '购物车' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shopping_cart_21
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shopping_cart_22
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shopping_cart_22`;
|
CREATE TABLE `t_shopping_cart_22` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`number` int NULL DEFAULT 1 COMMENT '数量',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '购物车' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shopping_cart_22
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shopping_cart_23
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shopping_cart_23`;
|
CREATE TABLE `t_shopping_cart_23` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`number` int NULL DEFAULT 1 COMMENT '数量',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '购物车' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shopping_cart_23
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shopping_cart_24
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shopping_cart_24`;
|
CREATE TABLE `t_shopping_cart_24` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`number` int NULL DEFAULT 1 COMMENT '数量',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '购物车' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shopping_cart_24
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shopping_cart_25
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shopping_cart_25`;
|
CREATE TABLE `t_shopping_cart_25` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`number` int NULL DEFAULT 1 COMMENT '数量',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '购物车' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shopping_cart_25
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shopping_cart_26
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shopping_cart_26`;
|
CREATE TABLE `t_shopping_cart_26` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`number` int NULL DEFAULT 1 COMMENT '数量',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '购物车' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shopping_cart_26
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shopping_cart_27
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shopping_cart_27`;
|
CREATE TABLE `t_shopping_cart_27` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`number` int NULL DEFAULT 1 COMMENT '数量',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '购物车' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shopping_cart_27
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shopping_cart_28
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shopping_cart_28`;
|
CREATE TABLE `t_shopping_cart_28` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`number` int NULL DEFAULT 1 COMMENT '数量',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '购物车' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shopping_cart_28
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shopping_cart_29
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shopping_cart_29`;
|
CREATE TABLE `t_shopping_cart_29` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`number` int NULL DEFAULT 1 COMMENT '数量',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '购物车' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shopping_cart_29
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shopping_cart_3
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shopping_cart_3`;
|
CREATE TABLE `t_shopping_cart_3` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`number` int NULL DEFAULT 1 COMMENT '数量',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '购物车' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shopping_cart_3
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shopping_cart_30
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shopping_cart_30`;
|
CREATE TABLE `t_shopping_cart_30` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`number` int NULL DEFAULT 1 COMMENT '数量',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '购物车' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shopping_cart_30
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shopping_cart_31
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shopping_cart_31`;
|
CREATE TABLE `t_shopping_cart_31` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`number` int NULL DEFAULT 1 COMMENT '数量',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '购物车' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shopping_cart_31
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shopping_cart_32
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shopping_cart_32`;
|
CREATE TABLE `t_shopping_cart_32` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`number` int NULL DEFAULT 1 COMMENT '数量',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '购物车' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shopping_cart_32
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shopping_cart_33
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shopping_cart_33`;
|
CREATE TABLE `t_shopping_cart_33` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`number` int NULL DEFAULT 1 COMMENT '数量',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '购物车' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shopping_cart_33
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shopping_cart_34
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shopping_cart_34`;
|
CREATE TABLE `t_shopping_cart_34` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`number` int NULL DEFAULT 1 COMMENT '数量',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '购物车' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shopping_cart_34
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shopping_cart_35
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shopping_cart_35`;
|
CREATE TABLE `t_shopping_cart_35` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`number` int NULL DEFAULT 1 COMMENT '数量',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '购物车' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shopping_cart_35
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shopping_cart_36
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shopping_cart_36`;
|
CREATE TABLE `t_shopping_cart_36` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`number` int NULL DEFAULT 1 COMMENT '数量',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '购物车' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shopping_cart_36
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shopping_cart_37
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shopping_cart_37`;
|
CREATE TABLE `t_shopping_cart_37` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`number` int NULL DEFAULT 1 COMMENT '数量',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '购物车' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shopping_cart_37
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shopping_cart_38
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shopping_cart_38`;
|
CREATE TABLE `t_shopping_cart_38` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`number` int NULL DEFAULT 1 COMMENT '数量',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '购物车' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shopping_cart_38
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shopping_cart_39
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shopping_cart_39`;
|
CREATE TABLE `t_shopping_cart_39` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`number` int NULL DEFAULT 1 COMMENT '数量',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '购物车' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shopping_cart_39
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shopping_cart_4
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shopping_cart_4`;
|
CREATE TABLE `t_shopping_cart_4` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`number` int NULL DEFAULT 1 COMMENT '数量',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '购物车' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shopping_cart_4
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shopping_cart_40
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shopping_cart_40`;
|
CREATE TABLE `t_shopping_cart_40` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`number` int NULL DEFAULT 1 COMMENT '数量',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '购物车' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shopping_cart_40
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shopping_cart_41
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shopping_cart_41`;
|
CREATE TABLE `t_shopping_cart_41` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`number` int NULL DEFAULT 1 COMMENT '数量',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '购物车' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shopping_cart_41
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shopping_cart_42
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shopping_cart_42`;
|
CREATE TABLE `t_shopping_cart_42` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`number` int NULL DEFAULT 1 COMMENT '数量',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '购物车' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shopping_cart_42
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shopping_cart_43
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shopping_cart_43`;
|
CREATE TABLE `t_shopping_cart_43` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`number` int NULL DEFAULT 1 COMMENT '数量',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '购物车' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shopping_cart_43
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shopping_cart_44
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shopping_cart_44`;
|
CREATE TABLE `t_shopping_cart_44` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`number` int NULL DEFAULT 1 COMMENT '数量',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '购物车' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shopping_cart_44
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shopping_cart_45
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shopping_cart_45`;
|
CREATE TABLE `t_shopping_cart_45` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`number` int NULL DEFAULT 1 COMMENT '数量',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '购物车' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shopping_cart_45
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shopping_cart_46
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shopping_cart_46`;
|
CREATE TABLE `t_shopping_cart_46` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`number` int NULL DEFAULT 1 COMMENT '数量',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '购物车' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shopping_cart_46
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shopping_cart_47
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shopping_cart_47`;
|
CREATE TABLE `t_shopping_cart_47` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`number` int NULL DEFAULT 1 COMMENT '数量',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '购物车' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shopping_cart_47
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shopping_cart_48
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shopping_cart_48`;
|
CREATE TABLE `t_shopping_cart_48` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`number` int NULL DEFAULT 1 COMMENT '数量',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '购物车' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shopping_cart_48
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shopping_cart_49
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shopping_cart_49`;
|
CREATE TABLE `t_shopping_cart_49` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`number` int NULL DEFAULT 1 COMMENT '数量',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '购物车' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shopping_cart_49
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shopping_cart_5
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shopping_cart_5`;
|
CREATE TABLE `t_shopping_cart_5` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`number` int NULL DEFAULT 1 COMMENT '数量',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '购物车' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shopping_cart_5
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shopping_cart_6
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shopping_cart_6`;
|
CREATE TABLE `t_shopping_cart_6` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`number` int NULL DEFAULT 1 COMMENT '数量',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '购物车' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shopping_cart_6
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shopping_cart_7
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shopping_cart_7`;
|
CREATE TABLE `t_shopping_cart_7` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`number` int NULL DEFAULT 1 COMMENT '数量',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '购物车' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shopping_cart_7
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shopping_cart_8
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shopping_cart_8`;
|
CREATE TABLE `t_shopping_cart_8` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`number` int NULL DEFAULT 1 COMMENT '数量',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '购物车' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shopping_cart_8
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_shopping_cart_9
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_shopping_cart_9`;
|
CREATE TABLE `t_shopping_cart_9` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`goods_id` int NULL DEFAULT NULL COMMENT '商品id',
|
`number` int NULL DEFAULT 1 COMMENT '数量',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '购物车' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of t_shopping_cart_9
|
-- ----------------------------
|
|
SET FOREIGN_KEY_CHECKS = 1;
|
