From bd636bb9d2f75beabc7d99055ee4fb13c063f10c Mon Sep 17 00:00:00 2001 From: liujie <1793218484@qq.com> Date: 星期一, 19 一月 2026 16:05:00 +0800 Subject: [PATCH] Merge branch 'master' of http://120.76.84.145:10101/gitblit/r/java/estate_expert --- docs/sql/estate_expert.sql | 999 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 999 insertions(+), 0 deletions(-) diff --git a/docs/sql/estate_expert.sql b/docs/sql/estate_expert.sql new file mode 100644 index 0000000..6e9d9e0 --- /dev/null +++ b/docs/sql/estate_expert.sql @@ -0,0 +1,999 @@ +/* + Navicat Premium Data Transfer + + Source Server : 杰哥本地 + Source Server Type : MySQL + Source Server Version : 80035 + Source Host : 192.168.110.111:3306 + Source Schema : estate_expert + + Target Server Type : MySQL + Target Server Version : 80035 + File Encoding : 65001 + + Date: 17/01/2026 10:54:02 +*/ + +SET NAMES utf8mb4; +SET FOREIGN_KEY_CHECKS = 0; + +-- ---------------------------- +-- Table structure for accident_brief +-- ---------------------------- +DROP TABLE IF EXISTS `accident_brief`; +CREATE TABLE `accident_brief` ( + `id` int(0) NOT NULL AUTO_INCREMENT, + `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '标题', + `province` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '省', + `city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '市', + `area` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '区', + `classify_id` int(0) NULL DEFAULT NULL COMMENT '类别idaccident_classification id', + `casualties` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '伤亡情况', + `img` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '封面图', + `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '情况简述', + `time` date NULL DEFAULT NULL COMMENT '发生时间', + `detail` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '详情', + `state` int(0) NULL DEFAULT NULL COMMENT '1启用 2关闭', + `creator_id` int(0) NULL DEFAULT NULL, + `deleted` bit(1) NULL DEFAULT NULL COMMENT 'false正常true删除', + `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), + PRIMARY KEY (`id`) USING BTREE, + INDEX `classify_id`(`classify_id`) USING BTREE, + CONSTRAINT `accident_brief_ibfk_1` FOREIGN KEY (`classify_id`) REFERENCES `accident_classification` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT +) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '事故简讯' ROW_FORMAT = Dynamic; + +-- ---------------------------- +-- Table structure for accident_classification +-- ---------------------------- +DROP TABLE IF EXISTS `accident_classification`; +CREATE TABLE `accident_classification` ( + `id` int(0) NOT NULL AUTO_INCREMENT, + `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '分类名称', + `creator_id` int(0) NULL DEFAULT NULL, + `deleted` bit(1) NULL DEFAULT NULL COMMENT 'false正常true删除', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '事故分类' ROW_FORMAT = Dynamic; + +-- ---------------------------- +-- Table structure for archive +-- ---------------------------- +DROP TABLE IF EXISTS `archive`; +CREATE TABLE `archive` ( + `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键ID', + `create_time` datetime(6) NOT NULL COMMENT '创建时间', + `deleted` bit(1) NOT NULL COMMENT '是否删除', + `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '档案名称', + `update_time` datetime(6) NOT NULL COMMENT '更新时间', + `file_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '文件名', + `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注', + `type` int(0) NOT NULL COMMENT '档案类型：1-第三方报告 2-培训资料 3-标准规范 4-技术服务方案 5-检查照片', + `creator_id` int(0) NULL DEFAULT NULL COMMENT '创建者ID', + `file_id` int(0) NULL DEFAULT NULL COMMENT '关联文件ID', + PRIMARY KEY (`id`) USING BTREE, + UNIQUE INDEX `UK_pnk12l4936a21pst3p696mgt6`(`name`) USING BTREE, + INDEX `FK7s8lle5fxe2nppq0ei7mv59a0`(`creator_id`) USING BTREE, + INDEX `FK88dkaflqa7oi3voh9xyipv7ue`(`file_id`) USING BTREE, + CONSTRAINT `archive_ibfk_1` FOREIGN KEY (`creator_id`) REFERENCES `user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, + CONSTRAINT `archive_ibfk_2` FOREIGN KEY (`file_id`) REFERENCES `user_file` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT +) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '档案表' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for by_pass_info +-- ---------------------------- +DROP TABLE IF EXISTS `by_pass_info`; +CREATE TABLE `by_pass_info` ( + `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键ID', + `advice` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '建议', + `conclusion` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '结论', + `device_hierarchy_paths` json NULL COMMENT '设备层级路径（JSON格式）', + `system_hierarchy_paths` json NULL COMMENT '综合体系层级路径（JSON格式）', + `device_hierarchy_path_map` json NULL COMMENT '设备层级路径映射（JSON格式）', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB AUTO_INCREMENT = 130 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '旁站信息表' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for car +-- ---------------------------- +DROP TABLE IF EXISTS `car`; +CREATE TABLE `car` ( + `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键ID', + `create_time` datetime(6) NOT NULL COMMENT '创建时间', + `deleted` bit(1) NOT NULL COMMENT '是否删除', + `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '车牌号', + `update_time` datetime(6) NOT NULL COMMENT '更新时间', + `department_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '部门路径', + `initial_mileage` int(0) NULL DEFAULT NULL COMMENT '初始里程', + `model` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '车辆型号', + `creator_id` int(0) NULL DEFAULT NULL COMMENT '创建者ID', + `driver_id` int(0) NULL DEFAULT NULL COMMENT '司机ID', + PRIMARY KEY (`id`) USING BTREE, + UNIQUE INDEX `UK_biyf1xj7bo43hek7073jen2l`(`name`) USING BTREE, + INDEX `FKrbunbtq2td6uiupfb4gkejvl0`(`creator_id`) USING BTREE, + INDEX `FKlolhfn4hivlmxajrirccbmsfc`(`driver_id`) USING BTREE, + CONSTRAINT `car_ibfk_1` FOREIGN KEY (`driver_id`) REFERENCES `user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, + CONSTRAINT `car_ibfk_2` FOREIGN KEY (`creator_id`) REFERENCES `user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT +) ENGINE = InnoDB AUTO_INCREMENT = 13 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '车辆表' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for car_image +-- ---------------------------- +DROP TABLE IF EXISTS `car_image`; +CREATE TABLE `car_image` ( + `car_id` int(0) NOT NULL COMMENT '车辆ID', + `user_file_id` int(0) NOT NULL COMMENT '文件ID', + PRIMARY KEY (`car_id`, `user_file_id`) USING BTREE, + INDEX `FK9mwjil3uv40vc4t5wyldgd5ja`(`user_file_id`) USING BTREE, + CONSTRAINT `car_image_ibfk_1` FOREIGN KEY (`car_id`) REFERENCES `car` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, + CONSTRAINT `car_image_ibfk_2` FOREIGN KEY (`user_file_id`) REFERENCES `user_file` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '车辆照片关联表' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for check +-- ---------------------------- +DROP TABLE IF EXISTS `check`; +CREATE TABLE `check` ( + `id` int(0) NOT NULL AUTO_INCREMENT, + `plan_id` int(0) NULL DEFAULT NULL COMMENT '计划id', + `project_id` int(0) NULL DEFAULT NULL COMMENT '项目id', + `client_id` int(0) NULL DEFAULT NULL COMMENT '委托方id', + `safety_slip` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '安全告知单', + `check_user_img` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '检查人员照片', + `integrity_notification` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '廉政告知单', + `time` date NULL DEFAULT NULL COMMENT '检查时间', + `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '检查情况' ROW_FORMAT = Dynamic; + +-- ---------------------------- +-- Table structure for client +-- ---------------------------- +DROP TABLE IF EXISTS `client`; +CREATE TABLE `client` ( + `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键ID', + `create_time` datetime(6) NOT NULL COMMENT '创建时间', + `deleted` bit(1) NOT NULL COMMENT '是否删除', + `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '委托方名称', + `update_time` datetime(6) NOT NULL COMMENT '更新时间', + `intention` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '客户意向', + `type` int(0) NOT NULL COMMENT '客户类型：1-地产 2-开发商 3-投资 4-政府 5-咨询 6-其他', + `creator_id` int(0) NULL DEFAULT NULL COMMENT '创建者ID', + PRIMARY KEY (`id`) USING BTREE, + UNIQUE INDEX `UK_dn5jasds5r1j3ewo5k3nhwkkq`(`name`) USING BTREE, + INDEX `FKska29ab3o11u5wyjggfvo2a9d`(`creator_id`) USING BTREE, + CONSTRAINT `client_ibfk_1` FOREIGN KEY (`creator_id`) REFERENCES `user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT +) ENGINE = InnoDB AUTO_INCREMENT = 23 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '委托方表' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for client_param +-- ---------------------------- +DROP TABLE IF EXISTS `client_param`; +CREATE TABLE `client_param` ( + `id` int(0) NOT NULL AUTO_INCREMENT, + `client_id` int(0) NULL DEFAULT NULL, + `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '大屏显示名称', + `logo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, + `big_hidden_danger` int(0) NULL DEFAULT NULL COMMENT '1开启 2关闭 重大隐患', + `general_hidden_danger` int(0) NULL DEFAULT NULL COMMENT '1开启 2关闭 一般隐患', + `comment_type` int(0) NULL DEFAULT NULL COMMENT '1模糊评价 2打分评价', + `safety_id` int(0) NULL DEFAULT NULL COMMENT '安全报告模板 id', + `device_template_id` int(0) NULL DEFAULT NULL COMMENT '设备模板id', + `project_num` int(0) NULL DEFAULT NULL COMMENT '项目总数', + `under_construction_project` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '在建项目json', + `asset_project` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '资产项目json', + `permission_client` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '委托方权限 ，拼接', + `permission_project` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '项目方权限 ，拼接', + PRIMARY KEY (`id`) USING BTREE, + INDEX `client_id`(`client_id`) USING BTREE, + CONSTRAINT `client_param_ibfk_1` FOREIGN KEY (`client_id`) REFERENCES `client` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT +) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; + +-- ---------------------------- +-- Table structure for construction_license_file +-- ---------------------------- +DROP TABLE IF EXISTS `construction_license_file`; +CREATE TABLE `construction_license_file` ( + `project_id` int(0) NOT NULL COMMENT '项目ID', + `user_file_id` int(0) NOT NULL COMMENT '文件ID', + INDEX `FKtjy6tqoern01dq631bkgxepug`(`user_file_id`) USING BTREE, + INDEX `FKw1g7lhtc4bbt0xoti3mucfgj`(`project_id`) USING BTREE, + CONSTRAINT `construction_license_file_ibfk_1` FOREIGN KEY (`user_file_id`) REFERENCES `user_file` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, + CONSTRAINT `construction_license_file_ibfk_2` FOREIGN KEY (`project_id`) REFERENCES `project` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '施工许可证文件关联表' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for contract +-- ---------------------------- +DROP TABLE IF EXISTS `contract`; +CREATE TABLE `contract` ( + `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键ID', + `create_time` datetime(6) NOT NULL COMMENT '创建时间', + `deleted` bit(1) NOT NULL COMMENT '是否删除', + `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '合同编号', + `update_time` datetime(6) NOT NULL COMMENT '更新时间', + `state` int(0) NOT NULL COMMENT '合同状态：1-未开始 2-进行中 3-已完成 4-已终止', + `creator_id` int(0) NULL DEFAULT NULL COMMENT '创建者ID', + `client_id` int(0) NULL DEFAULT NULL COMMENT '委托方ID', + `contract_file_id` int(0) NULL DEFAULT NULL COMMENT '合同文件ID', + `tech_service_file_id` int(0) NULL DEFAULT NULL COMMENT '技术服务文件ID', + PRIMARY KEY (`id`) USING BTREE, + UNIQUE INDEX `UK_4xyfavpqspaivrlw6ylc5wbs4`(`name`) USING BTREE, + INDEX `FKt85yrahvoxd2f2f3mwxkpq2jq`(`creator_id`) USING BTREE, + INDEX `FKlhq3p3xl25vvnfvyfc51ica0j`(`client_id`) USING BTREE, + INDEX `FKljstd7tyoxd6n3ggq0qh0fpkt`(`contract_file_id`) USING BTREE, + INDEX `FKqu6u668po8yitduuvub3lev62`(`tech_service_file_id`) USING BTREE, + CONSTRAINT `contract_ibfk_1` FOREIGN KEY (`client_id`) REFERENCES `client` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, + CONSTRAINT `contract_ibfk_2` FOREIGN KEY (`contract_file_id`) REFERENCES `user_file` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, + CONSTRAINT `contract_ibfk_3` FOREIGN KEY (`tech_service_file_id`) REFERENCES `user_file` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, + CONSTRAINT `contract_ibfk_4` FOREIGN KEY (`creator_id`) REFERENCES `user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT +) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '合同表' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for device +-- ---------------------------- +DROP TABLE IF EXISTS `device`; +CREATE TABLE `device` ( + `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键ID', + `create_time` datetime(6) NOT NULL COMMENT '创建时间', + `deleted` bit(1) NOT NULL COMMENT '是否删除', + `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '设备编号', + `update_time` datetime(6) NOT NULL COMMENT '更新时间', + `busy` bit(1) NOT NULL COMMENT '设备是否正在使用中', + `manufacturer_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '出厂编号', + `properties` json NULL COMMENT '设备详细信息（JSON格式）', + `type` int(0) NOT NULL COMMENT '设备类型：1-塔式起重机 2-施工升降机 3-物料提升机 4-桥式起重机 5-附着式升降脚手架 6-流动式起重机 7-高处作业吊篮 8-门式起重机 9-架桥机 10-其他', + `creator_id` int(0) NULL DEFAULT NULL COMMENT '创建者ID', + PRIMARY KEY (`id`) USING BTREE, + UNIQUE INDEX `UK_oesoxj95nuiic4anb0i5fh9b1`(`name`) USING BTREE, + INDEX `FKpa2an8lp73u1svyfchfmsohm1`(`creator_id`) USING BTREE, + CONSTRAINT `device_ibfk_1` FOREIGN KEY (`creator_id`) REFERENCES `user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT +) ENGINE = InnoDB AUTO_INCREMENT = 53 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '设备表' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for device_usage +-- ---------------------------- +DROP TABLE IF EXISTS `device_usage`; +CREATE TABLE `device_usage` ( + `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键ID', + `create_time` datetime(6) NOT NULL COMMENT '创建时间', + `deleted` bit(1) NOT NULL COMMENT '是否删除', + `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '名称', + `update_time` datetime(6) NOT NULL COMMENT '更新时间', + `properties` json NULL COMMENT '设备详细信息（JSON格式）', + `creator_id` int(0) NULL DEFAULT NULL COMMENT '创建者ID', + `device_id` int(0) NULL DEFAULT NULL COMMENT '设备ID', + `project_id` int(0) NULL DEFAULT NULL COMMENT '项目ID', + `disabled` bit(1) NOT NULL COMMENT '是否已移除', + PRIMARY KEY (`id`) USING BTREE, + UNIQUE INDEX `UK_risnh4etgheal92ohgocuexi9`(`name`) USING BTREE, + INDEX `FKf7jo6b85tn0tepcnxu51wsiwk`(`creator_id`) USING BTREE, + INDEX `FKlc8fv0cf3nn0qr74l42io3ubd`(`device_id`) USING BTREE, + INDEX `FKs5lx2he35l05e2x3gvqj3sa4o`(`project_id`) USING BTREE, + CONSTRAINT `device_usage_ibfk_1` FOREIGN KEY (`creator_id`) REFERENCES `user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, + CONSTRAINT `device_usage_ibfk_2` FOREIGN KEY (`device_id`) REFERENCES `device` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, + CONSTRAINT `device_usage_ibfk_3` FOREIGN KEY (`project_id`) REFERENCES `project` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT +) ENGINE = InnoDB AUTO_INCREMENT = 94 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '设备使用记录表' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for error_review +-- ---------------------------- +DROP TABLE IF EXISTS `error_review`; +CREATE TABLE `error_review` ( + `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键ID', + `create_time` datetime(6) NOT NULL COMMENT '创建时间', + `deleted` bit(1) NOT NULL COMMENT '是否删除', + `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '名称', + `update_time` datetime(6) NOT NULL COMMENT '更新时间', + `content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '复核意见', + `state` int(0) NOT NULL COMMENT '复核结果：1-未整改 2-部分整改 3-已整改', + `creator_id` int(0) NULL DEFAULT NULL COMMENT '创建者ID', + PRIMARY KEY (`id`) USING BTREE, + UNIQUE INDEX `UK_rcij19manaa6ynkd9p5ose05e`(`name`) USING BTREE, + INDEX `FKbj82xe5i7033bg2xjbyogs98b`(`creator_id`) USING BTREE, + CONSTRAINT `FKbj82xe5i7033bg2xjbyogs98b` FOREIGN KEY (`creator_id`) REFERENCES `user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT +) ENGINE = InnoDB AUTO_INCREMENT = 2574 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '错误审查表' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for error_review_image +-- ---------------------------- +DROP TABLE IF EXISTS `error_review_image`; +CREATE TABLE `error_review_image` ( + `error_review_id` int(0) NOT NULL COMMENT '错误审查ID', + `user_file_id` int(0) NOT NULL COMMENT '文件ID', + INDEX `FKjga6a7or42ue16xk4tcv78tv3`(`user_file_id`) USING BTREE, + INDEX `FKqpky7kcbmpwrc35fmxua71ysp`(`error_review_id`) USING BTREE, + CONSTRAINT `FKjga6a7or42ue16xk4tcv78tv3` FOREIGN KEY (`user_file_id`) REFERENCES `user_file` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, + CONSTRAINT `FKqpky7kcbmpwrc35fmxua71ysp` FOREIGN KEY (`error_review_id`) REFERENCES `error_review` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '错误审查图片关联表' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for eval_result +-- ---------------------------- +DROP TABLE IF EXISTS `eval_result`; +CREATE TABLE `eval_result` ( + `type` varchar(31) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '评估类型：score-打分评估 fuzzy-模糊评估', + `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键ID', + `create_time` datetime(6) NOT NULL COMMENT '创建时间', + `deleted` bit(1) NOT NULL COMMENT '是否删除', + `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '名称', + `update_time` datetime(6) NOT NULL COMMENT '更新时间', + `contain_device_res` bit(1) NOT NULL COMMENT '是否包含设备评分', + `contain_system_res` bit(1) NOT NULL COMMENT '是否包含综合体系评分', + `display_score` float NOT NULL COMMENT '用于地图显示的矫正分数', + `score` float NOT NULL COMMENT '实际评分', + `device_res_map` json NULL COMMENT '设备评分结果（JSON格式）', + `risk_level` int(0) NULL DEFAULT NULL COMMENT '风险等级：0-拒绝接受风险 1-不可接受风险 2-重大风险 3-中等风险 4-可接受风险', + `system_res` json NULL COMMENT '综合体系评分结果（JSON格式）', + `creator_id` int(0) NULL DEFAULT NULL COMMENT '创建者ID', + `client_id` int(0) NULL DEFAULT NULL COMMENT '委托方ID（冗余字段）', + `plan_id` int(0) NULL DEFAULT NULL COMMENT '计划ID（冗余字段）', + `project_id` int(0) NULL DEFAULT NULL COMMENT '项目ID（冗余字段）', + `check_task_id` int(0) NOT NULL COMMENT '检查任务ID', + `error_counts` json NULL COMMENT '错误统计（JSON格式）', + PRIMARY KEY (`id`) USING BTREE, + UNIQUE INDEX `UK_pvvf72shhq9t6wlm2y02rcfvu`(`name`) USING BTREE, + INDEX `FKsxrkk98w6vsle4pjyj282rm3r`(`creator_id`) USING BTREE, + INDEX `FK50cx9yxu41kv538ovr472ory0`(`client_id`) USING BTREE, + INDEX `FKmx4j23v4yddpfbrse346cc173`(`plan_id`) USING BTREE, + INDEX `FKmmxpnlrqt6uif3xdaix984ja2`(`project_id`) USING BTREE, + INDEX `FKp6epfx7f3h9vopntaebfrxirk`(`check_task_id`) USING BTREE, + CONSTRAINT `FK50cx9yxu41kv538ovr472ory0` FOREIGN KEY (`client_id`) REFERENCES `client` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, + CONSTRAINT `FKmmxpnlrqt6uif3xdaix984ja2` FOREIGN KEY (`project_id`) REFERENCES `project` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, + CONSTRAINT `FKmx4j23v4yddpfbrse346cc173` FOREIGN KEY (`plan_id`) REFERENCES `plan` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, + CONSTRAINT `FKp6epfx7f3h9vopntaebfrxirk` FOREIGN KEY (`check_task_id`) REFERENCES `task` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, + CONSTRAINT `FKsxrkk98w6vsle4pjyj282rm3r` FOREIGN KEY (`creator_id`) REFERENCES `user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT +) ENGINE = InnoDB AUTO_INCREMENT = 2085 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '评估结果表' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for expert +-- ---------------------------- +DROP TABLE IF EXISTS `expert`; +CREATE TABLE `expert` ( + `type` varchar(31) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '专家类型：system-综合体系专家 device-设备专家', + `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键ID', + `create_time` datetime(6) NOT NULL COMMENT '创建时间', + `deleted` bit(1) NOT NULL COMMENT '是否删除', + `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '专家名称', + `update_time` datetime(6) NOT NULL COMMENT '更新时间', + `compare_matrix_map` json NULL COMMENT '比较矩阵集合（JSON格式）', + `contact` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '联系方式', + `expert_funcs` json NULL COMMENT '专家功能列表（JSON格式）', + `expert_inquiry_weight` float NULL DEFAULT NULL COMMENT '专家调查权重', + `matrix_weight` float NULL DEFAULT NULL COMMENT '矩阵权重', + `membership_weight` float NULL DEFAULT NULL COMMENT '隶属度权重', + `weight_map` json NULL COMMENT '权重表（JSON格式）', + `creator_id` int(0) NULL DEFAULT NULL COMMENT '创建者ID', + `membership_matrix_id` int(0) NULL DEFAULT NULL COMMENT '隶属度矩阵ID', + `device_model_id` int(0) NULL DEFAULT NULL COMMENT '设备模型ID', + `system_model_id` int(0) NULL DEFAULT NULL COMMENT '综合体系模型ID', + PRIMARY KEY (`id`) USING BTREE, + UNIQUE INDEX `UK_nn0irsspkqqc6a8fdk3pbfbej`(`name`) USING BTREE, + INDEX `FKlx2hiineui1kd9u7ehabsjbfy`(`creator_id`) USING BTREE, + INDEX `FKungoupq4ywxpme0ke1v9uwlf`(`membership_matrix_id`) USING BTREE, + INDEX `FK3anr57vcf9w523tiaej9qda2r`(`device_model_id`) USING BTREE, + INDEX `FKswugknhc8seixy6n8bieuw5oo`(`system_model_id`) USING BTREE, + CONSTRAINT `FK3anr57vcf9w523tiaej9qda2r` FOREIGN KEY (`device_model_id`) REFERENCES `model` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, + CONSTRAINT `FKlx2hiineui1kd9u7ehabsjbfy` FOREIGN KEY (`creator_id`) REFERENCES `user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, + CONSTRAINT `FKswugknhc8seixy6n8bieuw5oo` FOREIGN KEY (`system_model_id`) REFERENCES `model` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, + CONSTRAINT `FKungoupq4ywxpme0ke1v9uwlf` FOREIGN KEY (`membership_matrix_id`) REFERENCES `membership_matrix` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT +) ENGINE = InnoDB AUTO_INCREMENT = 34 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '专家表' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for hierarchy +-- ---------------------------- +DROP TABLE IF EXISTS `hierarchy`; +CREATE TABLE `hierarchy` ( + `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键ID', + `create_time` datetime(6) NOT NULL COMMENT '创建时间', + `deleted` bit(1) NOT NULL COMMENT '是否删除', + `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '层级名称', + `update_time` datetime(6) NOT NULL COMMENT '更新时间', + `content` json NULL COMMENT '层级树形数据（JSON格式）', + `creator_id` int(0) NULL DEFAULT NULL COMMENT '创建者ID', + PRIMARY KEY (`id`) USING BTREE, + UNIQUE INDEX `UK_p2ds8knyy984vrax9qmg7pu4p`(`name`) USING BTREE, + INDEX `FKnrhe2n80u00c7d0n9f0s4igh9`(`creator_id`) USING BTREE, + CONSTRAINT `FKnrhe2n80u00c7d0n9f0s4igh9` FOREIGN KEY (`creator_id`) REFERENCES `user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT +) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '层级表' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for measure_rule +-- ---------------------------- +DROP TABLE IF EXISTS `measure_rule`; +CREATE TABLE `measure_rule` ( + `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键ID', + `create_time` datetime(6) NOT NULL COMMENT '创建时间', + `deleted` bit(1) NOT NULL COMMENT '是否删除', + `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '规则编号', + `update_time` datetime(6) NOT NULL COMMENT '更新时间', + `measure_expr1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '评判标准', + `measure_expr2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '爆版值', + `measure_point` float NOT NULL COMMENT '检测点', + `measure_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '测量类别', + `creator_id` int(0) NULL DEFAULT NULL COMMENT '创建者ID', + `hierarchy_id` int(0) NOT NULL COMMENT '层级ID', + `hierarchy_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '层级路径', + `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '描述', + PRIMARY KEY (`id`) USING BTREE, + UNIQUE INDEX `UK_66fx7flf9rmkchxhn3aldbxe5`(`name`) USING BTREE, + INDEX `FK4tdy8vdwmxcwwwwxhgdbdb287`(`creator_id`) USING BTREE, + CONSTRAINT `FK4tdy8vdwmxcwwwwxhgdbdb287` FOREIGN KEY (`creator_id`) REFERENCES `user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT +) ENGINE = InnoDB AUTO_INCREMENT = 1420 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '测量规则表' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for membership_matrix +-- ---------------------------- +DROP TABLE IF EXISTS `membership_matrix`; +CREATE TABLE `membership_matrix` ( + `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键ID', + `data` json NULL COMMENT '隶属度矩阵数据（JSON格式）', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB AUTO_INCREMENT = 34 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '隶属度矩阵表' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for model +-- ---------------------------- +DROP TABLE IF EXISTS `model`; +CREATE TABLE `model` ( + `type` varchar(31) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '模型类型：system-综合体系模型 device-设备体系模型 measure-实测实量模型', + `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键ID', + `create_time` datetime(6) NOT NULL COMMENT '创建时间', + `deleted` bit(1) NOT NULL COMMENT '是否删除', + `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '模型名称', + `update_time` datetime(6) NOT NULL COMMENT '更新时间', + `version` int(0) NOT NULL COMMENT '版本号', + `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '描述', + `enable` bit(1) NULL DEFAULT NULL COMMENT '是否启用', + `published` bit(1) NULL DEFAULT NULL COMMENT '是否已发布', + `hierarchy_paths` json NULL COMMENT '层级路径列表（JSON格式）', + `problem_ids` json NULL COMMENT '问题ID列表（JSON格式）', + `creator_id` int(0) NULL DEFAULT NULL COMMENT '创建者ID', + `hierarchy_id` int(0) NULL DEFAULT NULL COMMENT '层级ID', + PRIMARY KEY (`id`) USING BTREE, + UNIQUE INDEX `UK_ca0u5wgwbvi61aty72boerxqy`(`name`) USING BTREE, + INDEX `FKlmo1yhgm2ds20qug7ekmo4nrl`(`creator_id`) USING BTREE, + INDEX `FKiug9cjmmidgfbhkpl0y97xo7s`(`hierarchy_id`) USING BTREE, + CONSTRAINT `FKiug9cjmmidgfbhkpl0y97xo7s` FOREIGN KEY (`hierarchy_id`) REFERENCES `hierarchy` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, + CONSTRAINT `FKlmo1yhgm2ds20qug7ekmo4nrl` FOREIGN KEY (`creator_id`) REFERENCES `user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT +) ENGINE = InnoDB AUTO_INCREMENT = 15 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '模型表' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for on_duty +-- ---------------------------- +DROP TABLE IF EXISTS `on_duty`; +CREATE TABLE `on_duty` ( + `id` int(0) NOT NULL AUTO_INCREMENT, + `plan_id` int(0) NULL DEFAULT NULL COMMENT '计划id', + `project_id` int(0) NULL DEFAULT NULL COMMENT '项目id', + `client_id` int(0) NULL DEFAULT NULL COMMENT '委托方id', + `content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '人员在岗', + `position_id` int(0) NULL DEFAULT NULL COMMENT '岗位id', + `position_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '岗位名称', + `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '问题备注', + `img` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '图片', + `time` date NULL DEFAULT NULL COMMENT '检查时间', + `state` int(0) NULL DEFAULT NULL COMMENT '1在岗 2未在岗 3请假', + `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间', + PRIMARY KEY (`id`) USING BTREE, + INDEX `plan_id`(`plan_id`) USING BTREE, + CONSTRAINT `on_duty_ibfk_1` FOREIGN KEY (`plan_id`) REFERENCES `plan` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT +) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '在岗情况' ROW_FORMAT = Dynamic; + +-- ---------------------------- +-- Table structure for plan +-- ---------------------------- +DROP TABLE IF EXISTS `plan`; +CREATE TABLE `plan` ( + `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键ID', + `create_time` datetime(6) NOT NULL COMMENT '创建时间', + `deleted` bit(1) NOT NULL COMMENT '是否删除', + `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '计划名称', + `update_time` datetime(6) NOT NULL COMMENT '更新时间', + `completed_time` datetime(6) NULL DEFAULT NULL COMMENT '完成时间', + `state` int(0) NOT NULL COMMENT '计划状态：1-已发布 2-执行中 3-计划完成', + `type` int(0) NULL DEFAULT NULL COMMENT '计划类型：1-安全检查 2-质量检查 3-综合检查 4-设备检查 5-运营检查', + `creator_id` int(0) NULL DEFAULT NULL COMMENT '创建者ID', + `client_id` int(0) NULL DEFAULT NULL COMMENT '委托方ID', + `device_fuzzy_math_id` int(0) NULL DEFAULT NULL COMMENT '设备模糊数学专家ID', + `device_model_id` int(0) NULL DEFAULT NULL COMMENT '设备体系模型ID', + `device_score_expert_id` int(0) NULL DEFAULT NULL COMMENT '设备打分表专家ID', + `system_fuzzy_expert_id` int(0) NULL DEFAULT NULL COMMENT '综合体系模糊数学专家ID', + `system_model_id` int(0) NULL DEFAULT NULL COMMENT '综合体系模型ID', + `system_score_expert_id` int(0) NULL DEFAULT NULL COMMENT '综合体系打分表专家ID', + `project_id` int(0) NULL DEFAULT NULL COMMENT '项目ID', + PRIMARY KEY (`id`) USING BTREE, + UNIQUE INDEX `UK_rj3sbkfpr08prx7c5h7fm0ir8`(`name`) USING BTREE, + INDEX `FKk77raqf4hu0rrvgs2bkvxwwt`(`creator_id`) USING BTREE, + INDEX `FK5jc3u76cf23uhajupswc1d1ir`(`client_id`) USING BTREE, + INDEX `FK9hp0xbmgbmtns86ifnfosqhw1`(`device_fuzzy_math_id`) USING BTREE, + INDEX `FK52krnp00vmennnr6avwvks63b`(`device_model_id`) USING BTREE, + INDEX `FKmn7fu3bll0khcspn3jivsgulo`(`device_score_expert_id`) USING BTREE, + INDEX `FK4iwyrpkuykfgv7w1v50b8vtc4`(`system_fuzzy_expert_id`) USING BTREE, + INDEX `FKnwo1cmw034llxwt1t2f7rw4dv`(`system_model_id`) USING BTREE, + INDEX `FK4hq77ahv6o8xdy0q0tam0pr6s`(`system_score_expert_id`) USING BTREE, + INDEX `FKmcne7qnx1nd4tabjmdfci2bwk`(`project_id`) USING BTREE, + CONSTRAINT `FK4hq77ahv6o8xdy0q0tam0pr6s` FOREIGN KEY (`system_score_expert_id`) REFERENCES `expert` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, + CONSTRAINT `FK4iwyrpkuykfgv7w1v50b8vtc4` FOREIGN KEY (`system_fuzzy_expert_id`) REFERENCES `expert` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, + CONSTRAINT `FK52krnp00vmennnr6avwvks63b` FOREIGN KEY (`device_model_id`) REFERENCES `model` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, + CONSTRAINT `FK5jc3u76cf23uhajupswc1d1ir` FOREIGN KEY (`client_id`) REFERENCES `client` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, + CONSTRAINT `FK9hp0xbmgbmtns86ifnfosqhw1` FOREIGN KEY (`device_fuzzy_math_id`) REFERENCES `expert` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, + CONSTRAINT `FKk77raqf4hu0rrvgs2bkvxwwt` FOREIGN KEY (`creator_id`) REFERENCES `user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, + CONSTRAINT `FKmcne7qnx1nd4tabjmdfci2bwk` FOREIGN KEY (`project_id`) REFERENCES `project` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, + CONSTRAINT `FKmn7fu3bll0khcspn3jivsgulo` FOREIGN KEY (`device_score_expert_id`) REFERENCES `expert` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, + CONSTRAINT `FKnwo1cmw034llxwt1t2f7rw4dv` FOREIGN KEY (`system_model_id`) REFERENCES `model` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT +) ENGINE = InnoDB AUTO_INCREMENT = 82 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '计划表' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for position +-- ---------------------------- +DROP TABLE IF EXISTS `position`; +CREATE TABLE `position` ( + `id` int(0) NOT NULL AUTO_INCREMENT, + `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '岗位名称', + `creator_id` int(0) NULL DEFAULT NULL, + `deleted` bit(1) NULL DEFAULT NULL COMMENT 'false正常true删除', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '岗位设置' ROW_FORMAT = Dynamic; + +-- ---------------------------- +-- Table structure for problem +-- ---------------------------- +DROP TABLE IF EXISTS `problem`; +CREATE TABLE `problem` ( + `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键ID', + `create_time` datetime(6) NOT NULL COMMENT '创建时间', + `deleted` bit(1) NOT NULL COMMENT '是否删除', + `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '问题名称', + `update_time` datetime(6) NOT NULL COMMENT '更新时间', + `correct_practice` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '正确做法', + `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '问题描述', + `hierarchy_id` int(0) NOT NULL COMMENT '层级ID', + `hierarchy_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '层级路径', + `incident_types` json NULL COMMENT '事故类型列表（JSON格式）', + `num_value` float NULL DEFAULT NULL COMMENT '数值', + `number_factors` json NULL COMMENT '数量系数列表（JSON格式）', + `responsible_department` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '责任部门', + `responsible_person` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '责任人', + `review_paradigm` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '复查范例', + `scale_factors` json NULL COMMENT '规模系数列表（JSON格式）', + `specific_terms` json NULL COMMENT '具体条款列表（JSON格式）', + `suggest_actions` json NULL COMMENT '建议行动列表（JSON格式）', + `creator_id` int(0) NULL DEFAULT NULL COMMENT '创建者ID', + `incident_case_file_id` int(0) NULL DEFAULT NULL COMMENT '事故案例文件ID', + PRIMARY KEY (`id`) USING BTREE, + UNIQUE INDEX `UK_qg87jy9l8hwkmuc1e8e4nvuo`(`name`) USING BTREE, + INDEX `FKdmhuth1edc7lnr5577oi9xs82`(`creator_id`) USING BTREE, + INDEX `FKju5rr4lpeukbj1aixpf0dhrix`(`incident_case_file_id`) USING BTREE, + CONSTRAINT `FKdmhuth1edc7lnr5577oi9xs82` FOREIGN KEY (`creator_id`) REFERENCES `user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, + CONSTRAINT `FKju5rr4lpeukbj1aixpf0dhrix` FOREIGN KEY (`incident_case_file_id`) REFERENCES `user_file` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT +) ENGINE = InnoDB AUTO_INCREMENT = 12590 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '问题表' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for project +-- ---------------------------- +DROP TABLE IF EXISTS `project`; +CREATE TABLE `project` ( + `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键ID', + `create_time` datetime(6) NOT NULL COMMENT '创建时间', + `deleted` bit(1) NOT NULL COMMENT '是否删除', + `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '项目名称', + `update_time` datetime(6) NOT NULL COMMENT '更新时间', + `address_info` json NULL COMMENT '地址信息（JSON格式）', + `branch_company` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '所属分公司', + `construction_company_info` json NULL COMMENT '施工单位信息（JSON格式）', + `construction_license` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '施工许可证号', + `department_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '部门路径', + `development_company_info` json NULL COMMENT '建设公司信息（JSON格式）', + `item_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '项目编号', + `project_cost` int(0) NULL DEFAULT NULL COMMENT '工程造价（元）', + `supervisor_company_info` json NULL COMMENT '监理公司信息（JSON格式）', + `type` int(0) NOT NULL COMMENT '项目类型：1-房建 2-市政 3-建筑工程等', + `usage_type` int(0) NOT NULL COMMENT '项目用途类型', + `creator_id` int(0) NULL DEFAULT NULL COMMENT '创建者ID', + `client_id` int(0) NULL DEFAULT NULL COMMENT '委托方ID', + `permission` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '权限信息（拼接）', + `scale` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '项目规模', + `status` int(0) NULL DEFAULT 1 COMMENT '状态：1-在建 2-完成', + `success_time` datetime(0) NULL DEFAULT NULL COMMENT '完成时间', + PRIMARY KEY (`id`) USING BTREE, + UNIQUE INDEX `UK_3k75vvu7mevyvvb5may5lj8k7`(`name`) USING BTREE, + INDEX `FKoc22ltfbv8myeewvtm5j7q0dg`(`creator_id`) USING BTREE, + INDEX `FK8nw995uro0115f1go0dmrtn2d`(`client_id`) USING BTREE, + CONSTRAINT `FK8nw995uro0115f1go0dmrtn2d` FOREIGN KEY (`client_id`) REFERENCES `client` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, + CONSTRAINT `FKoc22ltfbv8myeewvtm5j7q0dg` FOREIGN KEY (`creator_id`) REFERENCES `user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT +) ENGINE = InnoDB AUTO_INCREMENT = 902 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '项目表' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for project_info +-- ---------------------------- +DROP TABLE IF EXISTS `project_info`; +CREATE TABLE `project_info` ( + `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键ID', + `create_time` datetime(6) NOT NULL COMMENT '创建时间', + `deleted` bit(1) NOT NULL COMMENT '是否删除', + `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '名称', + `update_time` datetime(6) NOT NULL COMMENT '更新时间', + `dangerous_options` json NULL COMMENT '危大工程选项（JSON格式）', + `detail` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '项目详情', + `progress` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '项目进展', + `progress_this_season` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '近一季度施工进展情况', + `super_dangerous_options` json NULL COMMENT '超大危工程选项（JSON格式）', + `hazard_source` json NULL COMMENT '风险源（JSON格式）', + `update_date` date NOT NULL COMMENT '更新日期', + `creator_id` int(0) NULL DEFAULT NULL COMMENT '创建者ID', + `check_task_id` int(0) NULL DEFAULT NULL COMMENT '检查任务ID', + `project_id` int(0) NULL DEFAULT NULL COMMENT '项目ID', + `hazard_source_types` json NULL COMMENT '风险源类型（JSON格式）', + PRIMARY KEY (`id`) USING BTREE, + UNIQUE INDEX `UK_4hxmp6gcsjxhybpkneuyl6gks`(`name`) USING BTREE, + INDEX `FK7dr0i9tutuo4cmaw98ocdrj1u`(`creator_id`) USING BTREE, + INDEX `FK74s6tpmoroc2dug27iu3u20wk`(`check_task_id`) USING BTREE, + INDEX `FKs1uef3fl2ftkgkjk8dmihrxjj`(`project_id`) USING BTREE, + CONSTRAINT `FK74s6tpmoroc2dug27iu3u20wk` FOREIGN KEY (`check_task_id`) REFERENCES `task` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, + CONSTRAINT `FK7dr0i9tutuo4cmaw98ocdrj1u` FOREIGN KEY (`creator_id`) REFERENCES `user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, + CONSTRAINT `FKs1uef3fl2ftkgkjk8dmihrxjj` FOREIGN KEY (`project_id`) REFERENCES `project` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT +) ENGINE = InnoDB AUTO_INCREMENT = 124 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '项目信息表' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for record +-- ---------------------------- +DROP TABLE IF EXISTS `record`; +CREATE TABLE `record` ( + `record_type` varchar(31) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '记录类型：error-错误记录 warning-警告记录 info-信息记录', + `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键ID', + `create_time` datetime(6) NOT NULL COMMENT '创建时间', + `deleted` bit(1) NOT NULL COMMENT '是否删除', + `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '名称', + `update_time` datetime(6) NOT NULL COMMENT '更新时间', + `hierarchy_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '检查内容（冗余字段）', + `hierarchy_names` json NULL COMMENT '层级名称集合（JSON格式）', + `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '问题备注', + `level` int(0) NULL DEFAULT NULL COMMENT '隐患等级：1-一级隐患 2-二级隐患 3-三级隐患 4-四级隐患', + `number_factor_index` int(0) NULL DEFAULT NULL COMMENT '数量系数索引', + `problem_part` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '问题部位', + `reformed` bit(1) NULL DEFAULT NULL COMMENT '是否已整改', + `scale_factor_index` int(0) NULL DEFAULT NULL COMMENT '规模系数索引', + `specific_term_indexes` json NULL COMMENT '具体条款索引（JSON格式）', + `suggestion` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '建议', + `hierarchy_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '层级路径', + `content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '内容', + `creator_id` int(0) NULL DEFAULT NULL COMMENT '创建者ID', + `check_task_id` int(0) NULL DEFAULT NULL COMMENT '检查任务ID', + `device_id` int(0) NULL DEFAULT NULL COMMENT '相关设备ID', + `problem_id` int(0) NULL DEFAULT NULL COMMENT '问题ID', + `error_review_id` int(0) NULL DEFAULT NULL COMMENT '错误审查ID', + `responsible_person` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '责任人', + PRIMARY KEY (`id`) USING BTREE, + UNIQUE INDEX `UK_9jxn0ikujw88oo4md3yt02tuw`(`name`) USING BTREE, + INDEX `FKq4py9r62jhdnv5ke76vujra6i`(`creator_id`) USING BTREE, + INDEX `FKss3j0pm8hymss9hussprv3u23`(`check_task_id`) USING BTREE, + INDEX `FK2isgjgm4rxinal6vqaemvi633`(`device_id`) USING BTREE, + INDEX `FK5l7m0s96mld18cupctgipj71u`(`problem_id`) USING BTREE, + INDEX `FK4rnk48158vforifvox512cufw`(`error_review_id`) USING BTREE, + CONSTRAINT `FK2isgjgm4rxinal6vqaemvi633` FOREIGN KEY (`device_id`) REFERENCES `device` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, + CONSTRAINT `FK4rnk48158vforifvox512cufw` FOREIGN KEY (`error_review_id`) REFERENCES `error_review` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, + CONSTRAINT `FK5l7m0s96mld18cupctgipj71u` FOREIGN KEY (`problem_id`) REFERENCES `problem` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, + CONSTRAINT `FKq4py9r62jhdnv5ke76vujra6i` FOREIGN KEY (`creator_id`) REFERENCES `user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, + CONSTRAINT `FKss3j0pm8hymss9hussprv3u23` FOREIGN KEY (`check_task_id`) REFERENCES `task` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT +) ENGINE = InnoDB AUTO_INCREMENT = 35473 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '检查记录表' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for record_image +-- ---------------------------- +DROP TABLE IF EXISTS `record_image`; +CREATE TABLE `record_image` ( + `record_id` int(0) NOT NULL COMMENT '记录ID', + `user_file_id` int(0) NOT NULL COMMENT '文件ID', + INDEX `FKtelm8dofokba2238o81rl3cqc`(`user_file_id`) USING BTREE, + INDEX `FKp69h59oc52348scaouvoh9uxc`(`record_id`) USING BTREE, + CONSTRAINT `FKp69h59oc52348scaouvoh9uxc` FOREIGN KEY (`record_id`) REFERENCES `record` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, + CONSTRAINT `FKtelm8dofokba2238o81rl3cqc` FOREIGN KEY (`user_file_id`) REFERENCES `user_file` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '检查记录图片关联表' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for report_template +-- ---------------------------- +DROP TABLE IF EXISTS `report_template`; +CREATE TABLE `report_template` ( + `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键ID', + `create_time` datetime(6) NOT NULL COMMENT '创建时间', + `deleted` bit(1) NOT NULL COMMENT '是否删除', + `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '模板名称', + `update_time` datetime(6) NOT NULL COMMENT '更新时间', + `config` json NULL COMMENT '模板配置（JSON格式）', + `number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '报告模板编号', + `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注', + `sub_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '模板子编号', + `type` int(0) NOT NULL COMMENT '类型：1-第三方评估报告 2-设备风险评估报告', + `creator_id` int(0) NULL DEFAULT NULL COMMENT '创建者ID', + PRIMARY KEY (`id`) USING BTREE, + UNIQUE INDEX `UK_89qb90hrav5wfas34webrhntv`(`name`) USING BTREE, + INDEX `FKrelffikjlulwjl6u0n77lcip3`(`creator_id`) USING BTREE, + CONSTRAINT `FKrelffikjlulwjl6u0n77lcip3` FOREIGN KEY (`creator_id`) REFERENCES `user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT +) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '报告模板表' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for role +-- ---------------------------- +DROP TABLE IF EXISTS `role`; +CREATE TABLE `role` ( + `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键ID', + `create_time` datetime(6) NOT NULL COMMENT '创建时间', + `deleted` bit(1) NOT NULL COMMENT '是否删除', + `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '角色名称', + `update_time` datetime(6) NOT NULL COMMENT '更新时间', + `permission_ids` json NULL COMMENT '权限ID列表（JSON格式）', + `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注', + `creator_id` int(0) NULL DEFAULT NULL COMMENT '创建者ID', + PRIMARY KEY (`id`) USING BTREE, + UNIQUE INDEX `UK_8sewwnpamngi6b1dwaa88askk`(`name`) USING BTREE, + INDEX `FKgiycbu32u3ohnrmlp1xpl7bh4`(`creator_id`) USING BTREE, + CONSTRAINT `FKgiycbu32u3ohnrmlp1xpl7bh4` FOREIGN KEY (`creator_id`) REFERENCES `user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT +) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '角色表' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for screen_account +-- ---------------------------- +DROP TABLE IF EXISTS `screen_account`; +CREATE TABLE `screen_account` ( + `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键ID', + `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '姓名', + `type` int(0) NOT NULL COMMENT '类型：1-委托方 2-项目', + `state` int(0) NULL DEFAULT NULL COMMENT '状态：1-启用 2-关闭', + `deleted` bit(1) NULL DEFAULT NULL COMMENT '是否删除：false-正常 true-删除', + `create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间', + `creator_id` int(0) NULL DEFAULT NULL COMMENT '创建者ID', + `account` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '账号', + `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '密码', + `update_time` datetime(6) NOT NULL COMMENT '更新时间', + `client_project_ids` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '委托方/项目ID列表', + PRIMARY KEY (`id`) USING BTREE, + INDEX `FKp6hjs0nkx0cjars256fhi010l`(`creator_id`) USING BTREE, + CONSTRAINT `FKp6hjs0nkx0cjars256fhi010l` FOREIGN KEY (`creator_id`) REFERENCES `user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT +) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '智慧大屏账户表' ROW_FORMAT = Dynamic; + +-- ---------------------------- +-- Table structure for session +-- ---------------------------- +DROP TABLE IF EXISTS `session`; +CREATE TABLE `session` ( + `id` bigint(0) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '会话ID', + `create_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间', + `update_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间', + `status` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT 'enabled' COMMENT '状态：enabled-启用，disabled-禁用', + `session_id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '会话ID', + `agent_id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '智能体ID', + `user_id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '用户ID', + `ref_id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '引用ID', + `name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '会话名称', + `query` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '创建参数，JSON格式', + PRIMARY KEY (`id`) USING BTREE, + UNIQUE INDEX `idx_session_id`(`session_id`) USING BTREE, + INDEX `idx_agent_id`(`agent_id`) USING BTREE, + INDEX `idx_user_id`(`user_id`) USING BTREE, + INDEX `idx_status`(`status`) USING BTREE, + INDEX `idx_create_time`(`create_time`) USING BTREE +) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '会话表' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for sign_record +-- ---------------------------- +DROP TABLE IF EXISTS `sign_record`; +CREATE TABLE `sign_record` ( + `type` varchar(31) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '签到类型：work-工作签到 project-项目签到', + `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键ID', + `create_time` datetime(6) NOT NULL COMMENT '创建时间', + `deleted` bit(1) NOT NULL COMMENT '是否删除', + `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '名称', + `update_time` datetime(6) NOT NULL COMMENT '更新时间', + `gps` json NULL COMMENT '经纬度（JSON格式：[经度, 纬度]）', + `location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '地点信息', + `content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '签到内容', + `work_time_period` int(0) NULL DEFAULT NULL COMMENT '工作时段', + `work_type` int(0) NULL DEFAULT NULL COMMENT '工作类型', + `creator_id` int(0) NULL DEFAULT NULL COMMENT '创建者ID', + `project_id` int(0) NULL DEFAULT NULL COMMENT '项目ID', + PRIMARY KEY (`id`) USING BTREE, + UNIQUE INDEX `UK_hd63p3oy8vj6c9dc9oyrffqu7`(`name`) USING BTREE, + INDEX `FKr1g64j422ur1wgb272h1hbco2`(`creator_id`) USING BTREE, + INDEX `FKsmfkp26ygaqcnx77kvefsyeig`(`project_id`) USING BTREE, + CONSTRAINT `FKr1g64j422ur1wgb272h1hbco2` FOREIGN KEY (`creator_id`) REFERENCES `user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, + CONSTRAINT `FKsmfkp26ygaqcnx77kvefsyeig` FOREIGN KEY (`project_id`) REFERENCES `project` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT +) ENGINE = InnoDB AUTO_INCREMENT = 3306 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '签到记录表' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for sign_record_image +-- ---------------------------- +DROP TABLE IF EXISTS `sign_record_image`; +CREATE TABLE `sign_record_image` ( + `sign_record_id` int(0) NOT NULL COMMENT '签到记录ID', + `user_file_id` int(0) NOT NULL COMMENT '文件ID', + INDEX `FKlkuxxqn0gpfwat43mlct926iu`(`user_file_id`) USING BTREE, + INDEX `FKgvlp4so4q532gnbyofcviyoph`(`sign_record_id`) USING BTREE, + CONSTRAINT `FKgvlp4so4q532gnbyofcviyoph` FOREIGN KEY (`sign_record_id`) REFERENCES `sign_record` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, + CONSTRAINT `FKlkuxxqn0gpfwat43mlct926iu` FOREIGN KEY (`user_file_id`) REFERENCES `user_file` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '签到记录图片关联表' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for task +-- ---------------------------- +DROP TABLE IF EXISTS `task`; +CREATE TABLE `task` ( + `task_type` varchar(31) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '任务类型：check_task-检查任务 review-复查任务', + `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键ID', + `create_time` datetime(6) NOT NULL COMMENT '创建时间', + `deleted` bit(1) NOT NULL COMMENT '是否删除', + `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '任务名称', + `update_time` datetime(6) NOT NULL COMMENT '更新时间', + `assemble_place` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '集合地点', + `date` date NULL DEFAULT NULL COMMENT '任务日期', + `device_fuzzy_map` json NULL COMMENT '设备模糊评分结果（JSON格式）', + `device_score_map` json NULL COMMENT '设备打分结果（JSON格式）', + `gps` json NULL COMMENT '经纬度（JSON格式）', + `location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '地点信息', + `state` int(0) NULL DEFAULT NULL COMMENT '任务状态：1-未开始 2-已发布 3-执行中 4-已完成 5-已驳回 6-待复查 7-复查中 8-复查完成', + `system_fuzzy` float NULL DEFAULT NULL COMMENT '综合体系模糊评分', + `system_score` float NULL DEFAULT NULL COMMENT '综合体系打分', + `review_problems` json NULL COMMENT '复查问题列表（JSON格式）', + `creator_id` int(0) NULL DEFAULT NULL COMMENT '创建者ID', + `bypass_info_id` int(0) NULL DEFAULT NULL COMMENT '旁站信息ID', + `plan_id` int(0) NULL DEFAULT NULL COMMENT '计划ID', + `project_id` int(0) NULL DEFAULT NULL COMMENT '项目ID', + `review_task_id` int(0) NULL DEFAULT NULL COMMENT '复查任务ID', + `project_info_id` int(0) NULL DEFAULT NULL COMMENT '项目信息ID', + PRIMARY KEY (`id`) USING BTREE, + UNIQUE INDEX `UK_lerptdo9d67pejjpbfau899tm`(`name`) USING BTREE, + INDEX `FKqc1galw66ryn480v0lygu3n4c`(`creator_id`) USING BTREE, + INDEX `FKgt8kywda5laqlx131gtl2wv9f`(`bypass_info_id`) USING BTREE, + INDEX `FKgvvo2w30gq9wxnbi69rx4iqb4`(`plan_id`) USING BTREE, + INDEX `FKk8qrwowg31kx7hp93sru1pdqa`(`project_id`) USING BTREE, + INDEX `FKsweyei4dievip1irm2wje59a9`(`review_task_id`) USING BTREE, + INDEX `FK7k3v9vies3aqtvvkubj3h9456`(`project_info_id`) USING BTREE, + CONSTRAINT `FK7k3v9vies3aqtvvkubj3h9456` FOREIGN KEY (`project_info_id`) REFERENCES `project_info` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, + CONSTRAINT `FKgt8kywda5laqlx131gtl2wv9f` FOREIGN KEY (`bypass_info_id`) REFERENCES `by_pass_info` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, + CONSTRAINT `FKgvvo2w30gq9wxnbi69rx4iqb4` FOREIGN KEY (`plan_id`) REFERENCES `plan` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, + CONSTRAINT `FKk8qrwowg31kx7hp93sru1pdqa` FOREIGN KEY (`project_id`) REFERENCES `project` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, + CONSTRAINT `FKqc1galw66ryn480v0lygu3n4c` FOREIGN KEY (`creator_id`) REFERENCES `user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, + CONSTRAINT `FKsweyei4dievip1irm2wje59a9` FOREIGN KEY (`review_task_id`) REFERENCES `task` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT +) ENGINE = InnoDB AUTO_INCREMENT = 1263 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '任务表' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for task_car +-- ---------------------------- +DROP TABLE IF EXISTS `task_car`; +CREATE TABLE `task_car` ( + `task_id` int(0) NOT NULL COMMENT '任务ID', + `car_id` int(0) NOT NULL COMMENT '车辆ID', + INDEX `FK46bm8ddv675vmkd6txps4f8md`(`car_id`) USING BTREE, + INDEX `FKhl6gnd2keb7glrnr2y9cj8h3h`(`task_id`) USING BTREE, + CONSTRAINT `FK46bm8ddv675vmkd6txps4f8md` FOREIGN KEY (`car_id`) REFERENCES `car` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, + CONSTRAINT `FKhl6gnd2keb7glrnr2y9cj8h3h` FOREIGN KEY (`task_id`) REFERENCES `task` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '任务车辆关联表' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for task_driver +-- ---------------------------- +DROP TABLE IF EXISTS `task_driver`; +CREATE TABLE `task_driver` ( + `task_id` int(0) NOT NULL COMMENT '任务ID', + `user_id` int(0) NOT NULL COMMENT '司机ID', + INDEX `FK43kbgq6w30xphantv9cuqsh1p`(`user_id`) USING BTREE, + INDEX `FK2cvt76kxt4quyywpmnfjkpu8n`(`task_id`) USING BTREE, + CONSTRAINT `FK2cvt76kxt4quyywpmnfjkpu8n` FOREIGN KEY (`task_id`) REFERENCES `task` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, + CONSTRAINT `FK43kbgq6w30xphantv9cuqsh1p` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '任务司机关联表' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for task_group_leader +-- ---------------------------- +DROP TABLE IF EXISTS `task_group_leader`; +CREATE TABLE `task_group_leader` ( + `task_id` int(0) NOT NULL COMMENT '任务ID', + `user_id` int(0) NOT NULL COMMENT '组长ID', + PRIMARY KEY (`task_id`, `user_id`) USING BTREE, + INDEX `FK29yiewul0bi1uo1pvvqlb1pv4`(`user_id`) USING BTREE, + CONSTRAINT `FK29yiewul0bi1uo1pvvqlb1pv4` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, + CONSTRAINT `FKo80bmutd566yl2qy0vblx0on8` FOREIGN KEY (`task_id`) REFERENCES `task` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '任务组长关联表' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for task_group_member +-- ---------------------------- +DROP TABLE IF EXISTS `task_group_member`; +CREATE TABLE `task_group_member` ( + `task_id` int(0) NOT NULL COMMENT '任务ID', + `user_id` int(0) NOT NULL COMMENT '组员ID', + PRIMARY KEY (`task_id`, `user_id`) USING BTREE, + INDEX `FKm5opb525qw5w6coskbr8qfbbw`(`user_id`) USING BTREE, + CONSTRAINT `FKfbvifxik68r3n6hiyehu7fjmc` FOREIGN KEY (`task_id`) REFERENCES `task` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, + CONSTRAINT `FKm5opb525qw5w6coskbr8qfbbw` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '任务组员关联表' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for user +-- ---------------------------- +DROP TABLE IF EXISTS `user`; +CREATE TABLE `user` ( + `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键ID', + `create_time` datetime(6) NOT NULL COMMENT '创建时间', + `deleted` bit(1) NOT NULL COMMENT '是否删除', + `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '用户名', + `update_time` datetime(6) NOT NULL COMMENT '更新时间', + `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '头像', + `department_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '部门路径', + `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '邮箱', + `last_access_time` datetime(6) NULL DEFAULT NULL COMMENT '最后访问时间', + `mobile` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '手机号', + `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '密码', + `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注', + `role_id` int(0) NOT NULL COMMENT '角色ID', + `state` int(0) NOT NULL COMMENT '用户状态：1-正常 2-禁用', + `creator_id` int(0) NULL DEFAULT NULL COMMENT '创建者ID', + PRIMARY KEY (`id`) USING BTREE, + UNIQUE INDEX `UK_gj2fy3dcix7ph7k8684gka40c`(`name`) USING BTREE, + UNIQUE INDEX `UK_cnjwxx5favk5ycqajjt17fwy1`(`mobile`) USING BTREE, + INDEX `idx_name`(`name`) USING BTREE, + INDEX `idx_mobile`(`mobile`) USING BTREE, + INDEX `FKrlj77ymttuppjd3f7xvuk7x1q`(`creator_id`) USING BTREE, + CONSTRAINT `FKrlj77ymttuppjd3f7xvuk7x1q` FOREIGN KEY (`creator_id`) REFERENCES `user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT +) ENGINE = InnoDB AUTO_INCREMENT = 69 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '用户表' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for user_file +-- ---------------------------- +DROP TABLE IF EXISTS `user_file`; +CREATE TABLE `user_file` ( + `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键ID', + `create_time` datetime(6) NOT NULL COMMENT '创建时间', + `deleted` bit(1) NOT NULL COMMENT '是否删除', + `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '文件名', + `update_time` datetime(6) NOT NULL COMMENT '更新时间', + `content_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '文件类型', + `extension` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '文件扩展名', + `origin_file_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '原始文件名', + `size` bigint(0) NULL DEFAULT NULL COMMENT '文件大小', + `creator_id` int(0) NULL DEFAULT NULL COMMENT '创建者ID', + PRIMARY KEY (`id`) USING BTREE, + UNIQUE INDEX `UK_n6dbo8upfokee0smgnoa9rljs`(`name`) USING BTREE, + INDEX `FKkgl3n12kv8rhlu4yce9ekxbaa`(`creator_id`) USING BTREE, + CONSTRAINT `FKkgl3n12kv8rhlu4yce9ekxbaa` FOREIGN KEY (`creator_id`) REFERENCES `user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT +) ENGINE = InnoDB AUTO_INCREMENT = 14869 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '用户文件表' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for user_session +-- ---------------------------- +DROP TABLE IF EXISTS `user_session`; +CREATE TABLE `user_session` ( + `id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '主键ID', + `client_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '客户端代码', + `create_time` datetime(6) NOT NULL COMMENT '创建时间', + `device_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '设备代码', + `expire_time` datetime(6) NULL DEFAULT NULL COMMENT '过期时间', + `extra` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '额外信息', + `ip_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'IP地址', + `last_access_time` datetime(6) NOT NULL COMMENT '最后访问时间', + `state` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '会话状态', + `token` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '会话令牌', + `user_id` int(0) NULL DEFAULT NULL COMMENT '用户ID', + PRIMARY KEY (`id`) USING BTREE, + INDEX `idx_id_token`(`id`, `token`) USING BTREE, + INDEX `FKs2btlvdomqggby8a3dnlq98ks`(`user_id`) USING BTREE, + CONSTRAINT `FKs2btlvdomqggby8a3dnlq98ks` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT +) ENGINE = InnoDB AUTO_INCREMENT = 1398 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '用户会话表' ROW_FORMAT = DYNAMIC; + +-- ---------------------------- +-- Table structure for work_presentation +-- ---------------------------- +DROP TABLE IF EXISTS `work_presentation`; +CREATE TABLE `work_presentation` ( + `id` int(0) NOT NULL AUTO_INCREMENT, + `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '标题', + `type` int(0) NULL DEFAULT NULL COMMENT '工作类型', + `intro` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '简介', + `img` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '图片', + `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), + `state` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '1显示 2隐藏', + `client_id` int(0) NULL DEFAULT NULL COMMENT '委托方id', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; + +SET FOREIGN_KEY_CHECKS = 1; -- Gitblit v1.7.1