/*
|
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: 16/07/2024 09:28:41
|
*/
|
|
SET NAMES utf8mb4;
|
SET FOREIGN_KEY_CHECKS = 0;
|
|
-- ----------------------------
|
-- 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:已改派 ;2:拒绝)',
|
`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 '下单用户名称',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 69 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '改派管理' 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 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;
|
|
-- ----------------------------
|
-- 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已删除',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '用户评价表' 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:已改派，6:待改派)',
|
`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_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;
|
|
-- ----------------------------
|
-- 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',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '用户提现申请记录表' ROW_FORMAT = DYNAMIC;
|
|
SET FOREIGN_KEY_CHECKS = 1;
|
