From 08ef63eb44102f05c21e5370fd096a7f0cfee20c Mon Sep 17 00:00:00 2001
From: 无关风月 <443237572@qq.com>
Date: 星期五, 27 二月 2026 10:05:03 +0800
Subject: [PATCH] Merge remote-tracking branch 'origin/master'
---
sql/xprt_maintenance.sql | 405 ++++++++++++++++++++++++++++++++++++++++++++++-----------
1 files changed, 327 insertions(+), 78 deletions(-)
diff --git a/sql/xprt_maintenance.sql b/sql/xprt_maintenance.sql
index 37e5c72..c400d32 100644
--- a/sql/xprt_maintenance.sql
+++ b/sql/xprt_maintenance.sql
@@ -11,7 +11,7 @@
Target Server Version : 80019 (8.0.19)
File Encoding : 65001
- Date: 25/02/2026 18:54:48
+ Date: 26/02/2026 16:56:16
*/
SET NAMES utf8mb4;
@@ -130,7 +130,7 @@
INSERT INTO `xp_charging_record_1` VALUES (2026580977223528449, NULL, 1, 100, '{\"id\": \"53753298-fa1a-4b95-98b5-e683b1e4228d\", \"url\": \"https://we-park-life.oss-cn-beijing.aliyuncs.com/img/K4vqtLmVc6.png\", \"name\": \"测试.jpg\"}', '2026-02-25 16:52:12', NULL, NULL, NULL, 3, NULL, 0, '2026-02-25 16:52:12', '2026-02-25 16:52:12', '', '');
INSERT INTO `xp_charging_record_1` VALUES (2026581595472326657, NULL, 1, 100, '{\"id\": \"32387857-1338-4ffd-8163-c4dc0ebcff68\", \"url\": \"https://we-park-life.oss-cn-beijing.aliyuncs.com/img/K4vqtLmVc6.png\", \"name\": \"测试.jpg\"}', '2026-02-25 16:54:39', NULL, NULL, NULL, 3, NULL, 0, '2026-02-25 16:54:39', '2026-02-25 16:54:39', '', '');
INSERT INTO `xp_charging_record_1` VALUES (2026581976239599618, NULL, 1, 100, '{\"id\": \"e13331ed-f88c-4c37-ba3e-4304289fea86\", \"url\": \"https://we-park-life.oss-cn-beijing.aliyuncs.com/img/K4vqtLmVc6.png\", \"name\": \"测试.jpg\"}', '2026-02-25 16:56:10', NULL, NULL, NULL, 3, NULL, 0, '2026-02-25 16:56:10', '2026-02-25 16:56:10', '', '');
-INSERT INTO `xp_charging_record_1` VALUES (2026583010991173633, NULL, 1, 100, '{\"id\": \"1767c9e2-42eb-485c-aab0-65822a6ddbb0\", \"url\": \"https://we-park-life.oss-cn-beijing.aliyuncs.com/img/K4vqtLmVc6.png\", \"name\": \"测试.jpg\"}', '2026-02-25 17:00:17', NULL, NULL, NULL, 3, NULL, 0, '2026-02-25 17:00:17', '2026-02-25 17:00:17', '', '');
+INSERT INTO `xp_charging_record_1` VALUES (2026583010991173633, NULL, 1, 100, '{\"id\": \"1767c9e2-42eb-485c-aab0-65822a6ddbb0\", \"url\": \"https://we-park-life.oss-cn-beijing.aliyuncs.com/img/K4vqtLmVc6.png\", \"name\": \"测试.jpg\"}', '2026-02-25 17:00:17', 1000, '{\"id\": \"5b10435c-95db-44d0-a599-79b3c8b5e0df\", \"url\": \"https://we-park-life.oss-cn-beijing.aliyuncs.com/img/K4vqtLmVc6.png\", \"name\": \"测试.jpg\"}', '2026-02-26 12:03:20', 3, 3, 0, '2026-02-25 17:00:17', '2026-02-26 12:03:20', '', '');
INSERT INTO `xp_charging_record_1` VALUES (2026583200875704322, NULL, 1, 100, '{\"id\": \"03b8ceb5-4ee4-45f3-bd09-bd5891825ed1\", \"url\": \"https://we-park-life.oss-cn-beijing.aliyuncs.com/img/K4vqtLmVc6.png\", \"name\": \"测试.jpg\"}', '2026-02-25 17:01:02', 1000, '{\"id\": \"05a5dc43-bc55-4993-abe3-602032d96eef\", \"url\": \"https://we-park-life.oss-cn-beijing.aliyuncs.com/img/K4vqtLmVc6.png\", \"name\": \"测试.jpg\"}', '2026-02-25 18:09:01', 3, 3, 0, '2026-02-25 17:01:02', '2026-02-25 18:09:01', '', '');
-- ----------------------------
@@ -673,12 +673,13 @@
`create_by` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '创建人',
`update_by` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '修改人',
PRIMARY KEY (`id`) USING BTREE
-) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '打卡地址管理' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '打卡地址管理' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of xp_check_location
-- ----------------------------
-INSERT INTO `xp_check_location` VALUES (1, '天府新谷', 100.00, 104.065861, 30.657401, 1, 0, '2026-02-13 15:27:03', '2026-02-24 22:00:22', '', '');
+INSERT INTO `xp_check_location` VALUES (1, '四川省成都市青羊区少城街道人民公园', 100.00, 104.057643, 30.657083, 1, 0, '2026-02-13 15:27:03', '2026-02-26 14:13:51', '', '开发');
+INSERT INTO `xp_check_location` VALUES (2, '成都金融城', 5000.00, 104.076544, 30.581039, 1, 1, '2026-02-26 11:47:25', '2026-02-26 11:50:20', '开发', '开发');
-- ----------------------------
-- Table structure for xp_clock_in
@@ -706,7 +707,7 @@
PRIMARY KEY (`id`) USING BTREE,
INDEX `idx_uid`(`app_user_id` ASC) USING BTREE COMMENT '用户id索引',
INDEX `idx_sid`(`shift_id` ASC) USING BTREE COMMENT '班次id索引'
-) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '打卡明细' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '打卡明细' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of xp_clock_in
@@ -1149,13 +1150,22 @@
INDEX `idx_vid`(`vehicle_id` ASC) USING BTREE COMMENT '车辆id',
INDEX `idx_uid`(`applicant_id` ASC) USING BTREE COMMENT '申请人id',
INDEX `idx_status`(`audit_status` ASC) USING BTREE COMMENT '状态'
-) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '保单申请' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '保单申请' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of xp_policy_application
-- ----------------------------
INSERT INTO `xp_policy_application` VALUES (1, 2, 1, '2026-02-19 16:18:45', NULL, 1, '', NULL, 0, '2026-02-19 16:19:12', '2026-02-19 16:19:12', '', '');
INSERT INTO `xp_policy_application` VALUES (2, 1, 1, '2026-02-22 15:10:18', NULL, 1, '', NULL, 0, '2026-02-22 15:10:18', '2026-02-22 15:10:18', '', '');
+INSERT INTO `xp_policy_application` VALUES (3, 2, 3, '2026-02-25 20:44:57', NULL, 1, '', NULL, 0, '2026-02-25 20:44:57', '2026-02-25 20:44:57', '', '');
+INSERT INTO `xp_policy_application` VALUES (4, 2, 3, '2026-02-25 20:44:58', NULL, 1, '', NULL, 0, '2026-02-25 20:44:58', '2026-02-25 20:44:58', '', '');
+INSERT INTO `xp_policy_application` VALUES (5, 2, 3, '2026-02-25 20:44:58', NULL, 1, '', NULL, 0, '2026-02-25 20:44:58', '2026-02-25 20:44:58', '', '');
+INSERT INTO `xp_policy_application` VALUES (6, 2, 3, '2026-02-25 20:44:58', NULL, 1, '', NULL, 0, '2026-02-25 20:44:58', '2026-02-25 20:44:58', '', '');
+INSERT INTO `xp_policy_application` VALUES (7, 2, 3, '2026-02-25 20:44:58', NULL, 1, '', NULL, 0, '2026-02-25 20:44:58', '2026-02-25 20:44:58', '', '');
+INSERT INTO `xp_policy_application` VALUES (8, 2, 3, '2026-02-25 20:44:59', NULL, 1, '', NULL, 0, '2026-02-25 20:44:59', '2026-02-25 20:44:59', '', '');
+INSERT INTO `xp_policy_application` VALUES (9, 2, 3, '2026-02-25 20:44:59', NULL, 1, '', NULL, 0, '2026-02-25 20:44:59', '2026-02-25 20:44:59', '', '');
+INSERT INTO `xp_policy_application` VALUES (10, 2, 3, '2026-02-25 20:44:59', NULL, 1, '', NULL, 0, '2026-02-25 20:44:59', '2026-02-25 20:44:59', '', '');
+INSERT INTO `xp_policy_application` VALUES (11, 2, 3, '2026-02-25 20:44:59', NULL, 1, '', NULL, 0, '2026-02-25 20:44:59', '2026-02-25 20:44:59', '', '');
-- ----------------------------
-- Table structure for xp_position
@@ -1171,7 +1181,7 @@
`create_by` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '创建人',
`update_by` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '修改人',
PRIMARY KEY (`id`) USING BTREE
-) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '运维岗位' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '运维岗位' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of xp_position
@@ -1243,14 +1253,19 @@
`update_by` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '修改人',
PRIMARY KEY (`id`) USING BTREE,
INDEX `idx_name`(`shift_name` ASC) USING BTREE COMMENT '名称'
-) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '班次管理' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '班次管理' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of xp_shift
-- ----------------------------
-INSERT INTO `xp_shift` VALUES (1, '早', '红', '08:00', '16:00', 0, '11:30', '12:30', 0, '2026-02-19 20:48:02', '2026-02-19 20:48:24', '', '');
-INSERT INTO `xp_shift` VALUES (2, '中', '绿', '16:00', '00:00', 0, '06:30', '07:30', 0, '2026-02-19 20:48:02', '2026-02-19 20:49:49', '', '');
-INSERT INTO `xp_shift` VALUES (3, '晚', '蓝', '00:00', '08:00', 0, '03:30', '04:30', 0, '2026-02-19 20:48:02', '2026-02-19 20:49:58', '', '');
+INSERT INTO `xp_shift` VALUES (1, '早', '红', '08:00', '16:00', 0, '11:30', '12:30', 1, '2026-02-19 20:48:02', '2026-02-26 14:50:29', '', '开发');
+INSERT INTO `xp_shift` VALUES (2, '中', '绿', '16:00', '00:00', 0, '06:30', '07:30', 1, '2026-02-19 20:48:02', '2026-02-26 14:50:30', '', '开发');
+INSERT INTO `xp_shift` VALUES (3, '晚', '蓝', '00:00', '08:00', 0, '03:30', '04:30', 1, '2026-02-19 20:48:02', '2026-02-26 14:50:31', '', '开发');
+INSERT INTO `xp_shift` VALUES (4, '', '', '06:00', '12:00', 0, '', '', 1, '2026-02-26 14:40:36', '2026-02-26 14:45:58', '开发', '开发');
+INSERT INTO `xp_shift` VALUES (5, '早班', '#B886F8', '09:00', '12:00', 0, '', '', 0, '2026-02-26 14:46:42', '2026-02-26 14:52:27', '开发', '开发');
+INSERT INTO `xp_shift` VALUES (6, '中班', '#FCCA00', '12:00', '18:00', 1, '15:00', '16:00', 0, '2026-02-26 14:50:55', '2026-02-26 14:50:55', '开发', '开发');
+INSERT INTO `xp_shift` VALUES (7, '晚班', '#16A60C', '18:00', '23:00', 0, '', '', 0, '2026-02-26 14:51:49', '2026-02-26 14:51:49', '开发', '开发');
+INSERT INTO `xp_shift` VALUES (8, '全天', '#54BCBD', '09:00', '22:00', 1, '12:00', '13:00', 0, '2026-02-26 14:52:18', '2026-02-26 14:52:18', '开发', '开发');
-- ----------------------------
-- Table structure for xp_task
@@ -3354,7 +3369,7 @@
-- ----------------------------
-- Records of xp_vehicle
-- ----------------------------
-INSERT INTO `xp_vehicle` VALUES (1, '03', '12312312312312312', '1', '粤PXV7029', '阿斯蒂芬', '白色', '{\"id\": \"926c50a3\", \"url\": \"https://zos.alipayobjects.com/rmsportal/jkjgkEfvpUPVyRjUImniVslZfWPnJuuZ.png\", \"name\": \"6lvylsNkTqdn86fe4fc2e7832b2ecd08d28bb4bc3c8c.png\"}', '采购', '备注', '2026-02-14 00:00:00', '宝相寺', '18224358736', '2026-02-21 00:00:00', '[{\"id\": \"6514c2ab\", \"url\": \"https://zos.alipayobjects.com/rmsportal/jkjgkEfvpUPVyRjUImniVslZfWPnJuuZ.png\", \"name\": \"90.jpg\"}]', '[{\"id\": \"ae9cb5ff\", \"url\": \"https://zos.alipayobjects.com/rmsportal/jkjgkEfvpUPVyRjUImniVslZfWPnJuuZ.png\", \"name\": \"90.jpg\"}]', 23, '[{\"id\": \"35bd87e9\", \"url\": \"https://zos.alipayobjects.com/rmsportal/jkjgkEfvpUPVyRjUImniVslZfWPnJuuZ.png\", \"name\": \"52852962eb8be041576show.jpg\"}]', '2026-02-28 00:00:00', 0, 2, 3, '2026-02-13 16:05:40', 1, 1, 1, 100, NULL, 0, '2026-02-13 16:05:40', '2026-02-24 11:20:58', '', '');
+INSERT INTO `xp_vehicle` VALUES (1, '03', '12312312312312312', '1', '粤PXV7029', '阿斯蒂芬', '白色', '{\"id\": \"926c50a3\", \"url\": \"https://zos.alipayobjects.com/rmsportal/jkjgkEfvpUPVyRjUImniVslZfWPnJuuZ.png\", \"name\": \"6lvylsNkTqdn86fe4fc2e7832b2ecd08d28bb4bc3c8c.png\"}', '采购', '备注', '2026-02-14 00:00:00', '宝相寺', '18224358736', '2026-02-21 00:00:00', '[{\"id\": \"6514c2ab\", \"url\": \"https://zos.alipayobjects.com/rmsportal/jkjgkEfvpUPVyRjUImniVslZfWPnJuuZ.png\", \"name\": \"90.jpg\"}]', '[{\"id\": \"ae9cb5ff\", \"url\": \"https://zos.alipayobjects.com/rmsportal/jkjgkEfvpUPVyRjUImniVslZfWPnJuuZ.png\", \"name\": \"90.jpg\"}]', 23, '[{\"id\": \"35bd87e9\", \"url\": \"https://zos.alipayobjects.com/rmsportal/jkjgkEfvpUPVyRjUImniVslZfWPnJuuZ.png\", \"name\": \"52852962eb8be041576show.jpg\"}]', '2026-02-28 00:00:00', 0, 2, 3, '2026-02-13 16:05:40', 1, 1, 1, 100, NULL, 0, '2026-02-13 16:05:40', '2026-02-25 20:57:50', '', '');
INSERT INTO `xp_vehicle` VALUES (2, '1', 'CDTEST005', '1', '1', '1', '1', '{\"id\": \"926c50a3\", \"url\": \"https://q3.itc.cn/images01/20240319/ebdf9d93de4a498bbb819a0bce143cb7.jpeg\", \"name\": \"6lvylsNkTqdn86fe4fc2e7832b2ecd08d28bb4bc3c8c.png\"}', '1', '1', '2026-02-13 10:19:47', '1', '1', '2026-02-13 10:19:51', '1', '1', 22, '1', '2026-02-13 10:20:03', 0, 2, 1, '2026-02-13 10:20:21', 2, 1, 1, 10, NULL, 0, '2026-02-13 10:19:31', '2026-02-13 21:17:15', '1', '1');
INSERT INTO `xp_vehicle` VALUES (4, '0001', '21312323333333312', '1', '川X00001', '型号001', '白色', '{\"id\": \"926c50a3\", \"url\": \"https://q3.itc.cn/images01/20240319/ebdf9d93de4a498bbb819a0bce143cb7.jpeg\", \"name\": \"6lvylsNkTqdn86fe4fc2e7832b2ecd08d28bb4bc3c8c.png\"}', '采购', '这是备注001', '2026-02-26 00:00:00', '宝相寺', '18224358736', '2026-02-27 00:00:00', '[{\"id\": \"6ad5adb7\", \"url\": null, \"name\": \"5c7915bf-bb79-4450-924b-73c5b523055f.jpg\"}]', '[{\"id\": \"f203241c\", \"url\": null, \"name\": \"6c49230287fa2bfb9d5ee9783a14584c.jpg\"}]', 15, '[{\"id\": \"e4d966a2\", \"url\": null, \"name\": \"602e0742de3b93bc391d71641e4a904c.jpg\"}]', '2026-02-28 00:00:00', 0, 2, 1, '2026-02-13 14:50:59', 2, 1, NULL, 100, NULL, 0, '2026-02-13 14:50:59', '2026-02-13 21:17:15', '', '');
INSERT INTO `xp_vehicle` VALUES (6, '1001', 'TEST0041111111111', '1', '粤PXV7029', '1', '1', '{\"id\": \"926c50a3\", \"url\": \"https://zos.alipayobjects.com/rmsportal/jkjgkEfvpUPVyRjUImniVslZfWPnJuuZ.png\", \"name\": \"6lvylsNkTqdn86fe4fc2e7832b2ecd08d28bb4bc3c8c.png\"}', '1', '1', '2026-02-13 10:19:47', '1', '1', '2026-02-13 10:19:51', '1', '1', 23, '1', '2026-02-13 10:20:03', 0, 2, 1, '2026-02-13 10:20:21', 1, 1, 1, 1, NULL, 0, '2026-02-13 10:19:31', '2026-02-22 10:06:20', '1', '');
@@ -3407,11 +3422,242 @@
`create_by` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '创建人',
`update_by` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '修改人',
PRIMARY KEY (`id`) USING BTREE
-) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '车辆清洁' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '车辆清洁' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of xp_vehicle_clean
-- ----------------------------
+INSERT INTO `xp_vehicle_clean` VALUES (1, NULL, 1, '{\"id\": \"03613bf8-7469-471b-90e6-4084edc21eef\", \"url\": \"https://we-park-life.oss-cn-beijing.aliyuncs.com/img/K4vqtLmVc6.png\", \"name\": \"测试.jpg\"}', 3, 0, '2026-02-26 16:17:18', '2026-02-26 16:17:18', '', '');
+
+-- ----------------------------
+-- Table structure for xp_vehicle_clean_0
+-- ----------------------------
+DROP TABLE IF EXISTS `xp_vehicle_clean_0`;
+CREATE TABLE `xp_vehicle_clean_0` (
+ `id` bigint NOT NULL AUTO_INCREMENT,
+ `task_id` bigint NULL DEFAULT NULL COMMENT '任务id',
+ `vehicle_id` bigint NOT NULL COMMENT '车辆id',
+ `task_image` json NOT NULL COMMENT '完成图片',
+ `operations_user_id` bigint NOT NULL COMMENT '操作人id',
+ `is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0=未删除 1=已删除',
+ `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
+ `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
+ `create_by` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '创建人',
+ `update_by` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '修改人',
+ PRIMARY KEY (`id`) USING BTREE
+) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '车辆清洁' ROW_FORMAT = Dynamic;
+
+-- ----------------------------
+-- Records of xp_vehicle_clean_0
+-- ----------------------------
+INSERT INTO `xp_vehicle_clean_0` VALUES (1, NULL, 1, '{\"id\": \"03613bf8-7469-471b-90e6-4084edc21eef\", \"url\": \"https://we-park-life.oss-cn-beijing.aliyuncs.com/img/K4vqtLmVc6.png\", \"name\": \"测试.jpg\"}', 3, 0, '2026-02-26 16:17:18', '2026-02-26 16:17:18', '', '');
+
+-- ----------------------------
+-- Table structure for xp_vehicle_clean_1
+-- ----------------------------
+DROP TABLE IF EXISTS `xp_vehicle_clean_1`;
+CREATE TABLE `xp_vehicle_clean_1` (
+ `id` bigint NOT NULL AUTO_INCREMENT,
+ `task_id` bigint NULL DEFAULT NULL COMMENT '任务id',
+ `vehicle_id` bigint NOT NULL COMMENT '车辆id',
+ `task_image` json NOT NULL COMMENT '完成图片',
+ `operations_user_id` bigint NOT NULL COMMENT '操作人id',
+ `is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0=未删除 1=已删除',
+ `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
+ `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
+ `create_by` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '创建人',
+ `update_by` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '修改人',
+ PRIMARY KEY (`id`) USING BTREE
+) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '车辆清洁' ROW_FORMAT = Dynamic;
+
+-- ----------------------------
+-- Records of xp_vehicle_clean_1
+-- ----------------------------
+INSERT INTO `xp_vehicle_clean_1` VALUES (1, NULL, 1, '{\"id\": \"03613bf8-7469-471b-90e6-4084edc21eef\", \"url\": \"https://we-park-life.oss-cn-beijing.aliyuncs.com/img/K4vqtLmVc6.png\", \"name\": \"测试.jpg\"}', 3, 0, '2026-02-26 16:17:18', '2026-02-26 16:17:18', '', '');
+
+-- ----------------------------
+-- Table structure for xp_vehicle_clean_2
+-- ----------------------------
+DROP TABLE IF EXISTS `xp_vehicle_clean_2`;
+CREATE TABLE `xp_vehicle_clean_2` (
+ `id` bigint NOT NULL AUTO_INCREMENT,
+ `task_id` bigint NULL DEFAULT NULL COMMENT '任务id',
+ `vehicle_id` bigint NOT NULL COMMENT '车辆id',
+ `task_image` json NOT NULL COMMENT '完成图片',
+ `operations_user_id` bigint NOT NULL COMMENT '操作人id',
+ `is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0=未删除 1=已删除',
+ `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
+ `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
+ `create_by` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '创建人',
+ `update_by` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '修改人',
+ PRIMARY KEY (`id`) USING BTREE
+) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '车辆清洁' ROW_FORMAT = Dynamic;
+
+-- ----------------------------
+-- Records of xp_vehicle_clean_2
+-- ----------------------------
+INSERT INTO `xp_vehicle_clean_2` VALUES (1, NULL, 1, '{\"id\": \"03613bf8-7469-471b-90e6-4084edc21eef\", \"url\": \"https://we-park-life.oss-cn-beijing.aliyuncs.com/img/K4vqtLmVc6.png\", \"name\": \"测试.jpg\"}', 3, 0, '2026-02-26 16:17:18', '2026-02-26 16:17:18', '', '');
+
+-- ----------------------------
+-- Table structure for xp_vehicle_clean_3
+-- ----------------------------
+DROP TABLE IF EXISTS `xp_vehicle_clean_3`;
+CREATE TABLE `xp_vehicle_clean_3` (
+ `id` bigint NOT NULL AUTO_INCREMENT,
+ `task_id` bigint NULL DEFAULT NULL COMMENT '任务id',
+ `vehicle_id` bigint NOT NULL COMMENT '车辆id',
+ `task_image` json NOT NULL COMMENT '完成图片',
+ `operations_user_id` bigint NOT NULL COMMENT '操作人id',
+ `is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0=未删除 1=已删除',
+ `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
+ `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
+ `create_by` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '创建人',
+ `update_by` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '修改人',
+ PRIMARY KEY (`id`) USING BTREE
+) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '车辆清洁' ROW_FORMAT = Dynamic;
+
+-- ----------------------------
+-- Records of xp_vehicle_clean_3
+-- ----------------------------
+INSERT INTO `xp_vehicle_clean_3` VALUES (1, NULL, 1, '{\"id\": \"03613bf8-7469-471b-90e6-4084edc21eef\", \"url\": \"https://we-park-life.oss-cn-beijing.aliyuncs.com/img/K4vqtLmVc6.png\", \"name\": \"测试.jpg\"}', 3, 0, '2026-02-26 16:17:18', '2026-02-26 16:17:18', '', '');
+
+-- ----------------------------
+-- Table structure for xp_vehicle_clean_4
+-- ----------------------------
+DROP TABLE IF EXISTS `xp_vehicle_clean_4`;
+CREATE TABLE `xp_vehicle_clean_4` (
+ `id` bigint NOT NULL AUTO_INCREMENT,
+ `task_id` bigint NULL DEFAULT NULL COMMENT '任务id',
+ `vehicle_id` bigint NOT NULL COMMENT '车辆id',
+ `task_image` json NOT NULL COMMENT '完成图片',
+ `operations_user_id` bigint NOT NULL COMMENT '操作人id',
+ `is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0=未删除 1=已删除',
+ `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
+ `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
+ `create_by` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '创建人',
+ `update_by` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '修改人',
+ PRIMARY KEY (`id`) USING BTREE
+) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '车辆清洁' ROW_FORMAT = Dynamic;
+
+-- ----------------------------
+-- Records of xp_vehicle_clean_4
+-- ----------------------------
+INSERT INTO `xp_vehicle_clean_4` VALUES (1, NULL, 1, '{\"id\": \"03613bf8-7469-471b-90e6-4084edc21eef\", \"url\": \"https://we-park-life.oss-cn-beijing.aliyuncs.com/img/K4vqtLmVc6.png\", \"name\": \"测试.jpg\"}', 3, 0, '2026-02-26 16:17:18', '2026-02-26 16:17:18', '', '');
+
+-- ----------------------------
+-- Table structure for xp_vehicle_clean_5
+-- ----------------------------
+DROP TABLE IF EXISTS `xp_vehicle_clean_5`;
+CREATE TABLE `xp_vehicle_clean_5` (
+ `id` bigint NOT NULL AUTO_INCREMENT,
+ `task_id` bigint NULL DEFAULT NULL COMMENT '任务id',
+ `vehicle_id` bigint NOT NULL COMMENT '车辆id',
+ `task_image` json NOT NULL COMMENT '完成图片',
+ `operations_user_id` bigint NOT NULL COMMENT '操作人id',
+ `is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0=未删除 1=已删除',
+ `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
+ `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
+ `create_by` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '创建人',
+ `update_by` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '修改人',
+ PRIMARY KEY (`id`) USING BTREE
+) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '车辆清洁' ROW_FORMAT = Dynamic;
+
+-- ----------------------------
+-- Records of xp_vehicle_clean_5
+-- ----------------------------
+INSERT INTO `xp_vehicle_clean_5` VALUES (1, NULL, 1, '{\"id\": \"03613bf8-7469-471b-90e6-4084edc21eef\", \"url\": \"https://we-park-life.oss-cn-beijing.aliyuncs.com/img/K4vqtLmVc6.png\", \"name\": \"测试.jpg\"}', 3, 0, '2026-02-26 16:17:18', '2026-02-26 16:17:18', '', '');
+
+-- ----------------------------
+-- Table structure for xp_vehicle_clean_6
+-- ----------------------------
+DROP TABLE IF EXISTS `xp_vehicle_clean_6`;
+CREATE TABLE `xp_vehicle_clean_6` (
+ `id` bigint NOT NULL AUTO_INCREMENT,
+ `task_id` bigint NULL DEFAULT NULL COMMENT '任务id',
+ `vehicle_id` bigint NOT NULL COMMENT '车辆id',
+ `task_image` json NOT NULL COMMENT '完成图片',
+ `operations_user_id` bigint NOT NULL COMMENT '操作人id',
+ `is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0=未删除 1=已删除',
+ `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
+ `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
+ `create_by` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '创建人',
+ `update_by` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '修改人',
+ PRIMARY KEY (`id`) USING BTREE
+) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '车辆清洁' ROW_FORMAT = Dynamic;
+
+-- ----------------------------
+-- Records of xp_vehicle_clean_6
+-- ----------------------------
+INSERT INTO `xp_vehicle_clean_6` VALUES (1, NULL, 1, '{\"id\": \"03613bf8-7469-471b-90e6-4084edc21eef\", \"url\": \"https://we-park-life.oss-cn-beijing.aliyuncs.com/img/K4vqtLmVc6.png\", \"name\": \"测试.jpg\"}', 3, 0, '2026-02-26 16:17:18', '2026-02-26 16:17:18', '', '');
+
+-- ----------------------------
+-- Table structure for xp_vehicle_clean_7
+-- ----------------------------
+DROP TABLE IF EXISTS `xp_vehicle_clean_7`;
+CREATE TABLE `xp_vehicle_clean_7` (
+ `id` bigint NOT NULL AUTO_INCREMENT,
+ `task_id` bigint NULL DEFAULT NULL COMMENT '任务id',
+ `vehicle_id` bigint NOT NULL COMMENT '车辆id',
+ `task_image` json NOT NULL COMMENT '完成图片',
+ `operations_user_id` bigint NOT NULL COMMENT '操作人id',
+ `is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0=未删除 1=已删除',
+ `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
+ `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
+ `create_by` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '创建人',
+ `update_by` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '修改人',
+ PRIMARY KEY (`id`) USING BTREE
+) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '车辆清洁' ROW_FORMAT = Dynamic;
+
+-- ----------------------------
+-- Records of xp_vehicle_clean_7
+-- ----------------------------
+INSERT INTO `xp_vehicle_clean_7` VALUES (1, NULL, 1, '{\"id\": \"03613bf8-7469-471b-90e6-4084edc21eef\", \"url\": \"https://we-park-life.oss-cn-beijing.aliyuncs.com/img/K4vqtLmVc6.png\", \"name\": \"测试.jpg\"}', 3, 0, '2026-02-26 16:17:18', '2026-02-26 16:17:18', '', '');
+
+-- ----------------------------
+-- Table structure for xp_vehicle_clean_8
+-- ----------------------------
+DROP TABLE IF EXISTS `xp_vehicle_clean_8`;
+CREATE TABLE `xp_vehicle_clean_8` (
+ `id` bigint NOT NULL AUTO_INCREMENT,
+ `task_id` bigint NULL DEFAULT NULL COMMENT '任务id',
+ `vehicle_id` bigint NOT NULL COMMENT '车辆id',
+ `task_image` json NOT NULL COMMENT '完成图片',
+ `operations_user_id` bigint NOT NULL COMMENT '操作人id',
+ `is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0=未删除 1=已删除',
+ `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
+ `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
+ `create_by` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '创建人',
+ `update_by` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '修改人',
+ PRIMARY KEY (`id`) USING BTREE
+) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '车辆清洁' ROW_FORMAT = Dynamic;
+
+-- ----------------------------
+-- Records of xp_vehicle_clean_8
+-- ----------------------------
+INSERT INTO `xp_vehicle_clean_8` VALUES (1, NULL, 1, '{\"id\": \"03613bf8-7469-471b-90e6-4084edc21eef\", \"url\": \"https://we-park-life.oss-cn-beijing.aliyuncs.com/img/K4vqtLmVc6.png\", \"name\": \"测试.jpg\"}', 3, 0, '2026-02-26 16:17:18', '2026-02-26 16:17:18', '', '');
+
+-- ----------------------------
+-- Table structure for xp_vehicle_clean_9
+-- ----------------------------
+DROP TABLE IF EXISTS `xp_vehicle_clean_9`;
+CREATE TABLE `xp_vehicle_clean_9` (
+ `id` bigint NOT NULL AUTO_INCREMENT,
+ `task_id` bigint NULL DEFAULT NULL COMMENT '任务id',
+ `vehicle_id` bigint NOT NULL COMMENT '车辆id',
+ `task_image` json NOT NULL COMMENT '完成图片',
+ `operations_user_id` bigint NOT NULL COMMENT '操作人id',
+ `is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0=未删除 1=已删除',
+ `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
+ `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
+ `create_by` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '创建人',
+ `update_by` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '修改人',
+ PRIMARY KEY (`id`) USING BTREE
+) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '车辆清洁' ROW_FORMAT = Dynamic;
+
+-- ----------------------------
+-- Records of xp_vehicle_clean_9
+-- ----------------------------
+INSERT INTO `xp_vehicle_clean_9` VALUES (1, NULL, 1, '{\"id\": \"03613bf8-7469-471b-90e6-4084edc21eef\", \"url\": \"https://we-park-life.oss-cn-beijing.aliyuncs.com/img/K4vqtLmVc6.png\", \"name\": \"测试.jpg\"}', 3, 0, '2026-02-26 16:17:18', '2026-02-26 16:17:18', '', '');
-- ----------------------------
-- Table structure for xp_vehicle_description
@@ -3915,7 +4161,7 @@
`fog_light` json NOT NULL COMMENT '雾灯',
`body_emblem` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '车身标识',
`cabin_cleaning` json NOT NULL COMMENT '舱内清洁',
- `lost_items` json NOT NULL COMMENT '遗失物品',
+ `lost_items` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '遗失物品',
`remarks` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '备注',
`operations_user_id` bigint NOT NULL COMMENT '操作人id',
`is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0=未删除 1=已删除',
@@ -3952,7 +4198,7 @@
`fog_light` json NOT NULL COMMENT '雾灯',
`body_emblem` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '车身标识',
`cabin_cleaning` json NOT NULL COMMENT '舱内清洁',
- `lost_items` json NOT NULL COMMENT '遗失物品',
+ `lost_items` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '遗失物品',
`remarks` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '备注',
`operations_user_id` bigint NOT NULL COMMENT '操作人id',
`is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0=未删除 1=已删除',
@@ -3988,7 +4234,7 @@
`fog_light` json NOT NULL COMMENT '雾灯',
`body_emblem` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '车身标识',
`cabin_cleaning` json NOT NULL COMMENT '舱内清洁',
- `lost_items` json NOT NULL COMMENT '遗失物品',
+ `lost_items` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '遗失物品',
`remarks` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '备注',
`operations_user_id` bigint NOT NULL COMMENT '操作人id',
`is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0=未删除 1=已删除',
@@ -4005,6 +4251,7 @@
-- ----------------------------
-- Records of xp_vehicle_preparation_1
-- ----------------------------
+INSERT INTO `xp_vehicle_preparation_1` VALUES (1, NULL, 1, '2.5', '2.5', '2.5', '2.5', '{\"id\": \"4974561c-ae22-486c-8008-07e4ca6d76d3\", \"url\": \"https://we-park-life.oss-cn-beijing.aliyuncs.com/img/K4vqtLmVc6.png\", \"name\": \"测试.jpg\"}', '{\"id\": \"6901b20a-4e32-42be-8cc3-24c895396a3e\", \"url\": \"https://we-park-life.oss-cn-beijing.aliyuncs.com/img/K4vqtLmVc6.png\", \"name\": \"测试.jpg\"}', '{\"id\": \"bb9706cf-c917-42eb-baab-0548ed118502\", \"url\": \"https://we-park-life.oss-cn-beijing.aliyuncs.com/img/K4vqtLmVc6.png\", \"name\": \"测试.jpg\"}', '{\"id\": \"c7926ae3-6d01-46e5-83f5-34b78961a14a\", \"url\": \"https://we-park-life.oss-cn-beijing.aliyuncs.com/img/K4vqtLmVc6.png\", \"name\": \"测试.jpg\"}', NULL, '{\"id\": \"320066da-00b1-487c-9d71-02dd1c234bc5\", \"url\": \"https://we-park-life.oss-cn-beijing.aliyuncs.com/img/K4vqtLmVc6.png\", \"name\": \"测试.jpg\"}', '', '', 3, 0, '2026-02-26 16:30:46', '2026-02-26 16:30:46', '', '');
-- ----------------------------
-- Table structure for xp_vehicle_preparation_2
@@ -4024,7 +4271,7 @@
`fog_light` json NOT NULL COMMENT '雾灯',
`body_emblem` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '车身标识',
`cabin_cleaning` json NOT NULL COMMENT '舱内清洁',
- `lost_items` json NOT NULL COMMENT '遗失物品',
+ `lost_items` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '遗失物品',
`remarks` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '备注',
`operations_user_id` bigint NOT NULL COMMENT '操作人id',
`is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0=未删除 1=已删除',
@@ -4061,7 +4308,7 @@
`fog_light` json NOT NULL COMMENT '雾灯',
`body_emblem` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '车身标识',
`cabin_cleaning` json NOT NULL COMMENT '舱内清洁',
- `lost_items` json NOT NULL COMMENT '遗失物品',
+ `lost_items` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '遗失物品',
`remarks` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '备注',
`operations_user_id` bigint NOT NULL COMMENT '操作人id',
`is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0=未删除 1=已删除',
@@ -4097,7 +4344,7 @@
`fog_light` json NOT NULL COMMENT '雾灯',
`body_emblem` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '车身标识',
`cabin_cleaning` json NOT NULL COMMENT '舱内清洁',
- `lost_items` json NOT NULL COMMENT '遗失物品',
+ `lost_items` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '遗失物品',
`remarks` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '备注',
`operations_user_id` bigint NOT NULL COMMENT '操作人id',
`is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0=未删除 1=已删除',
@@ -4133,7 +4380,7 @@
`fog_light` json NOT NULL COMMENT '雾灯',
`body_emblem` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '车身标识',
`cabin_cleaning` json NOT NULL COMMENT '舱内清洁',
- `lost_items` json NOT NULL COMMENT '遗失物品',
+ `lost_items` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '遗失物品',
`remarks` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '备注',
`operations_user_id` bigint NOT NULL COMMENT '操作人id',
`is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0=未删除 1=已删除',
@@ -4169,7 +4416,7 @@
`fog_light` json NOT NULL COMMENT '雾灯',
`body_emblem` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '车身标识',
`cabin_cleaning` json NOT NULL COMMENT '舱内清洁',
- `lost_items` json NOT NULL COMMENT '遗失物品',
+ `lost_items` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '遗失物品',
`remarks` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '备注',
`operations_user_id` bigint NOT NULL COMMENT '操作人id',
`is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0=未删除 1=已删除',
@@ -4205,7 +4452,7 @@
`fog_light` json NOT NULL COMMENT '雾灯',
`body_emblem` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '车身标识',
`cabin_cleaning` json NOT NULL COMMENT '舱内清洁',
- `lost_items` json NOT NULL COMMENT '遗失物品',
+ `lost_items` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '遗失物品',
`remarks` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '备注',
`operations_user_id` bigint NOT NULL COMMENT '操作人id',
`is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0=未删除 1=已删除',
@@ -4241,7 +4488,7 @@
`fog_light` json NOT NULL COMMENT '雾灯',
`body_emblem` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '车身标识',
`cabin_cleaning` json NOT NULL COMMENT '舱内清洁',
- `lost_items` json NOT NULL COMMENT '遗失物品',
+ `lost_items` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '遗失物品',
`remarks` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '备注',
`operations_user_id` bigint NOT NULL COMMENT '操作人id',
`is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0=未删除 1=已删除',
@@ -4277,7 +4524,7 @@
`fog_light` json NOT NULL COMMENT '雾灯',
`body_emblem` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '车身标识',
`cabin_cleaning` json NOT NULL COMMENT '舱内清洁',
- `lost_items` json NOT NULL COMMENT '遗失物品',
+ `lost_items` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '遗失物品',
`remarks` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '备注',
`operations_user_id` bigint NOT NULL COMMENT '操作人id',
`is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0=未删除 1=已删除',
@@ -4304,15 +4551,15 @@
`task_id` bigint NULL DEFAULT NULL COMMENT '任务id',
`vehicle_id` bigint NOT NULL COMMENT '车辆id',
`start_time` datetime NOT NULL COMMENT '开始时间',
- `end_time` datetime NOT NULL COMMENT '结束时间',
- `repair_reason` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '维修原因',
+ `end_time` datetime NULL DEFAULT NULL COMMENT '结束时间',
+ `repair_reason` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '维修原因',
`start_repair_picture` json NOT NULL COMMENT '维修前图片',
`repair_money` double(10, 2) NULL DEFAULT NULL COMMENT '维修费用',
- `repair_money_detail` json NOT NULL COMMENT '维修费用明细',
+ `repair_money_detail` json NULL COMMENT '维修费用明细',
`send_user_id` bigint NOT NULL COMMENT '送修人',
`send_time` datetime NOT NULL COMMENT '送修时间',
- `return_user_id` bigint NOT NULL COMMENT '取回人',
- `return_time` datetime NOT NULL COMMENT '取回时间',
+ `return_user_id` bigint NULL DEFAULT NULL COMMENT '取回人',
+ `return_time` datetime NULL DEFAULT NULL COMMENT '取回时间',
`is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0=未删除 1=已删除',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
@@ -4339,15 +4586,15 @@
`task_id` bigint NULL DEFAULT NULL COMMENT '任务id',
`vehicle_id` bigint NOT NULL COMMENT '车辆id',
`start_time` datetime NOT NULL COMMENT '开始时间',
- `end_time` datetime NOT NULL COMMENT '结束时间',
- `repair_reason` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '维修原因',
+ `end_time` datetime NULL DEFAULT NULL COMMENT '结束时间',
+ `repair_reason` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '维修原因',
`start_repair_picture` json NOT NULL COMMENT '维修前图片',
`repair_money` double(10, 2) NULL DEFAULT NULL COMMENT '维修费用',
- `repair_money_detail` json NOT NULL COMMENT '维修费用明细',
+ `repair_money_detail` json NULL COMMENT '维修费用明细',
`send_user_id` bigint NOT NULL COMMENT '送修人',
`send_time` datetime NOT NULL COMMENT '送修时间',
- `return_user_id` bigint NOT NULL COMMENT '取回人',
- `return_time` datetime NOT NULL COMMENT '取回时间',
+ `return_user_id` bigint NULL DEFAULT NULL COMMENT '取回人',
+ `return_time` datetime NULL DEFAULT NULL COMMENT '取回时间',
`is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0=未删除 1=已删除',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
@@ -4373,15 +4620,15 @@
`task_id` bigint NULL DEFAULT NULL COMMENT '任务id',
`vehicle_id` bigint NOT NULL COMMENT '车辆id',
`start_time` datetime NOT NULL COMMENT '开始时间',
- `end_time` datetime NOT NULL COMMENT '结束时间',
- `repair_reason` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '维修原因',
+ `end_time` datetime NULL DEFAULT NULL COMMENT '结束时间',
+ `repair_reason` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '维修原因',
`start_repair_picture` json NOT NULL COMMENT '维修前图片',
`repair_money` double(10, 2) NULL DEFAULT NULL COMMENT '维修费用',
- `repair_money_detail` json NOT NULL COMMENT '维修费用明细',
+ `repair_money_detail` json NULL COMMENT '维修费用明细',
`send_user_id` bigint NOT NULL COMMENT '送修人',
`send_time` datetime NOT NULL COMMENT '送修时间',
- `return_user_id` bigint NOT NULL COMMENT '取回人',
- `return_time` datetime NOT NULL COMMENT '取回时间',
+ `return_user_id` bigint NULL DEFAULT NULL COMMENT '取回人',
+ `return_time` datetime NULL DEFAULT NULL COMMENT '取回时间',
`is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0=未删除 1=已删除',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
@@ -4397,6 +4644,8 @@
-- ----------------------------
-- Records of xp_vehicle_repair_1
-- ----------------------------
+INSERT INTO `xp_vehicle_repair_1` VALUES (2026825064358916098, NULL, 1, '2026-02-26 00:00:00', '2026-02-27 00:00:00', '123', '{\"id\": \"abbe37b9-b9fd-49ba-8f79-405b6243e516\", \"url\": \"https://we-park-life.oss-cn-beijing.aliyuncs.com/img/K4vqtLmVc6.png\", \"name\": \"测试.jpg\"}', 1000.00, '{\"id\": \"88ec341c-1452-4881-b342-e607daa954e2\", \"url\": \"https://we-park-life.oss-cn-beijing.aliyuncs.com/img/K4vqtLmVc6.png\", \"name\": \"测试.jpg\"}', 3, '2026-02-26 09:02:07', 3, '2026-02-26 12:23:49', 0, '2026-02-26 09:02:07', '2026-02-26 12:23:49', '', '');
+INSERT INTO `xp_vehicle_repair_1` VALUES (2026879672955482114, NULL, 1, '2026-02-26 00:00:00', '2026-06-26 00:00:00', '1234455', '{\"id\": \"1a96fd88-8450-487b-b62c-4c9e2e793100\", \"url\": \"https://we-park-life.oss-cn-beijing.aliyuncs.com/img/K4vqtLmVc6.png\", \"name\": \"测试.jpg\"}', NULL, NULL, 3, '2026-02-26 12:39:06', NULL, NULL, 0, '2026-02-26 12:39:06', '2026-02-26 12:39:06', '', '');
-- ----------------------------
-- Table structure for xp_vehicle_repair_2
@@ -4407,15 +4656,15 @@
`task_id` bigint NULL DEFAULT NULL COMMENT '任务id',
`vehicle_id` bigint NOT NULL COMMENT '车辆id',
`start_time` datetime NOT NULL COMMENT '开始时间',
- `end_time` datetime NOT NULL COMMENT '结束时间',
- `repair_reason` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '维修原因',
+ `end_time` datetime NULL DEFAULT NULL COMMENT '结束时间',
+ `repair_reason` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '维修原因',
`start_repair_picture` json NOT NULL COMMENT '维修前图片',
`repair_money` double(10, 2) NULL DEFAULT NULL COMMENT '维修费用',
- `repair_money_detail` json NOT NULL COMMENT '维修费用明细',
+ `repair_money_detail` json NULL COMMENT '维修费用明细',
`send_user_id` bigint NOT NULL COMMENT '送修人',
`send_time` datetime NOT NULL COMMENT '送修时间',
- `return_user_id` bigint NOT NULL COMMENT '取回人',
- `return_time` datetime NOT NULL COMMENT '取回时间',
+ `return_user_id` bigint NULL DEFAULT NULL COMMENT '取回人',
+ `return_time` datetime NULL DEFAULT NULL COMMENT '取回时间',
`is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0=未删除 1=已删除',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
@@ -4441,15 +4690,15 @@
`task_id` bigint NULL DEFAULT NULL COMMENT '任务id',
`vehicle_id` bigint NOT NULL COMMENT '车辆id',
`start_time` datetime NOT NULL COMMENT '开始时间',
- `end_time` datetime NOT NULL COMMENT '结束时间',
- `repair_reason` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '维修原因',
+ `end_time` datetime NULL DEFAULT NULL COMMENT '结束时间',
+ `repair_reason` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '维修原因',
`start_repair_picture` json NOT NULL COMMENT '维修前图片',
`repair_money` double(10, 2) NULL DEFAULT NULL COMMENT '维修费用',
`repair_money_detail` json NOT NULL COMMENT '维修费用明细',
`send_user_id` bigint NOT NULL COMMENT '送修人',
`send_time` datetime NOT NULL COMMENT '送修时间',
- `return_user_id` bigint NOT NULL COMMENT '取回人',
- `return_time` datetime NOT NULL COMMENT '取回时间',
+ `return_user_id` bigint NULL DEFAULT NULL COMMENT '取回人',
+ `return_time` datetime NULL DEFAULT NULL COMMENT '取回时间',
`is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0=未删除 1=已删除',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
@@ -4475,15 +4724,15 @@
`task_id` bigint NULL DEFAULT NULL COMMENT '任务id',
`vehicle_id` bigint NOT NULL COMMENT '车辆id',
`start_time` datetime NOT NULL COMMENT '开始时间',
- `end_time` datetime NOT NULL COMMENT '结束时间',
- `repair_reason` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '维修原因',
+ `end_time` datetime NULL DEFAULT NULL COMMENT '结束时间',
+ `repair_reason` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '维修原因',
`start_repair_picture` json NOT NULL COMMENT '维修前图片',
`repair_money` double(10, 2) NULL DEFAULT NULL COMMENT '维修费用',
- `repair_money_detail` json NOT NULL COMMENT '维修费用明细',
+ `repair_money_detail` json NULL COMMENT '维修费用明细',
`send_user_id` bigint NOT NULL COMMENT '送修人',
`send_time` datetime NOT NULL COMMENT '送修时间',
- `return_user_id` bigint NOT NULL COMMENT '取回人',
- `return_time` datetime NOT NULL COMMENT '取回时间',
+ `return_user_id` bigint NULL DEFAULT NULL COMMENT '取回人',
+ `return_time` datetime NULL DEFAULT NULL COMMENT '取回时间',
`is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0=未删除 1=已删除',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
@@ -4509,15 +4758,15 @@
`task_id` bigint NULL DEFAULT NULL COMMENT '任务id',
`vehicle_id` bigint NOT NULL COMMENT '车辆id',
`start_time` datetime NOT NULL COMMENT '开始时间',
- `end_time` datetime NOT NULL COMMENT '结束时间',
- `repair_reason` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '维修原因',
+ `end_time` datetime NULL DEFAULT NULL COMMENT '结束时间',
+ `repair_reason` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '维修原因',
`start_repair_picture` json NOT NULL COMMENT '维修前图片',
`repair_money` double(10, 2) NULL DEFAULT NULL COMMENT '维修费用',
- `repair_money_detail` json NOT NULL COMMENT '维修费用明细',
+ `repair_money_detail` json NULL COMMENT '维修费用明细',
`send_user_id` bigint NOT NULL COMMENT '送修人',
`send_time` datetime NOT NULL COMMENT '送修时间',
- `return_user_id` bigint NOT NULL COMMENT '取回人',
- `return_time` datetime NOT NULL COMMENT '取回时间',
+ `return_user_id` bigint NULL DEFAULT NULL COMMENT '取回人',
+ `return_time` datetime NULL DEFAULT NULL COMMENT '取回时间',
`is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0=未删除 1=已删除',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
@@ -4544,15 +4793,15 @@
`task_id` bigint NULL DEFAULT NULL COMMENT '任务id',
`vehicle_id` bigint NOT NULL COMMENT '车辆id',
`start_time` datetime NOT NULL COMMENT '开始时间',
- `end_time` datetime NOT NULL COMMENT '结束时间',
- `repair_reason` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '维修原因',
+ `end_time` datetime NULL DEFAULT NULL COMMENT '结束时间',
+ `repair_reason` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '维修原因',
`start_repair_picture` json NOT NULL COMMENT '维修前图片',
`repair_money` double(10, 2) NULL DEFAULT NULL COMMENT '维修费用',
- `repair_money_detail` json NOT NULL COMMENT '维修费用明细',
+ `repair_money_detail` json NULL COMMENT '维修费用明细',
`send_user_id` bigint NOT NULL COMMENT '送修人',
`send_time` datetime NOT NULL COMMENT '送修时间',
- `return_user_id` bigint NOT NULL COMMENT '取回人',
- `return_time` datetime NOT NULL COMMENT '取回时间',
+ `return_user_id` bigint NULL DEFAULT NULL COMMENT '取回人',
+ `return_time` datetime NULL DEFAULT NULL COMMENT '取回时间',
`is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0=未删除 1=已删除',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
@@ -4578,15 +4827,15 @@
`task_id` bigint NULL DEFAULT NULL COMMENT '任务id',
`vehicle_id` bigint NOT NULL COMMENT '车辆id',
`start_time` datetime NOT NULL COMMENT '开始时间',
- `end_time` datetime NOT NULL COMMENT '结束时间',
- `repair_reason` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '维修原因',
+ `end_time` datetime NULL DEFAULT NULL COMMENT '结束时间',
+ `repair_reason` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '维修原因',
`start_repair_picture` json NOT NULL COMMENT '维修前图片',
`repair_money` double(10, 2) NULL DEFAULT NULL COMMENT '维修费用',
- `repair_money_detail` json NOT NULL COMMENT '维修费用明细',
+ `repair_money_detail` json NULL COMMENT '维修费用明细',
`send_user_id` bigint NOT NULL COMMENT '送修人',
`send_time` datetime NOT NULL COMMENT '送修时间',
- `return_user_id` bigint NOT NULL COMMENT '取回人',
- `return_time` datetime NOT NULL COMMENT '取回时间',
+ `return_user_id` bigint NULL DEFAULT NULL COMMENT '取回人',
+ `return_time` datetime NULL DEFAULT NULL COMMENT '取回时间',
`is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0=未删除 1=已删除',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
@@ -4612,15 +4861,15 @@
`task_id` bigint NULL DEFAULT NULL COMMENT '任务id',
`vehicle_id` bigint NOT NULL COMMENT '车辆id',
`start_time` datetime NOT NULL COMMENT '开始时间',
- `end_time` datetime NOT NULL COMMENT '结束时间',
- `repair_reason` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '维修原因',
+ `end_time` datetime NULL DEFAULT NULL COMMENT '结束时间',
+ `repair_reason` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '维修原因',
`start_repair_picture` json NOT NULL COMMENT '维修前图片',
`repair_money` double(10, 2) NULL DEFAULT NULL COMMENT '维修费用',
- `repair_money_detail` json NOT NULL COMMENT '维修费用明细',
+ `repair_money_detail` json NULL COMMENT '维修费用明细',
`send_user_id` bigint NOT NULL COMMENT '送修人',
`send_time` datetime NOT NULL COMMENT '送修时间',
- `return_user_id` bigint NOT NULL COMMENT '取回人',
- `return_time` datetime NOT NULL COMMENT '取回时间',
+ `return_user_id` bigint NULL DEFAULT NULL COMMENT '取回人',
+ `return_time` datetime NULL DEFAULT NULL COMMENT '取回时间',
`is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0=未删除 1=已删除',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
@@ -4646,15 +4895,15 @@
`task_id` bigint NULL DEFAULT NULL COMMENT '任务id',
`vehicle_id` bigint NOT NULL COMMENT '车辆id',
`start_time` datetime NOT NULL COMMENT '开始时间',
- `end_time` datetime NOT NULL COMMENT '结束时间',
- `repair_reason` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '维修原因',
+ `end_time` datetime NULL DEFAULT NULL COMMENT '结束时间',
+ `repair_reason` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '维修原因',
`start_repair_picture` json NOT NULL COMMENT '维修前图片',
`repair_money` double(10, 2) NULL DEFAULT NULL COMMENT '维修费用',
- `repair_money_detail` json NOT NULL COMMENT '维修费用明细',
+ `repair_money_detail` json NULL COMMENT '维修费用明细',
`send_user_id` bigint NOT NULL COMMENT '送修人',
`send_time` datetime NOT NULL COMMENT '送修时间',
- `return_user_id` bigint NOT NULL COMMENT '取回人',
- `return_time` datetime NOT NULL COMMENT '取回时间',
+ `return_user_id` bigint NULL DEFAULT NULL COMMENT '取回人',
+ `return_time` datetime NULL DEFAULT NULL COMMENT '取回时间',
`is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0=未删除 1=已删除',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
--
Gitblit v1.7.1