repair_backend/target/classes/sql/repair_report.sql

/*
 Navicat Premium Data Transfer

 Source Server         : 报修系统数据库
 Source Server Type    : MySQL
 Source Server Version : 80022
 Source Host           : 172.16.20.95:3306
 Source Schema         : repair_report

 Target Server Type    : MySQL
 Target Server Version : 80022
 File Encoding         : 65001

 Date: 04/01/2024 09:19:31
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for repair_admin
-- ----------------------------
DROP TABLE IF EXISTS `repair_admin`;
CREATE TABLE `repair_admin`  (
  `id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键UUID类型',
  `account` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '账号',
  `card_number` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '微校卡号',
  `password` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '密码',
  `username` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '昵称',
  `school_id` int(0) NOT NULL COMMENT '校区ID',
  `phone` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '手机号',
  `is_super` int(0) NOT NULL COMMENT '是否是超级管理员 不是：0；是：1',
  `statu` int(0) NOT NULL COMMENT '状态 正常：0；冻结：1',
  `is_mobile` int(0) NOT NULL COMMENT '是否是移动端创建 不是：0；是：1',
  `create_time` datetime(0) NOT NULL COMMENT '创建时间',
  `update_time` datetime(0) NOT NULL COMMENT '更新时间',
  `create_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建人员',
  `update_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '更新人员',
  `deleted` int(0) NOT NULL COMMENT '逻辑删除 未删除：0；删除：1',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for repair_area
-- ----------------------------
DROP TABLE IF EXISTS `repair_area`;
CREATE TABLE `repair_area`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `parent_id` int(0) NOT NULL COMMENT '父级ID',
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '区域/具体名称',
  `create_time` datetime(0) NOT NULL COMMENT '创建时间',
  `update_time` datetime(0) NOT NULL COMMENT '更新时间',
  `create_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建人员',
  `update_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '更新人员',
  `deleted` int(0) NOT NULL COMMENT '逻辑删除 未删除：0；删除：1',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 504 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for repair_article_build
-- ----------------------------
DROP TABLE IF EXISTS `repair_article_build`;
CREATE TABLE `repair_article_build`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `article_id` int(0) NOT NULL COMMENT '报修类型',
  `build_id` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '楼栋关联ID（多个楼栋用逗号隔开）',
  `user_id` int(0) NOT NULL COMMENT '用户ID',
  `create_time` datetime(0) NOT NULL COMMENT '创建时间',
  `update_time` datetime(0) NOT NULL COMMENT '更新时间',
  `create_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建人员',
  `update_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '更新人员',
  `deleted` int(0) NOT NULL COMMENT '逻辑删除 未删除：0；删除：1',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `ididx`(`id`, `deleted`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 684 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for repair_article_type
-- ----------------------------
DROP TABLE IF EXISTS `repair_article_type`;
CREATE TABLE `repair_article_type`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `order_num` int(0) NULL DEFAULT NULL COMMENT '序号',
  `school_id` int(0) NOT NULL COMMENT '校区ID',
  `parent_id` int(0) NOT NULL COMMENT '父级ID(parentid为0的是第一级)',
  `name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '报修故障（物品）类型名称',
  `create_time` datetime(0) NOT NULL COMMENT '创建时间',
  `update_time` datetime(0) NOT NULL COMMENT '更新时间',
  `create_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建人员',
  `update_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '更新人员',
  `deleted` int(0) NOT NULL COMMENT '逻辑删除 未删除：0；删除：1',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 481 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for repair_classes_settings
-- ----------------------------
DROP TABLE IF EXISTS `repair_classes_settings`;
CREATE TABLE `repair_classes_settings`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `user_id` int(0) NOT NULL COMMENT '用户ID',
  `start_date` date NOT NULL COMMENT '生效日期',
  `shift_id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '班次ID（多个班次用逗号隔开）',
  `create_time` datetime(0) NOT NULL COMMENT '创建时间',
  `update_time` datetime(0) NOT NULL COMMENT '更新时间',
  `create_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建人员',
  `update_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '更新人员',
  `deleted` int(0) NOT NULL COMMENT '逻辑删除 未删除：0；删除：1',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `unOne`(`user_id`, `start_date`, `shift_id`, `create_time`, `update_time`, `create_user`, `update_user`, `deleted`) USING BTREE COMMENT '不能存在重复值',
  INDEX `deletedIdx`(`user_id`, `deleted`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4213 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for repair_close
-- ----------------------------
DROP TABLE IF EXISTS `repair_close`;
CREATE TABLE `repair_close`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '关单原因',
  `create_time` datetime(0) NOT NULL COMMENT '创建时间',
  `update_time` datetime(0) NOT NULL COMMENT '更新时间',
  `create_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建人员',
  `update_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '更新人员',
  `deleted` int(0) NOT NULL COMMENT '逻辑删除 未删除：0；删除：1',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for repair_collaborate_record
-- ----------------------------
DROP TABLE IF EXISTS `repair_collaborate_record`;
CREATE TABLE `repair_collaborate_record`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `record_id` int(0) NOT NULL COMMENT '报修记录ID',
  `user_id` int(0) NOT NULL COMMENT '申请人ID',
  `approver_id` int(0) NULL DEFAULT NULL COMMENT '审批操作人ID',
  `collaborator` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '协作人ID（多个人用逗号隔开）',
  `voice` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '语音 可能做成语音文件上传的方式 然后这个字段记录语音文件名',
  `voice_length` int(0) NULL DEFAULT NULL COMMENT '录音时长',
  `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `approval_statu` int(0) NOT NULL COMMENT '审批状态 0拒绝 1同意 2待审批',
  `create_time` datetime(0) NOT NULL COMMENT '创建时间',
  `update_time` datetime(0) NOT NULL COMMENT '更新时间',
  `create_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建人员',
  `update_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '更新人员',
  `deleted` int(0) NOT NULL COMMENT '逻辑删除 未删除：0；删除：1',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 50 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for repair_consumables
-- ----------------------------
DROP TABLE IF EXISTS `repair_consumables`;
CREATE TABLE `repair_consumables`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `record_id` int(0) NOT NULL COMMENT '维修记录ID',
  `article_id` int(0) NOT NULL COMMENT '物品类型ID',
  `consume_id` int(0) NOT NULL COMMENT '耗材ID',
  `consume_name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '耗材名称',
  `price` decimal(10, 2) NOT NULL COMMENT '耗材单价',
  `number` double NOT NULL COMMENT '耗材数量',
  `total_price` decimal(10, 2) NOT NULL COMMENT '合计费用',
  `change_user` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '改价人',
  `create_time` datetime(0) NOT NULL COMMENT '创建时间',
  `update_time` datetime(0) NOT NULL COMMENT '更新时间',
  `create_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建人员',
  `update_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '更新人员',
  `deleted` int(0) NOT NULL COMMENT '逻辑删除 未删除：0；删除：1',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1030 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for repair_consume
-- ----------------------------
DROP TABLE IF EXISTS `repair_consume`;
CREATE TABLE `repair_consume`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `school_id` int(0) NOT NULL COMMENT '校区ID',
  `article_id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '故障（改名叫物品）类型ID （多个ID用逗号隔开）',
  `name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '耗材名称',
  `price` decimal(10, 2) NOT NULL COMMENT '单价',
  `content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '内容',
  `create_time` datetime(0) NOT NULL COMMENT '创建时间',
  `update_time` datetime(0) NOT NULL COMMENT '更新时间',
  `create_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建人员',
  `update_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '更新人员',
  `deleted` int(0) NOT NULL COMMENT '逻辑删除 未删除：0；删除：1',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 416 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for repair_dispatch_record
-- ----------------------------
DROP TABLE IF EXISTS `repair_dispatch_record`;
CREATE TABLE `repair_dispatch_record`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `record_id` int(0) NOT NULL COMMENT '报修记录ID',
  `users_id` int(0) NOT NULL COMMENT '被派单人ID',
  `assigned_time` datetime(0) NOT NULL COMMENT '被派单/被转单/被协作时间',
  `receiving_time` datetime(0) NULL DEFAULT NULL COMMENT '接单时间 用来计算是否接单超时 \r\n计算公式：\r\n（被派单时间 + 接单考核时间） < 接单时间',
  `acceptance_assess_time` int(0) NOT NULL COMMENT '接单考核时间',
  `source_id` int(0) NULL DEFAULT NULL COMMENT '协作或转单',
  `order_type` int(0) NOT NULL COMMENT '派单类型 0派单 1协作 2转单',
  `is_lose_efficacy` int(0) NOT NULL COMMENT '是否已失效（0未失效，1已失效）',
  `create_time` datetime(0) NOT NULL COMMENT '创建时间',
  `update_time` datetime(0) NOT NULL COMMENT '更新时间',
  `create_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建人员',
  `update_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '更新人员',
  `deleted` int(0) NOT NULL COMMENT '逻辑删除 未删除：0；删除：1',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `userIdx`(`users_id`, `is_lose_efficacy`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5667 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for repair_evaluate
-- ----------------------------
DROP TABLE IF EXISTS `repair_evaluate`;
CREATE TABLE `repair_evaluate`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `record_id` int(0) NOT NULL COMMENT '报修记录ID',
  `star` int(0) NOT NULL COMMENT '星级',
  `content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '评价内容',
  `create_time` datetime(0) NOT NULL COMMENT '创建时间',
  `update_time` datetime(0) NOT NULL COMMENT '更新时间',
  `create_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建人员',
  `update_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '更新人员',
  `deleted` int(0) NOT NULL COMMENT '逻辑删除 未删除：0；删除：1',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3750 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for repair_leave_message
-- ----------------------------
DROP TABLE IF EXISTS `repair_leave_message`;
CREATE TABLE `repair_leave_message`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `record_id` int(0) NOT NULL COMMENT '维修记录ID',
  `recipient_id` int(0) NOT NULL COMMENT '接收人员ID',
  `sender_id` int(0) NOT NULL COMMENT '发送人员ID',
  `content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '内容',
  `create_time` datetime(0) NOT NULL COMMENT '创建时间',
  `update_time` datetime(0) NOT NULL COMMENT '更新时间',
  `create_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建人员',
  `update_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '更新人员',
  `deleted` int(0) NOT NULL COMMENT '逻辑删除 未删除：0；删除：1',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 166 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for repair_notice_setting
-- ----------------------------
DROP TABLE IF EXISTS `repair_notice_setting`;
CREATE TABLE `repair_notice_setting`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '公告内容',
  `is_top` int(0) NOT NULL COMMENT '是否置顶展示 不展示：0 展示：1',
  `create_time` datetime(0) NOT NULL COMMENT '创建时间',
  `update_time` datetime(0) NOT NULL COMMENT '更新时间',
  `create_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建人员',
  `update_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '更新人员',
  `deleted` int(0) NOT NULL COMMENT '逻辑删除 未删除：0；删除：1',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 29 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for repair_offline_record
-- ----------------------------
DROP TABLE IF EXISTS `repair_offline_record`;
CREATE TABLE `repair_offline_record`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `record_id` int(0) NOT NULL COMMENT '报修记录ID',
  `voice` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '语音 可能做成语音文件上传的方式 然后这个字段记录语音文件名',
  `voice_length` int(0) NULL DEFAULT NULL COMMENT '录音时长',
  `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `user_id` int(0) NOT NULL COMMENT '申请人ID',
  `approver_id` int(0) NULL DEFAULT NULL COMMENT '审批操作人ID',
  `approval_statu` int(0) NOT NULL COMMENT '审批状态 0拒绝 1同意 2待审批',
  `refuse_remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '拒绝原因',
  `old_record` int(0) NOT NULL COMMENT '原来的工单状态',
  `create_time` datetime(0) NOT NULL COMMENT '创建时间',
  `update_time` datetime(0) NOT NULL COMMENT '更新时间',
  `create_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建人员',
  `update_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '更新人员',
  `deleted` int(0) NOT NULL COMMENT '逻辑删除 未删除：0；删除：1',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 344 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for repair_pay_record
-- ----------------------------
DROP TABLE IF EXISTS `repair_pay_record`;
CREATE TABLE `repair_pay_record`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `record_id` int(0) NOT NULL COMMENT '报修记录ID',
  `user_id` int(0) NOT NULL COMMENT '支付人员ID',
  `pay_no` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '支付流水号（对应支付平台的）',
  `pay_price` decimal(10, 2) NOT NULL COMMENT '交易金额',
  `is_success` int(0) NOT NULL COMMENT '是否支付成功 未支付/等待支付：1；支付成功：2；支付失败：3',
  `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '备注',
  `create_time` datetime(0) NOT NULL COMMENT '创建时间',
  `update_time` datetime(0) NOT NULL COMMENT '更新时间',
  `create_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建人员',
  `update_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '更新人员',
  `deleted` int(0) NOT NULL COMMENT '逻辑删除 未删除：0；删除：1',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 490 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for repair_receiving
-- ----------------------------
DROP TABLE IF EXISTS `repair_receiving`;
CREATE TABLE `repair_receiving`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `record_id` int(0) NOT NULL COMMENT '维修记录ID',
  `dispatch_id` int(0) NOT NULL COMMENT '派单ID（关联派单表）',
  `user_id` int(0) NOT NULL COMMENT '接单人ID',
  `receiving_time` datetime(0) NOT NULL COMMENT '接单时间',
  `finish_time` datetime(0) NULL DEFAULT NULL COMMENT '维修完成时间 用来计算是否维修超时 \r\n计算公式：\r\n（接单时间 + 维修考核时间） < 维修完成时间',
  `maintenance_assess_time` int(0) NOT NULL COMMENT '维修考核时间（单位：分钟）',
  `is_lose_efficacy` int(0) NOT NULL COMMENT '是否已失效（未失效：0；已失效：1）',
  `create_time` datetime(0) NOT NULL COMMENT '创建时间',
  `update_time` datetime(0) NOT NULL COMMENT '更新时间',
  `create_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建人员',
  `update_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '更新人员',
  `deleted` int(0) NOT NULL COMMENT '逻辑删除 未删除：0；删除：1',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4601 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for repair_record
-- ----------------------------
DROP TABLE IF EXISTS `repair_record`;
CREATE TABLE `repair_record`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `area_id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '报修区域',
  `article_id` int(0) NOT NULL COMMENT '报修物品ID',
  `record_no` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '报修单号(也是微信支付种的商户单号)',
  `school_id` int(0) NOT NULL COMMENT '校区ID',
  `address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '详细地址',
  `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '故障描述',
  `image` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '故障图片 最多三张（多张按逗号隔开）',
  `maintenancer` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '维修照片 最多两张 必填 （多张按逗号隔开）',
  `voice` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '报修录音',
  `voice_length` int(0) NULL DEFAULT NULL COMMENT '录音时长',
  `finish_voice` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '维修录音',
  `finish_voice_length` int(0) NULL DEFAULT NULL COMMENT '维修录音时长',
  `content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '维修内容',
  `customs_officer_id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '关单人ID 多个人用逗号隔开',
  `user_id` int(0) NOT NULL COMMENT '报修人ID',
  `user_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '报修人姓名',
  `user_phone` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '报修人联系电话',
  `user_class` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '报修人年级等信息',
  `build_id` int(0) NOT NULL COMMENT '楼栋ID',
  `price` decimal(10, 2) NULL DEFAULT NULL COMMENT '合计费用',
  `maintenancer_id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '维修人ID（多个人用逗号隔开）',
  `maintenancer_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '维修人姓名（用协作、改派操作之前第一个师傅的名字）',
  `maintenancer_phone` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '维修人联系电话（用协作、改派操作之前第一个师傅的电话）',
  `maintenance_state` int(0) NOT NULL COMMENT '维修状态(派单中，维修中，协作，转后勤，已完成，待确认，转单待审核，协作待审核，已取消，已关单)',
  `is_duty` int(0) NULL DEFAULT NULL COMMENT '是否是值班单 不是值班单0 是值班单1  定时到正常班次时间重新分配',
  `is_collaborate` int(0) NULL DEFAULT NULL COMMENT '是否是协作单 不是协作单0 是协作单1  判断关单用的',
  `logistics_personnel` int(0) NULL DEFAULT NULL COMMENT '后勤人员ID',
  `report_time` datetime(0) NOT NULL COMMENT '报修时间',
  `remark` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '关单原因',
  `create_time` datetime(0) NOT NULL COMMENT '创建时间',
  `update_time` datetime(0) NOT NULL COMMENT '更新时间',
  `create_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建人员',
  `update_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '更新人员',
  `deleted` int(0) NOT NULL COMMENT '逻辑删除 未删除：0；删除：1',
  `version` int(0) NOT NULL COMMENT '乐观锁',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5623 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for repair_refund_record
-- ----------------------------
DROP TABLE IF EXISTS `repair_refund_record`;
CREATE TABLE `repair_refund_record`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `record_id` int(0) NOT NULL COMMENT '报修记录ID',
  `user_id` int(0) NOT NULL COMMENT '被退款人员ID',
  `wx_no` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '商户退款单号（对应微信的）',
  `refund_no` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '微信退款单号（对应微信的）',
  `refund_price` decimal(10, 2) NOT NULL COMMENT '退款金额',
  `is_success` int(0) NOT NULL COMMENT '是否退款成功 退款中0；退款成功1；退款失败2',
  `approve` int(0) NULL DEFAULT NULL COMMENT '审批状态 待审批：0；通过：1；驳回：2',
  `approve_user` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '申请人',
  `approved_user` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '审批人',
  `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '备注',
  `create_time` datetime(0) NOT NULL COMMENT '创建时间',
  `update_time` datetime(0) NOT NULL COMMENT '更新时间',
  `create_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建人员',
  `update_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '更新人员',
  `deleted` int(0) NOT NULL COMMENT '逻辑删除 未删除：0；删除：1',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 47 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for repair_school
-- ----------------------------
DROP TABLE IF EXISTS `repair_school`;
CREATE TABLE `repair_school`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '校区名称',
  `create_time` datetime(0) NOT NULL COMMENT '创建时间',
  `update_time` datetime(0) NOT NULL COMMENT '更新时间',
  `create_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建人员',
  `update_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '更新人员',
  `deleted` int(0) NOT NULL COMMENT '逻辑删除 未删除：0；删除：1',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `name_unique`(`name`) USING BTREE COMMENT '校区名称不能重复'
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for repair_shift_settings
-- ----------------------------
DROP TABLE IF EXISTS `repair_shift_settings`;
CREATE TABLE `repair_shift_settings`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '班次名称',
  `start_time` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '开始时间',
  `end_time` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '结束时间',
  `not_work_time` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '非工作时间 多个时间用逗号隔开',
  `is_duty` int(0) NOT NULL COMMENT '是否值班 不值班：0；值班：1',
  `color` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '颜色（存储rgb值）',
  `create_time` datetime(0) NOT NULL COMMENT '创建时间',
  `update_time` datetime(0) NOT NULL COMMENT '更新时间',
  `create_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建人员',
  `update_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '更新人员',
  `deleted` int(0) NOT NULL COMMENT '逻辑删除 未删除：0；删除：1',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 15 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for repair_system_messages
-- ----------------------------
DROP TABLE IF EXISTS `repair_system_messages`;
CREATE TABLE `repair_system_messages`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `record_id` int(0) NOT NULL COMMENT '报修记录ID',
  `recipient_id` int(0) NOT NULL COMMENT '接收人员ID',
  `content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '内容',
  `is_read` int(0) NOT NULL COMMENT '是否已读 未读：0；已读：1',
  `create_time` datetime(0) NOT NULL COMMENT '创建时间',
  `update_time` datetime(0) NOT NULL COMMENT '更新时间',
  `create_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建人员',
  `update_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '更新人员',
  `deleted` int(0) NOT NULL COMMENT '逻辑删除 未删除：0；删除：1',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 31451 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for repair_system_setting
-- ----------------------------
DROP TABLE IF EXISTS `repair_system_setting`;
CREATE TABLE `repair_system_setting`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `hour` int(0) NOT NULL COMMENT '工单完成后多少小时，用户未评价系统默认好评',
  `emergency_call` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '黄家湖紧急电话',
  `emergency_mxh` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '墨轩湖紧急电话',
  `service_phone` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '服务监督电话',
  `create_time` datetime(0) NOT NULL COMMENT '创建时间',
  `update_time` datetime(0) NOT NULL COMMENT '更新时间',
  `create_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建人员',
  `update_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '更新人员',
  `deleted` int(0) NOT NULL COMMENT '逻辑删除 未删除：0；删除：1',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for repair_track_record
-- ----------------------------
DROP TABLE IF EXISTS `repair_track_record`;
CREATE TABLE `repair_track_record`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `record_id` int(0) NOT NULL COMMENT '报修记录ID',
  `maintenance_state` int(0) NOT NULL COMMENT '维修状态(派单中，维修中，协作，转后勤，已完成，待确认，转单待审核，协作待审核，已取消，已关单)',
  `content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '跟踪内容',
  `user_id` int(0) NULL DEFAULT NULL COMMENT '用户ID',
  `user_zzstr` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '对应身份',
  `image` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '照片',
  `voice` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '录音',
  `voice_length` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '录音时长',
  `create_time` datetime(0) NOT NULL COMMENT '创建时间',
  `update_time` datetime(0) NOT NULL COMMENT '更新时间',
  `create_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建人员',
  `update_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '更新人员',
  `deleted` int(0) NOT NULL COMMENT '逻辑删除 未删除：0；删除：1',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 18317 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for repair_transfer_record
-- ----------------------------
DROP TABLE IF EXISTS `repair_transfer_record`;
CREATE TABLE `repair_transfer_record`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `record_id` int(0) NOT NULL COMMENT '报修记录ID',
  `voice` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '语音 可能做成语音文件上传的方式 然后这个字段记录语音文件名',
  `voice_length` int(0) NULL DEFAULT NULL COMMENT '录音时长',
  `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `user_id` int(0) NOT NULL COMMENT '申请人ID',
  `approver_id` int(0) NULL DEFAULT NULL COMMENT '审批操作人ID',
  `approval_statu` int(0) NOT NULL COMMENT '审批状态 0拒绝 1同意 2待审批',
  `refuse_remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '拒绝原因',
  `create_time` datetime(0) NOT NULL COMMENT '创建时间',
  `update_time` datetime(0) NOT NULL COMMENT '更新时间',
  `create_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建人员',
  `update_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '更新人员',
  `deleted` int(0) NOT NULL COMMENT '逻辑删除 未删除：0；删除：1',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 222 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for repair_user
-- ----------------------------
DROP TABLE IF EXISTS `repair_user`;
CREATE TABLE `repair_user`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `card_number` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '微校卡号',
  `user_name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户名称',
  `user_phone` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户手机号',
  `user_zzid` int(0) NOT NULL COMMENT '用户身份ID 用户：0 维修师傅：1 郭班长：2 后勤人员：3',
  `user_class` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '报修人年级等信息',
  `work_type` int(0) NULL DEFAULT NULL COMMENT '工种',
  `identity_type` int(0) NULL DEFAULT NULL COMMENT '微校身份类型ID 其他：0； 学生：1； 教职工：4；校友：5；本科生：6',
  `college` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '学院',
  `grade` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '年级',
  `profession` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '专业',
  `school_id` int(0) NOT NULL COMMENT '校区ID',
  `state` int(0) NULL DEFAULT NULL COMMENT '员工状态 正常接单：1；停止接单：2；',
  `team_id` int(0) NULL DEFAULT NULL COMMENT '维修班 校方人员：0；第三方人员：1',
  `build_id` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '楼栋关联ID（多个楼栋用逗号隔开）',
  `article_id` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '故障类型（改名叫物品）关联ID（多个故障类型用逗号隔开）',
  `is_change` int(0) NULL DEFAULT NULL COMMENT '是否能转换  不能转换：0；能转换：1',
  `acceptance_assess_time` int(0) NULL DEFAULT NULL COMMENT '接单考核时间',
  `maintenance_assess_time` int(0) NULL DEFAULT NULL COMMENT '维修考核时间',
  `openid` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '微信唯一标识openid',
  `create_time` datetime(0) NOT NULL COMMENT '创建时间',
  `update_time` datetime(0) NOT NULL COMMENT '更新时间',
  `create_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建人员',
  `update_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '更新人员',
  `deleted` int(0) NOT NULL COMMENT '逻辑删除 未删除：0；删除：1',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `ididex`(`id`, `user_zzid`, `school_id`, `deleted`, `state`, `article_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 43737 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for repair_work_type
-- ----------------------------
DROP TABLE IF EXISTS `repair_work_type`;
CREATE TABLE `repair_work_type`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '工种名称',
  `create_time` datetime(0) NOT NULL COMMENT '创建时间',
  `update_time` datetime(0) NOT NULL COMMENT '更新时间',
  `create_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建人员',
  `update_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '更新人员',
  `deleted` int(0) NOT NULL COMMENT '逻辑删除 未删除：0；删除：1',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `name_unique`(`name`) USING BTREE COMMENT '工种类型名称不能重复'
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for wx_access_token
-- ----------------------------
DROP TABLE IF EXISTS `wx_access_token`;
CREATE TABLE `wx_access_token`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `access_token` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'access_token',
  `expires_time` datetime(0) NOT NULL COMMENT '过期时间',
  `create_time` datetime(0) NOT NULL COMMENT '创建时间',
  `update_time` datetime(0) NOT NULL COMMENT '更新时间',
  `create_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建人员',
  `update_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '更新人员',
  `deleted` int(0) NOT NULL COMMENT '逻辑删除 未删除：0；删除：1',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 532 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

SET FOREIGN_KEY_CHECKS = 1;