From ef7458a6eb8ad72f45b65a4e417a9d04f5015246 Mon Sep 17 00:00:00 2001 From: gongchunyi <deslre0381@gmail.com> Date: 星期六, 14 三月 2026 11:47:08 +0800 Subject: [PATCH] feat: 根据宜搭表单 ID 获取数据工具类 --- doc/宁夏-中盛建材.sql | 30 ++++++++++++++++++++++++++++++ 1 files changed, 30 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 64a938d..18b76f7 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" @@ -167,3 +167,33 @@ ROW_FORMAT = Dynamic; SET FOREIGN_KEY_CHECKS = 1; + + +alter table production_plan + add status tinyint default 0 not null comment '鐘舵�� 0鏈笅鍙� 1宸蹭笅鍙�'; + + +ALTER TABLE `product-inventory-management-zsjc`.`production_plan` + DROP COLUMN `data_sync_type`, + MODIFY COLUMN `data_source_type` tinyint NULL DEFAULT 1 COMMENT '鏁版嵁鏉ユ簮绫诲瀷锛�1=閽夐拤鍚屾 2=鎵嬪姩鏂板' AFTER `form_modified_time`; + +DROP TABLE IF EXISTS `base_param`; +CREATE TABLE `base_param` +( + id BIGINT PRIMARY KEY AUTO_INCREMENT COMMENT '涓婚敭ID', + param_key VARCHAR(100) NOT NULL COMMENT '鍙傛暟鍞竴鏍囪瘑', + param_name VARCHAR(100) NOT NULL COMMENT '鍙傛暟鍚嶇О', + param_type TINYINT NOT NULL COMMENT '鍙傛暟绫诲瀷(1鏁板瓧 2鏂囨湰)', + value_mode TINYINT DEFAULT 1 COMMENT '鍊兼ā寮�(1鍗曞�� 2鍖洪棿)', + unit VARCHAR(50) COMMENT '鍗曚綅', + default_value VARCHAR(200) COMMENT '榛樿鍊�(鍗曞�煎弬鏁�)', + default_min DECIMAL(10, 2) COMMENT '榛樿鏈�灏忓��(鍖洪棿鍙傛暟)', + default_max DECIMAL(10, 2) COMMENT '榛樿鏈�澶у��(鍖洪棿鍙傛暟)', + is_required TINYINT DEFAULT 0 COMMENT '鏄惁蹇呭～(0鍚� 1鏄�)', + remark VARCHAR(255) COMMENT '澶囨敞', + create_user VARCHAR(64) COMMENT '鍒涘缓浜�', + create_time DATETIME COMMENT '鍒涘缓鏃堕棿', + update_user VARCHAR(64) COMMENT '淇敼浜�', + update_time DATETIME COMMENT '淇敼鏃堕棿', + tenant_id BIGINT NOT NULL COMMENT '绉熸埛ID' +) COMMENT = '鍩虹鍙傛暟瀹氫箟琛�'; -- Gitblit v1.9.3