/*
 Navicat Premium Data Transfer

 Source Server         : 媒体经纪人-测试
 Source Server Type    : MySQL
 Source Server Version : 80042
 Source Host           : 124.221.59.58:3309
 Source Schema         : ai_smart_badge

 Target Server Type    : MySQL
 Target Server Version : 80042
 File Encoding         : 65001

 Date: 10/09/2025 07:38:10
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for project_management
-- ----------------------------
DROP TABLE IF EXISTS `project_management`;
CREATE TABLE `project_management`  (
  `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '主键，UUID',
  `dealership_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '所属经销商ID',
  `project_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '项目名称',
  `script_version` int NULL DEFAULT 1 COMMENT '话术版本',
  `script_publish_time` datetime NULL DEFAULT NULL COMMENT '话术发布时间',
  `salesperson_count` int NULL DEFAULT 0 COMMENT '销售人员数量',
  `avg_recording_duration` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '平均录音时长(分钟)',
  `step` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '步骤',
  `group_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '分组',
  `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '项目描述',
  `status` tinyint(1) NULL DEFAULT 1 COMMENT '项目状态(1启用 0停用)',
  `update_time` datetime NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '项目管理表' ROW_FORMAT = Dynamic;

SET FOREIGN_KEY_CHECKS = 1;


-- 50条项目管理表INSERT语句
-- 基于dealership.sql第76行的经销商ID信息生成

INSERT INTO `project_management` (`id`, `dealership_id`, `project_name`, `script_version`, `script_publish_time`, `salesperson_count`, `avg_recording_duration`, `step`, `group_name`, `create_time`, `description`, `status`, `update_time`) VALUES ('1957424785875087363', '1957424710587330562', '奔驰C级销售项目', 1, '2025-08-15 09:30:00', 12, 16.80, '进行中', '奔驰品牌组', '2025-08-15 09:30:00', '奔驰C级车型销售项目，重点培训销售话术和客户沟通技巧', 1, '2025-08-15 09:30:00');

INSERT INTO `project_management` (`id`, `dealership_id`, `project_name`, `script_version`, `script_publish_time`, `salesperson_count`, `avg_recording_duration`, `step`, `group_name`, `create_time`, `description`, `status`, `update_time`) VALUES ('1957424785875087364', '1957424711560409089', '奥迪A4L项目', 2, '2025-08-16 14:20:00', 18, 21.50, '已完成', '奥迪品牌组', '2025-08-16 14:20:00', '奥迪A4L车型销售项目，已完成话术培训和录音分析', 1, '2025-08-16 14:20:00');

INSERT INTO `project_management` (`id`, `dealership_id`, `project_name`, `script_version`, `script_publish_time`, `salesperson_count`, `avg_recording_duration`, `step`, `group_name`, `create_time`, `description`, `status`, `update_time`) VALUES ('1957424785875087365', '1957424714953601026', '宝马3系项目', 1, '2025-08-17 10:15:00', 16, 19.20, '进行中', '宝马品牌组', '2025-08-17 10:15:00', '宝马3系车型销售项目，正在进行话术优化和录音管理', 1, '2025-08-17 10:15:00');

INSERT INTO `project_management` (`id`, `dealership_id`, `project_name`, `script_version`, `script_publish_time`, `salesperson_count`, `avg_recording_duration`, `step`, `group_name`, `create_time`, `description`, `status`, `update_time`) VALUES ('1957424785875087366', '1957424739267981313', '雷克萨斯RX项目', 3, '2025-08-18 16:45:00', 14, 17.80, '已完成', '雷克萨斯品牌组', '2025-08-18 16:45:00', '雷克萨斯RX车型销售项目，已完成第三版话术培训', 1, '2025-08-18 16:45:00');

INSERT INTO `project_management` (`id`, `dealership_id`, `project_name`, `script_version`, `script_publish_time`, `salesperson_count`, `avg_recording_duration`, `step`, `group_name`, `create_time`, `description`, `status`, `update_time`) VALUES ('1957424785875087367', '1957424740000000001', '保时捷911项目', 1, '2025-08-19 11:30:00', 8, 25.60, '进行中', '保时捷品牌组', '2025-08-19 11:30:00', '保时捷911跑车销售项目，高性能车话术重点培训', 1, '2025-08-19 11:30:00');

INSERT INTO `project_management` (`id`, `dealership_id`, `project_name`, `script_version`, `script_publish_time`, `salesperson_count`, `avg_recording_duration`, `step`, `group_name`, `create_time`, `description`, `status`, `update_time`) VALUES ('1957424785875087368', '1957424740000000017', '威兹曼GT项目', 1, '2025-08-20 13:20:00', 6, 28.30, '进行中', '威兹曼品牌组', '2025-08-20 13:20:00', '威兹曼GT超跑销售项目，高端客户话术培训', 1, '2025-08-20 13:20:00');

INSERT INTO `project_management` (`id`, `dealership_id`, `project_name`, `script_version`, `script_publish_time`, `salesperson_count`, `avg_recording_duration`, `step`, `group_name`, `create_time`, `description`, `status`, `update_time`) VALUES ('1957424785875087369', '1957424710587330562', '奔驰E级项目', 2, '2025-08-21 09:45:00', 15, 18.90, '已完成', '奔驰品牌组', '2025-08-21 09:45:00', '奔驰E级豪华轿车销售项目，已完成话术升级和录音分析', 1, '2025-08-21 09:45:00');

INSERT INTO `project_management` (`id`, `dealership_id`, `project_name`, `script_version`, `script_publish_time`, `salesperson_count`, `avg_recording_duration`, `step`, `group_name`, `create_time`, `description`, `status`, `update_time`) VALUES ('1957424785875087370', '1957424711560409089', '奥迪Q5L项目', 1, '2025-08-22 15:10:00', 20, 22.40, '进行中', '奥迪品牌组', '2025-08-22 15:10:00', '奥迪Q5L SUV销售项目，商务客户话术培训', 1, '2025-08-22 15:10:00');

INSERT INTO `project_management` (`id`, `dealership_id`, `project_name`, `script_version`, `script_publish_time`, `salesperson_count`, `avg_recording_duration`, `step`, `group_name`, `create_time`, `description`, `status`, `update_time`) VALUES ('1957424785875087371', '1957424714953601026', '宝马X3项目', 2, '2025-08-23 12:25:00', 17, 20.10, '已完成', '宝马品牌组', '2025-08-23 12:25:00', '宝马X3 SUV销售项目，已完成话术优化和录音管理', 1, '2025-08-23 12:25:00');

INSERT INTO `project_management` (`id`, `dealership_id`, `project_name`, `script_version`, `script_publish_time`, `salesperson_count`, `avg_recording_duration`, `step`, `group_name`, `create_time`, `description`, `status`, `update_time`) VALUES ('1957424785875087372', '1957424739267981313', '雷克萨斯NX项目', 1, '2025-08-24 08:50:00', 12, 16.20, '进行中', '雷克萨斯品牌组', '2025-08-24 08:50:00', '雷克萨斯NX紧凑型SUV销售项目，混动技术话术培训', 1, '2025-08-24 08:50:00');

INSERT INTO `project_management` (`id`, `dealership_id`, `project_name`, `script_version`, `script_publish_time`, `salesperson_count`, `avg_recording_duration`, `step`, `group_name`, `create_time`, `description`, `status`, `update_time`) VALUES ('1957424785875087373', '1957424740000000001', '保时捷Macan项目', 2, '2025-08-25 14:35:00', 14, 19.70, '已完成', '保时捷品牌组', '2025-08-25 14:35:00', '保时捷Macan SUV销售项目，已完成豪华SUV话术培训', 1, '2025-08-25 14:35:00');

INSERT INTO `project_management` (`id`, `dealership_id`, `project_name`, `script_version`, `script_publish_time`, `salesperson_count`, `avg_recording_duration`, `step`, `group_name`, `create_time`, `description`, `status`, `update_time`) VALUES ('1957424785875087374', '1957424740000000017', '威兹曼MF5项目', 1, '2025-08-26 16:40:00', 5, 30.50, '进行中', '威兹曼品牌组', '2025-08-26 16:40:00', '威兹曼MF5超跑销售项目，顶级客户话术培训', 1, '2025-08-26 16:40:00');

INSERT INTO `project_management` (`id`, `dealership_id`, `project_name`, `script_version`, `script_publish_time`, `salesperson_count`, `avg_recording_duration`, `step`, `group_name`, `create_time`, `description`, `status`, `update_time`) VALUES ('1957424785875087375', '1957424710587330562', '奔驰GLC项目', 3, '2025-08-27 10:20:00', 19, 24.80, '已完成', '奔驰品牌组', '2025-08-27 10:20:00', '奔驰GLC SUV销售项目，已完成豪华车话术培训', 1, '2025-08-27 10:20:00');

INSERT INTO `project_management` (`id`, `dealership_id`, `project_name`, `script_version`, `script_publish_time`, `salesperson_count`, `avg_recording_duration`, `step`, `group_name`, `create_time`, `description`, `status`, `update_time`) VALUES ('1957424785875087376', '1957424711560409089', '奥迪A8L项目', 1, '2025-08-28 13:15:00', 10, 21.30, '进行中', '奥迪品牌组', '2025-08-28 13:15:00', '奥迪A8L旗舰轿车销售项目，家庭用车话术培训', 1, '2025-08-28 13:15:00');

INSERT INTO `project_management` (`id`, `dealership_id`, `project_name`, `script_version`, `script_publish_time`, `salesperson_count`, `avg_recording_duration`, `step`, `group_name`, `create_time`, `description`, `status`, `update_time`) VALUES ('1957424785875087377', '1957424714953601026', '宝马7系项目', 2, '2025-08-29 11:45:00', 14, 23.60, '已完成', '宝马品牌组', '2025-08-29 11:45:00', '宝马7系旗舰轿车销售项目，已完成豪华车话术培训', 1, '2025-08-29 11:45:00');

INSERT INTO `project_management` (`id`, `dealership_id`, `project_name`, `script_version`, `script_publish_time`, `salesperson_count`, `avg_recording_duration`, `step`, `group_name`, `create_time`, `description`, `status`, `update_time`) VALUES ('1957424785875087378', '1957424739267981313', '雷克萨斯LS项目', 1, '2025-08-30 09:30:00', 9, 26.20, '进行中', '雷克萨斯品牌组', '2025-08-30 09:30:00', '雷克萨斯LS旗舰轿车销售项目，豪华车话术培训', 1, '2025-08-30 09:30:00');

INSERT INTO `project_management` (`id`, `dealership_id`, `project_name`, `script_version`, `script_publish_time`, `salesperson_count`, `avg_recording_duration`, `step`, `group_name`, `create_time`, `description`, `status`, `update_time`) VALUES ('1957424785875087379', '1957424740000000001', '保时捷Cayenne项目', 2, '2025-09-01 15:25:00', 16, 18.40, '已完成', '保时捷品牌组', '2025-09-01 15:25:00', '保时捷Cayenne大型SUV销售项目，已完成豪华SUV话术培训', 1, '2025-09-01 15:25:00');

INSERT INTO `project_management` (`id`, `dealership_id`, `project_name`, `script_version`, `script_publish_time`, `salesperson_count`, `avg_recording_duration`, `step`, `group_name`, `create_time`, `description`, `status`, `update_time`) VALUES ('1957424785875087380', '1957424740000000017', '威兹曼Roadster项目', 1, '2025-09-02 12:10:00', 7, 27.80, '进行中', '威兹曼品牌组', '2025-09-02 12:10:00', '威兹曼Roadster敞篷跑车销售项目，个性化定制话术', 1, '2025-09-02 12:10:00');

INSERT INTO `project_management` (`id`, `dealership_id`, `project_name`, `script_version`, `script_publish_time`, `salesperson_count`, `avg_recording_duration`, `step`, `group_name`, `create_time`, `description`, `status`, `update_time`) VALUES ('1957424785875087381', '1957424710587330562', '奔驰S级项目', 1, '2025-09-03 14:50:00', 12, 22.10, '已完成', '奔驰品牌组', '2025-09-03 14:50:00', '奔驰S级旗舰轿车销售项目，已完成运动车话术培训', 1, '2025-09-03 14:50:00');

INSERT INTO `project_management` (`id`, `dealership_id`, `project_name`, `script_version`, `script_publish_time`, `salesperson_count`, `avg_recording_duration`, `step`, `group_name`, `create_time`, `description`, `status`, `update_time`) VALUES ('1957424785875087382', '1957424711560409089', '奥迪TT项目', 3, '2025-09-04 10:35:00', 8, 25.90, '进行中', '奥迪品牌组', '2025-09-04 10:35:00', '奥迪TT跑车销售项目，顶级豪华车话术培训', 1, '2025-09-04 10:35:00');

INSERT INTO `project_management` (`id`, `dealership_id`, `project_name`, `script_version`, `script_publish_time`, `salesperson_count`, `avg_recording_duration`, `step`, `group_name`, `create_time`, `description`, `status`, `update_time`) VALUES ('1957424785875087383', '1957424714953601026', '宝马X5项目', 1, '2025-09-05 16:20:00', 18, 20.70, '已完成', '宝马品牌组', '2025-09-05 16:20:00', '宝马X5中大型SUV销售项目，已完成豪华SUV话术培训', 1, '2025-09-05 16:20:00');

INSERT INTO `project_management` (`id`, `dealership_id`, `project_name`, `script_version`, `script_publish_time`, `salesperson_count`, `avg_recording_duration`, `step`, `group_name`, `create_time`, `description`, `status`, `update_time`) VALUES ('1957424785875087384', '1957424739267981313', '雷克萨斯GX项目', 2, '2025-09-06 13:40:00', 13, 19.50, '进行中', '雷克萨斯品牌组', '2025-09-06 13:40:00', '雷克萨斯GX硬派SUV销售项目，越野性能话术培训', 1, '2025-09-06 13:40:00');

INSERT INTO `project_management` (`id`, `dealership_id`, `project_name`, `script_version`, `script_publish_time`, `salesperson_count`, `avg_recording_duration`, `step`, `group_name`, `create_time`, `description`, `status`, `update_time`) VALUES ('1957424785875087385', '1957424740000000001', '保时捷Panamera项目', 1, '2025-09-07 11:15:00', 11, 17.30, '已完成', '保时捷品牌组', '2025-09-07 11:15:00', '保时捷Panamera豪华轿车销售项目，已完成多功能车话术培训', 1, '2025-09-07 11:15:00');

INSERT INTO `project_management` (`id`, `dealership_id`, `project_name`, `script_version`, `script_publish_time`, `salesperson_count`, `avg_recording_duration`, `step`, `group_name`, `create_time`, `description`, `status`, `update_time`) VALUES ('1957424785875087386', '1957424740000000017', '威兹曼Spyder项目', 2, '2025-09-08 15:55:00', 4, 32.20, '进行中', '威兹曼品牌组', '2025-09-08 15:55:00', '威兹曼Spyder敞篷跑车销售项目，限量版话术培训', 1, '2025-09-08 15:55:00');

INSERT INTO `project_management` (`id`, `dealership_id`, `project_name`, `script_version`, `script_publish_time`, `salesperson_count`, `avg_recording_duration`, `step`, `group_name`, `create_time`, `description`, `status`, `update_time`) VALUES ('1957424785875087387', '1957424710587330562', '奔驰AMG GT项目', 1, '2025-09-09 09:25:00', 7, 24.60, '已完成', '奔驰品牌组', '2025-09-09 09:25:00', '奔驰AMG GT跑车销售项目，已完成性能车话术培训', 1, '2025-09-09 09:25:00');

INSERT INTO `project_management` (`id`, `dealership_id`, `project_name`, `script_version`, `script_publish_time`, `salesperson_count`, `avg_recording_duration`, `step`, `group_name`, `create_time`, `description`, `status`, `update_time`) VALUES ('1957424785875087388', '1957424711560409089', '奥迪RS6项目', 2, '2025-09-10 14:30:00', 9, 26.80, '进行中', '奥迪品牌组', '2025-09-10 14:30:00', '奥迪RS6高性能旅行车销售项目，高性能车话术培训', 1, '2025-09-10 14:30:00');

INSERT INTO `project_management` (`id`, `dealership_id`, `project_name`, `script_version`, `script_publish_time`, `salesperson_count`, `avg_recording_duration`, `step`, `group_name`, `create_time`, `description`, `status`, `update_time`) VALUES ('1957424785875087389', '1957424714953601026', '宝马M3项目', 1, '2025-09-11 12:45:00', 11, 23.40, '已完成', '宝马品牌组', '2025-09-11 12:45:00', '宝马M3高性能轿车销售项目，已完成运动车话术培训', 1, '2025-09-11 12:45:00');

INSERT INTO `project_management` (`id`, `dealership_id`, `project_name`, `script_version`, `script_publish_time`, `salesperson_count`, `avg_recording_duration`, `step`, `group_name`, `create_time`, `description`, `status`, `update_time`) VALUES ('1957424785875087390', '1957424739267981313', '雷克萨斯LC项目', 1, '2025-09-12 16:10:00', 6, 28.70, '进行中', '雷克萨斯品牌组', '2025-09-12 16:10:00', '雷克萨斯LC豪华跑车销售项目，顶级跑车话术培训', 1, '2025-09-12 16:10:00');

INSERT INTO `project_management` (`id`, `dealership_id`, `project_name`, `script_version`, `script_publish_time`, `salesperson_count`, `avg_recording_duration`, `step`, `group_name`, `create_time`, `description`, `status`, `update_time`) VALUES ('1957424785875087391', '1957424740000000001', '保时捷Taycan项目', 1, '2025-09-13 10:20:00', 8, 21.90, '已完成', '保时捷品牌组', '2025-09-13 10:20:00', '保时捷Taycan电动跑车销售项目，已完成新能源话术培训', 1, '2025-09-13 10:20:00');

INSERT INTO `project_management` (`id`, `dealership_id`, `project_name`, `script_version`, `script_publish_time`, `salesperson_count`, `avg_recording_duration`, `step`, `group_name`, `create_time`, `description`, `status`, `update_time`) VALUES ('1957424785875087392', '1957424740000000017', '威兹曼Concept项目', 1, '2025-09-14 13:35:00', 3, 35.50, '进行中', '威兹曼品牌组', '2025-09-14 13:35:00', '威兹曼Concept概念车销售项目，未来科技话术培训', 1, '2025-09-14 13:35:00');

INSERT INTO `project_management` (`id`, `dealership_id`, `project_name`, `script_version`, `script_publish_time`, `salesperson_count`, `avg_recording_duration`, `step`, `group_name`, `create_time`, `description`, `status`, `update_time`) VALUES ('1957424785875087393', '1957424710587330562', '奔驰GLE项目', 2, '2025-09-15 08:40:00', 16, 19.80, '已完成', '奔驰品牌组', '2025-09-15 08:40:00', '奔驰GLE中大型SUV销售项目，已完成豪华SUV话术培训', 1, '2025-09-15 08:40:00');

INSERT INTO `project_management` (`id`, `dealership_id`, `project_name`, `script_version`, `script_publish_time`, `salesperson_count`, `avg_recording_duration`, `step`, `group_name`, `create_time`, `description`, `status`, `update_time`) VALUES ('1957424785875087394', '1957424711560409089', '奥迪Q7项目', 1, '2025-09-16 15:25:00', 17, 20.40, '进行中', '奥迪品牌组', '2025-09-16 15:25:00', '奥迪Q7大型SUV销售项目，商务客户话术培训', 1, '2025-09-16 15:25:00');

INSERT INTO `project_management` (`id`, `dealership_id`, `project_name`, `script_version`, `script_publish_time`, `salesperson_count`, `avg_recording_duration`, `step`, `group_name`, `create_time`, `description`, `status`, `update_time`) VALUES ('1957424785875087395', '1957424714953601026', '宝马X7项目', 2, '2025-09-17 12:30:00', 15, 22.60, '已完成', '宝马品牌组', '2025-09-17 12:30:00', '宝马X7全尺寸SUV销售项目，已完成豪华SUV话术培训', 1, '2025-09-17 12:30:00');

INSERT INTO `project_management` (`id`, `dealership_id`, `project_name`, `script_version`, `script_publish_time`, `salesperson_count`, `avg_recording_duration`, `step`, `group_name`, `create_time`, `description`, `status`, `update_time`) VALUES ('1957424785875087396', '1957424739267981313', '雷克萨斯UX项目', 1, '2025-09-18 11:15:00', 10, 17.90, '进行中', '雷克萨斯品牌组', '2025-09-18 11:15:00', '雷克萨斯UX紧凑型SUV销售项目，年轻客户话术培训', 1, '2025-09-18 11:15:00');

INSERT INTO `project_management` (`id`, `dealership_id`, `project_name`, `script_version`, `script_publish_time`, `salesperson_count`, `avg_recording_duration`, `step`, `group_name`, `create_time`, `description`, `status`, `update_time`) VALUES ('1957424785875087397', '1957424740000000001', '保时捷718项目', 1, '2025-09-19 14:50:00', 6, 26.30, '已完成', '保时捷品牌组', '2025-09-19 14:50:00', '保时捷718跑车销售项目，已完成入门跑车话术培训', 1, '2025-09-19 14:50:00');

INSERT INTO `project_management` (`id`, `dealership_id`, `project_name`, `script_version`, `script_publish_time`, `salesperson_count`, `avg_recording_duration`, `step`, `group_name`, `create_time`, `description`, `status`, `update_time`) VALUES ('1957424785875087398', '1957424740000000017', '威兹曼GT MF4项目', 2, '2025-09-20 16:35:00', 5, 29.80, '进行中', '威兹曼品牌组', '2025-09-20 16:35:00', '威兹曼GT MF4超跑销售项目，经典车型话术培训', 1, '2025-09-20 16:35:00');

INSERT INTO `project_management` (`id`, `dealership_id`, `project_name`, `script_version`, `script_publish_time`, `salesperson_count`, `avg_recording_duration`, `step`, `group_name`, `create_time`, `description`, `status`, `update_time`) VALUES ('1957424785875087399', '1957424710587330562', '奔驰CLA项目', 1, '2025-09-21 09:20:00', 13, 18.70, '已完成', '奔驰品牌组', '2025-09-21 09:20:00', '奔驰CLA紧凑型轿车销售项目，已完成年轻客户话术培训', 1, '2025-09-21 09:20:00');

INSERT INTO `project_management` (`id`, `dealership_id`, `project_name`, `script_version`, `script_publish_time`, `salesperson_count`, `avg_recording_duration`, `step`, `group_name`, `create_time`, `description`, `status`, `update_time`) VALUES ('1957424785875087400', '1957424711560409089', '奥迪A6L项目', 2, '2025-09-22 13:45:00', 19, 21.20, '进行中', '奥迪品牌组', '2025-09-22 13:45:00', '奥迪A6L中大型轿车销售项目，商务客户话术培训', 1, '2025-09-22 13:45:00');

INSERT INTO `project_management` (`id`, `dealership_id`, `project_name`, `script_version`, `script_publish_time`, `salesperson_count`, `avg_recording_duration`, `step`, `group_name`, `create_time`, `description`, `status`, `update_time`) VALUES ('1957424785875087401', '1957424714953601026', '宝马5系项目', 1, '2025-09-23 10:30:00', 18, 20.80, '已完成', '宝马品牌组', '2025-09-23 10:30:00', '宝马5系中大型轿车销售项目，已完成商务车话术培训', 1, '2025-09-23 10:30:00');

INSERT INTO `project_management` (`id`, `dealership_id`, `project_name`, `script_version`, `script_publish_time`, `salesperson_count`, `avg_recording_duration`, `step`, `group_name`, `create_time`, `description`, `status`, `update_time`) VALUES ('1957424785875087402', '1957424739267981313', '雷克萨斯IS项目', 2, '2025-09-24 15:10:00', 11, 19.40, '进行中', '雷克萨斯品牌组', '2025-09-24 15:10:00', '雷克萨斯IS运动轿车销售项目，运动性能话术培训', 1, '2025-09-24 15:10:00');

INSERT INTO `project_management` (`id`, `dealership_id`, `project_name`, `script_version`, `script_publish_time`, `salesperson_count`, `avg_recording_duration`, `step`, `group_name`, `create_time`, `description`, `status`, `update_time`) VALUES ('1957424785875087403', '1957424740000000001', '保时捷Boxster项目', 1, '2025-09-25 12:25:00', 7, 25.10, '已完成', '保时捷品牌组', '2025-09-25 12:25:00', '保时捷Boxster敞篷跑车销售项目，已完成敞篷车话术培训', 1, '2025-09-25 12:25:00');

INSERT INTO `project_management` (`id`, `dealership_id`, `project_name`, `script_version`, `script_publish_time`, `salesperson_count`, `avg_recording_duration`, `step`, `group_name`, `create_time`, `description`, `status`, `update_time`) VALUES ('1957424785875087404', '1957424740000000017', '威兹曼MF3项目', 1, '2025-09-26 14:40:00', 4, 31.60, '进行中', '威兹曼品牌组', '2025-09-26 14:40:00', '威兹曼MF3经典跑车销售项目，复古设计话术培训', 1, '2025-09-26 14:40:00');

INSERT INTO `project_management` (`id`, `dealership_id`, `project_name`, `script_version`, `script_publish_time`, `salesperson_count`, `avg_recording_duration`, `step`, `group_name`, `create_time`, `description`, `status`, `update_time`) VALUES ('1957424785875087405', '1957424710587330562', '奔驰GLB项目', 2, '2025-09-27 08:55:00', 14, 19.30, '已完成', '奔驰品牌组', '2025-09-27 08:55:00', '奔驰GLB紧凑型SUV销售项目，已完成家庭用车话术培训', 1, '2025-09-27 08:55:00');

INSERT INTO `project_management` (`id`, `dealership_id`, `project_name`, `script_version`, `script_publish_time`, `salesperson_count`, `avg_recording_duration`, `step`, `group_name`, `create_time`, `description`, `status`, `update_time`) VALUES ('1957424785875087406', '1957424711560409089', '奥迪A3项目', 1, '2025-09-28 16:20:00', 12, 17.60, '进行中', '奥迪品牌组', '2025-09-28 16:20:00', '奥迪A3紧凑型轿车销售项目，年轻客户话术培训', 1, '2025-09-28 16:20:00');

INSERT INTO `project_management` (`id`, `dealership_id`, `project_name`, `script_version`, `script_publish_time`, `salesperson_count`, `avg_recording_duration`, `step`, `group_name`, `create_time`, `description`, `status`, `update_time`) VALUES ('1957424785875087407', '1957424714953601026', '宝马X1项目', 1, '2025-09-29 11:35:00', 15, 18.90, '已完成', '宝马品牌组', '2025-09-29 11:35:00', '宝马X1紧凑型SUV销售项目，已完成入门SUV话术培训', 1, '2025-09-29 11:35:00');

INSERT INTO `project_management` (`id`, `dealership_id`, `project_name`, `script_version`, `script_publish_time`, `salesperson_count`, `avg_recording_duration`, `step`, `group_name`, `create_time`, `description`, `status`, `update_time`) VALUES ('1957424785875087408', '1957424739267981313', '雷克萨斯CT项目', 1, '2025-09-30 13:50:00', 8, 16.80, '进行中', '雷克萨斯品牌组', '2025-09-30 13:50:00', '雷克萨斯CT混动轿车销售项目，环保理念话术培训', 1, '2025-09-30 13:50:00');

INSERT INTO `project_management` (`id`, `dealership_id`, `project_name`, `script_version`, `script_publish_time`, `salesperson_count`, `avg_recording_duration`, `step`, `group_name`, `create_time`, `description`, `status`, `update_time`) VALUES ('1957424785875087409', '1957424740000000001', '保时捷Cayman项目', 2, '2025-10-01 10:15:00', 6, 24.70, '已完成', '保时捷品牌组', '2025-10-01 10:15:00', '保时捷Cayman跑车销售项目，已完成中置引擎话术培训', 1, '2025-10-01 10:15:00');

INSERT INTO `project_management` (`id`, `dealership_id`, `project_name`, `script_version`, `script_publish_time`, `salesperson_count`, `avg_recording_duration`, `step`, `group_name`, `create_time`, `description`, `status`, `update_time`) VALUES ('1957424785875087410', '1957424740000000017', '威兹曼MF6项目', 1, '2025-10-02 15:30:00', 3, 33.40, '进行中', '威兹曼品牌组', '2025-10-02 15:30:00', '威兹曼MF6旗舰超跑销售项目，顶级性能话术培训', 1, '2025-10-02 15:30:00');


适配JSON： 
{
  "project_management": [
    {
      "id": "1957424785875087363",
      "project_name": "奔驰C级销售项目"
    },
    {
      "id": "1957424785875087364",
      "project_name": "奥迪A4L项目"
    },
    {
      "id": "1957424785875087365",
      "project_name": "宝马3系项目"
    },
    {
      "id": "1957424785875087366",
      "project_name": "雷克萨斯RX项目"
    },
    {
      "id": "1957424785875087367",
      "project_name": "保时捷911项目"
    },
    {
      "id": "1957424785875087368",
      "project_name": "威兹曼GT项目"
    }
  ]
}



