/*
|
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;
|
