-- 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 `balance` -- DROP TABLE IF EXISTS `balance`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `balance` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增id', `tl_sn` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'tl设备sn', `house_sn` int NOT NULL COMMENT '仓室编号:1-11(11号仓室为缓冲瓶)', `start_time` datetime NOT NULL COMMENT '开始时间', `end_time` datetime 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 '终端id', 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 `balance` -- LOCK TABLES `balance` WRITE; /*!40000 ALTER TABLE `balance` DISABLE KEYS */; /*!40000 ALTER TABLE `balance` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `case_info` -- DROP TABLE IF EXISTS `case_info`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `case_info` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增id', `case_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '病例号', `husband` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '男方姓名', `husband_birth` datetime DEFAULT NULL COMMENT '男方出生日期', `wife` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '女方姓名', `wife_birth` datetime DEFAULT NULL COMMENT '女方出生日期', `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci 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 '操作终端', 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 `case_info` -- LOCK TABLES `case_info` WRITE; /*!40000 ALTER TABLE `case_info` DISABLE KEYS */; /*!40000 ALTER TABLE `case_info` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `debug_picture` -- DROP TABLE IF EXISTS `debug_picture`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `debug_picture` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增id', `picture_uuid` bigint NOT NULL COMMENT '图片id关联使用', `tl_id` bigint NOT NULL COMMENT 'tl设备id', `tl_sn` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'tl设备编号', `house_id` bigint NOT NULL COMMENT '仓室id', `house_sn` int NOT NULL COMMENT '仓室编号:1-11(11号仓室为缓冲瓶)', `well_sn` int NOT NULL COMMENT 'well编号：1-16', `ccd_sn` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'ccd编号', `photograph_type` int NOT NULL COMMENT '拍照模式:1:单张抓拍 2:水平拍照 3全程拍照', `source_image_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '原图名字', `source_image_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '原图url', `source_image_width` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '原图宽', `source_image_height` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '原图高', `image_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '抠图名字', `image_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '抠图url', `image_height` int NOT NULL COMMENT '裁剪高', `image_width` int NOT NULL COMMENT '裁剪宽', `image_time` datetime NOT NULL COMMENT ' 设备返回的拍摄时间(同一个时间的图片为同一个批次)', `vertical_motor_position` int DEFAULT NULL COMMENT '垂直电机位置', `horizontal_motor_position` int DEFAULT NULL COMMENT '水平电机位置', `crop_state` int NOT 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 '操作终端', 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 `debug_picture` -- LOCK TABLES `debug_picture` WRITE; /*!40000 ALTER TABLE `debug_picture` DISABLE KEYS */; /*!40000 ALTER TABLE `debug_picture` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `dictionary` -- DROP TABLE IF EXISTS `dictionary`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `dictionary` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '自增id', `dict_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '字典类型 1字典类型 2字典数据', `parent_id` bigint DEFAULT NULL COMMENT '上级id', `dict_sort` int NOT NULL DEFAULT '0' COMMENT '字典排序', `dict_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '字典key值', `dict_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '字典名', `dict_value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci 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 '终端id', `region` int NOT NULL DEFAULT '1' COMMENT '地区1.中文2.英文', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=68 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='字典表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `dictionary` -- LOCK TABLES `dictionary` WRITE; /*!40000 ALTER TABLE `dictionary` DISABLE KEYS */; INSERT INTO `dictionary` VALUES (7,'FERTILIZATION_TYPE',-1,2,'FERTILIZATION_TYPE','受精类型','受精方式',1,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(8,'FERTILIZATION_TYPE',7,6,'ICSI','ICSI','0',1,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(9,'FERTILIZATION_TYPE',7,7,'IVF','IVF','1',1,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(30,'PHOTO_SEARCH_BUTTON',-1,1,'PHOTO_SEARCH_BUTTON','图片查看按钮','图片查看按钮顶级分类',1,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(31,'PHOTO_SEARCH_BUTTON',30,1,'COMMON_BUTTON','全程时间普通按钮','全程时间普通按钮',1,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(32,'PHOTO_SEARCH_BUTTON',30,1,'KEY_BUTTON','关键节点按钮','关键节点按钮',1,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(33,'PHOTO_SEARCH_BUTTON',30,1,'QUICK_BUTTON','快捷定位按钮','快捷定位按钮',1,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(34,'PHOTO_SEARCH_BUTTON',30,1,'TIME_LINE','时间轴按钮','时间轴按钮',1,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(42,'FERTILIZATION_TYPE',-1,2,'FERTILIZATION_TYPE','Fertilization type','Mode of fertilization',1,'developer_developer','2023-07-05 15:42:40','developer_developer','2023-07-05 15:42:40','2016-12-31 16:00:00',1,2),(43,'FERTILIZATION_TYPE',42,6,'ICSI','ICSI','0',1,'developer_developer','2023-07-05 15:43:59','developer_developer','2023-07-05 15:46:51','2016-12-31 16:00:00',1,2),(44,'FERTILIZATION_TYPE',42,7,'IVF','IVF','1',1,'developer_developer','2023-07-05 15:46:10','developer_developer','2023-07-05 15:46:10','2016-12-31 16:00:00',1,2),(45,'PHOTO_SEARCH_BUTTON',-1,1,'PHOTO_SEARCH_BUTTON','Picture view button','Picture view button Top category',1,'developer_developer','2023-10-07 14:29:41','developer_developer','2023-10-07 14:29:41','2016-12-31 16:00:00',1,2),(46,'PHOTO_SEARCH_BUTTON',45,1,'COMMON_BUTTON','Full time normal button','Full time normal button',1,'developer_developer','2023-10-07 14:31:48','developer_developer','2023-10-07 14:31:48','2016-12-31 16:00:00',1,2),(47,'PHOTO_SEARCH_BUTTON',45,1,'KEY_BUTTON','Key node button','Key node button',1,'developer_developer','2023-10-07 14:31:59','developer_developer','2023-10-07 14:31:59','2016-12-31 16:00:00',1,2),(48,'PHOTO_SEARCH_BUTTON',45,1,'QUICK_BUTTON','Shortcut positioning button','Shortcut positioning button',1,'developer_developer','2023-10-07 14:32:18','developer_developer','2023-10-07 14:32:18','2016-12-31 16:00:00',1,2),(49,'PHOTO_SEARCH_BUTTON',45,1,'TIME_LINE','Timeline button','Timeline button',1,'developer_developer','2023-10-07 14:32:33','developer_developer','2023-10-07 14:32:33','2016-12-31 16:00:00',1,2),(50,'EMBRYO_MARK_TITLE_ENTITIES',-1,0,'MARK_RESULTS','标记结果','标记结果',1,'admin_admin','2024-04-17 15:19:21','admin_admin','2024-04-17 15:19:21','2016-12-31 16:00:00',1,1),(51,'EMBRYO_MARK_TITLE_ENTITIES',-1,0,'CASE_NUMBER','病例编号','病例编号',1,'admin_admin','2024-04-17 15:23:33','admin_admin','2024-04-17 15:23:33','2016-12-31 16:00:00',1,1),(52,'EMBRYO_MARK_TITLE_ENTITIES',-1,0,'WIFE_NAME','女方姓名','女方姓名',1,'admin_admin','2024-04-17 15:25:06','admin_admin','2024-04-17 15:25:06','2016-12-31 16:00:00',1,1),(53,'EMBRYO_MARK_TITLE_ENTITIES',-1,0,'HUSBAND_NAME','男方姓名','男方姓名',1,'admin_admin','2024-04-17 15:26:06','admin_admin','2024-04-17 15:26:06','2016-12-31 16:00:00',1,1),(54,'EMBRYO_MARK_TITLE_ENTITIES',-1,0,'HUSBAND_AGE','男方年龄','男方年龄',1,'admin_admin','2024-04-17 15:26:28','admin_admin','2024-04-17 15:26:28','2016-12-31 16:00:00',1,1),(55,'EMBRYO_MARK_TITLE_ENTITIES',-1,0,'WIFE_AGE','女方年龄','女方年龄',1,'admin_admin','2024-04-17 15:26:52','admin_admin','2024-04-17 15:26:52','2016-12-31 16:00:00',1,1),(56,'EMBRYO_MARK_TITLE_ENTITIES',-1,0,'FERTILIZATION_TIME','受精时间','受精时间',1,'admin_admin','2024-04-17 15:28:42','admin_admin','2024-04-17 15:28:42','2016-12-31 16:00:00',1,1),(57,'EMBRYO_MARK_TITLE_ENTITIES',-1,0,'FERTILIZATION_MODE','受精方式','受精方式',1,'admin_admin','2024-04-17 15:29:17','admin_admin','2024-04-17 15:29:17','2016-12-31 16:00:00',1,1),(58,'EMBRYO_MARK_TITLE_ENTITIES',-1,0,'MARK_RESULTS','MarkResults','MarkResults',1,'admin_admin','2024-04-17 15:19:21','admin_admin','2024-04-17 15:19:21','2016-12-31 16:00:00',1,2),(59,'EMBRYO_MARK_TITLE_ENTITIES',-1,0,'CASE_NUMBER','CaseNumber','CaseNumber',1,'admin_admin','2024-04-17 15:23:33','admin_admin','2024-04-17 15:23:33','2016-12-31 16:00:00',1,2),(60,'EMBRYO_MARK_TITLE_ENTITIES',-1,0,'WIFE_NAME','WifeName','WifeName',1,'admin_admin','2024-04-17 15:25:06','admin_admin','2024-04-17 15:25:06','2016-12-31 16:00:00',1,2),(61,'EMBRYO_MARK_TITLE_ENTITIES',-1,0,'HUSBAND_NAME','HusbandName','HusbandName',1,'admin_admin','2024-04-17 15:26:06','admin_admin','2024-04-17 15:26:06','2016-12-31 16:00:00',1,2),(62,'EMBRYO_MARK_TITLE_ENTITIES',-1,0,'HUSBAND_AGE','HusbandAge','HusbandAge',1,'admin_admin','2024-04-17 15:26:28','admin_admin','2024-04-17 15:26:28','2016-12-31 16:00:00',1,2),(63,'EMBRYO_MARK_TITLE_ENTITIES',-1,0,'WIFE_AGE','WifeAge','WifeAge',1,'admin_admin','2024-04-17 15:26:52','admin_admin','2024-04-17 15:26:52','2016-12-31 16:00:00',1,2),(64,'EMBRYO_MARK_TITLE_ENTITIES',-1,0,'FERTILIZATION_TIME','FertilizationTime','FertilizationTime',1,'admin_admin','2024-04-17 15:28:42','admin_admin','2024-04-17 15:28:42','2016-12-31 16:00:00',1,2),(65,'EMBRYO_MARK_TITLE_ENTITIES',-1,0,'FERTILIZATION_MODE','FertilizationMode','FertilizationMode',1,'admin_admin','2024-04-17 15:29:17','admin_admin','2024-04-17 15:29:17','2016-12-31 16:00:00',1,2),(66,'FERTILIZATION_TYPE',7,8,'IVM','IVM','2',1,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(67,'FERTILIZATION_TYPE',42,8,'IVM','IVM','2',1,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2); /*!40000 ALTER TABLE `dictionary` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `embryo` -- DROP TABLE IF EXISTS `embryo`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `embryo` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增id', `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', `well_sn` int NOT NULL COMMENT 'well编号', `start_time` datetime NOT NULL COMMENT '受精时间', `state` int NOT NULL COMMENT '胚胎当前状态: 0培养中 1冷冻 2移植 3作废 4结束培养 5删除 ', `state_time` datetime NOT NULL COMMENT '处于当前状态时间点', `develop_time` int DEFAULT NULL COMMENT '发育时长/分钟', `score` decimal(10,2) DEFAULT NULL COMMENT '胚胎得分', `level` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '胚胎等级', `blastocyst_level` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci 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 '操作端', 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 `embryo` -- LOCK TABLES `embryo` WRITE; /*!40000 ALTER TABLE `embryo` DISABLE KEYS */; /*!40000 ALTER TABLE `embryo` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `embryo_culture_record` -- DROP TABLE IF EXISTS `embryo_culture_record`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `embryo_culture_record` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增id', `tl_sn` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'tl设备sn', `house_sn` int NOT NULL COMMENT '仓室编号:1-11(11号仓室为缓冲瓶)', `case_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '病例编号', `wife` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '女方姓名', `wife_birth` datetime DEFAULT NULL COMMENT '女方出生日期', `husband` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '男方姓名', `husband_birth` datetime DEFAULT NULL COMMENT '男方出生日期', `phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '联系方式', `note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '备注', `vip` int NOT NULL COMMENT '是否为特殊培养记录 0普通 1重点关注', `embryo_count` int NOT NULL COMMENT '胚胎数量', `state` int NOT NULL COMMENT '培养状态: 0培养结束 1正在培养', `start_time` datetime NOT NULL COMMENT '受精时间', `fertilization_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '受精类型(字典key)', `fertilization_type_id` bigint NOT NULL COMMENT '受精类型id(字典value)', `end_time` datetime DEFAULT NULL COMMENT '培育结束时间', `develop_time` int DEFAULT NULL COMMENT '培养时长/分钟', `cycle` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '周期编号', `picture_table_name` 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 '操作端', 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 `embryo_culture_record` -- LOCK TABLES `embryo_culture_record` WRITE; /*!40000 ALTER TABLE `embryo_culture_record` DISABLE KEYS */; /*!40000 ALTER TABLE `embryo_culture_record` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `embryo_level` -- DROP TABLE IF EXISTS `embryo_level`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `embryo_level` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增id', `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '级别名称', `min` int NOT NULL COMMENT '最小', `max` int NOT NULL COMMENT '最大', `state` int NOT NULL COMMENT '状态 0 禁用 1 启用', `info` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci 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 '终端id', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `embryo_level` -- LOCK TABLES `embryo_level` WRITE; /*!40000 ALTER TABLE `embryo_level` DISABLE KEYS */; INSERT INTO `embryo_level` VALUES (1,'A级',90,100,1,'优质胚胎','developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1),(2,'B级',80,89,1,'一般胚胎','developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1),(3,'C级',60,79,1,'劣质胚胎','developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1),(4,'D级',0,59,1,'不合格胚胎','developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1); /*!40000 ALTER TABLE `embryo_level` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `embryo_mark` -- DROP TABLE IF EXISTS `embryo_mark`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `embryo_mark` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增id', `parent_id` bigint NOT NULL COMMENT '上级标记id', `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', `state` int NOT NULL COMMENT '当前阶段此次标记状态:0弃用 1启用', `image_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '标记图片地址', `develop_time` int DEFAULT NULL COMMENT '发育时间', `picture_time` datetime DEFAULT NULL COMMENT '图片时间', `picture_layer` int DEFAULT NULL COMMENT '图层', `picture_uuid` bigint DEFAULT NULL COMMENT '图片uuid', `mark_id` bigint NOT NULL COMMENT '标记id', `mark_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '标记key', `mark_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '标记阶段名', `child` int NOT NULL COMMENT '是否有子节点: 0无 1有(区分叶子节点)', `mark_type` int DEFAULT NULL COMMENT '标记类型：1 人工 2 ai', `batch_number` bigint NOT 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 '操作端', `score` decimal(5,2) DEFAULT '-1.00' 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 `embryo_mark` -- LOCK TABLES `embryo_mark` WRITE; /*!40000 ALTER TABLE `embryo_mark` DISABLE KEYS */; /*!40000 ALTER TABLE `embryo_mark` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `embryo_mark_splice` -- DROP TABLE IF EXISTS `embryo_mark_splice`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `embryo_mark_splice` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT ' ', `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', `stage` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `appear_time` int DEFAULT NULL COMMENT '出现时间', `disappearance_time` int DEFAULT NULL COMMENT '消失时间', `stage_processed_status` int DEFAULT NULL COMMENT '当前阶段此次标记状态:0 跳过 1 处理中 2 处理完成', `state` int DEFAULT NULL COMMENT '1 启用 0 禁用', `config_prob` decimal(10,4) DEFAULT NULL COMMENT '和配置时间段重合度', `properties` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '发育阶段详细指标', `picture_uuid` bigint DEFAULT NULL COMMENT '关联使用时使用', `image_time` datetime DEFAULT NULL COMMENT '设备返回的拍摄时间', `picture_layer` int DEFAULT NULL COMMENT '图片层', `image_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '抠图url', `compute_model` 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 '操作端', 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 `embryo_mark_splice` -- LOCK TABLES `embryo_mark_splice` WRITE; /*!40000 ALTER TABLE `embryo_mark_splice` DISABLE KEYS */; /*!40000 ALTER TABLE `embryo_mark_splice` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `identify_config` -- DROP TABLE IF EXISTS `identify_config`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `identify_config` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增id', `identify_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '图片识别key', `min_time` int NOT NULL COMMENT '阶段最小时间', `max_time` int NOT NULL COMMENT '阶段最大时间', `continue_time` int DEFAULT NULL COMMENT '持续时间', `appear_times` int DEFAULT NULL COMMENT '连续出现次数，认定阶段出现', `compute_model` int DEFAULT NULL COMMENT '计算模型', `order_num` int NOT 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 '终端id', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `identify_config` -- LOCK TABLES `identify_config` WRITE; /*!40000 ALTER TABLE `identify_config` DISABLE KEYS */; INSERT INTO `identify_config` VALUES (1,'0PN',0,10,10,2,NULL,1,'anonymous_anonymous','2023-10-27 10:44:25','anonymous_anonymous','2025-05-20 09:48:45','2016-12-31 16:00:00',1),(2,'2PN',10,23,12,2,1,2,'anonymous_anonymous','2023-10-27 10:44:25','anonymous_anonymous','2025-05-20 09:48:45','2016-12-31 16:00:00',1),(3,'2-cell',20,30,12,2,1,3,'anonymous_anonymous','2023-10-27 10:44:25','anonymous_anonymous','2025-05-20 09:48:45','2016-12-31 16:00:00',1),(4,'3-cell',24,40,2,1,NULL,4,'anonymous_anonymous','2023-10-27 10:44:25','anonymous_anonymous','2025-05-20 09:48:45','2016-12-31 16:00:00',1),(5,'4-cell',30,51,15,2,1,5,'anonymous_anonymous','2023-10-27 10:44:25','anonymous_anonymous','2025-05-20 09:48:45','2016-12-31 16:00:00',1),(6,'5-cell',40,55,2,1,NULL,6,'anonymous_anonymous','2023-10-27 10:44:25','anonymous_anonymous','2025-05-20 09:48:45','2016-12-31 16:00:00',1),(7,'6-cell',45,65,3,1,NULL,7,'anonymous_anonymous','2023-10-27 10:44:25','anonymous_anonymous','2025-05-20 09:48:45','2016-12-31 16:00:00',1),(8,'7-cell',55,70,4,1,NULL,8,'anonymous_anonymous','2023-10-27 10:44:25','anonymous_anonymous','2025-05-20 09:48:45','2016-12-31 16:00:00',1),(9,'8-cell',60,72,15,2,1,9,'anonymous_anonymous','2023-10-27 10:44:25','anonymous_anonymous','2025-05-20 09:48:45','2016-12-31 16:00:00',1),(10,'9-cell',70,90,5,1,NULL,10,'anonymous_anonymous','2023-10-27 10:44:25','anonymous_anonymous','2025-05-20 09:48:45','2016-12-31 16:00:00',1),(11,'fusion',70,100,14,2,NULL,11,'anonymous_anonymous','2023-10-27 10:44:25','anonymous_anonymous','2025-05-20 09:48:45','2016-12-31 16:00:00',1),(12,'1-blastula',94,108,9,1,1,12,'anonymous_anonymous','2023-10-27 10:44:25','anonymous_anonymous','2025-05-20 09:48:45','2016-12-31 16:00:00',1),(13,'2-blastula',100,108,5,1,1,13,'anonymous_anonymous','2023-10-27 10:44:25','anonymous_anonymous','2025-05-20 09:48:45','2016-12-31 16:00:00',1),(14,'3-blastula',108,114,6,1,1,14,'anonymous_anonymous','2023-10-27 10:44:25','anonymous_anonymous','2025-05-20 09:48:45','2016-12-31 16:00:00',1),(15,'4-blastula',114,120,6,1,1,15,'anonymous_anonymous','2023-10-27 10:44:25','anonymous_anonymous','2025-05-20 09:48:45','2016-12-31 16:00:00',1),(16,'5-blastula',120,144,15,1,1,16,'anonymous_anonymous','2023-10-27 10:44:25','anonymous_anonymous','2025-05-20 09:48:45','2016-12-31 16:00:00',1); /*!40000 ALTER TABLE `identify_config` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `log` -- DROP TABLE IF EXISTS `log`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `log` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增id', `tl_id` bigint NOT NULL COMMENT 'tl设备id', `tl_sn` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '设备编号', `house_id` bigint NOT NULL COMMENT '仓室id', `house_sn` int NOT NULL COMMENT '仓室编号:1-11(11号仓室为缓冲瓶)', `message` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '日志信息', `log_type` int DEFAULT NULL COMMENT '日志分类', `log_detail_type` 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 '终端id', 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 `log` -- LOCK TABLES `log` WRITE; /*!40000 ALTER TABLE `log` DISABLE KEYS */; /*!40000 ALTER TABLE `log` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mark` -- DROP TABLE IF EXISTS `mark`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `mark` ( `id` bigint NOT NULL AUTO_INCREMENT, `parent_id` bigint NOT NULL COMMENT '上级id', `stage` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '所属阶段key值', `key_id` bigint DEFAULT NULL COMMENT '发育阶段key_id', `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '发育阶段名', `order_num` int NOT NULL COMMENT '序号', `level` int DEFAULT NULL COMMENT '级别，从1开始', `weight` decimal(10,3) NOT NULL COMMENT '权重', `unit` int NOT NULL COMMENT '单位: 1分 2百分比', `mark_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '标记key值，编号', `key_node` int NOT NULL COMMENT '发育关键节点 0 否 1 是', `identify_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT 'AI_key', `identify_key_node` int DEFAULT NULL COMMENT 'Ai_key关键节点 0 否 1 是 2 关联关键节点', `state` int NOT NULL COMMENT '状态: 0禁用 1启用', `child` int NOT NULL COMMENT '是否有子节点: 0无 1有(区分叶子节点)', `model` bigint DEFAULT NULL COMMENT '所属模型', `min_time` int DEFAULT NULL COMMENT '最小时长 - 删 - 9/25模型启用', `max_time` int DEFAULT NULL COMMENT '最大时长 - 删 - 9/25模型启用', `default_value` int NOT NULL COMMENT '默认值 0 不是 1是（叶子节点）/计算分数 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 '操作终端', `region` int NOT NULL DEFAULT '1' COMMENT '地区1.中文2.英文', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=206 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='标记评分设置表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mark` -- LOCK TABLES `mark` WRITE; /*!40000 ALTER TABLE `mark` DISABLE KEYS */; INSERT INTO `mark` VALUES (1,-1,'2PN',1,'原核',1,1,0.000,2,'2PN',0,'2PN',0,1,1,70,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(2,1,'2PN',2,'原核数量',1,2,50.000,2,'2PN/PN-NUM',1,'2PN/Prokaryotic_number',1,1,1,70,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(3,2,'2PN',3,'1',2,3,0.000,1,'2PN/1',0,'2PN/1',0,1,0,70,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(4,2,'2PN',4,'2',3,3,100.000,1,'2PN/2',0,'2PN/2',0,1,0,70,NULL,NULL,1,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(6,2,'2PN',5,'3',4,3,0.000,1,'2PN/3',0,'2PN/3',0,1,0,70,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(7,-1,'2-cell',6,'2细胞',2,1,0.000,2,'2-cell',0,'2-cell',0,1,1,70,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(8,7,'2-cell',7,'碎片率',1,2,50.000,2,'2-cell/key_fragment',0,'2-cell/key_fragment',0,1,1,70,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(9,7,'2-cell',8,'均匀度',2,2,50.000,2,'2-cell/key_uniform',0,'2-cell/key_uniform',0,1,1,70,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(10,8,'2-cell',9,'<10%',1,3,100.000,1,'2-cell/<10%',0,'2-cell/<10%',0,1,0,70,NULL,NULL,1,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(11,8,'2-cell',10,'10%-20%',2,3,85.000,1,'2-cell/10%-20%',0,'2-cell/10%-20%',0,1,0,70,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(12,8,'2-cell',11,'20%-50%',3,3,70.000,1,'2-cell/20%-50%',0,'2-cell/20%-50%',0,1,0,70,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(13,8,'2-cell',12,'>50%',4,3,60.000,1,'2-cell/>50%',0,'2-cell/>50%',0,1,0,70,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(14,9,'2-cell',13,'均匀',1,3,100.000,1,'2-cell/uniform',0,'2-cell/uniform',0,1,0,70,NULL,NULL,1,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(15,9,'2-cell',14,'不均匀',2,3,80.000,1,'2-cell/nonuniform',0,'2-cell/nonuniform',0,1,0,70,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(16,-1,'4-cell',15,'4细胞',3,1,0.000,2,'4-cell',0,'4-cell',0,1,1,70,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(17,16,'4-cell',16,'碎片率',1,2,50.000,2,'4-cell/key_fragment',0,'4-cell/key_fragment',0,1,1,70,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(18,16,'4-cell',17,'均匀度',2,2,50.000,2,'4-cell/key_uniform',0,'4-cell/key_uniform',0,1,1,70,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(19,17,'4-cell',18,'<10%',1,3,100.000,1,'4-cell/<10%',0,'4-cell/<10%',0,1,0,70,NULL,NULL,1,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(20,17,'4-cell',19,'10%-20%',2,3,85.000,1,'4-cell/10%-20%',0,'4-cell/10%-20%',0,1,0,70,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(21,17,'4-cell',20,'20%-50%',3,3,70.000,1,'4-cell/20%-50%',0,'4-cell/20%-50%',0,1,0,70,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(22,17,'4-cell',21,'>50%',4,3,60.000,1,'4-cell/>50%',0,'4-cell/>50%',0,1,0,70,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(23,18,'4-cell',22,'均匀',1,3,100.000,1,'4-cell/uniform',0,'4-cell/uniform',0,1,0,70,NULL,NULL,1,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(24,18,'4-cell',23,'不均匀',2,3,80.000,1,'4-cell/nonuniform',0,'4-cell/nonuniform',0,1,0,70,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(25,-1,'8-cell',24,'8细胞',4,1,0.000,2,'8-cell',0,'8-cell',0,1,1,70,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(26,25,'8-cell',25,'碎片率',1,2,50.000,2,'8-cell/key_fragment',0,'8-cell/key_fragment',0,1,1,70,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(27,25,'8-cell',26,'均匀度',2,2,50.000,2,'8-cell/key_uniform',0,'8-cell/key_uniform',0,1,1,70,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(28,26,'8-cell',27,'<10%',1,3,100.000,1,'8-cell/<10%',0,'8-cell/<10%',0,1,0,70,NULL,NULL,1,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(29,26,'8-cell',28,'10%-20%',2,3,85.000,1,'8-cell/10%-20%',0,'8-cell/10%-20%',0,1,0,70,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(30,26,'8-cell',29,'20%-50%',3,3,70.000,1,'8-cell/20%-50%',0,'8-cell/20%-50%',0,1,0,70,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(31,26,'8-cell',30,'>50%',4,3,60.000,1,'8-cell/>50%',0,'8-cell/>50%',0,1,0,70,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(32,27,'8-cell',31,'均匀',1,3,100.000,1,'8-cell/uniform',0,'8-cell/uniform',0,1,0,70,NULL,NULL,1,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(33,27,'8-cell',32,'不均匀',2,3,80.000,1,'8-cell/nonuniform',0,'8-cell/nonuniform',0,1,0,70,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(34,-1,'blastula',33,'囊胚',6,1,0.000,2,'blastula',0,'blastula',0,1,1,70,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(35,34,'blastula',34,'内细胞团',2,2,50.000,2,'blastula/ICM',0,'blastula/blastula_ICM',0,1,1,70,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(36,34,'blastula',35,'外滋养层',3,2,50.000,2,'blastula/TE',0,'blastula/blastula_TE',0,1,1,70,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(37,35,'blastula',36,'A',1,3,100.000,1,'blastula/ICM-A',0,'blastula/ICM_A',0,1,0,70,NULL,NULL,1,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(38,35,'blastula',37,'B',2,3,80.000,1,'blastula/ICM-B',0,'blastula/ICM_B',0,1,0,70,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(39,35,'blastula',38,'C',3,3,60.000,1,'blastula/ICM-C',0,'blastula/ICM_C',0,1,0,70,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(40,36,'blastula',39,'A',1,3,100.000,1,'blastula/TE-A',0,'blastula/TE_A',0,1,0,70,NULL,NULL,1,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(41,36,'blastula',40,'B',2,3,80.000,1,'blastula/TE-B',0,'blastula/TE_B',0,1,0,70,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(42,36,'blastula',41,'C',3,3,60.000,1,'blastula/TE-C',0,'blastula/TE_C',0,1,0,70,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(43,34,'blastula',42,'扩张期',1,2,0.000,2,'blastula/Expansion',2,'blastula/blastula_Expansion',1,1,1,70,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(44,43,'blastula',43,'1',1,3,0.000,1,'blastula/1',0,'blastula/1',0,1,0,70,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(45,43,'blastula',44,'2',2,3,0.000,1,'blastula/2',0,'blastula/2',0,1,0,70,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(46,43,'blastula',45,'3',3,3,0.000,1,'blastula/3',0,'blastula/3',0,1,0,70,NULL,NULL,1,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(47,43,'blastula',46,'4',4,3,0.000,1,'blastula/4',0,'blastula/4',0,1,0,70,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(48,43,'blastula',47,'5',5,3,0.000,1,'blastula/5',0,'blastula/5',0,1,0,70,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(49,43,'blastula',48,'6',6,3,0.000,1,'blastula/6',0,'blastula/6',0,1,0,70,NULL,NULL,1,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(70,-2,'D3模型',NULL,'D3',0,1,0.000,0,'D3模型',0,NULL,NULL,1,0,NULL,0,72,1,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(71,-2,'D5模型',NULL,'D5',0,1,0.000,0,'D5模型',0,NULL,NULL,1,0,71,72,144,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(73,1,'2PN',70,'核仁数量',2,2,25.000,2,'nucleolus-NUM',0,'2PN/Nucleolar_number',0,1,1,70,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(74,73,'2PN',71,'6-7',1,3,100.000,1,'num-2',0,'2PN/6-7',0,1,0,70,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(75,73,'2PN',72,'9-11',2,3,100.000,1,'num-3',0,'2PN/9-11',0,1,0,70,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(76,73,'2PN',73,'12-14',3,3,100.000,1,'num-4',0,'2PN/12-14',0,1,0,70,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(77,73,'2PN',74,'15-17',4,3,100.000,1,'num-5',0,'2PN/15-17',0,1,0,70,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(78,73,'2PN',75,'看不清',5,3,100.000,1,'num-6',0,'2PN/unclear',0,1,0,70,NULL,NULL,1,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(82,1,'2PN',79,'Z分级',3,2,25.000,2,'Z-Level',0,'2PN/z_grade',0,1,1,70,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(83,82,'2PN',80,'Z1',1,3,100.000,1,'Level-1',0,'2PN/Z1',0,1,0,70,NULL,NULL,1,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(84,82,'2PN',81,'Z2',2,3,85.000,1,'Level-2',0,'2PN/Z2',0,1,0,70,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(85,82,'2PN',82,'Z3',3,3,70.000,1,'Level-3',0,'2PN/Z3',0,1,0,70,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(86,82,'2PN',83,'不确定',4,3,60.000,1,'Level-4',0,'2PN/unknown',0,1,0,70,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(87,-1,'fusion',84,'融合期',5,1,0.000,2,'fusion',0,'fusion',0,1,1,70,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(88,87,'fusion',79,'致密化',3,2,100.000,2,'Densification',0,'fusion/tM_densification',0,1,1,70,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(89,88,'fusion',86,'<50%',1,3,100.000,1,'fusion/<50%',0,'fusion/<50%',0,1,0,70,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(92,88,'fusion',87,'>50%',1,3,60.000,1,'fusion/>50%',0,'fusion/>50%',0,1,0,70,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(139,-1,'2PN',92,'PN',1,1,0.000,2,'2PN',0,'2PN',0,1,1,187,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(140,139,'2PN',93,'PN_number',1,2,50.000,2,'2PN/PN-NUM',1,'2PN/Prokaryotic_number',1,1,1,187,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(141,140,'2PN',94,'1',2,3,0.000,1,'2PN/1',0,'2PN/1',0,1,0,187,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(142,140,'2PN',95,'2',3,3,100.000,1,'2PN/2',0,'2PN/2',0,1,0,187,NULL,NULL,1,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(143,140,'2PN',96,'3',4,3,0.000,1,'2PN/3',0,'2PN/3',0,1,0,187,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(144,-1,'2-cell',97,'2cell',2,1,0.000,2,'2-cell',0,'2-cell',0,1,1,187,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(145,144,'2-cell',98,'Fragmentation',1,2,50.000,2,'2-cell/key_fragment',0,'2-cell/key_fragment',0,1,1,187,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','admin_admin','2025-06-18 13:40:27','2016-12-31 16:00:00',1,2),(146,144,'2-cell',99,'Uniform',2,2,50.000,2,'2-cell/key_uniform',0,'2-cell/key_uniform',0,1,1,187,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','admin_admin','2025-06-18 13:40:42','2016-12-31 16:00:00',1,2),(147,145,'2-cell',100,'<10%',1,3,100.000,1,'2-cell/<10%',0,'2-cell/<10%',0,1,0,187,NULL,NULL,1,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(148,145,'2-cell',101,'10%-20%',2,3,85.000,1,'2-cell/10%-20%',0,'2-cell/10%-20%',0,1,0,187,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(149,145,'2-cell',102,'20%-50%',3,3,70.000,1,'2-cell/20%-50%',0,'2-cell/20%-50%',0,1,0,187,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(150,145,'2-cell',103,'>50%',4,3,60.000,1,'2-cell/>50%',0,'2-cell/>50%',0,1,0,187,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(151,146,'2-cell',104,'Uniform',1,3,100.000,1,'2-cell/uniform',0,'2-cell/uniform',0,1,0,187,NULL,NULL,1,'developer_developer','2017-01-01 00:00:00','admin_admin','2025-06-18 13:40:54','2016-12-31 16:00:00',1,2),(152,146,'2-cell',105,'Nonuniform',2,3,80.000,1,'2-cell/nonuniform',0,'2-cell/nonuniform',0,1,0,187,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','admin_admin','2025-06-18 13:40:59','2016-12-31 16:00:00',1,2),(153,-1,'4-cell',106,'4cell',3,1,0.000,2,'4-cell',0,'4-cell',0,1,1,187,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(154,153,'4-cell',107,'Fragmentation',1,2,50.000,2,'4-cell/key_fragment',0,'4-cell/key_fragment',0,1,1,187,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','admin_admin','2025-06-18 13:41:11','2016-12-31 16:00:00',1,2),(155,153,'4-cell',108,'Uniform',2,2,50.000,2,'4-cell/key_uniform',0,'4-cell/key_uniform',0,1,1,187,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','admin_admin','2025-06-18 13:41:17','2016-12-31 16:00:00',1,2),(156,154,'4-cell',109,'<10%',1,3,100.000,1,'4-cell/<10%',0,'4-cell/<10%',0,1,0,187,NULL,NULL,1,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(157,154,'4-cell',110,'10%-20%',2,3,85.000,1,'4-cell/10%-20%',0,'4-cell/10%-20%',0,1,0,187,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(158,154,'4-cell',111,'20%-50%',3,3,70.000,1,'4-cell/20%-50%',0,'4-cell/20%-50%',0,1,0,187,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(159,154,'4-cell',112,'>50%',4,3,60.000,1,'4-cell/>50%',0,'4-cell/>50%',0,1,0,187,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(160,155,'4-cell',113,'Uniform',1,3,100.000,1,'4-cell/uniform',0,'4-cell/uniform',0,1,0,187,NULL,NULL,1,'developer_developer','2017-01-01 00:00:00','admin_admin','2025-06-18 13:41:24','2016-12-31 16:00:00',1,2),(161,155,'4-cell',114,'Nonuniform',2,3,80.000,1,'4-cell/nonuniform',0,'4-cell/nonuniform',0,1,0,187,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','admin_admin','2025-06-18 13:41:29','2016-12-31 16:00:00',1,2),(162,-1,'8-cell',115,'8cell',4,1,0.000,2,'8-cell',0,'8-cell',0,1,1,187,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(163,162,'8-cell',116,'Fragmentation',1,2,50.000,2,'8-cell/key_fragment',0,'8-cell/key_fragment',0,1,1,187,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','admin_admin','2025-06-18 13:41:33','2016-12-31 16:00:00',1,2),(164,162,'8-cell',117,'Uniform',2,2,50.000,2,'8-cell/key_uniform',0,'8-cell/key_uniform',0,1,1,187,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','admin_admin','2025-06-18 13:41:41','2016-12-31 16:00:00',1,2),(165,163,'8-cell',118,'<10%',1,3,100.000,1,'8-cell/<10%',0,'8-cell/<10%',0,1,0,187,NULL,NULL,1,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(166,163,'8-cell',119,'10%-20%',2,3,85.000,1,'8-cell/10%-20%',0,'8-cell/10%-20%',0,1,0,187,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(167,163,'8-cell',120,'20%-50%',3,3,70.000,1,'8-cell/20%-50%',0,'8-cell/20%-50%',0,1,0,187,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(168,163,'8-cell',121,'>50%',4,3,60.000,1,'8-cell/>50%',0,'8-cell/>50%',0,1,0,187,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(169,164,'8-cell',122,'Uniform',1,3,100.000,1,'8-cell/uniform',0,'8-cell/uniform',0,1,0,187,NULL,NULL,1,'developer_developer','2017-01-01 00:00:00','admin_admin','2025-06-18 13:43:50','2016-12-31 16:00:00',1,2),(170,164,'8-cell',123,'Nonuniform',2,3,80.000,1,'8-cell/nonuniform',0,'8-cell/nonuniform',0,1,0,187,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','admin_admin','2025-06-18 13:43:59','2016-12-31 16:00:00',1,2),(171,-1,'blastula',124,'Blastocyst',6,1,0.000,2,'blastula',0,'blastula',0,1,1,187,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(172,171,'blastula',125,'ICM',2,2,50.000,2,'blastula/ICM',0,'blastula/blastula_ICM',0,1,1,187,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(173,171,'blastula',126,'TE',3,2,50.000,2,'blastula/TE',0,'blastula/blastula_TE',0,1,1,187,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(174,172,'blastula',127,'A',1,3,100.000,1,'blastula/ICM-A',0,'blastula/ICM_A',0,1,0,187,NULL,NULL,1,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(175,172,'blastula',128,'B',2,3,80.000,1,'blastula/ICM-B',0,'blastula/ICM_B',0,1,0,187,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(176,172,'blastula',129,'C',3,3,60.000,1,'blastula/ICM-C',0,'blastula/ICM_C',0,1,0,187,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(177,173,'blastula',130,'A',1,3,100.000,1,'blastula/TE-A',0,'blastula/TE_A',0,1,0,187,NULL,NULL,1,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(178,173,'blastula',131,'B',2,3,80.000,1,'blastula/TE-B',0,'blastula/TE_B',0,1,0,187,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(179,173,'blastula',132,'C',3,3,60.000,1,'blastula/TE-C',0,'blastula/TE_C',0,1,0,187,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(180,171,'blastula',133,'Expansion',1,2,0.000,2,'blastula/Expansion',2,'blastula/blastula_Expansion',1,1,1,187,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(181,180,'blastula',134,'1',1,3,0.000,1,'blastula/1',0,'blastula/1',0,1,0,187,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(182,180,'blastula',135,'2',2,3,0.000,1,'blastula/2',0,'blastula/2',0,1,0,187,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(183,180,'blastula',136,'3',3,3,0.000,1,'blastula/3',0,'blastula/3',0,1,0,187,NULL,NULL,1,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(184,180,'blastula',137,'4',4,3,0.000,1,'blastula/4',0,'blastula/4',0,1,0,187,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(185,180,'blastula',138,'5',5,3,0.000,1,'blastula/5',0,'blastula/5',0,1,0,187,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(186,180,'blastula',139,'6',6,3,0.000,1,'blastula/6',0,'blastula/6',0,1,0,187,NULL,NULL,1,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(187,-2,'D3_Model',NULL,'D3',0,1,0.000,0,'D3_Model',0,NULL,NULL,1,0,71,0,72,1,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(188,-2,'D5_Model',NULL,'D5',0,1,0.000,0,'D5_Model',0,NULL,NULL,1,0,71,72,144,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(189,139,'2PN',140,'Nucleolus-number',2,2,25.000,2,'nucleolus-NUM',0,'2PN/Nucleolar_number',0,1,1,187,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','admin_admin','2025-06-18 14:11:19','2016-12-31 16:00:00',1,2),(190,189,'2PN',141,'Nucleolus_number',1,3,100.000,1,'num-2',0,'2PN/6-7',0,1,0,187,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','admin_admin','2025-06-18 13:45:56','2016-12-31 16:00:00',1,2),(191,189,'2PN',142,'9-11',2,3,100.000,1,'num-3',0,'2PN/9-11',0,1,0,187,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(192,189,'2PN',143,'12-14',3,3,100.000,1,'num-4',0,'2PN/12-14',0,1,0,187,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(193,189,'2PN',144,'15-17',4,3,100.000,1,'num-5',0,'2PN/15-17',0,1,0,187,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(194,189,'2PN',145,'Unclear',5,3,100.000,1,'num-6',0,'2PN/unclear',0,1,0,187,NULL,NULL,1,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(195,139,'2PN',146,'Z-Level',3,2,25.000,2,'Z-Level',0,'2PN/z_grade',0,1,1,187,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','admin_admin','2025-06-18 14:11:13','2016-12-31 16:00:00',1,2),(196,195,'2PN',147,'Z _Score',1,3,100.000,1,'Level-1',0,'2PN/Z1',0,1,0,187,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','admin_admin','2025-06-18 13:49:14','2016-12-31 16:00:00',1,2),(197,195,'2PN',148,'Z2',2,3,85.000,1,'Level-2',0,'2PN/Z2',0,1,0,187,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','admin_admin','2025-06-18 13:44:57','2016-12-31 16:00:00',1,2),(198,195,'2PN',149,'Z3',3,3,70.000,1,'Level-3',0,'2PN/Z3',0,1,0,187,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(199,195,'2PN',150,'Indeterminacy',4,3,60.000,1,'Level-4',0,'2PN/unknown',0,1,0,187,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(200,-1,'fusion',151,'Fusion',5,1,0.000,2,'fusion',0,'fusion',0,1,1,187,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(201,200,'fusion',152,'Densification',3,2,100.000,2,'Densification',0,'fusion/tM_densification',0,1,1,187,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(202,201,'fusion',153,'<50%',1,3,100.000,1,'fusion/<50%',0,'fusion/<50%',0,1,0,187,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(203,201,'fusion',154,'>50%',1,3,60.000,1,'fusion/>50%',0,'fusion/>50%',0,1,0,187,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(204,140,'2PN',155,'0',1,3,0.000,1,'2PN/0',0,'2PN/0',0,1,0,187,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(205,2,'2PN',69,'0',1,3,0.000,1,'2PN/0',0,'2PN/0',0,1,0,70,NULL,NULL,0,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1); /*!40000 ALTER TABLE `mark` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mark_key` -- DROP TABLE IF EXISTS `mark_key`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `mark_key` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增id', `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '名称', `mark_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'key值（唯一）', `identfy_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT 'AI_key', `state` int NOT NULL COMMENT '状态 0 禁用 1 启用', `order_num` int DEFAULT NULL COMMENT '序号 - 备用', `info` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci 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 '终端id', `region` int NOT NULL DEFAULT '1' COMMENT '地区1.中文2.英文', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=156 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mark_key` -- LOCK TABLES `mark_key` WRITE; /*!40000 ALTER TABLE `mark_key` DISABLE KEYS */; INSERT INTO `mark_key` VALUES (1,'原核','2PN',NULL,1,1,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(2,'原核数量','2PN/PN-NUM',NULL,1,2,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(3,'1','2PN/1',NULL,1,3,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(4,'2','2PN/2',NULL,1,4,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(5,'3','2PN/3',NULL,1,5,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(6,'2细胞','2-cell',NULL,1,6,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(7,'碎片率','2-cell/key_fragment',NULL,1,7,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(8,'均匀度','2-cell/key_uniform',NULL,1,8,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(9,'<10%','2-cell/<10%',NULL,1,9,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(10,'10%-20%','2-cell/10%-20%',NULL,1,10,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(11,'20%-50%','2-cell/20%-50%',NULL,1,11,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(12,'>50%','2-cell/>50%',NULL,1,12,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(13,'均匀','2-cell/uniform',NULL,1,13,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(14,'不均匀','2-cell/nonuniform',NULL,1,14,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(15,'4细胞','4-cell',NULL,1,15,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(16,'碎片率','4-cell/key_fragment',NULL,1,16,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(17,'均匀度','4-cell/key_uniform',NULL,1,17,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(18,'<10%','4-cell/<10%',NULL,1,18,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(19,'10%-20%','4-cell/10%-20%',NULL,1,19,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(20,'20%-50%','4-cell/20%-50%',NULL,1,20,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(21,'>50%','4-cell/>50%',NULL,1,21,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(22,'均匀','4-cell/uniform',NULL,1,22,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(23,'不均匀','4-cell/nonuniform',NULL,1,23,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(24,'8细胞','8-cell',NULL,1,24,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(25,'碎片率','8-cell/key_fragment',NULL,1,25,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(26,'均匀度','8-cell/key_uniform',NULL,1,26,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(27,'<10%','8-cell/<10%',NULL,1,27,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(28,'10%-20%','8-cell/10%-20%',NULL,1,28,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(29,'20%-50%','8-cell/20%-50%',NULL,1,29,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(30,'>50%','8-cell/>50%',NULL,1,30,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(31,'均匀','8-cell/uniform',NULL,1,31,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(32,'不均匀','8-cell/nonuniform',NULL,1,32,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(33,'囊胚','blastula',NULL,1,33,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(34,'内细胞团','blastula/ICM',NULL,1,34,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(35,'滋养层细胞','blastula/TE',NULL,1,35,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(36,'A','blastula/ICM-A',NULL,1,36,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(37,'B','blastula/ICM-B',NULL,1,37,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(38,'C','blastula/ICM-C',NULL,1,38,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(39,'A','blastula/TE-A',NULL,1,39,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(40,'B','blastula/TE-B',NULL,1,40,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(41,'C','blastula/TE-C',NULL,1,41,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(42,'扩张期','blastula/Expansion',NULL,1,42,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(43,'1','blastula/1',NULL,1,43,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(44,'2','blastula/2',NULL,1,44,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(45,'3','blastula/3',NULL,1,45,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(46,'4','blastula/4',NULL,1,46,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(47,'5','blastula/5',NULL,1,47,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(48,'6','blastula/6',NULL,1,48,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(69,'0','2PN/0',NULL,1,69,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(70,'核仁数量','nucleolus-NUM',NULL,1,70,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(71,'6-8个','num-2',NULL,1,71,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(72,'9-11个','num-3',NULL,1,72,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(73,'12-14个','num-4',NULL,1,73,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(74,'15-17个','num-5',NULL,1,74,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(75,'看不清','num-6',NULL,1,75,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(79,'Z分级','Z-Level',NULL,1,79,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(80,'Z1','Level-1',NULL,1,80,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(81,'Z2','Level-2',NULL,1,81,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(82,'Z3','Level-3',NULL,1,82,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(83,'不确定','Level-4',NULL,1,83,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(84,'融合期','fusion',NULL,1,84,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(85,'致密化','Densification',NULL,1,85,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(86,'<50%','fusion/<50%',NULL,1,86,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(87,'>50%','fusion/>50%',NULL,1,89,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(92,'PN','2PN',NULL,1,1,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(93,'PN_number','2PN/PN-NUM',NULL,1,2,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(94,'1','2PN/1',NULL,1,3,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(95,'2','2PN/2',NULL,1,4,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(96,'3','2PN/3',NULL,1,5,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(97,'2cell','2-cell',NULL,1,6,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(98,'fragment','2-cell/key_fragment',NULL,1,7,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(99,'uniform','2-cell/key_uniform',NULL,1,8,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(100,'<10%','2-cell/<10%',NULL,1,9,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(101,'10%-20%','2-cell/10%-20%',NULL,1,10,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(102,'20%-50%','2-cell/20%-50%',NULL,1,11,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(103,'>50%','2-cell/>50%',NULL,1,12,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(104,'uniform','2-cell/uniform',NULL,1,13,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(105,'nonuniform','2-cell/nonuniform',NULL,1,14,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(106,'4cell','4-cell',NULL,1,15,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(107,'fragment','4-cell/key_fragment',NULL,1,16,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(108,'uniform','4-cell/key_uniform',NULL,1,17,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(109,'<10%','4-cell/<10%',NULL,1,18,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(110,'10%-20%','4-cell/10%-20%',NULL,1,19,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(111,'20%-50%','4-cell/20%-50%',NULL,1,20,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(112,'>50%','4-cell/>50%',NULL,1,21,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(113,'uniform','4-cell/uniform',NULL,1,22,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(114,'nonuniform','4-cell/nonuniform',NULL,1,23,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(115,'8cell','8-cell',NULL,1,24,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(116,'fragment','8-cell/key_fragment',NULL,1,25,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(117,'uniform','8-cell/key_uniform',NULL,1,26,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(118,'<10%','8-cell/<10%',NULL,1,27,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(119,'10%-20%','8-cell/10%-20%',NULL,1,28,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(120,'20%-50%','8-cell/20%-50%',NULL,1,29,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(121,'>50%','8-cell/>50%',NULL,1,30,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(122,'uniform','8-cell/uniform',NULL,1,31,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(123,'cell/nonuniform','8-cell/nonuniform',NULL,1,32,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(124,'Blastocyst','blastula',NULL,1,33,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(125,'ICM','blastula/ICM',NULL,1,34,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(126,'TE','blastula/TE',NULL,1,35,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(127,'A','blastula/ICM-A',NULL,1,36,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(128,'B','blastula/ICM-B',NULL,1,37,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(129,'C','blastula/ICM-C',NULL,1,38,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(130,'A','blastula/TE-A',NULL,1,39,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(131,'B','blastula/TE-B',NULL,1,40,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(132,'C','blastula/TE-C',NULL,1,41,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(133,'Expansion','blastula/Expansion',NULL,1,42,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(134,'1','blastula/1',NULL,1,43,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(135,'2','blastula/2',NULL,1,44,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(136,'3','blastula/3',NULL,1,45,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(137,'4','blastula/4',NULL,1,46,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(138,'5','blastula/5',NULL,1,47,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(139,'6','blastula/6',NULL,1,48,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(140,'0','2PN/0',NULL,1,69,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(141,'Nucleolus-number','nucleolus-NUM',NULL,1,70,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(142,'6-8','num-2',NULL,1,71,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(143,'9-11','num-3',NULL,1,72,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(144,'12-14','num-4',NULL,1,73,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(145,'15-17','num-5',NULL,1,74,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(146,'Unclear','num-6',NULL,1,75,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(147,'Z_Level','Z-Level',NULL,1,79,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(148,'Z1','Level-1',NULL,1,80,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(149,'Z2','Level-2',NULL,1,81,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(150,'Z3','Level-3',NULL,1,82,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(151,'Indeterminacy','Level-4',NULL,1,83,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(152,'Fusion','fusion',NULL,1,84,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(153,'Densification','Densification',NULL,1,85,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(154,'<50%','fusion/<50%',NULL,1,86,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(155,'>50%','fusion/>50%',NULL,1,89,NULL,'developer_developer','2017-01-01 00:00:00','developer_developer','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2); /*!40000 ALTER TABLE `mark_key` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mark_weight` -- DROP TABLE IF EXISTS `mark_weight`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `mark_weight` ( `id` bigint NOT NULL AUTO_INCREMENT, `parent_id` bigint NOT NULL DEFAULT '-1' COMMENT '上级id，无上级默认-1', `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '名称', `mark_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '标记key值', `weight` decimal(10,3) NOT NULL COMMENT '权重', `order_num` int NOT 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 '操作终端', `region` int NOT NULL DEFAULT '1' COMMENT '地区1.中文2.英文', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='标记评分设置表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mark_weight` -- LOCK TABLES `mark_weight` WRITE; /*!40000 ALTER TABLE `mark_weight` DISABLE KEYS */; INSERT INTO `mark_weight` VALUES (1,-1,'D2','D2',0.000,4,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(2,1,'原核','2PN',50.000,1,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(3,1,'2细胞','2-cell',25.000,2,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(4,1,'4细胞','4-cell',25.000,3,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(5,-1,'D3','D3',0.000,3,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(6,5,'原核','2PN',10.000,1,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(7,5,'2细胞','2-cell',5.000,2,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(8,5,'4细胞','4-cell',5.000,3,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(9,5,'8细胞','8-cell',80.000,4,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(10,-1,'D4','D4',0.000,2,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(11,10,'原核','2PN',5.000,1,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(12,10,'2细胞','2-cell',5.000,2,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(13,10,'4细胞','4-cell',10.000,3,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(14,10,'8细胞','8-cell',50.000,4,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(15,10,'融合期','fusion',30.000,5,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(16,-1,'D5','D5',0.000,1,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(17,16,'原核','2PN',3.000,1,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(18,16,'2细胞','2-cell',2.000,2,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(19,16,'4细胞','4-cell',2.000,3,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(20,16,'8细胞','8-cell',10.000,4,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(21,16,'融合期','fusion',3.000,5,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(22,16,'囊胚','blastula',80.000,6,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(23,-1,'D2','D2',0.000,4,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(24,23,'PN','2PN',50.000,1,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(25,23,'2cell','2-cell',25.000,2,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(26,23,'4cell','4-cell',25.000,3,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(27,-1,'D3','D3',0.000,3,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(28,27,'PN','2PN',10.000,1,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(29,27,'2cell','2-cell',5.000,2,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(30,27,'4cell','4-cell',5.000,3,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(31,27,'8cell','8-cell',80.000,4,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(32,-1,'D4','D4',0.000,2,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(33,32,'PN','2PN',5.000,1,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(34,32,'2cell','2-cell',5.000,2,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(35,32,'4cell','4-cell',10.000,3,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(36,32,'8cell','8-cell',50.000,4,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(37,32,'Fusion','fusion',30.000,5,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(38,-1,'D5','D5',0.000,1,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(39,38,'PN','2PN',3.000,1,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(40,38,'2cell','2-cell',2.000,2,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(41,38,'4cell','4-cell',2.000,3,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(42,38,'8cell','8-cell',10.000,4,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(43,38,'Fusion','fusion',3.000,5,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(44,38,'Blastocyst','blastula',80.000,6,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2); /*!40000 ALTER TABLE `mark_weight` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `message` -- DROP TABLE IF EXISTS `message`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `message` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增主键', `alarm_id` bigint NOT NULL COMMENT '告警记录id', `alarm_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '告警类型key', `tl_sn` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'tl设备编号', `house_sn` int DEFAULT NULL COMMENT '仓室编号:1-11(11号仓室为缓冲瓶)', `well_sn` int DEFAULT NULL COMMENT 'well编号', `account` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '用户账号', `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '消息标题', `text` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '消息内容', `text_detail` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '消息详情', `read_status` int NOT NULL COMMENT '消息状态：0 未读 1 已读', `read_time` datetime DEFAULT NULL COMMENT '读取时间', `type` int NOT NULL COMMENT '是否完成： 0正在报警 1结束报警', `start_time` datetime NOT NULL COMMENT '开始时间', `end_time` datetime DEFAULT NULL COMMENT '结束时间', `continue_time` int DEFAULT NULL COMMENT '持续时间 / s', `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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `message` -- LOCK TABLES `message` WRITE; /*!40000 ALTER TABLE `message` DISABLE KEYS */; /*!40000 ALTER TABLE `message` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `photo_search_button` -- DROP TABLE IF EXISTS `photo_search_button`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `photo_search_button` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增id', `button_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '按钮名', `min_hour` int NOT NULL COMMENT '按钮最小时间', `max_hour` int NOT NULL COMMENT '按钮最大时间', `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '按钮类型:\r\n1全程时间 common_button\r\n2关键节点 key_button \r\n3快捷定位 quick_button\r\n4时间轴 time_line', `state` int NOT NULL COMMENT '按钮状态:0禁用 1启用', `order_num` int NOT 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 '操作终端', `region` int NOT NULL DEFAULT '1' COMMENT '地区1.中文2.英文', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=63 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='图片快速检索按钮设置表： 配置关键节点和普通节点时间段'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `photo_search_button` -- LOCK TABLES `photo_search_button` WRITE; /*!40000 ALTER TABLE `photo_search_button` DISABLE KEYS */; INSERT INTO `photo_search_button` VALUES (1,'原核',16,18,'QUICK_BUTTON',1,2,'admin_admin','2017-01-01 00:00:00','admin_admin','2025-02-12 11:37:05','2016-12-31 16:00:00',1,1),(2,'2细胞',25,29,'QUICK_BUTTON',1,3,'admin_admin','2017-01-01 00:00:00','admin_admin','2025-02-12 11:37:11','2016-12-31 16:00:00',1,1),(3,'4细胞',43,45,'QUICK_BUTTON',1,4,'admin_admin','2017-01-01 00:00:00','admin_admin','2025-02-12 11:37:16','2016-12-31 16:00:00',1,1),(4,'8细胞',67,69,'QUICK_BUTTON',1,5,'admin_admin','2017-01-01 00:00:00','admin_admin','2025-02-12 11:37:22','2016-12-31 16:00:00',1,1),(5,'囊胚',114,118,'QUICK_BUTTON',1,7,'admin_admin','2017-01-01 00:00:00','admin_admin','2025-02-12 11:37:37','2016-12-31 16:00:00',1,1),(6,'2PB',2,6,'KEY_BUTTON',1,0,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(7,'原核',16,18,'KEY_BUTTON',1,0,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(8,'2细胞',25,29,'KEY_BUTTON',1,0,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(9,'4细胞',43,45,'KEY_BUTTON',1,0,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(10,'D1',0,24,'COMMON_BUTTON',1,0,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(11,'D2',25,48,'COMMON_BUTTON',1,0,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(12,'D3',49,72,'COMMON_BUTTON',1,0,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(13,'D4',73,96,'COMMON_BUTTON',1,0,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(14,'D5',97,120,'COMMON_BUTTON',1,0,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(15,'D6',121,144,'COMMON_BUTTON',1,0,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(17,'24',0,24,'TIME_LINE',1,0,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(18,'48',24,48,'TIME_LINE',1,0,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(19,'72',48,72,'TIME_LINE',1,0,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(20,'96',72,96,'TIME_LINE',1,0,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(21,'120',96,120,'TIME_LINE',1,0,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(22,'144',120,144,'TIME_LINE',1,0,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(23,'168',144,168,'TIME_LINE',1,0,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(25,'D7',145,168,'COMMON_BUTTON',1,0,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(26,'8细胞',67,69,'KEY_BUTTON',1,0,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(27,'融合期',90,94,'KEY_BUTTON',1,0,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(28,'囊胚',114,118,'KEY_BUTTON',1,0,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,1),(33,'2PB',2,6,'QUICK_BUTTON',1,1,'admin_admin','2025-01-13 15:48:53','admin_admin','2025-01-13 15:48:53','2016-12-31 16:00:00',1,1),(34,'融合期',90,94,'QUICK_BUTTON',1,6,'admin_admin','2025-01-13 15:51:25','admin_admin','2025-02-12 11:37:30','2016-12-31 16:00:00',1,1),(35,'PN',16,18,'QUICK_BUTTON',1,2,'admin_admin','2017-01-01 00:00:00','admin_admin','2025-02-12 11:37:05','2016-12-31 16:00:00',1,2),(36,'2cell',25,29,'QUICK_BUTTON',1,3,'admin_admin','2017-01-01 00:00:00','admin_admin','2025-02-12 11:37:11','2016-12-31 16:00:00',1,2),(37,'4cell',43,45,'QUICK_BUTTON',1,4,'admin_admin','2017-01-01 00:00:00','admin_admin','2025-02-12 11:37:16','2016-12-31 16:00:00',1,2),(38,'8cell',67,69,'QUICK_BUTTON',1,5,'admin_admin','2017-01-01 00:00:00','admin_admin','2025-02-12 11:37:22','2016-12-31 16:00:00',1,2),(39,'Blastocyst',114,118,'QUICK_BUTTON',1,7,'admin_admin','2017-01-01 00:00:00','admin_admin','2025-02-12 11:37:37','2016-12-31 16:00:00',1,2),(40,'2PB',2,6,'KEY_BUTTON',1,0,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(41,'PN',16,18,'KEY_BUTTON',1,0,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(42,'2cell',25,29,'KEY_BUTTON',1,0,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(43,'4cell',43,45,'KEY_BUTTON',1,0,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(44,'D1',0,24,'COMMON_BUTTON',1,0,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(45,'D2',25,48,'COMMON_BUTTON',1,0,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(46,'D3',49,72,'COMMON_BUTTON',1,0,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(47,'D4',73,96,'COMMON_BUTTON',1,0,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(48,'D5',97,120,'COMMON_BUTTON',1,0,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(49,'D6',121,144,'COMMON_BUTTON',1,0,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(50,'24',0,24,'TIME_LINE',1,0,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(51,'48',24,48,'TIME_LINE',1,0,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(52,'72',48,72,'TIME_LINE',1,0,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(53,'96',72,96,'TIME_LINE',1,0,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(54,'120',96,120,'TIME_LINE',1,0,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(55,'144',120,144,'TIME_LINE',1,0,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(56,'168',144,168,'TIME_LINE',1,0,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(57,'D7',145,168,'COMMON_BUTTON',1,0,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(58,'8cell',67,69,'KEY_BUTTON',1,0,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(59,'Fusion',90,94,'KEY_BUTTON',1,0,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(60,'Blastocyst',114,118,'KEY_BUTTON',1,0,'admin_admin','2017-01-01 00:00:00','admin_admin','2017-01-01 00:00:00','2016-12-31 16:00:00',1,2),(61,'2PB',2,6,'QUICK_BUTTON',1,1,'admin_admin','2025-01-13 15:48:53','admin_admin','2025-01-13 15:48:53','2016-12-31 16:00:00',1,2),(62,'Fusion',90,94,'QUICK_BUTTON',1,6,'admin_admin','2025-01-13 15:51:25','admin_admin','2025-02-12 11:37:30','2016-12-31 16:00:00',1,2); /*!40000 ALTER TABLE `photo_search_button` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `picture` -- DROP TABLE IF EXISTS `picture`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `picture` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增id', `picture_uuid` bigint NOT NULL COMMENT '关联使用时使用', `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号仓室为缓冲瓶)', `well_sn` int NOT NULL COMMENT 'well编号 1-16', `ccd_sn` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'ccd编号', `source_image_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '原图名字', `source_image_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '原图的本地路径(不是上传后的保存路径)', `source_image_width` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '原图宽', `source_image_height` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '原图高', `source_image_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '原图url', `image_time` datetime NOT NULL COMMENT '设备返回的拍摄时间', `photograph_type` int NOT NULL COMMENT '对焦还是ccd拍照 1对焦 0拍照', `total_layer` int NOT NULL COMMENT '拍照总层数', `picture_layer` int NOT NULL COMMENT '图片层', `shooting_position` int NOT NULL COMMENT '垂直电机位置', `image_score` decimal(10,3) DEFAULT NULL COMMENT '图片分数(如果是对焦才有值) ', `clearest` int DEFAULT NULL COMMENT '是否是最清晰的(CCD拍照才有)0不是 1最清晰 ', `the_end` int NOT NULL COMMENT '拍照结束标记1 结束 0 未结束 (结束后开始更新对焦起点,ccd拍照结束开始合成视频)', `image_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '抠图图片名', `image_height` int NOT NULL COMMENT '裁剪高', `image_width` int NOT NULL COMMENT '裁剪宽', `image_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '抠图url', `radius` int DEFAULT NULL COMMENT '识别圆的半径', `crop_state` int NOT NULL COMMENT '抠图是否成功 0 未裁剪 1 成功 -1 失败', `embryo_culture_record_id` bigint NOT NULL COMMENT '培养记录id', `embryo_id` bigint NOT NULL COMMENT '胚胎id', `batch_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '拍照批次号', `horizontal_position` int DEFAULT NULL COMMENT '水平电机位置', `fertilization_time` datetime DEFAULT NULL COMMENT '受精时间', `develop_time` int NOT NULL COMMENT '发育时长/分钟\r\n自动对焦是0', `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 unsigned DEFAULT NULL COMMENT '操作终端', `use_time` bigint DEFAULT '0' COMMENT '抠图消耗的时间单位ms', PRIMARY KEY (`id`) USING BTREE, KEY `picture_uuid` (`picture_uuid`) USING BTREE, KEY `tl_sn` (`tl_sn`,`house_sn`,`well_sn`) USING BTREE, KEY `create_time` (`create_time`) USING BTREE, KEY `update_time` (`update_time`) USING BTREE, KEY `picture_layer` (`picture_layer`) USING BTREE, KEY `photograph_type` (`photograph_type`) USING BTREE, KEY `embryo_id` (`embryo_id`,`photograph_type`,`picture_layer`,`crop_state`) USING BTREE COMMENT 'well级别查询抠图成功的图片', KEY `embryo_culture_record_id` (`embryo_id`,`clearest`,`crop_state`,`develop_time`) USING BTREE COMMENT '仓室级别查询最清晰图片' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='ccd拍照图片留存表：记录CCD拍照和自动对焦原图以及抠图相关信息'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `picture` -- LOCK TABLES `picture` WRITE; /*!40000 ALTER TABLE `picture` DISABLE KEYS */; /*!40000 ALTER TABLE `picture` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `picture_identify_middle` -- DROP TABLE IF EXISTS `picture_identify_middle`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `picture_identify_middle` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增主键', `tl_sn` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'tl设备编号', `house_sn` int NOT NULL COMMENT '仓室编号', `state` int NOT NULL COMMENT '状态 0 移除 1 正常\r\n', `last_update_time` datetime NOT 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 '终端id', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `picture_identify_middle` -- LOCK TABLES `picture_identify_middle` WRITE; /*!40000 ALTER TABLE `picture_identify_middle` DISABLE KEYS */; /*!40000 ALTER TABLE `picture_identify_middle` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `picture_identify_result` -- DROP TABLE IF EXISTS `picture_identify_result`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `picture_identify_result` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增id', `picture_uuid` bigint NOT NULL COMMENT '关联使用时使用', `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号仓室为缓冲瓶)', `well_sn` int NOT NULL COMMENT 'well编号 1-16', `image_time` datetime NOT NULL COMMENT '设备返回的拍摄时间', `picture_layer` int NOT NULL COMMENT '图片层', `image_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '抠图url', `embryo_culture_record_id` bigint NOT NULL COMMENT '培养记录id', `embryo_id` bigint NOT NULL COMMENT '胚胎id', `develop_time` int NOT NULL COMMENT '发育时长/分钟\r\n', `stage` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '发育阶段', `stage_prob` decimal(10,4) DEFAULT NULL COMMENT '阶段可能性', `properties` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '发育阶段详细指标', `identify_state` int NOT NULL COMMENT '图片是被状态 0 未识别 1 识别成功 2 识别失败 3 已上传等待识别', `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 unsigned DEFAULT NULL COMMENT '操作终端', PRIMARY KEY (`id`) USING BTREE, KEY `picture_uuid` (`picture_uuid`) USING BTREE, KEY `tl_sn` (`tl_sn`,`house_sn`,`well_sn`) USING BTREE, KEY `create_time` (`create_time`) USING BTREE, KEY `update_time` (`update_time`) USING BTREE, KEY `picture_layer` (`picture_layer`) USING BTREE, KEY `embryo_id` (`embryo_id`) USING BTREE, KEY `embryo_culture_record_id` (`embryo_culture_record_id`,`develop_time`,`picture_layer`,`identify_state`) USING BTREE, KEY `identify_state` (`identify_state`) 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 `picture_identify_result` -- LOCK TABLES `picture_identify_result` WRITE; /*!40000 ALTER TABLE `picture_identify_result` DISABLE KEYS */; /*!40000 ALTER TABLE `picture_identify_result` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `picture_identify_result_cache` -- DROP TABLE IF EXISTS `picture_identify_result_cache`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `picture_identify_result_cache` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增id', `picture_uuid` bigint NOT NULL COMMENT '关联使用时使用', `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号仓室为缓冲瓶)', `well_sn` int NOT NULL COMMENT 'well编号 1-16', `image_time` datetime NOT NULL COMMENT '设备返回的拍摄时间', `picture_layer` int NOT NULL COMMENT '图片层', `image_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '抠图url', `embryo_culture_record_id` bigint NOT NULL COMMENT '培养记录id', `embryo_id` bigint NOT NULL COMMENT '胚胎id', `develop_time` int NOT NULL COMMENT '发育时长/分钟\r\n', `stage` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '发育阶段', `stage_prob` decimal(10,4) NOT NULL COMMENT '阶段可能性', `properties` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '发育阶段详细指标', `identify_state` int NOT NULL COMMENT '数据处理是否成功 0 否 1是', `identify_time` datetime DEFAULT NULL COMMENT '识别时间', `mark_state` int DEFAULT 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 unsigned DEFAULT NULL COMMENT '操作终端', PRIMARY KEY (`id`) USING BTREE, KEY `picture_uuid` (`picture_uuid`) USING BTREE, KEY `tl_sn` (`tl_sn`,`house_sn`,`well_sn`) USING BTREE, KEY `create_time` (`create_time`) USING BTREE, KEY `update_time` (`update_time`) USING BTREE, KEY `picture_layer` (`picture_layer`) USING BTREE, KEY `embryo_id` (`embryo_id`) USING BTREE, KEY `embryo_culture_record_id` (`embryo_culture_record_id`,`develop_time`,`picture_layer`,`identify_state`) USING BTREE, KEY `identify_state` (`identify_state`) 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 `picture_identify_result_cache` -- LOCK TABLES `picture_identify_result_cache` WRITE; /*!40000 ALTER TABLE `picture_identify_result_cache` DISABLE KEYS */; /*!40000 ALTER TABLE `picture_identify_result_cache` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `software_version` -- DROP TABLE IF EXISTS `software_version`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `software_version` ( `id` bigint NOT NULL COMMENT '自增id', `release_version` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '发布版本', `run_version` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '运行版本', `version_log` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '运行版本log', `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 '终端id', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `software_version` -- LOCK TABLES `software_version` WRITE; /*!40000 ALTER TABLE `software_version` DISABLE KEYS */; INSERT INTO `software_version` VALUES (1,'2.0.0','2.0.0','/...',1,'admin_admin','2023-11-02 14:38:31','admin_admin','2023-11-02 14:38:39','2016-12-31 16:00:00',1); /*!40000 ALTER TABLE `software_version` ENABLE KEYS */; UNLOCK TABLES; -- -- 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; /*!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:31