aivfo-tl-3.0/sql/aivfo-tl.sql

-- 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