Database ER Diagram

Added on: Feb 26, 2025
User Prompt

/*
Navicat Premium Data Transfer

Source Server : cbxrmyy
Source Server Type : MySQL
Source Server Version : 80036
Source Host : yaoyantech.com:3306
Source Schema : cbxrmyy

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

Date: 26/02/2025 19:12:55
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for t_department
-- ----------------------------
DROP TABLE IF EXISTS `t_department`;
CREATE TABLE `t_department` (
`department_id` bigint NOT NULL AUTO_INCREMENT COMMENT '部门主键id',
`name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '部门名称',
`manager_id` bigint NULL DEFAULT NULL COMMENT '部门负责人id',
`parent_id` bigint NOT NULL DEFAULT 0 COMMENT '部门的父级id',
`sort` int NOT NULL COMMENT '部门排序',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
PRIMARY KEY (`department_id`) USING BTREE,
INDEX `parent_id`(`parent_id` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 48 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '部门' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for t_employee
-- ----------------------------
DROP TABLE IF EXISTS `t_employee`;
CREATE TABLE `t_employee` (
`employee_id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
`login_name` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '登录帐号',
`login_pwd` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '登录密码',
`actual_name` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '员工名称',
`avatar` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
`gender` tinyint(1) NOT NULL DEFAULT 0 COMMENT '性别',
`phone` varchar(15) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '手机号码',
`department_id` int NOT NULL COMMENT '部门id',
`position_id` bigint NULL DEFAULT NULL COMMENT '职务ID',
`email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '邮箱',
`disabled_flag` tinyint UNSIGNED NOT NULL COMMENT '是否被禁用 0否1是',
`deleted_flag` tinyint UNSIGNED NOT NULL COMMENT '是否删除0否 1是',
`administrator_flag` tinyint NOT NULL DEFAULT 0 COMMENT '是否为超级管理员: 0 不是，1是',
`remark` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '备注',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
PRIMARY KEY (`employee_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 141 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '员工表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for t_file
-- ----------------------------
DROP TABLE IF EXISTS `t_file`;
CREATE TABLE `t_file` (
`file_id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`foreign_id` bigint NULL DEFAULT NULL COMMENT '外键ID[设备ID、维修申请ID等]',
`file_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '文件名称',
`file_size` int NULL DEFAULT NULL COMMENT '文件大小',
`file_key` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '文件key，用于文件下载',
`file_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '文件类型',
`creator_id` int NULL DEFAULT NULL COMMENT '创建人，即上传人',
`creator_user_type` int NULL DEFAULT NULL COMMENT '创建人用户类型',
`creator_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人姓名',
`update_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '上次更新时间',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`deleted_flag` tinyint(1) NOT NULL DEFAULT 0 COMMENT '删除状态',
`delete_user_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '删除人',
`delete_time` datetime NULL DEFAULT NULL COMMENT '删除时间',
`folder_type` int NULL DEFAULT NULL,
PRIMARY KEY (`file_id`) USING BTREE,
UNIQUE INDEX `uk_file_key`(`file_key` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8309 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '文件' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for t_role
-- ----------------------------
DROP TABLE IF EXISTS `t_role`;
CREATE TABLE `t_role` (
`role_id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
`role_name` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '角色名称',
`role_code` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '角色编码',
`remark` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '角色描述',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
PRIMARY KEY (`role_id`) USING BTREE,
UNIQUE INDEX `role_code_uni`(`role_code` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 67 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '角色表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for t_role_employee
-- ----------------------------
DROP TABLE IF EXISTS `t_role_employee`;
CREATE TABLE `t_role_employee` (
`id` bigint NOT NULL AUTO_INCREMENT,
`role_id` bigint NOT NULL COMMENT '角色id',
`employee_id` bigint NOT NULL COMMENT '员工id',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `uk_role_employee`(`role_id` ASC, `employee_id` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 466 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '角色员工功能表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for t_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `t_role_menu`;
CREATE TABLE `t_role_menu` (
`role_menu_id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
`role_id` bigint NOT NULL COMMENT '角色id',
`menu_id` bigint NOT NULL COMMENT '菜单id',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
PRIMARY KEY (`role_menu_id`) USING BTREE,
INDEX `idx_role_id`(`role_id` ASC) USING BTREE,
INDEX `idx_menu_id`(`menu_id` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6752 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '角色-菜单\n' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for t_sbcg_annual_plan
-- ----------------------------
DROP TABLE IF EXISTS `t_sbcg_annual_plan`;
CREATE TABLE `t_sbcg_annual_plan` (
`annual_plan_id` int NOT NULL AUTO_INCREMENT COMMENT '年度计划唯一标识符',
`planning_dept` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '计划科室',
`using_office` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '使用科室',
`project_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '项目名称',
`project_summary` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '项目简介',
`self_budget` decimal(10, 2) NOT NULL COMMENT '预计自筹（万元）',
`total_budget` decimal(10, 2) NOT NULL COMMENT '预算金额合计（万元）',
`city_funding` decimal(10, 2) NULL DEFAULT NULL COMMENT '市本级财政拨款（万元）',
`is_gov_project` tinyint(1) NULL DEFAULT NULL COMMENT '是否为政府采购项目',
`procurement_method` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '采购方式',
`procurement_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '采购形式',
`project_attributes` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '项目属性',
`deleted_flag` tinyint(1) NOT NULL DEFAULT 0 COMMENT '删除状态',
PRIMARY KEY (`annual_plan_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '年度计划表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for t_wxgl_record
-- ----------------------------
DROP TABLE IF EXISTS `t_wxgl_record`;
CREATE TABLE `t_wxgl_record` (
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`repair_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '维修单号',
`engineer_name` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '维修工程师',
`repair_cost` decimal(10, 2) NOT NULL COMMENT '维修费用',
`repair_time` datetime NOT NULL COMMENT '维修日期',
`repair_hour` int NOT NULL COMMENT '维修工时',
`repair_explain` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '维修说明',
`repair_type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '维修类型',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2497 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for t_wxgl_requests
-- ----------------------------
DROP TABLE IF EXISTS `t_wxgl_requests`;
CREATE TABLE `t_wxgl_requests` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`repair_status` tinyint(1) NOT NULL COMMENT '维修状态',
`repair_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '维修单号',
`department` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '报修科室',
`requester` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '报修人',
`requester_time` datetime NOT NULL COMMENT '报修时间',
`requester_phone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '报修人电话',
`equipment_id` bigint NOT NULL COMMENT '设备主键',
`equipment_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '设备名称',
`urgency` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '紧急程度',
`fault_issue` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '故障问题',
`fault_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '故障描述',
`accepter` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '接单人',
`accept_time` datetime NULL DEFAULT NULL COMMENT '接单时间',
`dispose_time` datetime NULL DEFAULT NULL COMMENT '处理时间',
`repair_result` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '处理结果',
`demote` tinyint(1) NULL DEFAULT NULL COMMENT '是否降级使用',
`self_pickup` tinyint(1) NULL DEFAULT NULL COMMENT '是否自提',
`solution` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '解决方案',
`suggestion` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '改善建议',
`acceptancer` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '验收人',
`acceptance_time` datetime NULL DEFAULT NULL COMMENT '验收时间',
`attitude` tinyint(1) NULL DEFAULT NULL COMMENT '服务态度',
`technology` tinyint(1) NULL DEFAULT NULL COMMENT '技术水平',
`efficiency` tinyint(1) NULL DEFAULT NULL COMMENT '维修效率',
`downtime` int NULL DEFAULT NULL COMMENT '停机时长',
`acceptance_situation` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '验收情况',
`deleted_flag` tinyint(1) NOT NULL DEFAULT 0 COMMENT '删除状态',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `repair_id`(`repair_id` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2992 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for t_wxgl_used_fitting
-- ----------------------------
DROP TABLE IF EXISTS `t_wxgl_used_fitting`;
CREATE TABLE `t_wxgl_used_fitting` (
`used_fitting_id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
`repair_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '维修单号',
`fitting_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '配件名称',
`fitting_model` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '配件型号',
`fitting_cost` decimal(10, 2) NOT NULL COMMENT '配件价格',
`fitting_used_num` int NOT NULL COMMENT '使用数量',
PRIMARY KEY (`used_fitting_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 25 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '维修处理配件使用表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for t_zcgl_check
-- ----------------------------
DROP TABLE IF EXISTS `t_zcgl_check`;
CREATE TABLE `t_zcgl_check` (
`id` int NOT NULL AUTO_INCREMENT,
`check_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '盘点单号',
`check_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '盘点名称',
`create_user` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '计划人',
`create_time` datetime NOT NULL COMMENT '计划时间',
`start_time` date NOT NULL COMMENT '盘点开始时间',
`end_time` date NOT NULL COMMENT '盘点结束时间',
`remark` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '盘点描述',
`status` int NOT NULL DEFAULT 0 COMMENT '盘点单状态 (0: 准备就绪, 1: 执行中, 2: 完成)',
`deleted_flag` int NOT NULL DEFAULT 0 COMMENT '删除状态 (默认值为0表示未删除)',
`deleted_user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '删除人',
`delete_time` datetime NULL DEFAULT NULL COMMENT '删除时间',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `check_id`(`check_number` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 24 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for t_zcgl_check_range
-- ----------------------------
DROP TABLE IF EXISTS `t_zcgl_check_range`;
CREATE TABLE `t_zcgl_check_range` (
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`check_id` bigint NOT NULL COMMENT '盘点单ID',
`equipment_id` int NOT NULL COMMENT '设备id',
`result` tinyint NOT NULL DEFAULT 0 COMMENT '盘点结果【0:待盘点，1:盘准，2:待确认】',
`operator` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '盘点人',
`setting_time` datetime NULL DEFAULT NULL COMMENT '盘点时间',
`remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
PRIMARY KEY (`id`) USING BTREE,
INDEX `idx_check_id_is_checked`(`check_id` ASC, `result` ASC) USING BTREE,
INDEX `idx_equipment_id`(`equipment_id` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 543 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for t_zcgl_equipment
-- ----------------------------
DROP TABLE IF EXISTS `t_zcgl_equipment`;
CREATE TABLE `t_zcgl_equipment` (
`equipment_id` bigint NOT NULL AUTO_INCREMENT COMMENT '设备编号',
`equipment_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '设备名称',
`asset_number` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '资产编号',
`department` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '使用科室',
`brand` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '品牌',
`specifications_model` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '规格型号',
`risk_level` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '风险等级',
`serial_number` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '设备序列号',
`storage_location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '存放地点',
`manufacturer` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '设备厂家',
`original_value` decimal(10, 2) NULL DEFAULT NULL COMMENT '原值',
`net_value` decimal(10, 2) NULL DEFAULT NULL COMMENT '净值',
`accumulated_depreciation` decimal(10, 2) NULL DEFAULT NULL COMMENT '累计折旧',
`expected_service_life` int NULL DEFAULT NULL COMMENT '预计使用年限',
`manufacture_date` date NULL DEFAULT NULL COMMENT '出厂日期',
`acceptance_date` date NULL DEFAULT NULL COMMENT '验收日期',
`warranty_date` date NULL DEFAULT NULL COMMENT '保修日期',
`use_status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '使用状态【0：未启用，1：使用中，2：维修中，3：已报废】',
`is_life_saving` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否是生命急救类设备',
`add_on_bail` tinyint(1) NULL DEFAULT 0 COMMENT '是否为保外医院新增资产【0：否；1：是】',
`remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注',
`deleted_flag` tinyint(1) NULL DEFAULT 0 COMMENT '删除状态',
`create_user_id` bigint NULL DEFAULT NULL COMMENT '创建人ID',
`create_user_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人',
`create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_user_id` bigint NULL DEFAULT NULL COMMENT '更新人ID',
`update_user_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人',
`update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (`equipment_id`) USING BTREE,
INDEX `idx_t_zcgl_equipment_equipment_id`(`equipment_id` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 14993 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '设备信息表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for t_zcgl_equipment_retirement
-- ----------------------------
DROP TABLE IF EXISTS `t_zcgl_equipment_retirement`;
CREATE TABLE `t_zcgl_equipment_retirement` (
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
`retirement_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '报废单号',
`retirement_user` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '申请人',
`retirement_time` datetime NOT NULL COMMENT '申请时间',
`equipment_id` int NOT NULL COMMENT '设备编号',
`equipment_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '设备名称',
`department` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '所属科室',
`scrap_basis` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '报废依据',
`supplementary` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '补充说明',
`audit_time` datetime NULL DEFAULT NULL COMMENT '审核时间',
`status` int NOT NULL DEFAULT 0 COMMENT '状态【0未审核，1审核通过，2审核不通过】',
`audit_opinions` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '审核意见',
`audit_user` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '审核人',
`deleted_flag` int NOT NULL DEFAULT 0 COMMENT '删除状态 (默认值为0表示未删除)',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 38 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '设备报废表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for t_zlgl_inspection
-- ----------------------------
DROP TABLE IF EXISTS `t_zlgl_inspection`;
CREATE TABLE `t_zlgl_inspection` (
`formulate_id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
`formulate_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '计划名称',
`formulater` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '计划制定人',
`formulate_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '计划制定日期',
`check_cycle` int NOT NULL COMMENT '检查周期',
`cycle_unit` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '周期单位',
`cycle_date` date NOT NULL COMMENT '下次巡检日期',
`submit_flag` tinyint(1) NOT NULL COMMENT '提交状态',
`deleted_flag` tinyint(1) NOT NULL DEFAULT 0 COMMENT '删除状态',
PRIMARY KEY (`formulate_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 34 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '巡检计划表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for t_zlgl_inspection_equipment
-- ----------------------------
DROP TABLE IF EXISTS `t_zlgl_inspection_equipment`;
CREATE TABLE `t_zlgl_inspection_equipment` (
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
`equipment_id` int NOT NULL COMMENT '设备编号',
`formulate_id` int NOT NULL COMMENT '巡检编号',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 504 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for t_zlgl_inspection_implementation
-- ----------------------------
DROP TABLE IF EXISTS `t_zlgl_inspection_implementation`;
CREATE TABLE `t_zlgl_inspection_implementation` (
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
`formulate_id` int NOT NULL COMMENT '巡检计划ID',
`formulate_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '巡检单号',
`implementer` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '巡检工程师',
`normal` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '巡检正常的设备ID列表',
`abnormal` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '巡检异常的设备ID列表',
`implement_date` date NOT NULL COMMENT '巡检日期',
`inspection_condition` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '巡检情况说明',
`accept_time` datetime NULL DEFAULT NULL COMMENT '验收时间',
`acceptor` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '科室验收人',
`satisfaction` tinyint NULL DEFAULT NULL COMMENT '科室验收满意程度',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 650 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '巡检情况表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for t_zlgl_maintain
-- ----------------------------
DROP TABLE IF EXISTS `t_zlgl_maintain`;
CREATE TABLE `t_zlgl_maintain` (
`id` int NOT NULL AUTO_INCREMENT,
`maintain_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '计划编号',
`maintain_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '计划名称',
`charger` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '计划负责人',
`predict_time` datetime NOT NULL COMMENT '预计执行时间',
`check_cycle` int NOT NULL COMMENT '检查周期',
`cycle_unit` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '周期单位',
`exec_mode` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '执行方式',
`maintain_level` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '保养级别',
`department` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '科室',
`update_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
`remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注',
`deleted_flag` tinyint(1) NOT NULL DEFAULT 0 COMMENT '删除状态',
`deleted_user_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '删除人',
`delete_time` datetime NULL DEFAULT NULL COMMENT '删除时间',
`status` int NOT NULL DEFAULT 0 COMMENT '状态【0启用、1禁用】',
PRIMARY KEY (`id`) USING BTREE,
INDEX `idx_t_zlgl_maintain_maintain_id`(`maintain_id` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 86 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for t_zlgl_maintain_equipment
-- ----------------------------
DROP TABLE IF EXISTS `t_zlgl_maintain_equipment`;
CREATE TABLE `t_zlgl_maintain_equipment` (
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
`maintain_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '保养计划id',
`equipment_id` int NOT NULL COMMENT '设备id',
`plan_content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '计划内容',
`notice` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '注意事项',
`executor` varchar(20) 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 '备注',
`exec_time` datetime NULL DEFAULT NULL COMMENT '预计执行时间',
`deleted_flag` tinyint(1) NULL DEFAULT 0 COMMENT '删除状态',
`deleted_user_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '删除人',
`delete_time` datetime NULL DEFAULT NULL COMMENT '删除时间',
`status` int NOT NULL,
PRIMARY KEY (`id`) USING BTREE,
INDEX `idx_t_zlgl_maintain_equipment_equipment_id`(`equipment_id` ASC) USING BTREE,
INDEX `idx_t_zlgl_maintain_equipment_maintain_id`(`maintain_id` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 334 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for t_zlgl_maintain_implementation
-- ----------------------------
DROP TABLE IF EXISTS `t_zlgl_maintain_implementation`;
CREATE TABLE `t_zlgl_maintain_implementation` (
`id` int NOT NULL AUTO_INCREMENT COMMENT 'id',
`maintain_time` datetime NOT NULL COMMENT '保养时间',
`abnormal_condition` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '异常情况',
`is_abnormal` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '是否异常[正常/异常/异常已处理]',
`spent_time` decimal(10, 2) NULL DEFAULT NULL COMMENT '所用工时',
`part_amount` decimal(10, 3) NULL DEFAULT NULL COMMENT '配件金额',
`total_cost` decimal(10, 3) NULL DEFAULT NULL COMMENT '费用合计',
`suggest` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '改善建议',
`is_finish` int NULL DEFAULT NULL COMMENT '是否完成[已完成/未完成]',
`satisfaction` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '满意度[非常满意/满意/比较满意/一般/不满意]',
`accept_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '验收人',
`reception_time` datetime NULL DEFAULT NULL COMMENT '验收时间',
`accept_evaluate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '验收评价',
`equipment_id` int NULL DEFAULT NULL COMMENT '设备id',
`me_id` int NULL DEFAULT NULL COMMENT 't_zlgl_maintain_equipment_id',
`maintain_num` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '保养编号',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 92 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

SET FOREIGN_KEY_CHECKS = 1;

Get Embed Code
Open in Builder