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 | 2 ++ 1 files changed, 2 insertions(+), 0 deletions(-) diff --git a/sql/product-inventory-management-new-pro.sql b/sql/product-inventory-management-new-pro.sql index 2752b38..4afdf6d 100644 --- a/sql/product-inventory-management-new-pro.sql +++ b/sql/product-inventory-management-new-pro.sql @@ -4416,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 '淇敼鏃堕棿', @@ -4895,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