From 4f45f29e6b53f4c01b414409c5000ff4e212b3d9 Mon Sep 17 00:00:00 2001
From: huminmin <mac@MacBook-Pro.local>
Date: 星期五, 05 六月 2026 13:36:54 +0800
Subject: [PATCH] 增加eip
---
basic-server/doc/EIP线缆对接.sql | 31 +++++++++++++++++++++++++++++++
1 files changed, 31 insertions(+), 0 deletions(-)
diff --git "a/basic-server/doc/EIP\347\272\277\347\274\206\345\257\271\346\216\245.sql" "b/basic-server/doc/EIP\347\272\277\347\274\206\345\257\271\346\216\245.sql"
new file mode 100644
index 0000000..dda6ea4
--- /dev/null
+++ "b/basic-server/doc/EIP\347\272\277\347\274\206\345\257\271\346\216\245.sql"
@@ -0,0 +1,31 @@
+CREATE TABLE `eip_cable_test_data` (
+ `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '涓婚敭',
+ `cable_type` VARCHAR(50) DEFAULT NULL COMMENT '绾跨紗绫诲瀷缂栫爜',
+ `cable_type_name` VARCHAR(100) DEFAULT NULL COMMENT '绾跨紗绫诲瀷鍚嶇О',
+ `sample_code` VARCHAR(100) DEFAULT NULL COMMENT '鏍峰搧缂栧彿',
+ `product_name` VARCHAR(200) DEFAULT NULL COMMENT '浜у搧鍚嶇О',
+ `spec_model` VARCHAR(200) DEFAULT NULL COMMENT '瑙勬牸鍨嬪彿',
+ `test_type` VARCHAR(100) DEFAULT NULL COMMENT '璇曢獙绫诲瀷',
+ `test_result` VARCHAR(100) DEFAULT NULL COMMENT '璇曢獙缁撴灉',
+ `raw_material` VARCHAR(500) DEFAULT NULL COMMENT '鍘熸潗鏂�',
+ `process_inspection` VARCHAR(500) DEFAULT NULL COMMENT '杩囩▼妫�',
+ `final_inspection` VARCHAR(500) DEFAULT NULL COMMENT '鎴愬搧妫�',
+ `test_date` DATE DEFAULT NULL COMMENT '璇曢獙鏃堕棿',
+ `source_system` VARCHAR(100) DEFAULT NULL COMMENT '鏉ユ簮绯荤粺',
+ `sync_batch_no` VARCHAR(100) DEFAULT NULL COMMENT '鍚屾鎵规鍙�',
+ `sync_status` TINYINT DEFAULT '1' COMMENT '鍚屾鐘舵�侊細0澶辫触锛�1鎴愬姛',
+ `remark` VARCHAR(500) DEFAULT NULL COMMENT '澶囨敞',
+ `create_by` VARCHAR(100) DEFAULT NULL COMMENT '鍒涘缓浜�',
+ `update_by` VARCHAR(100) DEFAULT NULL COMMENT '淇敼浜�',
+ `create_time` DATETIME DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
+ `update_time` DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿',
+ PRIMARY KEY (`id`),
+ KEY `idx_cable_type` (`cable_type`),
+ KEY `idx_sample_code` (`sample_code`),
+ KEY `idx_test_date` (`test_date`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='EIP绾跨紗璇曢獙鏁版嵁琛�';
+
+INSERT INTO `sys_menu`
+(`menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `route_name`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `remark`)
+VALUES
+('EIP绾跨紗瀵规帴', 0, 14, 'quality-eip-cable', 'quality/eipCable/index', NULL, 'QualityEipCable', '1', '0', 'C', '0', '0', 'quality:eipCable:list', 'guide', 'admin', NOW(), '璐ㄩ噺绠＄悊-绾跨紗绫籈IP瀵规帴');
--
Gitblit v1.9.3