From 3b8f1579d4a4eced3e5547f619b892fa2b7fa96d Mon Sep 17 00:00:00 2001 From: zss <zss@example.com> Date: 星期四, 19 三月 2026 15:06:55 +0800 Subject: [PATCH] 宜搭获取销售发货明细 --- doc/宁夏-中盛建材.sql | 26 ++++++++++++++++++++++++++ 1 files changed, 26 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 098fde4..d91f818 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" @@ -375,3 +375,29 @@ ROW_FORMAT = Dynamic; SET FOREIGN_KEY_CHECKS = 1; + +CREATE TABLE `product-inventory-management-zsjc`.`sales_delivery` ( + `id` int NOT NULL AUTO_INCREMENT, + `delivery_date` date NULL COMMENT '渚涜揣鏃ユ湡', + `delivery_code` varchar(255) NULL COMMENT '鍙戣揣鍗曠紪鍙�', + `project_name` varchar(255) NULL COMMENT '椤圭洰鍚嶇О', + `delivery_place` varchar(255) NULL COMMENT '閫佽揣鍦扮偣', + `link_man` varchar(255) NULL COMMENT '鑱旂郴浜�', + `link_phone` varchar(255) NULL COMMENT '鑱旂郴鐢佃瘽', + `delivery_remark` varchar(255) NULL COMMENT '鍙戣揣澶囨敞', + `material_code` varchar(255) NULL COMMENT '鐗╂枡浠ｇ爜', + `product_name` varchar(255) NULL COMMENT '浜у搧鍚嶇О', + `model` varchar(255) NULL COMMENT '浜у搧瑙勬牸', + `volume` decimal(10, 4) NULL COMMENT '鏂归噺', + `unit_price` decimal(10, 2) NULL COMMENT '鍗曚环', + `price` decimal(10, 2) NULL COMMENT '浠锋牸', + `product_remark` varchar(255) NULL COMMENT '浜у搧澶囨敞', + `customer` varchar(255) NULL COMMENT '瀹㈡埛鍚嶇О', + `salesman` varchar(255) NULL COMMENT '涓氬姟鍛�', + `delivery_method` varchar(255) NULL COMMENT '鍙戣揣鏂瑰紡', + `form_instance_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '瀹滄惌琛ㄥ崟瀹炰緥ID', + `form_modified_time` datetime(0) NULL DEFAULT NULL COMMENT '瀹滄惌淇敼鏃堕棿', + `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), + `update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0), + PRIMARY KEY (`id`) + ) COMMENT = '閿�鍞彂璐ф槑缁�(瀹滄惌)'; -- Gitblit v1.9.3