From 96d562d24734ce1ba05e2d5b4f86dd97c23f9f90 Mon Sep 17 00:00:00 2001 From: gongchunyi <deslre0381@gmail.com> Date: 星期一, 09 三月 2026 17:24:03 +0800 Subject: [PATCH] feat: 新增-销售生产需求表 --- doc/宁夏-中盛建材.sql | 53 +++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 53 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" new file mode 100644 index 0000000..78cf397 --- /dev/null +++ "b/doc/\345\256\201\345\244\217-\344\270\255\347\233\233\345\273\272\346\235\220.sql" @@ -0,0 +1,53 @@ +CREATE TABLE `prod_demand_main` +( + `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '鑷涓婚敭', + `tenant_id` varchar(20) DEFAULT '000000' 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 '澶囨敞', + + 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` varchar(20) DEFAULT '000000' COMMENT '绉熸埛缂栧彿', + `form_instance_id` varchar(64) NOT NULL COMMENT '涓昏〃鍗曞疄渚婭D (澶栭敭锛屽叧鑱斾富琛�)', + `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_form_instance_id` (`form_instance_id`) +) ENGINE = InnoDB + DEFAULT CHARSET = utf8mb4 COMMENT ='閿�鍞敓浜ч渶姹俖鏄庣粏琛�'; \ No newline at end of file -- Gitblit v1.9.3