From 0674b30cb6e106ca23d432430aad1cad93cbbc99 Mon Sep 17 00:00:00 2001
From: gongchunyi <deslre0381@gmail.com>
Date: 星期二, 10 三月 2026 10:12:43 +0800
Subject: [PATCH] refactor: 合并生产需求子表
---
doc/宁夏-中盛建材.sql | 83 ++++++++++++++++-------------------------
1 files changed, 32 insertions(+), 51 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 16572ba..ee0341f 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"
@@ -1,53 +1,34 @@
-CREATE TABLE `prod_demand_main`
+CREATE TABLE `production_plan`
(
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '鑷涓婚敭',
- `tenant_id` bigint(20) NOT NULL COMMENT '绉熸埛缂栧彿',
- `dept_id` bigint(20) DEFAULT NULL COMMENT '閮ㄩ棬ID (鐢ㄤ簬鏁版嵁鏉冮檺闅旂)',
- `form_instance_id` varchar(64) NOT NULL COMMENT '琛ㄥ崟瀹炰緥鍞竴ID (鍏宠仈瀛愯〃鐢�)',
- `serial_no` varchar(64) DEFAULT NULL COMMENT '鍗曟嵁娴佹按鍙� (serialNo)',
- `title` varchar(128) DEFAULT NULL COMMENT '鍗曟嵁鏍囬 (title)',
- `originator_user_id` varchar(64) DEFAULT NULL COMMENT '绗笁鏂瑰彂璧蜂汉ID (creatorUserId)',
- `originator_name` varchar(64) DEFAULT NULL COMMENT '绗笁鏂瑰彂璧蜂汉濮撳悕 (originator.userName)',
- `biz_create_time` datetime DEFAULT NULL COMMENT '绗笁鏂瑰崟鎹垱寤烘椂闂� (createdTimeGMT)',
- `project_name` varchar(128) DEFAULT NULL COMMENT '椤圭洰鍚嶇О/瀹㈡埛 (textField_lbkozohg)',
- `batch_no` varchar(128) DEFAULT NULL COMMENT '鎵规/鍏宠仈缂栧彿 (textField_l7fytfco)',
- `contact_person` varchar(128) DEFAULT NULL COMMENT '鑱旂郴浜�/澶囨敞 (textareaField_l7fytfcy)',
- `ext_text1` varchar(128) DEFAULT NULL COMMENT '棰勭暀鏂囨湰1 (textField_l7fytfcx)',
- `ext_text2` varchar(128) DEFAULT NULL COMMENT '棰勭暀鏂囨湰2 (textField_lbknlltp)',
- `create_user` bigint(20) DEFAULT NULL COMMENT '鍒涘缓鑰�',
- `create_time` datetime DEFAULT NULL COMMENT '鍒涘缓鏃堕棿',
- `update_user` bigint(20) DEFAULT NULL COMMENT '鏇存柊鑰�',
- `update_time` datetime DEFAULT NULL COMMENT '鏇存柊鏃堕棿',
- `remark` varchar(500) DEFAULT NULL COMMENT '澶囨敞',
-
+ `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '鑷涓婚敭',
+ `form_instance_id` VARCHAR(64) NOT NULL COMMENT '琛ㄥ崟瀹炰緥ID',
+ `serial_no` VARCHAR(64) DEFAULT NULL COMMENT '鍗曟嵁娴佹按鍙�',
+ `title` VARCHAR(128) DEFAULT NULL COMMENT '鍗曟嵁鏍囬',
+ `originator_user_id` VARCHAR(64) DEFAULT NULL COMMENT '鍙戣捣浜篒D',
+ `originator_name` VARCHAR(64) DEFAULT NULL COMMENT '鍙戣捣浜哄鍚�',
+ `biz_create_time` DATETIME DEFAULT NULL COMMENT '鍗曟嵁鍒涘缓鏃堕棿',
+ `project_name` VARCHAR(128) DEFAULT NULL COMMENT '椤圭洰鍚嶇О',
+ `batch_no` VARCHAR(128) DEFAULT NULL COMMENT '鎵规鍙�',
+ `contact_person` VARCHAR(128) DEFAULT NULL COMMENT '鑱旂郴浜�',
+ `ext_text1` VARCHAR(128) DEFAULT NULL COMMENT '棰勭暀1',
+ `ext_text2` VARCHAR(128) DEFAULT NULL COMMENT '棰勭暀2',
+ `material_code` VARCHAR(64) DEFAULT NULL COMMENT '鐗╂枡缂栫爜',
+ `material_category` VARCHAR(64) DEFAULT NULL COMMENT '鐗╂枡鍒嗙被',
+ `spec_desc` VARCHAR(128) DEFAULT NULL COMMENT '瑙勬牸鎻忚堪',
+ `grade_type` VARCHAR(32) DEFAULT NULL COMMENT '绛夌骇',
+ `length` DECIMAL(10, 2) DEFAULT NULL COMMENT '闀垮害',
+ `width` DECIMAL(10, 2) DEFAULT NULL COMMENT '瀹藉害',
+ `thickness` DECIMAL(10, 2) DEFAULT NULL COMMENT '鍘氬害',
+ `quantity` INT DEFAULT NULL COMMENT '鏁伴噺',
+ `volume` DECIMAL(10, 4) DEFAULT NULL COMMENT '鎬讳綋绉�',
+ `date_start` DATETIME DEFAULT NULL COMMENT '寮�濮嬫椂闂�',
+ `date_end` DATETIME DEFAULT NULL COMMENT '缁撴潫鏃堕棿',
+ `association_receipt` TEXT COMMENT '鍏宠仈鍗曟嵁',
+ `data_sync_type` TINYINT DEFAULT 1 COMMENT '鏁版嵁鏂瑰紡: 1=鎵嬪姩 2=瀹氭椂',
+ `data_source_type` TINYINT DEFAULT 1 COMMENT '鏁版嵁鏉ユ簮: 1=閿�鍞鍗� 2=鐢熶骇棰勬祴',
+ `create_time` DATETIME DEFAULT CURRENT_TIMESTAMP,
+ `update_time` DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
- UNIQUE KEY `uk_form_instance_id` (`form_instance_id`)
-) ENGINE = InnoDB
- DEFAULT CHARSET = utf8mb4 COMMENT ='閿�鍞敓浜ч渶姹�';
-
-CREATE TABLE `prod_demand_detail`
-(
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '鑷涓婚敭',
- `tenant_id` bigint(20) NOT NULL COMMENT '绉熸埛缂栧彿',
- `prod_demand_main_id` bigint(20) NOT NULL COMMENT '鐖剁被鍏宠仈ID',
- `material_code` varchar(64) DEFAULT NULL COMMENT '鐗╂枡缂栫爜 (textField_l9xo62q5)',
- `material_category` varchar(64) DEFAULT NULL COMMENT '鐗╂枡鍒嗙被 (textField_l9xo62q7)',
- `spec_desc` varchar(128) DEFAULT NULL COMMENT '瑙勬牸鎻忚堪 (textField_l9xo62q8)',
- `grade_type` varchar(32) DEFAULT NULL COMMENT '绛夌骇/绫诲瀷 (radioField_m9urarr2)',
- `length` decimal(10, 2) DEFAULT NULL COMMENT '闀垮害 (numberField_lb7lgatg)',
- `width` decimal(10, 2) DEFAULT NULL COMMENT '瀹藉害 (numberField_lb7lgath)',
- `thickness` decimal(10, 2) DEFAULT NULL COMMENT '鍘氬害 (numberField_lb7lgati)',
- `quantity` int(11) DEFAULT NULL COMMENT '鏁伴噺 (numberField_lb7lgatj)',
- `volume` decimal(10, 4) DEFAULT NULL COMMENT '鎬讳綋绉� (numberField_l7fytfd3)',
- `date_range` varchar(255) DEFAULT NULL COMMENT '鏃堕棿鍖洪棿鏁扮粍瀛楃涓� (cascadeDateField_lfxqqluw)',
- `association_receipt` text DEFAULT NULL COMMENT '鍏宠仈鐨勫叾浠栧崟鎹� (associationFormField_l9xo62q6_id)',
- `create_user` bigint(20) DEFAULT NULL COMMENT '鍒涘缓鑰�',
- `create_time` datetime DEFAULT NULL COMMENT '鍒涘缓鏃堕棿',
- `update_user` bigint(20) DEFAULT NULL COMMENT '鏇存柊鑰�',
- `update_time` datetime DEFAULT NULL COMMENT '鏇存柊鏃堕棿',
- `remark` varchar(500) DEFAULT NULL COMMENT '澶囨敞',
-
- PRIMARY KEY (`id`),
- KEY `idx_prod_demand_main_id` (`prod_demand_main_id`)
-) ENGINE = InnoDB
- DEFAULT CHARSET = utf8mb4 COMMENT ='閿�鍞敓浜ч渶姹俖鏄庣粏琛�';
\ No newline at end of file
+ KEY `idx_form_instance_id` (`form_instance_id`)
+) ENGINE = INNODB
+ DEFAULT CHARSET = utf8mb4 COMMENT = '閿�鍞敓浜ч渶姹�';
\ No newline at end of file
--
Gitblit v1.9.3