/*
|
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
|
|
Target Server Type : MySQL
|
Target Server Version : 80037 (8.0.37)
|
File Encoding : 65001
|
|
Date: 26/07/2024 11:50:32
|
*/
|
|
SET NAMES utf8mb4;
|
SET FOREIGN_KEY_CHECKS = 0;
|
|
-- ----------------------------
|
-- Table structure for config_info
|
-- ----------------------------
|
DROP TABLE IF EXISTS `config_info`;
|
CREATE TABLE `config_info` (
|
`id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
|
`data_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT 'data_id',
|
`group_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
|
`content` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT 'content',
|
`md5` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT 'md5',
|
`gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
`gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
|
`src_user` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL COMMENT 'source user',
|
`src_ip` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT 'source ip',
|
`app_name` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
|
`tenant_id` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT '' COMMENT '租户字段',
|
`c_desc` varchar(256) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
|
`c_use` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
|
`effect` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
|
`type` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
|
`c_schema` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL,
|
PRIMARY KEY (`id`) USING BTREE,
|
UNIQUE INDEX `uk_configinfo_datagrouptenant`(`data_id` ASC, `group_id` ASC, `tenant_id` ASC) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_bin COMMENT = 'config_info' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Table structure for config_info_aggr
|
-- ----------------------------
|
DROP TABLE IF EXISTS `config_info_aggr`;
|
CREATE TABLE `config_info_aggr` (
|
`id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
|
`data_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT 'data_id',
|
`group_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT 'group_id',
|
`datum_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT 'datum_id',
|
`content` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '内容',
|
`gmt_modified` datetime NOT NULL COMMENT '修改时间',
|
`app_name` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
|
`tenant_id` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT '' COMMENT '租户字段',
|
PRIMARY KEY (`id`) USING BTREE,
|
UNIQUE INDEX `uk_configinfoaggr_datagrouptenantdatum`(`data_id` ASC, `group_id` ASC, `tenant_id` ASC, `datum_id` ASC) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_bin COMMENT = '增加租户字段' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Table structure for config_info_beta
|
-- ----------------------------
|
DROP TABLE IF EXISTS `config_info_beta`;
|
CREATE TABLE `config_info_beta` (
|
`id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
|
`data_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT 'data_id',
|
`group_id` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT 'group_id',
|
`app_name` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT 'app_name',
|
`content` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT 'content',
|
`beta_ips` varchar(1024) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT 'betaIps',
|
`md5` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT 'md5',
|
`gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
`gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
|
`src_user` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL COMMENT 'source user',
|
`src_ip` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT 'source ip',
|
`tenant_id` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT '' COMMENT '租户字段',
|
PRIMARY KEY (`id`) USING BTREE,
|
UNIQUE INDEX `uk_configinfobeta_datagrouptenant`(`data_id` ASC, `group_id` ASC, `tenant_id` ASC) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_bin COMMENT = 'config_info_beta' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Table structure for config_info_tag
|
-- ----------------------------
|
DROP TABLE IF EXISTS `config_info_tag`;
|
CREATE TABLE `config_info_tag` (
|
`id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
|
`data_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT 'data_id',
|
`group_id` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT 'group_id',
|
`tenant_id` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT '' COMMENT 'tenant_id',
|
`tag_id` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT 'tag_id',
|
`app_name` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT 'app_name',
|
`content` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT 'content',
|
`md5` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT 'md5',
|
`gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
`gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
|
`src_user` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL COMMENT 'source user',
|
`src_ip` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT 'source ip',
|
PRIMARY KEY (`id`) USING BTREE,
|
UNIQUE INDEX `uk_configinfotag_datagrouptenanttag`(`data_id` ASC, `group_id` ASC, `tenant_id` ASC, `tag_id` ASC) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_bin COMMENT = 'config_info_tag' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Table structure for config_tags_relation
|
-- ----------------------------
|
DROP TABLE IF EXISTS `config_tags_relation`;
|
CREATE TABLE `config_tags_relation` (
|
`id` bigint NOT NULL COMMENT 'id',
|
`tag_name` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT 'tag_name',
|
`tag_type` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT 'tag_type',
|
`data_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT 'data_id',
|
`group_id` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT 'group_id',
|
`tenant_id` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT '' COMMENT 'tenant_id',
|
`nid` bigint NOT NULL AUTO_INCREMENT,
|
PRIMARY KEY (`nid`) USING BTREE,
|
UNIQUE INDEX `uk_configtagrelation_configidtag`(`id` ASC, `tag_name` ASC, `tag_type` ASC) USING BTREE,
|
INDEX `idx_tenant_id`(`tenant_id` ASC) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_bin COMMENT = 'config_tag_relation' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- 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 group_capacity
|
-- ----------------------------
|
DROP TABLE IF EXISTS `group_capacity`;
|
CREATE TABLE `group_capacity` (
|
`id` bigint UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键ID',
|
`group_id` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '' COMMENT 'Group ID，空字符表示整个集群',
|
`quota` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '配额，0表示使用默认值',
|
`usage` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '使用量',
|
`max_size` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '单个配置大小上限，单位为字节，0表示使用默认值',
|
`max_aggr_count` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '聚合子配置最大个数，，0表示使用默认值',
|
`max_aggr_size` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '单个聚合数据的子配置大小上限，单位为字节，0表示使用默认值',
|
`max_history_count` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '最大变更历史数量',
|
`gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
`gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
|
PRIMARY KEY (`id`) USING BTREE,
|
UNIQUE INDEX `uk_group_id`(`group_id` ASC) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_bin COMMENT = '集群、各Group容量信息表' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Table structure for his_config_info
|
-- ----------------------------
|
DROP TABLE IF EXISTS `his_config_info`;
|
CREATE TABLE `his_config_info` (
|
`id` bigint UNSIGNED NOT NULL,
|
`nid` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
|
`data_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,
|
`group_id` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,
|
`app_name` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT 'app_name',
|
`content` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,
|
`md5` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
|
`gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
`gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
`src_user` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL,
|
`src_ip` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
|
`op_type` char(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
|
`tenant_id` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT '' COMMENT '租户字段',
|
PRIMARY KEY (`nid`) USING BTREE,
|
INDEX `idx_gmt_create`(`gmt_create` ASC) USING BTREE,
|
INDEX `idx_gmt_modified`(`gmt_modified` ASC) USING BTREE,
|
INDEX `idx_did`(`data_id` ASC) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_bin COMMENT = '多租户改造' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Table structure for permissions
|
-- ----------------------------
|
DROP TABLE IF EXISTS `permissions`;
|
CREATE TABLE `permissions` (
|
`role` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
`resource` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
`action` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
UNIQUE INDEX `uk_role_permission`(`role` ASC, `resource` ASC, `action` ASC) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Table structure for roles
|
-- ----------------------------
|
DROP TABLE IF EXISTS `roles`;
|
CREATE TABLE `roles` (
|
`username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
`role` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
UNIQUE INDEX `idx_user_role`(`username` ASC, `role` ASC) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Table structure for sys_agreement
|
-- ----------------------------
|
DROP TABLE IF EXISTS `sys_agreement`;
|
CREATE TABLE `sys_agreement` (
|
`id` int NOT NULL AUTO_INCREMENT,
|
`content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '内容',
|
`content_type` 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已删除',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '协议政策、司机操作指导' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Table structure for sys_config
|
-- ----------------------------
|
DROP TABLE IF EXISTS `sys_config`;
|
CREATE TABLE `sys_config` (
|
`config_id` int NOT NULL AUTO_INCREMENT COMMENT '参数主键',
|
`config_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '参数名称',
|
`config_key` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '参数键名',
|
`config_value` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '参数键值',
|
`config_type` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT 'N' COMMENT '系统内置（Y是 N否）',
|
`create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '创建者',
|
`create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
|
`update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '更新者',
|
`update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
|
`remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注',
|
PRIMARY KEY (`config_id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 100 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '参数配置表' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Table structure for sys_dict_data
|
-- ----------------------------
|
DROP TABLE IF EXISTS `sys_dict_data`;
|
CREATE TABLE `sys_dict_data` (
|
`dict_code` bigint NOT NULL AUTO_INCREMENT COMMENT '字典编码',
|
`dict_sort` int NULL DEFAULT 0 COMMENT '字典排序',
|
`dict_label` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '字典标签',
|
`dict_value` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '字典键值',
|
`dict_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '字典类型',
|
`css_class` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '样式属性（其他样式扩展）',
|
`list_class` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '表格回显样式',
|
`is_default` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT 'N' COMMENT '是否默认（Y是 N否）',
|
`status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '0' COMMENT '状态（0正常 1停用）',
|
`create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '创建者',
|
`create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
|
`update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '更新者',
|
`update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
|
`remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注',
|
PRIMARY KEY (`dict_code`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 100 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '字典数据表' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Table structure for sys_dict_type
|
-- ----------------------------
|
DROP TABLE IF EXISTS `sys_dict_type`;
|
CREATE TABLE `sys_dict_type` (
|
`dict_id` bigint NOT NULL AUTO_INCREMENT COMMENT '字典主键',
|
`dict_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '字典名称',
|
`dict_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '字典类型',
|
`status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '0' COMMENT '状态（0正常 1停用）',
|
`create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '创建者',
|
`create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
|
`update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '更新者',
|
`update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
|
`remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注',
|
PRIMARY KEY (`dict_id`) USING BTREE,
|
UNIQUE INDEX `dict_type`(`dict_type` ASC) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 100 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '字典类型表' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Table structure for sys_franchisee
|
-- ----------------------------
|
DROP TABLE IF EXISTS `sys_franchisee`;
|
CREATE TABLE `sys_franchisee` (
|
`id` int NOT NULL AUTO_INCREMENT,
|
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '加盟商名称',
|
`head` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '负责人',
|
`head_phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '负责人电话',
|
`id_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '负责人身份证号码',
|
`business_license` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '营业执照',
|
`admin_account` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '管理员账号',
|
`admin_password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '管理员密码',
|
`city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '管辖城市',
|
`Identity_photo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '身份证正反面照片 ,隔开',
|
`role_id` int NOT NULL COMMENT '角色id',
|
`is_enable` 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已删除',
|
`city_str` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '城市数组字符串',
|
`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 = 16 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '加盟商信息表' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Table structure for sys_logininfor
|
-- ----------------------------
|
DROP TABLE IF EXISTS `sys_logininfor`;
|
CREATE TABLE `sys_logininfor` (
|
`info_id` bigint NOT NULL AUTO_INCREMENT COMMENT '访问ID',
|
`user_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '用户账号',
|
`ipaddr` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '登录IP地址',
|
`status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '0' COMMENT '登录状态（0成功 1失败）',
|
`msg` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '提示信息',
|
`access_time` datetime NULL DEFAULT NULL COMMENT '访问时间',
|
PRIMARY KEY (`info_id`) USING BTREE,
|
INDEX `idx_sys_logininfor_s`(`status` ASC) USING BTREE,
|
INDEX `idx_sys_logininfor_lt`(`access_time` ASC) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 218 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '系统访问记录' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Table structure for sys_master_worker
|
-- ----------------------------
|
DROP TABLE IF EXISTS `sys_master_worker`;
|
CREATE TABLE `sys_master_worker` (
|
`id` int NOT NULL AUTO_INCREMENT,
|
`city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '服务城市',
|
`user_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户编号(用户昵称/用户id)',
|
`password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户登录密码(默认123456)',
|
`real_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '真实姓名',
|
`sex` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '性别 ',
|
`birthday` datetime NULL DEFAULT NULL COMMENT '生日',
|
`id_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '身份证号码',
|
`vehicle_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '车辆类型',
|
`vehicle_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '车牌号',
|
`phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '手机号',
|
`profile_picture` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '头像',
|
`identity_photo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '身份证正反面照片 ,隔开',
|
`driving_license` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '行驶证照片',
|
`is_enable` 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已删除',
|
`city_str` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '城市数组字符串',
|
`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 = 600563739 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '师傅信息表' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Table structure for sys_menu
|
-- ----------------------------
|
DROP TABLE IF EXISTS `sys_menu`;
|
CREATE TABLE `sys_menu` (
|
`menu_id` bigint NOT NULL AUTO_INCREMENT COMMENT '菜单ID',
|
`menu_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '菜单名称',
|
`parent_id` bigint NULL DEFAULT 0 COMMENT '父菜单ID',
|
`order_num` int NULL DEFAULT 0 COMMENT '显示顺序',
|
`path` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '路由地址',
|
`component` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '组件路径',
|
`query` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '路由参数',
|
`is_frame` int NULL DEFAULT 1 COMMENT '是否为外链（0是 1否）',
|
`is_cache` int NULL DEFAULT 0 COMMENT '是否缓存（0缓存 1不缓存）',
|
`menu_type` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '菜单类型（M目录 C菜单 F按钮）',
|
`visible` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '菜单状态（0显示 1隐藏）',
|
`status` tinyint(1) NULL DEFAULT 0 COMMENT '菜单状态（0正常 1停用）',
|
`perms` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '权限标识',
|
`icon` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '#' COMMENT '菜单图标',
|
`create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
|
`create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
|
`update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
|
`update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
|
`remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '备注',
|
PRIMARY KEY (`menu_id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 2027 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '菜单权限表' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Table structure for sys_notices
|
-- ----------------------------
|
DROP TABLE IF EXISTS `sys_notices`;
|
CREATE TABLE `sys_notices` (
|
`id` int NOT NULL AUTO_INCREMENT,
|
`notice_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '通知标题',
|
`notice_detail` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '通知内容',
|
`sort` int 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 = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '系统通知管理' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Table structure for sys_prize
|
-- ----------------------------
|
DROP TABLE IF EXISTS `sys_prize`;
|
CREATE TABLE `sys_prize` (
|
`id` int NOT NULL AUTO_INCREMENT,
|
`prize_image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '奖品图片',
|
`prize_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '奖品名称',
|
`probability` double(10, 2) 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 = 8 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '奖品管理' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Table structure for sys_problem
|
-- ----------------------------
|
DROP TABLE IF EXISTS `sys_problem`;
|
CREATE TABLE `sys_problem` (
|
`id` int NOT NULL AUTO_INCREMENT,
|
`title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '标题',
|
`detail` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '详情内容',
|
`sort` int 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 = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '常见问题管理' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Table structure for sys_recovery_classify
|
-- ----------------------------
|
DROP TABLE IF EXISTS `sys_recovery_classify`;
|
CREATE TABLE `sys_recovery_classify` (
|
`id` int NOT NULL AUTO_INCREMENT,
|
`sup_classify` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '上级分类名称',
|
`sub_classify` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '下级分类名称',
|
`home_page_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '首页显示名称',
|
`classification_picture` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '分类图标',
|
`type_describe` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '分类描述',
|
`sort` int NULL DEFAULT NULL COMMENT '排序权重',
|
`brief_introduction` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '分类简介',
|
`is_recommend` 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已删除',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 42 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '回收分类表' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Table structure for sys_recovery_serve
|
-- ----------------------------
|
DROP TABLE IF EXISTS `sys_recovery_serve`;
|
CREATE TABLE `sys_recovery_serve` (
|
`id` int NOT NULL AUTO_INCREMENT,
|
`classify_id` int NOT NULL COMMENT '所属分类id',
|
`serve_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '服务名称',
|
`serve_describe` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '服务描述',
|
`estimate_price` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '预估价格',
|
`default_price` decimal(10, 2) NULL DEFAULT NULL COMMENT '默认回收价',
|
`sort` int NULL DEFAULT NULL COMMENT '排序权重',
|
`cover` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '封面图片',
|
`rotate` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci 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 = 38 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '回收服务列表' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Table structure for sys_recovery_serve_price
|
-- ----------------------------
|
DROP TABLE IF EXISTS `sys_recovery_serve_price`;
|
CREATE TABLE `sys_recovery_serve_price` (
|
`id` int NOT NULL AUTO_INCREMENT,
|
`recovery_serve_id` int NOT NULL COMMENT '回收服务id',
|
`recovery_price` decimal(10, 2) NULL DEFAULT NULL COMMENT '回收价格',
|
`city` 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',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 20 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '回收服务对应回收价格及所在城市' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Table structure for sys_role
|
-- ----------------------------
|
DROP TABLE IF EXISTS `sys_role`;
|
CREATE TABLE `sys_role` (
|
`role_id` bigint NOT NULL AUTO_INCREMENT COMMENT '角色ID',
|
`role_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '角色名称',
|
`role_illustrate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '角色说明',
|
`role_key` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '角色权限字符串',
|
`role_sort` int NULL DEFAULT NULL COMMENT '显示顺序',
|
`data_scope` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '1' COMMENT '数据范围（1：全部数据权限 2：自定数据权限 3：本部门数据权限 4：本部门及以下数据权限）',
|
`menu_check_strictly` tinyint(1) NULL DEFAULT 1 COMMENT '菜单树选择项是否关联显示',
|
`dept_check_strictly` tinyint(1) NULL DEFAULT 1 COMMENT '部门树选择项是否关联显示',
|
`status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '角色状态（0正常 1停用）',
|
`del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
|
`create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
|
`create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
|
`update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
|
`update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
|
`remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
|
PRIMARY KEY (`role_id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 93 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '角色信息表' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Table structure for sys_role_menu
|
-- ----------------------------
|
DROP TABLE IF EXISTS `sys_role_menu`;
|
CREATE TABLE `sys_role_menu` (
|
`role_id` bigint NOT NULL COMMENT '角色ID',
|
`menu_id` bigint NOT NULL COMMENT '菜单ID',
|
PRIMARY KEY (`role_id`, `menu_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '角色和菜单关联表' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Table structure for sys_rotate
|
-- ----------------------------
|
DROP TABLE IF EXISTS `sys_rotate`;
|
CREATE TABLE `sys_rotate` (
|
`id` int NOT NULL AUTO_INCREMENT,
|
`rotate_picture` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '轮播图图片',
|
`sort` int NULL DEFAULT NULL COMMENT '排序',
|
`rotate_serve_id` int NULL DEFAULT NULL COMMENT '跳转服务id',
|
`is_rotate` 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已删除',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '轮播图图片管理' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Table structure for sys_serve_advantage
|
-- ----------------------------
|
DROP TABLE IF EXISTS `sys_serve_advantage`;
|
CREATE TABLE `sys_serve_advantage` (
|
`id` int NOT NULL AUTO_INCREMENT,
|
`title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '标题',
|
`describe_detail` 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_site
|
-- ----------------------------
|
DROP TABLE IF EXISTS `sys_site`;
|
CREATE TABLE `sys_site` (
|
`id` int NOT NULL AUTO_INCREMENT,
|
`site_name` 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 = 12 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '服务站点表' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Table structure for sys_user
|
-- ----------------------------
|
DROP TABLE IF EXISTS `sys_user`;
|
CREATE TABLE `sys_user` (
|
`user_id` bigint NOT NULL AUTO_INCREMENT COMMENT '用户ID',
|
`nick_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '账号名称',
|
`account` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '账号',
|
`password` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '密码',
|
`is_enable` int NULL DEFAULT 0 COMMENT '是否启用(0:未启用;1:已启用)',
|
`login_ip` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '最后登录IP',
|
`login_date` datetime NULL DEFAULT NULL COMMENT '最后登录时间',
|
`passWordUpdate` datetime NULL DEFAULT NULL COMMENT '密码修改时间',
|
`create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
|
`create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
|
`update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
|
`update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
|
`is_delete` int NULL DEFAULT NULL COMMENT '是否软删除 0未删除;1已删除',
|
`franchisee_id` int NULL DEFAULT NULL COMMENT '加盟商id',
|
PRIMARY KEY (`user_id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 219 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户信息表' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Table structure for sys_user_role
|
-- ----------------------------
|
DROP TABLE IF EXISTS `sys_user_role`;
|
CREATE TABLE `sys_user_role` (
|
`user_id` bigint NOT NULL COMMENT '用户ID',
|
`role_id` bigint NOT NULL COMMENT '角色ID',
|
PRIMARY KEY (`user_id`, `role_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_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 sys_worker_process
|
-- ----------------------------
|
DROP TABLE IF EXISTS `sys_worker_process`;
|
CREATE TABLE `sys_worker_process` (
|
`id` int NOT NULL AUTO_INCREMENT,
|
`city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '服务城市',
|
`real_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '真实姓名',
|
`sex` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '性别 ',
|
`birthday` datetime NULL DEFAULT NULL COMMENT '生日',
|
`id_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '身份证号码',
|
`vehicle_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '车辆类型',
|
`vehicle_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '车牌号',
|
`phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '手机号',
|
`profile_picture` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '头像',
|
`identity_photo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '身份证正反面照片 ,隔开',
|
`driving_license` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci 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已删除',
|
`opinion` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '审批意见',
|
`city_str` 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',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 7512401 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '师傅入驻审核表' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Table structure for t_region
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_region`;
|
CREATE TABLE `t_region` (
|
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID',
|
`name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '城市名称',
|
`code` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
|
`city_code` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
|
`parent_id` int NULL DEFAULT NULL COMMENT '父级ID',
|
`english` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '英文名称',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 3537 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '省市区三级联动' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Table structure for t_user
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_user`;
|
CREATE TABLE `t_user` (
|
`id` int NOT NULL AUTO_INCREMENT,
|
`user_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户编号',
|
`nickname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户昵称',
|
`phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '手机号',
|
`profile_picture` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '头像',
|
`state` int NULL DEFAULT NULL COMMENT '账号状态 0未启用;1已启用',
|
`city` 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 '城市编码',
|
`open_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '微信openId',
|
`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 = 28 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '用户列表' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Table structure for t_user_collect
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_user_collect`;
|
CREATE TABLE `t_user_collect` (
|
`id` int NOT NULL AUTO_INCREMENT,
|
`user_id` int NULL DEFAULT NULL COMMENT '用户id',
|
`serve_id` int NULL DEFAULT NULL COMMENT '回收服务id',
|
`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 = 17 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '用户收藏表' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Table structure for t_user_recipient
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_user_recipient`;
|
CREATE TABLE `t_user_recipient` (
|
`id` int NOT NULL AUTO_INCREMENT,
|
`user_id` int NULL DEFAULT NULL COMMENT '用户id',
|
`recipient` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '收件人姓名',
|
`recipientPhone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '收件人电话',
|
`address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '地址',
|
`address_detail` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '详细地址',
|
`isDefault` int NULL DEFAULT NULL COMMENT '是否为默认地址0否1是',
|
`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 0 COMMENT '是否删除 0否1是',
|
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '地图搜索名称',
|
`city` 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',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 14 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '用户收货地址' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Table structure for tenant_capacity
|
-- ----------------------------
|
DROP TABLE IF EXISTS `tenant_capacity`;
|
CREATE TABLE `tenant_capacity` (
|
`id` bigint UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键ID',
|
`tenant_id` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '' COMMENT 'Tenant ID',
|
`quota` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '配额，0表示使用默认值',
|
`usage` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '使用量',
|
`max_size` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '单个配置大小上限，单位为字节，0表示使用默认值',
|
`max_aggr_count` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '聚合子配置最大个数',
|
`max_aggr_size` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '单个聚合数据的子配置大小上限，单位为字节，0表示使用默认值',
|
`max_history_count` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '最大变更历史数量',
|
`gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
`gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
|
PRIMARY KEY (`id`) USING BTREE,
|
UNIQUE INDEX `uk_tenant_id`(`tenant_id` ASC) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_bin COMMENT = '租户容量信息表' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Table structure for tenant_info
|
-- ----------------------------
|
DROP TABLE IF EXISTS `tenant_info`;
|
CREATE TABLE `tenant_info` (
|
`id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
|
`kp` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT 'kp',
|
`tenant_id` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT '' COMMENT 'tenant_id',
|
`tenant_name` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT '' COMMENT 'tenant_name',
|
`tenant_desc` varchar(256) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT 'tenant_desc',
|
`create_source` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT 'create_source',
|
`gmt_create` bigint NOT NULL COMMENT '创建时间',
|
`gmt_modified` bigint NOT NULL COMMENT '修改时间',
|
PRIMARY KEY (`id`) USING BTREE,
|
UNIQUE INDEX `uk_tenant_info_kptenantid`(`kp` ASC, `tenant_id` ASC) USING BTREE,
|
INDEX `idx_tenant_id`(`tenant_id` ASC) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_bin COMMENT = 'tenant_info' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Table structure for users
|
-- ----------------------------
|
DROP TABLE IF EXISTS `users`;
|
CREATE TABLE `users` (
|
`username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
`password` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
`enabled` tinyint(1) NOT NULL,
|
PRIMARY KEY (`username`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
|
SET FOREIGN_KEY_CHECKS = 1;
|
