From cea8396d93b31fe6037a0558febcabb2169363a8 Mon Sep 17 00:00:00 2001 From: gaoluyang <2820782392@qq.com> Date: 星期三, 14 十月 2026 14:02:25 +0800 Subject: [PATCH] feat(wm): 入库单和领料单支持手工填写关联信息 --- docs/sql/config_export_all_20260928.sql | 5 +++++ 1 files changed, 5 insertions(+), 0 deletions(-) diff --git a/docs/sql/config_export_all_20260928.sql b/docs/sql/config_export_all_20260928.sql index d5cbeb8..8dc5be9 100644 --- a/docs/sql/config_export_all_20260928.sql +++ b/docs/sql/config_export_all_20260928.sql @@ -6744,9 +6744,11 @@ `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '鍚嶇О', `iqc_id` bigint DEFAULT NULL COMMENT '鏉ユ枡妫�楠屽崟缂栧彿', `notice_id` bigint DEFAULT NULL COMMENT '鍒拌揣閫氱煡鍗曠紪鍙�', + `notice_code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '鍒拌揣閫氱煡鍗曠紪鐮侊紙鎵嬪伐濉啓/鍐椾綑锛�', `purchase_order_code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '閲囪喘璁㈠崟鍙�', `purchase_order_id` bigint DEFAULT NULL COMMENT '閲囪喘璁㈠崟缂栧彿', `vendor_id` bigint DEFAULT NULL COMMENT '渚涘簲鍟嗙紪鍙�', + `vendor_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '渚涘簲鍟嗗悕绉帮紙鎵嬪伐濉啓/鍐椾綑锛�', `receipt_date` datetime DEFAULT NULL COMMENT '閫�搴撴棩鏈�', `status` int DEFAULT NULL COMMENT '鐘舵��', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '澶囨敞', @@ -7129,7 +7131,9 @@ `code` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '鍗曞彿', `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '鍚嶇О', `work_order_id` bigint DEFAULT NULL COMMENT '鐢熶骇宸ュ崟 ID', + `work_order_code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '鐢熶骇宸ュ崟缂栧彿锛堟墜宸ュ～鍐�/鍐椾綑锛�', `task_id` bigint DEFAULT NULL COMMENT '鐢熶骇浠诲姟ID', + `task_code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '鐢熶骇浠诲姟缂栫爜锛堟墜宸ュ～鍐�/鍐椾綑锛�', `issue_date` datetime DEFAULT NULL COMMENT '棰嗘枡鏃ユ湡', `required_time` datetime DEFAULT NULL COMMENT '闇�姹傛椂闂�', `status` int DEFAULT NULL COMMENT '鐘舵��', @@ -7142,6 +7146,7 @@ `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿', `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', `workstation_id` int DEFAULT NULL, + `workstation_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '宸ヤ綔绔欏悕绉帮紙鎵嬪伐濉啓/鍐椾綑锛�', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='MES 鐢熶骇棰嗘枡鍗�'; -- Gitblit v1.9.3