From f8cc44e926fd22f9d1d864dc684c827f6960270b Mon Sep 17 00:00:00 2001 From: hjl <1657978663@qq.com> Date: 星期五, 26 七月 2024 11:51:30 +0800 Subject: [PATCH] feat: 最新代码及配置 --- sql/secondary_recovery_order.sql | 268 +++++++++++++++++++++++++++++++++++++++++++++++++---- 1 files changed, 246 insertions(+), 22 deletions(-) diff --git a/sql/secondary_recovery_order.sql b/sql/secondary_recovery_order.sql index b6bfa86..a716b52 100644 --- a/sql/secondary_recovery_order.sql +++ b/sql/secondary_recovery_order.sql @@ -11,11 +11,244 @@ Target Server Version : 80037 (8.0.37) File Encoding : 65001 - Date: 16/07/2024 09:28:41 + Date: 26/07/2024 11:50:39 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; + +-- ---------------------------- +-- Table structure for data_address +-- ---------------------------- +DROP TABLE IF EXISTS `data_address`; +CREATE TABLE `data_address` ( + `id` bigint NOT NULL AUTO_INCREMENT, + `uid` bigint NULL DEFAULT 0 COMMENT '用户UID', + `type` tinyint(1) NULL DEFAULT 0 COMMENT '地址类型(0普通,1默认)', + `username` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '收货姓名', + `phone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '收货手机', + `address` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '地址', + `latitude` decimal(20, 6) NULL DEFAULT NULL COMMENT '维度', + `longitude` decimal(20, 6) NULL DEFAULT NULL COMMENT '经度', + `xxdz` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '详细地址', + `create_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', + PRIMARY KEY (`id`) USING BTREE, + INDEX `idx_data_user_address_type`(`type` ASC) USING BTREE, + INDEX `idx_data_user_address_uuid`(`uid` ASC) USING BTREE +) ENGINE = InnoDB AUTO_INCREMENT = 42 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户地址' ROW_FORMAT = Dynamic; + +-- ---------------------------- +-- Table structure for data_advantage +-- ---------------------------- +DROP TABLE IF EXISTS `data_advantage`; +CREATE TABLE `data_advantage` ( + `id` bigint NOT NULL AUTO_INCREMENT, + `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '消息名称', + `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '内容', + `sort` bigint NULL DEFAULT 0 COMMENT '排序权重', + `create_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB AUTO_INCREMENT = 882 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '服务优势' ROW_FORMAT = Dynamic; + +-- ---------------------------- +-- Table structure for data_cate +-- ---------------------------- +DROP TABLE IF EXISTS `data_cate`; +CREATE TABLE `data_cate` ( + `id` bigint NOT NULL AUTO_INCREMENT, + `pid` bigint NULL DEFAULT 0 COMMENT '上级分类', + `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '分类名称', + `index_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '首页分类名称', + `cover` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '分类图标', + `remark` varchar(999) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '分类描述', + `remark_jj` varchar(999) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '分类简介', + `sort` bigint NULL DEFAULT 0 COMMENT '排序权重', + `index_status` tinyint NULL DEFAULT 0 COMMENT '是否首页推荐', + `create_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', + PRIMARY KEY (`id`) USING BTREE, + INDEX `idx_shop_goods_cate_sort`(`sort` ASC) USING BTREE +) ENGINE = InnoDB AUTO_INCREMENT = 26 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '回收分类' ROW_FORMAT = Dynamic; + +-- ---------------------------- +-- Table structure for data_collect +-- ---------------------------- +DROP TABLE IF EXISTS `data_collect`; +CREATE TABLE `data_collect` ( + `id` bigint NOT NULL AUTO_INCREMENT, + `uid` bigint NULL DEFAULT 0 COMMENT '用户ID', + `pid` bigint NULL DEFAULT 0 COMMENT '产品ID', + `create_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '收藏' ROW_FORMAT = Dynamic; + +-- ---------------------------- +-- Table structure for data_draw +-- ---------------------------- +DROP TABLE IF EXISTS `data_draw`; +CREATE TABLE `data_draw` ( + `id` int NOT NULL AUTO_INCREMENT, + `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '奖品名称', + `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '奖品图片', + `odds` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '中间几率', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB AUTO_INCREMENT = 19 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '奖品管理' ROW_FORMAT = Dynamic; + +-- ---------------------------- +-- Table structure for data_goods +-- ---------------------------- +DROP TABLE IF EXISTS `data_goods`; +CREATE TABLE `data_goods` ( + `id` bigint NOT NULL AUTO_INCREMENT, + `name` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '服务名称', + `remark` varchar(999) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '服务描述', + `price` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '预估价格', + `pg_price` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '评估价格', + `pid` int NULL DEFAULT 0 COMMENT '上级分类', + `cateids` varchar(999) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '分类编号', + `cover` varchar(999) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '服务封面', + `slider` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '轮播图片', + `sort` bigint NULL DEFAULT 0 COMMENT '列表排序权重', + `create_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB AUTO_INCREMENT = 22 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '服务内容' ROW_FORMAT = Dynamic; + +-- ---------------------------- +-- Table structure for data_message +-- ---------------------------- +DROP TABLE IF EXISTS `data_message`; +CREATE TABLE `data_message` ( + `id` bigint NOT NULL AUTO_INCREMENT, + `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '消息名称', + `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '消息内容', + `sort` bigint NULL DEFAULT 0 COMMENT '排序权重', + `create_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB AUTO_INCREMENT = 30 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '通知' ROW_FORMAT = Dynamic; + +-- ---------------------------- +-- Table structure for data_order +-- ---------------------------- +DROP TABLE IF EXISTS `data_order`; +CREATE TABLE `data_order` ( + `id` bigint NOT NULL AUTO_INCREMENT, + `order_type` tinyint(1) NULL DEFAULT 0 COMMENT '0用户订单1指定订单', + `order_no` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '商品订单单号', + `product_id` bigint NULL DEFAULT 0 COMMENT '产品ID', + `uid` bigint NULL DEFAULT 0 COMMENT '用户ID', + `server_uid` bigint NULL DEFAULT 0 COMMENT '服务用户ID', + `price` decimal(20, 2) NULL DEFAULT 0.00 COMMENT '实际金额', + `bt_price` decimal(20, 2) NULL DEFAULT 0.00 COMMENT '分享补贴金额', + `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '用户姓名', + `phone` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '用户手机', + `province` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '地址-省份', + `city` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '地址-城市', + `area` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '地址-区域', + `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '收货地址', + `xx_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '详细地址', + `latitude` decimal(20, 6) NULL DEFAULT NULL COMMENT '维度', + `longitude` decimal(20, 6) NULL DEFAULT NULL COMMENT '经度', + `sm_time` timestamp NULL DEFAULT NULL COMMENT '上门时间', + `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '服务备注', + `cancel_remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '取消订单描述', + `pj_level` int NULL DEFAULT 0 COMMENT '评价等级', + `pj_remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '评价描述', + `reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '修改时间原因', + `completeTime` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '完工时间', + `yhqrtp` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '用户确认图片', + `jjmptp` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '旧机铭牌图片', + `njtp` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '内机图片', + `wjhqttp` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '外机和其他图片', + `drawnum` int NOT NULL DEFAULT 0 COMMENT '抽奖次数', + `status` tinyint(1) NULL DEFAULT 1 COMMENT '订单流程状态(1待派单,2已派单,3已接单,4已完成,5已取消)', + `jd_status` tinyint(1) NULL DEFAULT 0 COMMENT '订单流程状态(0未接单1确定接单2取消接单)', + `zt_server_uid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '再投师傅ID', + `pj_status` tinyint(1) NULL DEFAULT 0 COMMENT '评价状态0未评价1已评价', + `time_status` tinyint(1) NULL DEFAULT 0 COMMENT '时间状态', + `create_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '订单创建时间', + `server_sendnum` int NOT NULL DEFAULT 0, + `user_sendnum` int NOT NULL DEFAULT 0, + `print` int NOT NULL DEFAULT 0, + PRIMARY KEY (`id`) USING BTREE, + INDEX `idx_shop_order_status`(`status` ASC) USING BTREE, + INDEX `idx_shop_order_orderno`(`order_no` ASC) USING BTREE, + INDEX `idx_shop_order_cancel_status`(`username` ASC) USING BTREE, + INDEX `idx_shop_order_deleted`(`remark` ASC) USING BTREE, + INDEX `idx_shop_order_mid`(`uid` ASC) USING BTREE +) ENGINE = InnoDB AUTO_INCREMENT = 10973 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '订单' ROW_FORMAT = Dynamic; + +-- ---------------------------- +-- Table structure for data_question +-- ---------------------------- +DROP TABLE IF EXISTS `data_question`; +CREATE TABLE `data_question` ( + `id` bigint NOT NULL AUTO_INCREMENT, + `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '消息名称', + `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '内容', + `sort` bigint NULL DEFAULT 0 COMMENT '排序权重', + `create_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '常见问题' ROW_FORMAT = Dynamic; + +-- ---------------------------- +-- Table structure for data_technician +-- ---------------------------- +DROP TABLE IF EXISTS `data_technician`; +CREATE TABLE `data_technician` ( + `id` bigint NOT NULL AUTO_INCREMENT, + `uid` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '用户ID', + `city` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '城市', + `username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '用户姓名', + `phone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '用户手机', + `car_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '车辆类型', + `car_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '车牌号码', + `idcard` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '身份证号码', + `idcard_z` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '身份证正面', + `idcard_f` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '身份证反面', + `xsz` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '行驶证', + `work_status` tinyint(1) NULL DEFAULT 1 COMMENT '工作状态(1正常,0休息)', + `status` tinyint(1) NULL DEFAULT 0 COMMENT '用户状态(0审核中，1同意,2驳回)', + `create_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '注册时间', + PRIMARY KEY (`id`) USING BTREE, + INDEX `idx_data_user_status`(`work_status` ASC) USING BTREE, + INDEX `idx_data_user_openid1`(`uid` ASC) USING BTREE +) ENGINE = InnoDB AUTO_INCREMENT = 104 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '技师' ROW_FORMAT = Dynamic; + +-- ---------------------------- +-- Table structure for data_transfer +-- ---------------------------- +DROP TABLE IF EXISTS `data_transfer`; +CREATE TABLE `data_transfer` ( + `id` bigint NOT NULL AUTO_INCREMENT, + `uid` bigint NULL DEFAULT 0 COMMENT '用户UID', + `code` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '提现单号', + `charge_amount` decimal(20, 2) NULL DEFAULT 0.00 COMMENT '提现手续费金额', + `amount` decimal(20, 2) NULL DEFAULT 0.00 COMMENT '提现转账金额', + `trade_no` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '交易单号', + `trade_time` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '打款时间', + `status` tinyint(1) NULL DEFAULT 0 COMMENT '提现状态(0待审核，1同意,2驳回,3打款中,4已打款,5已收款)', + `create_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', + PRIMARY KEY (`id`) USING BTREE, + INDEX `idx_data_user_transfer_code`(`code` ASC) USING BTREE, + INDEX `idx_data_user_transfer_status`(`status` ASC) USING BTREE, + INDEX `idx_data_user_transfer_uuid`(`uid` ASC) USING BTREE +) ENGINE = InnoDB AUTO_INCREMENT = 21 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '提现' ROW_FORMAT = Dynamic; + +-- ---------------------------- +-- Table structure for data_user +-- ---------------------------- +DROP TABLE IF EXISTS `data_user`; +CREATE TABLE `data_user` ( + `id` bigint NOT NULL AUTO_INCREMENT, + `openid` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '小程序OPENID', + `avatar` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '用户头像', + `nickname` varchar(99) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '用户昵称', + `price` decimal(20, 2) NULL DEFAULT 0.00 COMMENT '用户金额', + `status` tinyint(1) NULL DEFAULT 0 COMMENT '是否技师（1是0否）', + `sh_status` tinyint(1) NULL DEFAULT 0 COMMENT '是否提交审核（1是0否）', + `create_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '注册时间', + PRIMARY KEY (`id`) USING BTREE, + INDEX `idx_data_user_openid1`(`openid` ASC) USING BTREE +) ENGINE = InnoDB AUTO_INCREMENT = 1851 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for sys_change_dispatch @@ -27,7 +260,7 @@ `worker_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '申请师傅姓名', `apply_reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '申请原因', `apply_time` datetime NULL DEFAULT NULL COMMENT '申请改派时间', - `state` int NULL DEFAULT NULL COMMENT '改派状态 (0:未改派 ;1:已改派 ;2:拒绝)', + `state` int NULL DEFAULT NULL COMMENT '改派状态 (0:未改派 ;1:已改派)', `createBy` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `updateBy` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `createTime` datetime NULL DEFAULT NULL, @@ -37,8 +270,8 @@ `order_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '订单编号', `user_id` int NULL DEFAULT NULL COMMENT '下单用户id', `user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '下单用户名称', - PRIMARY KEY (`id`) USING BTREE -) ENGINE = InnoDB AUTO_INCREMENT = 69 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '改派管理' ROW_FORMAT = Dynamic; + `city_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '城市code' +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for sys_serve_coordinate @@ -74,17 +307,7 @@ `updateTime` datetime NULL DEFAULT NULL, `is_delete` int NULL DEFAULT NULL COMMENT '是否删除 0未删除;1已删除', PRIMARY KEY (`id`) USING BTREE -) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '师傅服务记录' ROW_FORMAT = Dynamic; - --- ---------------------------- --- Table structure for sys_withdrawal_setting --- ---------------------------- -DROP TABLE IF EXISTS `sys_withdrawal_setting`; -CREATE TABLE `sys_withdrawal_setting` ( - `id` int NOT NULL AUTO_INCREMENT, - `enable_process` int NOT NULL COMMENT '是否开启审核(0:未开启，1:已开启)', - PRIMARY KEY (`id`) USING BTREE -) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '审核管理全局设置' ROW_FORMAT = Dynamic; +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '师傅服务记录' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for t_evaluate @@ -104,8 +327,8 @@ `createTime` datetime NULL DEFAULT NULL, `updateTime` datetime NULL DEFAULT NULL, `is_delete` int NULL DEFAULT NULL COMMENT '是否删除 0未删除;1已删除', - PRIMARY KEY (`id`) USING BTREE -) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '用户评价表' ROW_FORMAT = DYNAMIC; + `city_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '城市code' +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for t_order @@ -130,7 +353,7 @@ `server_phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '服务人员手机号', `reservation_remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '预约备注(服务备注)', `order_money` decimal(10, 6) NULL DEFAULT NULL COMMENT '订单成交价(服务回收价 + 津贴)', - `state` int NULL DEFAULT NULL COMMENT '订单状态(0:待派单；1:待上门；2:待完工；3:已完结；4:已取消；5:已改派，6:待改派)', + `state` int NULL DEFAULT NULL COMMENT '订单状态(0:待派单；1:待上门；2:待完工；3:已完结；4:已取消；5:已改派)', `createBy` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `updateBy` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `createTime` datetime NULL DEFAULT NULL, @@ -147,10 +370,10 @@ `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '详细地址', `top_sort` int NULL DEFAULT NULL COMMENT '置顶顺序', `cancel_reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '订单取消原因', - `is_evaluate` int NULL DEFAULT NULL COMMENT '是否评价(0:未评价,1:已评价)', `is_reinvest` int NULL DEFAULT NULL COMMENT '是否为再投单 1:再投', - PRIMARY KEY (`id`) USING BTREE -) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '订单管理' ROW_FORMAT = DYNAMIC; + `is_evaluate` int NULL DEFAULT NULL COMMENT '是否评价(0:未评价,1:已评价)', + `city_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '城市code码' +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for t_withdraw @@ -172,7 +395,8 @@ `updateTime` datetime NULL DEFAULT NULL, `is_delete` int NULL DEFAULT NULL COMMENT '是否删除 0未删除;1已删除', `order_id` bigint NULL DEFAULT NULL COMMENT '订单id', + `city_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '城市code', PRIMARY KEY (`id`) USING BTREE -) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '用户提现申请记录表' ROW_FORMAT = DYNAMIC; +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '用户提现申请记录表' ROW_FORMAT = DYNAMIC; SET FOREIGN_KEY_CHECKS = 1; -- Gitblit v1.7.1