From 124a6178ae918de05886b52199b7755d4fa1ece3 Mon Sep 17 00:00:00 2001 From: zss <zss@example.com> Date: 星期三, 18 三月 2026 17:06:44 +0800 Subject: [PATCH] Merge remote-tracking branch 'origin/dev_宁夏_中盛建材' into dev_宁夏_中盛建材 --- doc/宁夏-中盛建材.sql | 107 +++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 107 insertions(+), 0 deletions(-) diff --git "a/doc/\345\256\201\345\244\217-\344\270\255\347\233\233\345\273\272\346\235\220.sql" "b/doc/\345\256\201\345\244\217-\344\270\255\347\233\233\345\273\272\346\235\220.sql" index ce5f676..098fde4 100644 --- "a/doc/\345\256\201\345\244\217-\344\270\255\347\233\233\345\273\272\346\235\220.sql" +++ "b/doc/\345\256\201\345\244\217-\344\270\255\347\233\233\345\273\272\346\235\220.sql" @@ -268,3 +268,110 @@ ADD COLUMN `sample_state` varchar(255) NULL COMMENT '璇曟牱鐘舵��' AFTER `sample_code`, ADD COLUMN `sample_time` date NULL COMMENT '鍙栨牱鏃ユ湡' AFTER `sample_state`, ADD COLUMN `license_plate_number` varchar(255) NULL COMMENT '杞︾墝鍙�' AFTER `sample_time`; + + +ALTER TABLE `product_bom` + ADD COLUMN `dict_code` bigint NOT NULL COMMENT '鍏宠仈瀛楀吀鏁版嵁缂栫爜锛坰ys_dict_data.dict_code锛�'; +ALTER TABLE `product_bom` ADD INDEX `idx_dict_code` (`dict_code`); + +ALTER TABLE `product-inventory-management-zsjc`.`process_route` + ADD COLUMN `dict_code` bigint NOT NULL COMMENT '浜у搧绫诲瀷瀛楀吀缂栫爜' AFTER `status`; + + +ALTER TABLE `product-inventory-management-zsjc`.`product_order` + ADD COLUMN `status` int NULL COMMENT '鐘舵�侊紙1.寰呭紑濮嬨��2.杩涜涓��3.宸插畬鎴愩��4.宸插彇娑堬級' AFTER `plan_complete_time`; + +DROP TABLE IF EXISTS `process_route_item_instance`; +CREATE TABLE `process_route_item_instance` +( + `id` bigint NOT NULL AUTO_INCREMENT, + `route_id` bigint NOT NULL DEFAULT 0 COMMENT '宸ヨ壓璺嚎id', + `product_model_id` bigint NULL DEFAULT 0 COMMENT '浜у搧id', + `process_id` bigint NOT NULL DEFAULT 0 COMMENT '宸ュ簭id', + `tenant_id` bigint NOT NULL COMMENT '绉熸埛id', + `create_time` datetime NULL DEFAULT NULL COMMENT '褰曞叆鏃堕棿', + `update_time` datetime NULL DEFAULT NULL COMMENT '鏇存柊鏃堕棿', + `drag_sort` int NULL DEFAULT NULL COMMENT '鎷栧姩鎺掑簭', + `is_quality` tinyint(1) NULL DEFAULT 1 COMMENT '鏄惁璐ㄦ宸ュ簭', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB + AUTO_INCREMENT = 83 + CHARACTER SET = utf8mb4 + COLLATE = utf8mb4_0900_ai_ci COMMENT = '宸ヨ壓璺嚎瀛愰泦-闄勮〃' + ROW_FORMAT = Dynamic; + +-- ---------------------------- +-- Table structure for process_route_item_param_instance +-- ---------------------------- +DROP TABLE IF EXISTS `process_route_item_param_instance`; +CREATE TABLE `process_route_item_param_instance` +( + `id` bigint NOT NULL AUTO_INCREMENT COMMENT '涓婚敭ID', + `route_item_id` bigint NOT NULL COMMENT '鍏宠仈宸ヨ壓璺嚎鏄庣粏ID (process_route_item.id)', + `param_id` bigint NOT NULL COMMENT '鍏宠仈鍩虹鍙傛暟瀹氫箟ID (base_param.id)', + `process_param_id` bigint NULL DEFAULT NULL COMMENT '鏉ユ簮宸ュ簭鍙傛暟ID', + `standard_value` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '姝よ矾绾胯妭鐐硅瀹氱殑鏍囧噯鍊�', + `min_value` decimal(10, 2) NULL DEFAULT NULL COMMENT '姝よ矾绾胯妭鐐硅瀹氱殑鏍囧噯鏈�灏忓��', + `max_value` decimal(10, 2) NULL DEFAULT NULL COMMENT '姝よ矾绾胯妭鐐硅瀹氱殑鏍囧噯鏈�澶у��', + `is_required` tinyint NOT NULL DEFAULT 0 COMMENT '鏄惁蹇呭～', + `sort` int NOT NULL DEFAULT 0 COMMENT '鎺掑簭', + `tenant_id` bigint NULL DEFAULT NULL COMMENT '绉熸埛ID', + `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP, + `update_time` datetime NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, + PRIMARY KEY (`id`) USING BTREE, + INDEX `idx_route_item_id` (`route_item_id` ASC) USING BTREE, + INDEX `idx_param_id` (`param_id` ASC) USING BTREE +) ENGINE = InnoDB + AUTO_INCREMENT = 178 + CHARACTER SET = utf8mb4 + COLLATE = utf8mb4_0900_ai_ci COMMENT = '宸ヨ壓璺嚎宸ュ簭鍙傛暟-闄勮〃' + ROW_FORMAT = Dynamic; + +-- ---------------------------- +-- Table structure for product_process_param_instance +-- ---------------------------- +DROP TABLE IF EXISTS `product_process_param_instance`; +CREATE TABLE `product_process_param_instance` +( + `id` bigint NOT NULL AUTO_INCREMENT COMMENT '涓婚敭ID', + `process_id` bigint NOT NULL COMMENT '鎵�灞炲伐搴廔D (product_process.id)', + `param_id` bigint NOT NULL COMMENT '鍏宠仈鍩虹鍙傛暟ID (base_param.id)', + `standard_value` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鍦ㄦ宸ュ簭璁惧畾鐨勬爣鍑嗗��(鍗曞�兼ā寮�)', + `min_value` decimal(10, 2) NULL DEFAULT NULL COMMENT '鍦ㄦ宸ュ簭璁惧畾鐨勬爣鍑嗘渶灏忓��(鍖洪棿妯″紡)', + `max_value` decimal(10, 2) NULL DEFAULT NULL COMMENT '鍦ㄦ宸ュ簭璁惧畾鐨勬爣鍑嗘渶澶у��(鍖洪棿妯″紡)', + `is_required` tinyint NOT NULL DEFAULT 0 COMMENT '鍦ㄦ宸ュ簭涓槸鍚﹀繀濉�(0-鍚�, 1-鏄�)', + `sort` int NOT NULL DEFAULT 0 COMMENT '鎺掑簭鍙�', + `tenant_id` bigint NULL DEFAULT NULL COMMENT '绉熸埛ID', + `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', + `update_time` datetime NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿', + PRIMARY KEY (`id`) USING BTREE, + INDEX `idx_process_id` (`process_id` ASC) USING BTREE, + INDEX `idx_param_id` (`param_id` ASC) USING BTREE +) ENGINE = InnoDB + AUTO_INCREMENT = 61 + CHARACTER SET = utf8mb4 + COLLATE = utf8mb4_0900_ai_ci COMMENT = '宸ュ簭缁戝畾鍙傛暟-闄勮〃' + ROW_FORMAT = Dynamic; + +-- ---------------------------- +-- Table structure for product_structure_instance +-- ---------------------------- +DROP TABLE IF EXISTS `product_structure_instance`; +CREATE TABLE `product_structure_instance` +( + `id` bigint NOT NULL AUTO_INCREMENT, + `parent_id` bigint NULL DEFAULT NULL COMMENT '鐖惰妭鐐笽D', + `product_model_id` bigint NULL DEFAULT NULL COMMENT '浜у搧id', + `process_id` bigint NULL DEFAULT NULL COMMENT '宸ュ簭id', + `unit_quantity` decimal(16, 4) NOT NULL COMMENT '鍗曚綅浜у嚭闇�瑕佹暟閲�', + `demanded_quantity` decimal(16, 4) NULL DEFAULT NULL COMMENT '闇�姹傛暟閲�', + `unit` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鍗曚綅', + `tenant_id` bigint NULL DEFAULT NULL COMMENT '绉熸埛id', + `bom_id` bigint NOT NULL COMMENT 'bom鐨刬d', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB + CHARACTER SET = utf8mb4 + COLLATE = utf8mb4_0900_ai_ci COMMENT = 'BOM瀛愰泦-闄勮〃' + ROW_FORMAT = Dynamic; + +SET FOREIGN_KEY_CHECKS = 1; -- Gitblit v1.9.3