From 361f5449f46da1fe7f4cef954dbf25bbe8b8101d Mon Sep 17 00:00:00 2001 From: 云 <2163098428@qq.com> Date: 星期三, 26 八月 2026 16:45:31 +0800 Subject: [PATCH] feat(sales): 添加发货地址字段支持 --- sql/product-inventory-management-new-pro.sql | 10 ++++++++++ 1 files changed, 10 insertions(+), 0 deletions(-) diff --git a/sql/product-inventory-management-new-pro.sql b/sql/product-inventory-management-new-pro.sql index 35c0008..4afdf6d 100644 --- a/sql/product-inventory-management-new-pro.sql +++ b/sql/product-inventory-management-new-pro.sql @@ -3299,6 +3299,10 @@ `no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '閫�璐у崟缂栧彿', `return_type` tinyint NOT NULL DEFAULT 0 COMMENT '閫�璐ф柟寮� 0閫�璐ч��娆� 1鎷掓敹', `supplier_id` bigint NOT NULL DEFAULT 0 COMMENT '渚涘簲鍟唅d', + `shipping_type` tinyint NULL DEFAULT NULL COMMENT '鍙戣揣绫诲瀷 1璐ц溅 2蹇��', + `truck_plate_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鍙戣揣杞︾墝鍙�', + `express_company` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '蹇�掑叕鍙�', + `express_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '蹇�掑崟鍙�', `project_id` bigint NOT NULL DEFAULT 0 COMMENT '椤圭洰id', `project_phase` tinyint NOT NULL DEFAULT 0 COMMENT '椤圭洰闃舵', `prepared_at` datetime NULL DEFAULT NULL COMMENT '鍒跺崟鏃ユ湡', @@ -3753,6 +3757,10 @@ `return_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '閫�璐у崟鍙�', `customer_id` bigint NULL DEFAULT NULL COMMENT '瀹㈡埛 id', `shipping_id` bigint NULL DEFAULT NULL COMMENT '鍏宠仈鍙戣揣鍗曞彿', + `shipping_type` tinyint NULL DEFAULT NULL COMMENT '鍙戣揣绫诲瀷 1璐ц溅 2蹇��', + `truck_plate_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鍙戣揣杞︾墝鍙�', + `express_company` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '蹇�掑叕鍙�', + `express_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '蹇�掑崟鍙�', `project_stage` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '椤圭洰闃舵', `maker` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鍒跺崟浜�', `make_time` timestamp NULL DEFAULT NULL COMMENT '鍒跺崟鏃堕棿', @@ -4408,6 +4416,7 @@ `sales_ledger_id` bigint NULL DEFAULT NULL COMMENT '閿�鍞彴璐d', `shipping_date` datetime NULL DEFAULT NULL COMMENT '鍙戣揣鏃ユ湡', `shipping_car_number` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '鍙戣揣杞︾墝鍙�', + `shipping_address` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鍙戣揣鍦板潃', `create_time` datetime NULL DEFAULT NULL COMMENT '鍒涘缓鏃堕棿', `create_user` bigint NULL DEFAULT NULL COMMENT '鍒涘缓鐢ㄦ埛', `update_time` datetime NULL DEFAULT NULL COMMENT '淇敼鏃堕棿', @@ -4887,6 +4896,7 @@ `company_phone` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鍏徃鐢佃瘽', `bank_account_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '寮�鎴疯', `bank_account_num` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '璐﹀彿', + `bank_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '閾惰仈琛屽彿', `contact_user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鑱旂郴浜�', `contact_user_phone` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鑱旂郴鐢佃瘽', `maintain_user_id` bigint NULL DEFAULT NULL COMMENT '缁存姢浜篒D', -- Gitblit v1.9.3