56 lines
6.5 KiB
Plaintext
56 lines
6.5 KiB
Plaintext
-- 2025-07-22添加的菜单栏
|
||
|
||
INSERT INTO sys_menu` ( `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ('设备维护记录', 2168, 4, 'inspectionItemRecord', 'mes/equipment/inspectionItemRecord', NULL, 1, 0, 'C', '0', '0', 'equipment:inspectionItemRecord:list', '#', 'admin', '2025-07-13 00:15:38', '', NULL, '');
|
||
INSERT INTO sys_menu` ( `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ('温湿度采集', 2168, 5, 'humidity', 'mes/equipment/humidity/index', NULL, 1, 0, 'C', '0', '0', 'equipment:humidity:list', '#', 'admin', '2025-07-21 15:59:01', 'admin', '2025-07-21 15:59:36', '');
|
||
|
||
|
||
INSERT INTO `sys_menu` ( `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( '入库工序', 2123, 9, 'reportWarehousing', 'mes/quality/reportWarehousing/index', NULL, 1, 0, 'C', '0', '0', 'quality:reportWarehousing:list', 'button', 'yavii', '2025-07-21 10:50:57', '', NULL, '');
|
||
INSERT INTO `sys_menu` ( `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( '入库工序查询', 2328, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'quality:reportWarehousing:query', '#', 'yavii', '2025-07-21 10:53:00', '', NULL, '');
|
||
INSERT INTO `sys_menu` ( `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( '入库工序新增', 2328, 2, '', NULL, NULL, 1, 0, 'F', '0', '0', 'quality:reportWarehousing:add', '#', 'yavii', '2025-07-21 10:54:02', 'yavii', '2025-07-21 10:54:14', '');
|
||
INSERT INTO `sys_menu` ( `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( '入库工序修改', 2328, 3, '', NULL, NULL, 1, 0, 'F', '0', '0', 'quality:reportWarehousing:edit', '#', 'yavii', '2025-07-21 10:54:47', '', NULL, '');
|
||
INSERT INTO `sys_menu` ( `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( '入库工序删除', 2328, 4, '', NULL, NULL, 1, 0, 'F', '0', '0', 'quality:reportWarehousing:remove', '#', 'yavii', '2025-07-21 10:55:47', 'yavii', '2025-07-21 10:56:05', '');
|
||
INSERT INTO `sys_menu` ( `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( '入库工序导出', 2328, 5, '', NULL, NULL, 1, 0, 'F', '0', '0', 'quality:reportWarehousing:export', '#', 'yavii', '2025-07-21 10:56:54', '', NULL, '');
|
||
|
||
|
||
|
||
DROP TABLE IF EXISTS `qc_warehousing`;
|
||
CREATE TABLE `qc_warehousing` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键ID',
|
||
`qc_no` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '质检单号',
|
||
`qc_item` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '质检物品',
|
||
`start_time` datetime NOT NULL COMMENT '开始时间',
|
||
`duration` int NULL DEFAULT NULL COMMENT '持续时间(分钟)',
|
||
`is_qualified` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '0' COMMENT '是否合格(0=不合格,1=合格)',
|
||
`remarks` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注',
|
||
`spare1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备用字段1',
|
||
`spare2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备用字段2',
|
||
`spare3` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备用字段3',
|
||
`create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '创建者',
|
||
`create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
|
||
`update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '更新者',
|
||
`update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
|
||
`del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE INDEX `idx_qc_no`(`qc_no`) USING BTREE COMMENT '质检单号唯一索引'
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '入库质检记录表' ROW_FORMAT = DYNAMIC;
|
||
|
||
|
||
|
||
DROP TABLE IF EXISTS `dm_inspection_record`;
|
||
CREATE TABLE `dm_inspection_record` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '记录ID',
|
||
`inspection_item_id` bigint(20) NOT NULL COMMENT '点检项目ID',
|
||
`check_date` date NOT NULL COMMENT '点检日期',
|
||
`check_time` time NOT NULL COMMENT '点检时间',
|
||
`status` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '点检结果（0=正常，1=异常）',
|
||
`remarks` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注说明',
|
||
`checked_by` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '点检人',
|
||
`photos` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '执行图片',
|
||
`create_by` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建者',
|
||
`create_time` datetime NOT NULL COMMENT '创建时间',
|
||
`update_by` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新人',
|
||
`update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
INDEX `idx_item_date`(`inspection_item_id`, `check_date`) USING BTREE COMMENT '项目日期索引'
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '设备点检记录表' ROW_FORMAT = DYNAMIC;
|