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