From 4ba399c0159d7dceff8f95beb05fb1a92dbda049 Mon Sep 17 00:00:00 2001 From: gaoluyang <2820782392@qq.com> Date: 星期日, 11 十月 2026 22:41:45 +0800 Subject: [PATCH] 天津-奇缘恒艺 录数据需求修改 --- sql/product-inventory-management-new-pro.sql | 12 ++++++++++-- 1 files changed, 10 insertions(+), 2 deletions(-) diff --git a/sql/product-inventory-management-new-pro.sql b/sql/product-inventory-management-new-pro.sql index 35c0008..351ef88 100644 --- a/sql/product-inventory-management-new-pro.sql +++ b/sql/product-inventory-management-new-pro.sql @@ -1037,7 +1037,7 @@ `update_time` datetime NULL DEFAULT NULL COMMENT '鏇存柊鏃堕棿', `create_user` int NOT NULL COMMENT '褰曞叆浜�', `update_user` int NOT NULL COMMENT '鏇存柊浜�', - `tenant_id` bigint NOT NULL COMMENT '绉熸埛id', + `tenant_id` bigint NULL DEFAULT NULL COMMENT '绉熸埛id', `device_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `device_model` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `maintenance_result` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '淇濆吇缁撴灉', @@ -1089,7 +1089,7 @@ `update_time` datetime NULL DEFAULT NULL COMMENT '鏇存柊鏃堕棿', `create_user` int NOT NULL COMMENT '褰曞叆浜�', `update_user` int NULL DEFAULT NULL COMMENT '鏇存柊浜�', - `tenant_id` bigint NOT NULL COMMENT '绉熸埛id', + `tenant_id` bigint NULL DEFAULT NULL COMMENT '绉熸埛id', `device_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `device_model` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `maintenance_price` decimal(10, 2) NULL DEFAULT NULL COMMENT '缁翠慨浠锋牸', @@ -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 '鍒跺崟鏃堕棿', -- Gitblit v1.9.3