/* 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;