-- MySQL dump 10.13 Distrib 8.0.46, for Linux (x86_64) -- -- Host: localhost Database: aivfo-tl -- ------------------------------------------------------ -- Server version 8.0.46 /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `video` -- DROP TABLE IF EXISTS `video`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `video` ( `id` bigint NOT NULL AUTO_INCREMENT, `tl_sn` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'tl设备编号', `house_sn` int NOT NULL COMMENT '仓室编号:1-11(11号仓室为缓冲瓶)', `embryo_culture_record_id` bigint NOT NULL COMMENT '培养记录id', `embryo_id` bigint NOT NULL COMMENT '胚胎id', `well_sn` int NOT NULL COMMENT 'well编号:1-16', `video_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '视频名', `video_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '视频地址', `picture_layer` int NOT NULL COMMENT '合成视频图层', `fps` int DEFAULT NULL COMMENT '视频帧率', `create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '创建人', `create_time` datetime NOT NULL COMMENT '创建时间', `update_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '修改人', `update_time` datetime NOT NULL COMMENT '修改时间', `deleted` timestamp NOT NULL COMMENT '已删除: 操作时间戳', `platform_id` int DEFAULT NULL COMMENT '操作终端', `picture_max_uuid` bigint DEFAULT NULL COMMENT '视频合成的最大图片uuid', PRIMARY KEY (`id`) USING BTREE, UNIQUE KEY `only_one` (`embryo_culture_record_id`,`embryo_id`,`deleted`,`picture_layer`) USING BTREE COMMENT '联合唯一主键' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='合成视频表： 记录合成视频信息'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `video` -- LOCK TABLES `video` WRITE; /*!40000 ALTER TABLE `video` DISABLE KEYS */; /*!40000 ALTER TABLE `video` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `video_pictures` -- DROP TABLE IF EXISTS `video_pictures`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `video_pictures` ( `id` bigint NOT NULL AUTO_INCREMENT, `tl_sn` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'tl设备编号', `house_sn` int NOT NULL COMMENT '仓室编号:1-11(11号仓室为缓冲瓶)', `video_id` bigint DEFAULT NULL COMMENT '视频id', `picture_uuid` bigint DEFAULT NULL COMMENT '图片uuid', `image_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '图片服务端url', `image_time` datetime NOT NULL COMMENT '图片时间', `state` int NOT NULL COMMENT '合成视频状态 0 失败 1成功', `create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '创建人', `create_time` datetime NOT NULL COMMENT '创建时间', `update_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '修改人', `update_time` datetime NOT NULL COMMENT '修改时间', `deleted` timestamp NOT NULL COMMENT '已删除: 操作时间戳', `platform_id` int DEFAULT NULL COMMENT '操作终端', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='合成视频图片表：记录各合成视频所使用的图片信息'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `video_pictures` -- LOCK TABLES `video_pictures` WRITE; /*!40000 ALTER TABLE `video_pictures` DISABLE KEYS */; /*!40000 ALTER TABLE `video_pictures` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `video_splice` -- DROP TABLE IF EXISTS `video_splice`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `video_splice` ( `id` bigint NOT NULL AUTO_INCREMENT, `video_id` bigint DEFAULT NULL COMMENT '培养记录id', `embryo_culture_record_id` bigint DEFAULT NULL COMMENT '需要合成视频的胚胎id', `embryo_id` bigint DEFAULT NULL COMMENT '需要合成视频的胚胎id', `create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '创建人', `create_time` datetime NOT NULL COMMENT '创建时间', `update_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '修改人', `update_time` datetime NOT NULL COMMENT '修改时间', `deleted` timestamp NOT NULL COMMENT '已删除: 操作时间戳', `platform_id` int DEFAULT NULL COMMENT '操作终端', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='合成视频表： 记录合成视频信息'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `video_splice` -- LOCK TABLES `video_splice` WRITE; /*!40000 ALTER TABLE `video_splice` DISABLE KEYS */; /*!40000 ALTER TABLE `video_splice` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `video_update` -- DROP TABLE IF EXISTS `video_update`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `video_update` ( `id` bigint NOT NULL AUTO_INCREMENT, `video_id` bigint NOT NULL COMMENT '视频id', `video_local_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '视频的存储本地路径', `fps` int NOT NULL COMMENT '合成视频的fps', `picture_max_uuid` bigint NOT NULL COMMENT '合成视频的最大图片uuid', `update_state` int NOT NULL COMMENT '视频上传状态\r\n0 等待上传\r\n1 上传中', `create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '创建人', `create_time` datetime NOT NULL COMMENT '创建时间', `update_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '修改人', `update_time` datetime NOT NULL COMMENT '修改时间', `deleted` timestamp NOT NULL COMMENT '已删除: 操作时间戳', `platform_id` int DEFAULT NULL COMMENT '操作终端', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='图片上传更新表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `video_update` -- LOCK TABLES `video_update` WRITE; /*!40000 ALTER TABLE `video_update` DISABLE KEYS */; /*!40000 ALTER TABLE `video_update` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2026-06-17 14:50:30