/*
|
Navicat Premium Data Transfer
|
|
Source Server : 二手回收-本地
|
Source Server Type : MySQL
|
Source Server Version : 80037 (8.0.37)
|
Source Host : localhost:3306
|
Source Schema : secondary_recovery_order
|
|
Target Server Type : MySQL
|
Target Server Version : 80037 (8.0.37)
|
File Encoding : 65001
|
|
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
|
-- ----------------------------
|
DROP TABLE IF EXISTS `sys_change_dispatch`;
|
CREATE TABLE `sys_change_dispatch` (
|
`id` bigint NOT NULL,
|
`worker_id` int NOT NULL COMMENT '申请师傅',
|
`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:已改派)',
|
`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,
|
`updateTime` datetime NULL DEFAULT NULL,
|
`is_delete` int NULL DEFAULT NULL COMMENT '是否删除 0未删除;1已删除',
|
`order_id` bigint NULL DEFAULT NULL COMMENT '订单id',
|
`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 '下单用户名称',
|
`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
|
-- ----------------------------
|
DROP TABLE IF EXISTS `sys_serve_coordinate`;
|
CREATE TABLE `sys_serve_coordinate` (
|
`id` int NOT NULL AUTO_INCREMENT,
|
`worker_id` int NOT NULL COMMENT '师傅id',
|
`order_id` int NULL DEFAULT NULL COMMENT '订单id',
|
`coordinate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '路线经纬度',
|
`longitude` decimal(10, 6) NULL DEFAULT NULL COMMENT '经度',
|
`latitude` decimal(10, 6) NULL DEFAULT NULL COMMENT '纬度',
|
`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,
|
`updateTime` datetime NULL DEFAULT NULL,
|
`is_delete` int NULL DEFAULT NULL COMMENT '是否删除 0未删除;1已删除',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 25 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '师傅路线经纬度信息' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Table structure for sys_serve_record
|
-- ----------------------------
|
DROP TABLE IF EXISTS `sys_serve_record`;
|
CREATE TABLE `sys_serve_record` (
|
`id` bigint NOT NULL,
|
`order_id` bigint NULL DEFAULT NULL COMMENT '订单id',
|
`photo` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '现场照片(多张照片 \',\'隔开)',
|
`remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '服务备注',
|
`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,
|
`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;
|
|
-- ----------------------------
|
-- Table structure for t_evaluate
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_evaluate`;
|
CREATE TABLE `t_evaluate` (
|
`id` bigint NOT NULL,
|
`user_id` int NOT NULL COMMENT '用户id',
|
`user_phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户手机号',
|
`order_id` bigint NULL DEFAULT NULL COMMENT '订单id',
|
`content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '评价内容',
|
`worker_id` int NULL DEFAULT NULL COMMENT '评价师傅id',
|
`star_rating` double(2, 1) NULL DEFAULT NULL COMMENT '评价星级',
|
`serve_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '服务单号',
|
`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,
|
`updateTime` datetime NULL DEFAULT NULL,
|
`is_delete` 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_order
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_order`;
|
CREATE TABLE `t_order` (
|
`id` bigint NOT NULL,
|
`city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '下单城市',
|
`order_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '订单编号',
|
`site_id` int NULL DEFAULT NULL COMMENT '站点id',
|
`site_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '站点名称',
|
`serve_id` int NOT NULL COMMENT '回收服务id',
|
`serve_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '回收服务名称',
|
`serve_price` decimal(10, 2) NULL DEFAULT NULL COMMENT '回收服务的回收价',
|
`user_id` int NULL DEFAULT NULL COMMENT '下单用户id',
|
`reservation_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '预约姓名',
|
`reservation_phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '预约手机号',
|
`reservation_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '预约地址',
|
`time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '预约上门时间段',
|
`server_id` int NULL DEFAULT NULL COMMENT '服务人员id',
|
`server_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '服务人员名称',
|
`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:已改派)',
|
`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,
|
`updateTime` datetime NULL DEFAULT NULL,
|
`is_delete` int NULL DEFAULT NULL COMMENT '是否删除 0未删除;1已删除',
|
`accept_time` datetime NULL DEFAULT NULL COMMENT '接单时间(师傅接单或后台派单，更新该字段时间)',
|
`type` int NULL DEFAULT NULL COMMENT '订单类型(0:正常订单,1:后台订单(后台订单与用户端、师傅端无联系))',
|
`longitude` double NULL DEFAULT NULL COMMENT '下单用户经度',
|
`latitude` double NULL DEFAULT NULL COMMENT '下单用户纬度',
|
`arrive_time` datetime NULL DEFAULT NULL COMMENT '师傅到达预约地点时间',
|
`complete_time` datetime NULL DEFAULT NULL COMMENT '订单完成时间',
|
`is_withdrawal` int NULL DEFAULT NULL COMMENT '是否已提现(0:未提现，1:已提现)',
|
`subsidy` decimal(10, 6) NULL DEFAULT NULL COMMENT '补贴金额',
|
`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_reinvest` int NULL DEFAULT NULL COMMENT '是否为再投单 1:再投',
|
`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
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_withdraw`;
|
CREATE TABLE `t_withdraw` (
|
`id` bigint NOT NULL,
|
`user_id` int NOT NULL COMMENT '用户id',
|
`user_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户编号',
|
`nick_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户昵称',
|
`user_phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户手机号',
|
`apply_for_time` datetime NOT NULL COMMENT '申请时间',
|
`apply_for_money` decimal(10, 2) NULL DEFAULT NULL COMMENT '申请金额',
|
`state` int NULL DEFAULT NULL COMMENT '申请状态 0待审核;1已通过;2已驳回',
|
`opinion` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '审批意见',
|
`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,
|
`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 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '用户提现申请记录表' ROW_FORMAT = DYNAMIC;
|
|
SET FOREIGN_KEY_CHECKS = 1;
|
