Главная Обзор Помощь
Регистрация Вход
huangjie
/
aivfo-tl-3.0
1
0
Ответвить 0
Файлы Задачи 0 Запросы на слияние 0 Вики
Дерево: 6b8dd8a87d
Ветки Метки
aivfo-tl-3.0
/
sql
/
aivfo_tl.sql

aivfo_tl.sql 121 KB
История Исходник

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023 
  1. -- MySQL dump 10.13  Distrib 8.0.46, for Linux (x86_64)
    2. 

  2. --
    3. 

  3. -- Host: localhost    Database: aivfo_tl
    4. 

  4. -- ------------------------------------------------------
    5. 

  5. -- Server version	8.0.46
    6. 

  6. /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
    7. 

  7. /*!40103 SET TIME_ZONE='+00:00' */;
    8. 

  8. /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
    9. 

  9. /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
    10. 

  10. /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
    11. 

  11. /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
    12. 

  12. 

  13. --
    14. 

  14. -- Table structure for table `balance`
    15. 

  15. --
    16. 

  16. 

  17. DROP TABLE IF EXISTS `balance`;
    18. 

  18. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    19. 

  19. /*!50503 SET character_set_client = utf8mb4 */;
    20. 

  20. CREATE TABLE `balance` (
    21. 

  21.   `id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增id',
    22. 

  22.   `tl_sn` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'tl设备sn',
    23. 

  23.   `house_sn` int NOT NULL COMMENT '仓室编号:1-11(11号仓室为缓冲瓶)',
    24. 

  24.   `start_time` datetime NOT NULL COMMENT '开始时间',
    25. 

  25.   `end_time` datetime DEFAULT NULL COMMENT '结束时间',
    26. 

  26.   `create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '创建人',
    27. 

  27.   `create_time` datetime NOT NULL COMMENT '创建时间',
    28. 

  28.   `update_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '修改人',
    29. 

  29.   `update_time` datetime NOT NULL COMMENT '修改时间',
    30. 

  30.   `deleted` timestamp NOT NULL COMMENT '已删除: 操作时间戳',
    31. 

  31.   `platform_id` int DEFAULT NULL COMMENT '终端id',
    32. 

  32.   PRIMARY KEY (`id`) USING BTREE
    33. 

  33. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='平衡记录表';
    34. 

  34. /*!40101 SET character_set_client = @saved_cs_client */;
    35. 

  35. 

  36. --
    37. 

  37. -- Dumping data for table `balance`
    38. 

  38. --
    39. 

  39. 

  40. LOCK TABLES `balance` WRITE;
    41. 

  41. /*!40000 ALTER TABLE `balance` DISABLE KEYS */;
    42. 

  42. /*!40000 ALTER TABLE `balance` ENABLE KEYS */;
    43. 

  43. UNLOCK TABLES;
    44. 

  44. 

  45. --
    46. 

  46. -- Table structure for table `case_info`
    47. 

  47. --
    48. 

  48. 

  49. DROP TABLE IF EXISTS `case_info`;
    50. 

  50. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    51. 

  51. /*!50503 SET character_set_client = utf8mb4 */;
    52. 

  52. CREATE TABLE `case_info` (
    53. 

  53.   `id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增id',
    54. 

  54.   `case_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '病例号',
    55. 

  55.   `husband` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '男方姓名',
    56. 

  56.   `husband_birth` datetime DEFAULT NULL COMMENT '男方出生日期',
    57. 

  57.   `wife` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '女方姓名',
    58. 

  58.   `wife_birth` datetime DEFAULT NULL COMMENT '女方出生日期',
    59. 

  59.   `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '联系方式',
    60. 

  60.   `create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '创建人',
    61. 

  61.   `create_time` datetime NOT NULL COMMENT '创建时间',
    62. 

  62.   `update_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '修改人',
    63. 

  63.   `update_time` datetime NOT NULL COMMENT '修改时间',
    64. 

  64.   `deleted` timestamp NOT NULL COMMENT '已删除: 操作时间戳',
    65. 

  65.   `platform_id` int DEFAULT NULL COMMENT '操作终端',
    66. 

  66.   PRIMARY KEY (`id`) USING BTREE
    67. 

  67. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='病例信息表';
    68. 

  68. /*!40101 SET character_set_client = @saved_cs_client */;
    69. 

  69. 

  70. --
    71. 

  71. -- Dumping data for table `case_info`
    72. 

  72. --
    73. 

  73. 

  74. LOCK TABLES `case_info` WRITE;
    75. 

  75. /*!40000 ALTER TABLE `case_info` DISABLE KEYS */;
    76. 

  76. /*!40000 ALTER TABLE `case_info` ENABLE KEYS */;
    77. 

  77. UNLOCK TABLES;
    78. 

  78. 

  79. --
    80. 

  80. -- Table structure for table `debug_picture`
    81. 

  81. --
    82. 

  82. 

  83. DROP TABLE IF EXISTS `debug_picture`;
    84. 

  84. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    85. 

  85. /*!50503 SET character_set_client = utf8mb4 */;
    86. 

  86. CREATE TABLE `debug_picture` (
    87. 

  87.   `id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增id',
    88. 

  88.   `picture_uuid` bigint NOT NULL COMMENT '图片id关联使用',
    89. 

  89.   `tl_id` bigint NOT NULL COMMENT 'tl设备id',
    90. 

  90.   `tl_sn` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'tl设备编号',
    91. 

  91.   `house_id` bigint NOT NULL COMMENT '仓室id',
    92. 

  92.   `house_sn` int NOT NULL COMMENT '仓室编号:1-11(11号仓室为缓冲瓶)',
    93. 

  93.   `well_sn` int NOT NULL COMMENT 'well编号：1-16',
    94. 

  94.   `ccd_sn` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'ccd编号',
    95. 

  95.   `photograph_type` int NOT NULL COMMENT '拍照模式:1:单张抓拍  2:水平拍照 3全程拍照',
    96. 

  96.   `source_image_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '原图名字',
    97. 

  97.   `source_image_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '原图url',
    98. 

  98.   `source_image_width` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '原图宽',
    99. 

  99.   `source_image_height` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '原图高',
    100. 

  100.   `image_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '抠图名字',
    101. 

  101.   `image_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '抠图url',
    102. 

  102.   `image_height` int NOT NULL COMMENT '裁剪高',
    103. 

  103.   `image_width` int NOT NULL COMMENT '裁剪宽',
    104. 

  104.   `image_time` datetime NOT NULL COMMENT ' 设备返回的拍摄时间(同一个时间的图片为同一个批次)',
    105. 

  105.   `vertical_motor_position` int DEFAULT NULL COMMENT '垂直电机位置',
    106. 

  106.   `horizontal_motor_position` int DEFAULT NULL COMMENT '水平电机位置',
    107. 

  107.   `crop_state` int NOT NULL COMMENT '抠图是否成功',
    108. 

  108.   `create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '创建人',
    109. 

  109.   `create_time` datetime NOT NULL COMMENT '创建时间',
    110. 

  110.   `update_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '修改人',
    111. 

  111.   `update_time` datetime NOT NULL COMMENT '修改时间',
    112. 

  112.   `deleted` timestamp NOT NULL COMMENT '已删除: 操作时间戳',
    113. 

  113.   `platform_id` int DEFAULT NULL COMMENT '操作终端',
    114. 

  114.   PRIMARY KEY (`id`) USING BTREE
    115. 

  115. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='仓室调试图片表：记录仓室调试下产生的原图抠图';
    116. 

  116. /*!40101 SET character_set_client = @saved_cs_client */;
    117. 

  117. 

  118. --
    119. 

  119. -- Dumping data for table `debug_picture`
    120. 

  120. --
    121. 

  121. 

  122. LOCK TABLES `debug_picture` WRITE;
    123. 

  123. /*!40000 ALTER TABLE `debug_picture` DISABLE KEYS */;
    124. 

  124. /*!40000 ALTER TABLE `debug_picture` ENABLE KEYS */;
    125. 

  125. UNLOCK TABLES;
    126. 

  126. 

  127. --
    128. 

  128. -- Table structure for table `dictionary`
    129. 

  129. --
    130. 

  130. 

  131. DROP TABLE IF EXISTS `dictionary`;
    132. 

  132. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    133. 

  133. /*!50503 SET character_set_client = utf8mb4 */;
    134. 

  134. CREATE TABLE `dictionary` (
    135. 

  135.   `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '自增id',
    136. 

  136.   `dict_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '字典类型 1字典类型 2字典数据',
    137. 

  137.   `parent_id` bigint DEFAULT NULL COMMENT '上级id',
    138. 

  138.   `dict_sort` int NOT NULL DEFAULT '0' COMMENT '字典排序',
    139. 

  139.   `dict_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '字典key值',
    140. 

  140.   `dict_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '字典名',
    141. 

  141.   `dict_value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '字典值',
    142. 

  142.   `state` int NOT NULL COMMENT '状态 0禁用 1启用',
    143. 

  143.   `create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '创建人',
    144. 

  144.   `create_time` datetime NOT NULL COMMENT '创建时间',
    145. 

  145.   `update_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '修改人',
    146. 

  146.   `update_time` datetime NOT NULL COMMENT '修改时间',
    147. 

  147.   `deleted` timestamp NOT NULL COMMENT '已删除: 操作时间戳',
    148. 

  148.   `platform_id` int DEFAULT NULL COMMENT '终端id',
    149. 

  149.   `region` int NOT NULL DEFAULT '1' COMMENT '地区1.中文2.英文',
    150. 

  150.   PRIMARY KEY (`id`) USING BTREE
    151. 

  151. ) ENGINE=InnoDB AUTO_INCREMENT=68 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='字典表';
    152. 

  152. /*!40101 SET character_set_client = @saved_cs_client */;
    153. 

  153. 

  154. --
    155. 

  155. -- Dumping data for table `dictionary`
    156. 

  156. --
    157. 

  157. 

  158. LOCK TABLES `dictionary` WRITE;
    159. 

  159. /*!40000 ALTER TABLE `dictionary` DISABLE KEYS */;
    160. 

  160. 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);
    161. 

  161. /*!40000 ALTER TABLE `dictionary` ENABLE KEYS */;
    162. 

  162. UNLOCK TABLES;
    163. 

  163. 

  164. --
    165. 

  165. -- Table structure for table `embryo`
    166. 

  166. --
    167. 

  167. 

  168. DROP TABLE IF EXISTS `embryo`;
    169. 

  169. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    170. 

  170. /*!50503 SET character_set_client = utf8mb4 */;
    171. 

  171. CREATE TABLE `embryo` (
    172. 

  172.   `id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增id',
    173. 

  173.   `tl_sn` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'tl设备编号',
    174. 

  174.   `house_sn` int NOT NULL COMMENT '仓室编号:1-11(11号仓室为缓冲瓶)',
    175. 

  175.   `embryo_culture_record_id` bigint NOT NULL COMMENT '培养记录id',
    176. 

  176.   `well_sn` int NOT NULL COMMENT 'well编号',
    177. 

  177.   `start_time` datetime NOT NULL COMMENT '受精时间',
    178. 

  178.   `state` int NOT NULL COMMENT '胚胎当前状态:   0培养中 1冷冻  2移植  3作废 4结束培养 5删除 ',
    179. 

  179.   `state_time` datetime NOT NULL COMMENT '处于当前状态时间点',
    180. 

  180.   `develop_time` int DEFAULT NULL COMMENT '发育时长/分钟',
    181. 

  181.   `score` decimal(10,2) DEFAULT NULL COMMENT '胚胎得分',
    182. 

  182.   `level` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '胚胎等级',
    183. 

  183.   `blastocyst_level` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '囊胚评级',
    184. 

  184.   `create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '创建人',
    185. 

  185.   `create_time` datetime NOT NULL COMMENT '创建时间',
    186. 

  186.   `update_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '修改人',
    187. 

  187.   `update_time` datetime NOT NULL COMMENT '修改时间',
    188. 

  188.   `deleted` timestamp NOT NULL COMMENT '已删除: 操作时间戳',
    189. 

  189.   `platform_id` int DEFAULT NULL COMMENT '操作端',
    190. 

  190.   PRIMARY KEY (`id`) USING BTREE
    191. 

  191. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='培养详情表: 记录培养记录胚胎详细信息';
    192. 

  192. /*!40101 SET character_set_client = @saved_cs_client */;
    193. 

  193. 

  194. --
    195. 

  195. -- Dumping data for table `embryo`
    196. 

  196. --
    197. 

  197. 

  198. LOCK TABLES `embryo` WRITE;
    199. 

  199. /*!40000 ALTER TABLE `embryo` DISABLE KEYS */;
    200. 

  200. /*!40000 ALTER TABLE `embryo` ENABLE KEYS */;
    201. 

  201. UNLOCK TABLES;
    202. 

  202. 

  203. --
    204. 

  204. -- Table structure for table `embryo_culture_record`
    205. 

  205. --
    206. 

  206. 

  207. DROP TABLE IF EXISTS `embryo_culture_record`;
    208. 

  208. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    209. 

  209. /*!50503 SET character_set_client = utf8mb4 */;
    210. 

  210. CREATE TABLE `embryo_culture_record` (
    211. 

  211.   `id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增id',
    212. 

  212.   `tl_sn` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'tl设备sn',
    213. 

  213.   `house_sn` int NOT NULL COMMENT '仓室编号:1-11(11号仓室为缓冲瓶)',
    214. 

  214.   `case_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '病例编号',
    215. 

  215.   `wife` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '女方姓名',
    216. 

  216.   `wife_birth` datetime DEFAULT NULL COMMENT '女方出生日期',
    217. 

  217.   `husband` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '男方姓名',
    218. 

  218.   `husband_birth` datetime DEFAULT NULL COMMENT '男方出生日期',
    219. 

  219.   `phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '联系方式',
    220. 

  220.   `note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '备注',
    221. 

  221.   `vip` int NOT NULL COMMENT '是否为特殊培养记录 0普通 1重点关注',
    222. 

  222.   `embryo_count` int NOT NULL COMMENT '胚胎数量',
    223. 

  223.   `state` int NOT NULL COMMENT '培养状态: 0培养结束 1正在培养',
    224. 

  224.   `start_time` datetime NOT NULL COMMENT '受精时间',
    225. 

  225.   `fertilization_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '受精类型(字典key)',
    226. 

  226.   `fertilization_type_id` bigint NOT NULL COMMENT '受精类型id(字典value)',
    227. 

  227.   `end_time` datetime DEFAULT NULL COMMENT '培育结束时间',
    228. 

  228.   `develop_time` int DEFAULT NULL COMMENT '培养时长/分钟',
    229. 

  229.   `cycle` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '周期编号',
    230. 

  230.   `picture_table_name` int DEFAULT NULL COMMENT '图片存放表名',
    231. 

  231.   `create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '创建人',
    232. 

  232.   `create_time` datetime NOT NULL COMMENT '创建时间',
    233. 

  233.   `update_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '修改人',
    234. 

  234.   `update_time` datetime NOT NULL COMMENT '修改时间',
    235. 

  235.   `deleted` timestamp NOT NULL COMMENT '已删除: 操作时间戳',
    236. 

  236.   `platform_id` int DEFAULT NULL COMMENT '操作端',
    237. 

  237.   PRIMARY KEY (`id`) USING BTREE
    238. 

  238. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='胚胎培养记录表';
    239. 

  239. /*!40101 SET character_set_client = @saved_cs_client */;
    240. 

  240. 

  241. --
    242. 

  242. -- Dumping data for table `embryo_culture_record`
    243. 

  243. --
    244. 

  244. 

  245. LOCK TABLES `embryo_culture_record` WRITE;
    246. 

  246. /*!40000 ALTER TABLE `embryo_culture_record` DISABLE KEYS */;
    247. 

  247. /*!40000 ALTER TABLE `embryo_culture_record` ENABLE KEYS */;
    248. 

  248. UNLOCK TABLES;
    249. 

  249. 

  250. --
    251. 

  251. -- Table structure for table `embryo_level`
    252. 

  252. --
    253. 

  253. 

  254. DROP TABLE IF EXISTS `embryo_level`;
    255. 

  255. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    256. 

  256. /*!50503 SET character_set_client = utf8mb4 */;
    257. 

  257. CREATE TABLE `embryo_level` (
    258. 

  258.   `id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增id',
    259. 

  259.   `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '级别名称',
    260. 

  260.   `min` int NOT NULL COMMENT '最小',
    261. 

  261.   `max` int NOT NULL COMMENT '最大',
    262. 

  262.   `state` int NOT NULL COMMENT '状态 0 禁用 1 启用',
    263. 

  263.   `info` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '备注',
    264. 

  264.   `create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '创建人',
    265. 

  265.   `create_time` datetime NOT NULL COMMENT '创建时间',
    266. 

  266.   `update_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '修改人',
    267. 

  267.   `update_time` datetime NOT NULL COMMENT '修改时间',
    268. 

  268.   `deleted` timestamp NOT NULL COMMENT '已删除: 操作时间戳',
    269. 

  269.   `platform_id` int DEFAULT NULL COMMENT '终端id',
    270. 

  270.   PRIMARY KEY (`id`) USING BTREE
    271. 

  271. ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;
    272. 

  272. /*!40101 SET character_set_client = @saved_cs_client */;
    273. 

  273. 

  274. --
    275. 

  275. -- Dumping data for table `embryo_level`
    276. 

  276. --
    277. 

  277. 

  278. LOCK TABLES `embryo_level` WRITE;
    279. 

  279. /*!40000 ALTER TABLE `embryo_level` DISABLE KEYS */;
    280. 

  280. 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);
    281. 

  281. /*!40000 ALTER TABLE `embryo_level` ENABLE KEYS */;
    282. 

  282. UNLOCK TABLES;
    283. 

  283. 

  284. --
    285. 

  285. -- Table structure for table `embryo_mark`
    286. 

  286. --
    287. 

  287. 

  288. DROP TABLE IF EXISTS `embryo_mark`;
    289. 

  289. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    290. 

  290. /*!50503 SET character_set_client = utf8mb4 */;
    291. 

  291. CREATE TABLE `embryo_mark` (
    292. 

  292.   `id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增id',
    293. 

  293.   `parent_id` bigint NOT NULL COMMENT '上级标记id',
    294. 

  294.   `tl_sn` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'tl设备编号',
    295. 

  295.   `house_sn` int NOT NULL COMMENT '仓室编号:1-11(11号仓室为缓冲瓶)',
    296. 

  296.   `embryo_culture_record_id` bigint NOT NULL COMMENT '培养记录id',
    297. 

  297.   `embryo_id` bigint NOT NULL COMMENT '胚胎id',
    298. 

  298.   `well_sn` int NOT NULL COMMENT 'well编号：1-16',
    299. 

  299.   `state` int NOT NULL COMMENT '当前阶段此次标记状态:0弃用 1启用',
    300. 

  300.   `image_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '标记图片地址',
    301. 

  301.   `develop_time` int DEFAULT NULL COMMENT '发育时间',
    302. 

  302.   `picture_time` datetime DEFAULT NULL COMMENT '图片时间',
    303. 

  303.   `picture_layer` int DEFAULT NULL COMMENT '图层',
    304. 

  304.   `picture_uuid` bigint DEFAULT NULL COMMENT '图片uuid',
    305. 

  305.   `mark_id` bigint NOT NULL COMMENT '标记id',
    306. 

  306.   `mark_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '标记key',
    307. 

  307.   `mark_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '标记阶段名',
    308. 

  308.   `child` int NOT NULL COMMENT '是否有子节点: 0无 1有(区分叶子节点)',
    309. 

  309.   `mark_type` int DEFAULT NULL COMMENT '标记类型：1 人工 2 ai',
    310. 

  310.   `batch_number` bigint NOT NULL COMMENT '批次号 - 根节点id',
    311. 

  311.   `create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '创建人',
    312. 

  312.   `create_time` datetime NOT NULL COMMENT '创建时间',
    313. 

  313.   `update_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '修改人',
    314. 

  314.   `update_time` datetime NOT NULL COMMENT '修改时间',
    315. 

  315.   `deleted` timestamp NOT NULL COMMENT '已删除: 操作时间戳',
    316. 

  316.   `platform_id` int DEFAULT NULL COMMENT '操作端',
    317. 

  317.   `score` decimal(5,2) DEFAULT '-1.00' COMMENT '阶段得分',
    318. 

  318.   PRIMARY KEY (`id`) USING BTREE
    319. 

  319. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='胚胎标记表';
    320. 

  320. /*!40101 SET character_set_client = @saved_cs_client */;
    321. 

  321. 

  322. --
    323. 

  323. -- Dumping data for table `embryo_mark`
    324. 

  324. --
    325. 

  325. 

  326. LOCK TABLES `embryo_mark` WRITE;
    327. 

  327. /*!40000 ALTER TABLE `embryo_mark` DISABLE KEYS */;
    328. 

  328. /*!40000 ALTER TABLE `embryo_mark` ENABLE KEYS */;
    329. 

  329. UNLOCK TABLES;
    330. 

  330. 

  331. --
    332. 

  332. -- Table structure for table `embryo_mark_splice`
    333. 

  333. --
    334. 

  334. 

  335. DROP TABLE IF EXISTS `embryo_mark_splice`;
    336. 

  336. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    337. 

  337. /*!50503 SET character_set_client = utf8mb4 */;
    338. 

  338. CREATE TABLE `embryo_mark_splice` (
    339. 

  339.   `id` bigint NOT NULL AUTO_INCREMENT COMMENT ' ',
    340. 

  340.   `tl_sn` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'tl设备编号',
    341. 

  341.   `house_sn` int NOT NULL COMMENT '仓室编号:1-11(11号仓室为缓冲瓶)',
    342. 

  342.   `embryo_culture_record_id` bigint NOT NULL COMMENT '培养记录id',
    343. 

  343.   `embryo_id` bigint NOT NULL COMMENT '胚胎id',
    344. 

  344.   `well_sn` int NOT NULL COMMENT 'well编号：1-16',
    345. 

  345.   `stage` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
    346. 

  346.   `appear_time` int DEFAULT NULL COMMENT '出现时间',
    347. 

  347.   `disappearance_time` int DEFAULT NULL COMMENT '消失时间',
    348. 

  348.   `stage_processed_status` int DEFAULT NULL COMMENT '当前阶段此次标记状态:0 跳过 1 处理中 2 处理完成',
    349. 

  349.   `state` int DEFAULT NULL COMMENT '1 启用 0 禁用',
    350. 

  350.   `config_prob` decimal(10,4) DEFAULT NULL COMMENT '和配置时间段重合度',
    351. 

  351.   `properties` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '发育阶段详细指标',
    352. 

  352.   `picture_uuid` bigint DEFAULT NULL COMMENT '关联使用时使用',
    353. 

  353.   `image_time` datetime DEFAULT NULL COMMENT '设备返回的拍摄时间',
    354. 

  354.   `picture_layer` int DEFAULT NULL COMMENT '图片层',
    355. 

  355.   `image_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '抠图url',
    356. 

  356.   `compute_model` int DEFAULT NULL COMMENT '计算类型',
    357. 

  357.   `create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '创建人',
    358. 

  358.   `create_time` datetime NOT NULL COMMENT '创建时间',
    359. 

  359.   `update_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '修改人',
    360. 

  360.   `update_time` datetime NOT NULL COMMENT '修改时间',
    361. 

  361.   `deleted` timestamp NOT NULL COMMENT '已删除: 操作时间戳',
    362. 

  362.   `platform_id` int DEFAULT NULL COMMENT '操作端',
    363. 

  363.   PRIMARY KEY (`id`) USING BTREE
    364. 

  364. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='胚胎标记表';
    365. 

  365. /*!40101 SET character_set_client = @saved_cs_client */;
    366. 

  366. 

  367. --
    368. 

  368. -- Dumping data for table `embryo_mark_splice`
    369. 

  369. --
    370. 

  370. 

  371. LOCK TABLES `embryo_mark_splice` WRITE;
    372. 

  372. /*!40000 ALTER TABLE `embryo_mark_splice` DISABLE KEYS */;
    373. 

  373. /*!40000 ALTER TABLE `embryo_mark_splice` ENABLE KEYS */;
    374. 

  374. UNLOCK TABLES;
    375. 

  375. 

  376. --
    377. 

  377. -- Table structure for table `identify_config`
    378. 

  378. --
    379. 

  379. 

  380. DROP TABLE IF EXISTS `identify_config`;
    381. 

  381. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    382. 

  382. /*!50503 SET character_set_client = utf8mb4 */;
    383. 

  383. CREATE TABLE `identify_config` (
    384. 

  384.   `id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增id',
    385. 

  385.   `identify_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '图片识别key',
    386. 

  386.   `min_time` int NOT NULL COMMENT '阶段最小时间',
    387. 

  387.   `max_time` int NOT NULL COMMENT '阶段最大时间',
    388. 

  388.   `continue_time` int DEFAULT NULL COMMENT '持续时间',
    389. 

  389.   `appear_times` int DEFAULT NULL COMMENT '连续出现次数，认定阶段出现',
    390. 

  390.   `compute_model` int DEFAULT NULL COMMENT '计算模型',
    391. 

  391.   `order_num` int NOT NULL COMMENT '阶段出现顺序',
    392. 

  392.   `create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '创建人',
    393. 

  393.   `create_time` datetime NOT NULL COMMENT '创建时间',
    394. 

  394.   `update_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '修改人',
    395. 

  395.   `update_time` datetime NOT NULL COMMENT '修改时间',
    396. 

  396.   `deleted` timestamp NOT NULL COMMENT '已删除: 操作时间戳',
    397. 

  397.   `platform_id` int DEFAULT NULL COMMENT '终端id',
    398. 

  398.   PRIMARY KEY (`id`) USING BTREE
    399. 

  399. ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;
    400. 

  400. /*!40101 SET character_set_client = @saved_cs_client */;
    401. 

  401. 

  402. --
    403. 

  403. -- Dumping data for table `identify_config`
    404. 

  404. --
    405. 

  405. 

  406. LOCK TABLES `identify_config` WRITE;
    407. 

  407. /*!40000 ALTER TABLE `identify_config` DISABLE KEYS */;
    408. 

  408. 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);
    409. 

  409. /*!40000 ALTER TABLE `identify_config` ENABLE KEYS */;
    410. 

  410. UNLOCK TABLES;
    411. 

  411. 

  412. --
    413. 

  413. -- Table structure for table `log`
    414. 

  414. --
    415. 

  415. 

  416. DROP TABLE IF EXISTS `log`;
    417. 

  417. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    418. 

  418. /*!50503 SET character_set_client = utf8mb4 */;
    419. 

  419. CREATE TABLE `log` (
    420. 

  420.   `id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增id',
    421. 

  421.   `tl_id` bigint NOT NULL COMMENT 'tl设备id',
    422. 

  422.   `tl_sn` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '设备编号',
    423. 

  423.   `house_id` bigint NOT NULL COMMENT '仓室id',
    424. 

  424.   `house_sn` int NOT NULL COMMENT '仓室编号:1-11(11号仓室为缓冲瓶)',
    425. 

  425.   `message` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '日志信息',
    426. 

  426.   `log_type` int DEFAULT NULL COMMENT '日志分类',
    427. 

  427.   `log_detail_type` int DEFAULT NULL COMMENT '日志详情分类',
    428. 

  428.   `create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '创建人',
    429. 

  429.   `create_time` datetime NOT NULL COMMENT '创建时间',
    430. 

  430.   `update_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '修改人',
    431. 

  431.   `update_time` datetime NOT NULL COMMENT '修改时间',
    432. 

  432.   `deleted` timestamp NOT NULL COMMENT '已删除: 操作时间戳',
    433. 

  433.   `platform_id` int DEFAULT NULL COMMENT '终端id',
    434. 

  434.   PRIMARY KEY (`id`) USING BTREE
    435. 

  435. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='日志表';
    436. 

  436. /*!40101 SET character_set_client = @saved_cs_client */;
    437. 

  437. 

  438. --
    439. 

  439. -- Dumping data for table `log`
    440. 

  440. --
    441. 

  441. 

  442. LOCK TABLES `log` WRITE;
    443. 

  443. /*!40000 ALTER TABLE `log` DISABLE KEYS */;
    444. 

  444. /*!40000 ALTER TABLE `log` ENABLE KEYS */;
    445. 

  445. UNLOCK TABLES;
    446. 

  446. 

  447. --
    448. 

  448. -- Table structure for table `mark`
    449. 

  449. --
    450. 

  450. 

  451. DROP TABLE IF EXISTS `mark`;
    452. 

  452. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    453. 

  453. /*!50503 SET character_set_client = utf8mb4 */;
    454. 

  454. CREATE TABLE `mark` (
    455. 

  455.   `id` bigint NOT NULL AUTO_INCREMENT,
    456. 

  456.   `parent_id` bigint NOT NULL COMMENT '上级id',
    457. 

  457.   `stage` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '所属阶段key值',
    458. 

  458.   `key_id` bigint DEFAULT NULL COMMENT '发育阶段key_id',
    459. 

  459.   `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '发育阶段名',
    460. 

  460.   `order_num` int NOT NULL COMMENT '序号',
    461. 

  461.   `level` int DEFAULT NULL COMMENT '级别，从1开始',
    462. 

  462.   `weight` decimal(10,3) NOT NULL COMMENT '权重',
    463. 

  463.   `unit` int NOT NULL COMMENT '单位: 1分 2百分比',
    464. 

  464.   `mark_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '标记key值，编号',
    465. 

  465.   `key_node` int NOT NULL COMMENT '发育关键节点 0 否 1 是',
    466. 

  466.   `identify_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT 'AI_key',
    467. 

  467.   `identify_key_node` int DEFAULT NULL COMMENT 'Ai_key关键节点 0 否 1 是 2 关联关键节点',
    468. 

  468.   `state` int NOT NULL COMMENT '状态: 0禁用 1启用',
    469. 

  469.   `child` int NOT NULL COMMENT '是否有子节点: 0无 1有(区分叶子节点)',
    470. 

  470.   `model` bigint DEFAULT NULL COMMENT '所属模型',
    471. 

  471.   `min_time` int DEFAULT NULL COMMENT '最小时长 - 删 - 9/25模型启用',
    472. 

  472.   `max_time` int DEFAULT NULL COMMENT '最大时长 - 删 - 9/25模型启用',
    473. 

  473.   `default_value` int NOT NULL COMMENT '默认值 0 不是 1是（叶子节点）/计算分数 0 否 1是（模型）',
    474. 

  474.   `create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '创建人',
    475. 

  475.   `create_time` datetime NOT NULL COMMENT '创建时间',
    476. 

  476.   `update_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '修改人',
    477. 

  477.   `update_time` datetime NOT NULL COMMENT '修改时间',
    478. 

  478.   `deleted` timestamp NOT NULL COMMENT '已删除: 操作时间戳',
    479. 

  479.   `platform_id` int DEFAULT NULL COMMENT '操作终端',
    480. 

  480.   `region` int NOT NULL DEFAULT '1' COMMENT '地区1.中文2.英文',
    481. 

  481.   PRIMARY KEY (`id`) USING BTREE
    482. 

  482. ) ENGINE=InnoDB AUTO_INCREMENT=206 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='标记评分设置表';
    483. 

  483. /*!40101 SET character_set_client = @saved_cs_client */;
    484. 

  484. 

  485. --
    486. 

  486. -- Dumping data for table `mark`
    487. 

  487. --
    488. 

  488. 

  489. LOCK TABLES `mark` WRITE;
    490. 

  490. /*!40000 ALTER TABLE `mark` DISABLE KEYS */;
    491. 

  491. 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);
    492. 

  492. /*!40000 ALTER TABLE `mark` ENABLE KEYS */;
    493. 

  493. UNLOCK TABLES;
    494. 

  494. 

  495. --
    496. 

  496. -- Table structure for table `mark_key`
    497. 

  497. --
    498. 

  498. 

  499. DROP TABLE IF EXISTS `mark_key`;
    500. 

  500. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    501. 

  501. /*!50503 SET character_set_client = utf8mb4 */;
    502. 

  502. CREATE TABLE `mark_key` (
    503. 

  503.   `id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增id',
    504. 

  504.   `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '名称',
    505. 

  505.   `mark_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'key值（唯一）',
    506. 

  506.   `identfy_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT 'AI_key',
    507. 

  507.   `state` int NOT NULL COMMENT '状态 0 禁用 1 启用',
    508. 

  508.   `order_num` int DEFAULT NULL COMMENT '序号 - 备用',
    509. 

  509.   `info` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '备注',
    510. 

  510.   `create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '创建人',
    511. 

  511.   `create_time` datetime NOT NULL COMMENT '创建时间',
    512. 

  512.   `update_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '修改人',
    513. 

  513.   `update_time` datetime NOT NULL COMMENT '修改时间',
    514. 

  514.   `deleted` timestamp NOT NULL COMMENT '已删除: 操作时间戳',
    515. 

  515.   `platform_id` int DEFAULT NULL COMMENT '终端id',
    516. 

  516.   `region` int NOT NULL DEFAULT '1' COMMENT '地区1.中文2.英文',
    517. 

  517.   PRIMARY KEY (`id`) USING BTREE
    518. 

  518. ) ENGINE=InnoDB AUTO_INCREMENT=156 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;
    519. 

  519. /*!40101 SET character_set_client = @saved_cs_client */;
    520. 

  520. 

  521. --
    522. 

  522. -- Dumping data for table `mark_key`
    523. 

  523. --
    524. 

  524. 

  525. LOCK TABLES `mark_key` WRITE;
    526. 

  526. /*!40000 ALTER TABLE `mark_key` DISABLE KEYS */;
    527. 

  527. 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);
    528. 

  528. /*!40000 ALTER TABLE `mark_key` ENABLE KEYS */;
    529. 

  529. UNLOCK TABLES;
    530. 

  530. 

  531. --
    532. 

  532. -- Table structure for table `mark_weight`
    533. 

  533. --
    534. 

  534. 

  535. DROP TABLE IF EXISTS `mark_weight`;
    536. 

  536. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    537. 

  537. /*!50503 SET character_set_client = utf8mb4 */;
    538. 

  538. CREATE TABLE `mark_weight` (
    539. 

  539.   `id` bigint NOT NULL AUTO_INCREMENT,
    540. 

  540.   `parent_id` bigint NOT NULL DEFAULT '-1' COMMENT '上级id，无上级默认-1',
    541. 

  541.   `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '名称',
    542. 

  542.   `mark_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '标记key值',
    543. 

  543.   `weight` decimal(10,3) NOT NULL COMMENT '权重',
    544. 

  544.   `order_num` int NOT NULL COMMENT '排序顺序',
    545. 

  545.   `create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '创建人',
    546. 

  546.   `create_time` datetime NOT NULL COMMENT '创建时间',
    547. 

  547.   `update_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '修改人',
    548. 

  548.   `update_time` datetime NOT NULL COMMENT '修改时间',
    549. 

  549.   `deleted` timestamp NOT NULL COMMENT '已删除: 操作时间戳',
    550. 

  550.   `platform_id` int DEFAULT NULL COMMENT '操作终端',
    551. 

  551.   `region` int NOT NULL DEFAULT '1' COMMENT '地区1.中文2.英文',
    552. 

  552.   PRIMARY KEY (`id`) USING BTREE
    553. 

  553. ) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='标记评分设置表';
    554. 

  554. /*!40101 SET character_set_client = @saved_cs_client */;
    555. 

  555. 

  556. --
    557. 

  557. -- Dumping data for table `mark_weight`
    558. 

  558. --
    559. 

  559. 

  560. LOCK TABLES `mark_weight` WRITE;
    561. 

  561. /*!40000 ALTER TABLE `mark_weight` DISABLE KEYS */;
    562. 

  562. 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);
    563. 

  563. /*!40000 ALTER TABLE `mark_weight` ENABLE KEYS */;
    564. 

  564. UNLOCK TABLES;
    565. 

  565. 

  566. --
    567. 

  567. -- Table structure for table `message`
    568. 

  568. --
    569. 

  569. 

  570. DROP TABLE IF EXISTS `message`;
    571. 

  571. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    572. 

  572. /*!50503 SET character_set_client = utf8mb4 */;
    573. 

  573. CREATE TABLE `message` (
    574. 

  574.   `id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增主键',
    575. 

  575.   `alarm_id` bigint NOT NULL COMMENT '告警记录id',
    576. 

  576.   `alarm_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '告警类型key',
    577. 

  577.   `tl_sn` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'tl设备编号',
    578. 

  578.   `house_sn` int DEFAULT NULL COMMENT '仓室编号:1-11(11号仓室为缓冲瓶)',
    579. 

  579.   `well_sn` int DEFAULT NULL COMMENT 'well编号',
    580. 

  580.   `account` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '用户账号',
    581. 

  581.   `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '消息标题',
    582. 

  582.   `text` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '消息内容',
    583. 

  583.   `text_detail` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '消息详情',
    584. 

  584.   `read_status` int NOT NULL COMMENT '消息状态：0 未读 1 已读',
    585. 

  585.   `read_time` datetime DEFAULT NULL COMMENT '读取时间',
    586. 

  586.   `type` int NOT NULL COMMENT '是否完成： 0正在报警  1结束报警',
    587. 

  587.   `start_time` datetime NOT NULL COMMENT '开始时间',
    588. 

  588.   `end_time` datetime DEFAULT NULL COMMENT '结束时间',
    589. 

  589.   `continue_time` int DEFAULT NULL COMMENT '持续时间 / s',
    590. 

  590.   `create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '创建人',
    591. 

  591.   `create_time` datetime NOT NULL COMMENT '创建时间',
    592. 

  592.   `update_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '修改人',
    593. 

  593.   `update_time` datetime NOT NULL COMMENT '修改时间',
    594. 

  594.   `deleted` timestamp NOT NULL COMMENT '已删除: 操作时间戳',
    595. 

  595.   `platform_id` int DEFAULT NULL COMMENT '操作终端',
    596. 

  596.   PRIMARY KEY (`id`) USING BTREE
    597. 

  597. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;
    598. 

  598. /*!40101 SET character_set_client = @saved_cs_client */;
    599. 

  599. 

  600. --
    601. 

  601. -- Dumping data for table `message`
    602. 

  602. --
    603. 

  603. 

  604. LOCK TABLES `message` WRITE;
    605. 

  605. /*!40000 ALTER TABLE `message` DISABLE KEYS */;
    606. 

  606. /*!40000 ALTER TABLE `message` ENABLE KEYS */;
    607. 

  607. UNLOCK TABLES;
    608. 

  608. 

  609. --
    610. 

  610. -- Table structure for table `photo_search_button`
    611. 

  611. --
    612. 

  612. 

  613. DROP TABLE IF EXISTS `photo_search_button`;
    614. 

  614. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    615. 

  615. /*!50503 SET character_set_client = utf8mb4 */;
    616. 

  616. CREATE TABLE `photo_search_button` (
    617. 

  617.   `id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增id',
    618. 

  618.   `button_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '按钮名',
    619. 

  619.   `min_hour` int NOT NULL COMMENT '按钮最小时间',
    620. 

  620.   `max_hour` int NOT NULL COMMENT '按钮最大时间',
    621. 

  621.   `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',
    622. 

  622.   `state` int NOT NULL COMMENT '按钮状态:0禁用 1启用',
    623. 

  623.   `order_num` int NOT NULL COMMENT '序号',
    624. 

  624.   `create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '创建人',
    625. 

  625.   `create_time` datetime NOT NULL COMMENT '创建时间',
    626. 

  626.   `update_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '修改人',
    627. 

  627.   `update_time` datetime NOT NULL COMMENT '修改时间',
    628. 

  628.   `deleted` timestamp NOT NULL COMMENT '已删除: 操作时间戳',
    629. 

  629.   `platform_id` int DEFAULT NULL COMMENT '操作终端',
    630. 

  630.   `region` int NOT NULL DEFAULT '1' COMMENT '地区1.中文2.英文',
    631. 

  631.   PRIMARY KEY (`id`) USING BTREE
    632. 

  632. ) ENGINE=InnoDB AUTO_INCREMENT=63 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='图片快速检索按钮设置表： 配置关键节点和普通节点时间段';
    633. 

  633. /*!40101 SET character_set_client = @saved_cs_client */;
    634. 

  634. 

  635. --
    636. 

  636. -- Dumping data for table `photo_search_button`
    637. 

  637. --
    638. 

  638. 

  639. LOCK TABLES `photo_search_button` WRITE;
    640. 

  640. /*!40000 ALTER TABLE `photo_search_button` DISABLE KEYS */;
    641. 

  641. 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);
    642. 

  642. /*!40000 ALTER TABLE `photo_search_button` ENABLE KEYS */;
    643. 

  643. UNLOCK TABLES;
    644. 

  644. 

  645. --
    646. 

  646. -- Table structure for table `picture`
    647. 

  647. --
    648. 

  648. 

  649. DROP TABLE IF EXISTS `picture`;
    650. 

  650. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    651. 

  651. /*!50503 SET character_set_client = utf8mb4 */;
    652. 

  652. CREATE TABLE `picture` (
    653. 

  653.   `id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增id',
    654. 

  654.   `picture_uuid` bigint NOT NULL COMMENT '关联使用时使用',
    655. 

  655.   `tl_sn` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'tl设备编号',
    656. 

  656.   `house_sn` int NOT NULL COMMENT '仓室编号:1-11(11号仓室为缓冲瓶)',
    657. 

  657.   `well_sn` int NOT NULL COMMENT 'well编号 1-16',
    658. 

  658.   `ccd_sn` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'ccd编号',
    659. 

  659.   `source_image_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '原图名字',
    660. 

  660.   `source_image_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '原图的本地路径(不是上传后的保存路径)',
    661. 

  661.   `source_image_width` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '原图宽',
    662. 

  662.   `source_image_height` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '原图高',
    663. 

  663.   `source_image_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '原图url',
    664. 

  664.   `image_time` datetime NOT NULL COMMENT '设备返回的拍摄时间',
    665. 

  665.   `photograph_type` int NOT NULL COMMENT '对焦还是ccd拍照 1对焦 0拍照',
    666. 

  666.   `total_layer` int NOT NULL COMMENT '拍照总层数',
    667. 

  667.   `picture_layer` int NOT NULL COMMENT '图片层',
    668. 

  668.   `shooting_position` int NOT NULL COMMENT '垂直电机位置',
    669. 

  669.   `image_score` decimal(10,3) DEFAULT NULL COMMENT '图片分数(如果是对焦才有值) ',
    670. 

  670.   `clearest` int DEFAULT NULL COMMENT '是否是最清晰的(CCD拍照才有)0不是 1最清晰 ',
    671. 

  671.   `the_end` int NOT NULL COMMENT '拍照结束标记1 结束 0 未结束 (结束后开始更新对焦起点,ccd拍照结束开始合成视频)',
    672. 

  672.   `image_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '抠图图片名',
    673. 

  673.   `image_height` int NOT NULL COMMENT '裁剪高',
    674. 

  674.   `image_width` int NOT NULL COMMENT '裁剪宽',
    675. 

  675.   `image_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '抠图url',
    676. 

  676.   `radius` int DEFAULT NULL COMMENT '识别圆的半径',
    677. 

  677.   `crop_state` int NOT NULL COMMENT '抠图是否成功 0 未裁剪 1 成功 -1 失败',
    678. 

  678.   `embryo_culture_record_id` bigint NOT NULL COMMENT '培养记录id',
    679. 

  679.   `embryo_id` bigint NOT NULL COMMENT '胚胎id',
    680. 

  680.   `batch_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '拍照批次号',
    681. 

  681.   `horizontal_position` int DEFAULT NULL COMMENT '水平电机位置',
    682. 

  682.   `fertilization_time` datetime DEFAULT NULL COMMENT '受精时间',
    683. 

  683.   `develop_time` int NOT NULL COMMENT '发育时长/分钟\r\n自动对焦是0',
    684. 

  684.   `create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '创建人',
    685. 

  685.   `create_time` datetime NOT NULL COMMENT '创建时间',
    686. 

  686.   `update_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '修改人',
    687. 

  687.   `update_time` datetime NOT NULL COMMENT '修改时间',
    688. 

  688.   `deleted` timestamp NOT NULL COMMENT '已删除: 操作时间戳',
    689. 

  689.   `platform_id` int unsigned DEFAULT NULL COMMENT '操作终端',
    690. 

  690.   `use_time` bigint DEFAULT '0' COMMENT '抠图消耗的时间单位ms',
    691. 

  691.   PRIMARY KEY (`id`) USING BTREE,
    692. 

  692.   KEY `picture_uuid` (`picture_uuid`) USING BTREE,
    693. 

  693.   KEY `tl_sn` (`tl_sn`,`house_sn`,`well_sn`) USING BTREE,
    694. 

  694.   KEY `create_time` (`create_time`) USING BTREE,
    695. 

  695.   KEY `update_time` (`update_time`) USING BTREE,
    696. 

  696.   KEY `picture_layer` (`picture_layer`) USING BTREE,
    697. 

  697.   KEY `photograph_type` (`photograph_type`) USING BTREE,
    698. 

  698.   KEY `embryo_id` (`embryo_id`,`photograph_type`,`picture_layer`,`crop_state`) USING BTREE COMMENT 'well级别查询抠图成功的图片',
    699. 

  699.   KEY `embryo_culture_record_id` (`embryo_id`,`clearest`,`crop_state`,`develop_time`) USING BTREE COMMENT '仓室级别查询最清晰图片'
    700. 

  700. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='ccd拍照图片留存表：记录CCD拍照和自动对焦原图以及抠图相关信息';
    701. 

  701. /*!40101 SET character_set_client = @saved_cs_client */;
    702. 

  702. 

  703. --
    704. 

  704. -- Dumping data for table `picture`
    705. 

  705. --
    706. 

  706. 

  707. LOCK TABLES `picture` WRITE;
    708. 

  708. /*!40000 ALTER TABLE `picture` DISABLE KEYS */;
    709. 

  709. /*!40000 ALTER TABLE `picture` ENABLE KEYS */;
    710. 

  710. UNLOCK TABLES;
    711. 

  711. 

  712. --
    713. 

  713. -- Table structure for table `picture_identify_middle`
    714. 

  714. --
    715. 

  715. 

  716. DROP TABLE IF EXISTS `picture_identify_middle`;
    717. 

  717. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    718. 

  718. /*!50503 SET character_set_client = utf8mb4 */;
    719. 

  719. CREATE TABLE `picture_identify_middle` (
    720. 

  720.   `id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增主键',
    721. 

  721.   `tl_sn` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'tl设备编号',
    722. 

  722.   `house_sn` int NOT NULL COMMENT '仓室编号',
    723. 

  723.   `state` int NOT NULL COMMENT '状态 0 移除 1 正常\r\n',
    724. 

  724.   `last_update_time` datetime NOT NULL COMMENT '最新识别结果跟新时间',
    725. 

  725.   `create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '创建人',
    726. 

  726.   `create_time` datetime NOT NULL COMMENT '创建时间',
    727. 

  727.   `update_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '修改人',
    728. 

  728.   `update_time` datetime NOT NULL COMMENT '修改时间',
    729. 

  729.   `deleted` timestamp NOT NULL COMMENT '已删除: 操作时间戳',
    730. 

  730.   `platform_id` int DEFAULT NULL COMMENT '终端id',
    731. 

  731.   PRIMARY KEY (`id`) USING BTREE
    732. 

  732. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;
    733. 

  733. /*!40101 SET character_set_client = @saved_cs_client */;
    734. 

  734. 

  735. --
    736. 

  736. -- Dumping data for table `picture_identify_middle`
    737. 

  737. --
    738. 

  738. 

  739. LOCK TABLES `picture_identify_middle` WRITE;
    740. 

  740. /*!40000 ALTER TABLE `picture_identify_middle` DISABLE KEYS */;
    741. 

  741. /*!40000 ALTER TABLE `picture_identify_middle` ENABLE KEYS */;
    742. 

  742. UNLOCK TABLES;
    743. 

  743. 

  744. --
    745. 

  745. -- Table structure for table `picture_identify_result`
    746. 

  746. --
    747. 

  747. 

  748. DROP TABLE IF EXISTS `picture_identify_result`;
    749. 

  749. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    750. 

  750. /*!50503 SET character_set_client = utf8mb4 */;
    751. 

  751. CREATE TABLE `picture_identify_result` (
    752. 

  752.   `id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增id',
    753. 

  753.   `picture_uuid` bigint NOT NULL COMMENT '关联使用时使用',
    754. 

  754.   `tl_sn` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'tl设备编号',
    755. 

  755.   `house_sn` int NOT NULL COMMENT '仓室编号:1-11(11号仓室为缓冲瓶)',
    756. 

  756.   `well_sn` int NOT NULL COMMENT 'well编号 1-16',
    757. 

  757.   `image_time` datetime NOT NULL COMMENT '设备返回的拍摄时间',
    758. 

  758.   `picture_layer` int NOT NULL COMMENT '图片层',
    759. 

  759.   `image_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '抠图url',
    760. 

  760.   `embryo_culture_record_id` bigint NOT NULL COMMENT '培养记录id',
    761. 

  761.   `embryo_id` bigint NOT NULL COMMENT '胚胎id',
    762. 

  762.   `develop_time` int NOT NULL COMMENT '发育时长/分钟\r\n',
    763. 

  763.   `stage` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '发育阶段',
    764. 

  764.   `stage_prob` decimal(10,4) DEFAULT NULL COMMENT '阶段可能性',
    765. 

  765.   `properties` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '发育阶段详细指标',
    766. 

  766.   `identify_state` int NOT NULL COMMENT '图片是被状态 0 未识别 1 识别成功 2 识别失败 3 已上传等待识别',
    767. 

  767.   `create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '创建人',
    768. 

  768.   `create_time` datetime NOT NULL COMMENT '创建时间',
    769. 

  769.   `update_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '修改人',
    770. 

  770.   `update_time` datetime NOT NULL COMMENT '修改时间',
    771. 

  771.   `deleted` timestamp NOT NULL COMMENT '已删除: 操作时间戳',
    772. 

  772.   `platform_id` int unsigned DEFAULT NULL COMMENT '操作终端',
    773. 

  773.   PRIMARY KEY (`id`) USING BTREE,
    774. 

  774.   KEY `picture_uuid` (`picture_uuid`) USING BTREE,
    775. 

  775.   KEY `tl_sn` (`tl_sn`,`house_sn`,`well_sn`) USING BTREE,
    776. 

  776.   KEY `create_time` (`create_time`) USING BTREE,
    777. 

  777.   KEY `update_time` (`update_time`) USING BTREE,
    778. 

  778.   KEY `picture_layer` (`picture_layer`) USING BTREE,
    779. 

  779.   KEY `embryo_id` (`embryo_id`) USING BTREE,
    780. 

  780.   KEY `embryo_culture_record_id` (`embryo_culture_record_id`,`develop_time`,`picture_layer`,`identify_state`) USING BTREE,
    781. 

  781.   KEY `identify_state` (`identify_state`) USING BTREE
    782. 

  782. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='图片识别结果信息表留存';
    783. 

  783. /*!40101 SET character_set_client = @saved_cs_client */;
    784. 

  784. 

  785. --
    786. 

  786. -- Dumping data for table `picture_identify_result`
    787. 

  787. --
    788. 

  788. 

  789. LOCK TABLES `picture_identify_result` WRITE;
    790. 

  790. /*!40000 ALTER TABLE `picture_identify_result` DISABLE KEYS */;
    791. 

  791. /*!40000 ALTER TABLE `picture_identify_result` ENABLE KEYS */;
    792. 

  792. UNLOCK TABLES;
    793. 

  793. 

  794. --
    795. 

  795. -- Table structure for table `picture_identify_result_cache`
    796. 

  796. --
    797. 

  797. 

  798. DROP TABLE IF EXISTS `picture_identify_result_cache`;
    799. 

  799. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    800. 

  800. /*!50503 SET character_set_client = utf8mb4 */;
    801. 

  801. CREATE TABLE `picture_identify_result_cache` (
    802. 

  802.   `id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增id',
    803. 

  803.   `picture_uuid` bigint NOT NULL COMMENT '关联使用时使用',
    804. 

  804.   `tl_sn` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'tl设备编号',
    805. 

  805.   `house_sn` int NOT NULL COMMENT '仓室编号:1-11(11号仓室为缓冲瓶)',
    806. 

  806.   `well_sn` int NOT NULL COMMENT 'well编号 1-16',
    807. 

  807.   `image_time` datetime NOT NULL COMMENT '设备返回的拍摄时间',
    808. 

  808.   `picture_layer` int NOT NULL COMMENT '图片层',
    809. 

  809.   `image_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '抠图url',
    810. 

  810.   `embryo_culture_record_id` bigint NOT NULL COMMENT '培养记录id',
    811. 

  811.   `embryo_id` bigint NOT NULL COMMENT '胚胎id',
    812. 

  812.   `develop_time` int NOT NULL COMMENT '发育时长/分钟\r\n',
    813. 

  813.   `stage` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '发育阶段',
    814. 

  814.   `stage_prob` decimal(10,4) NOT NULL COMMENT '阶段可能性',
    815. 

  815.   `properties` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '发育阶段详细指标',
    816. 

  816.   `identify_state` int NOT NULL COMMENT '数据处理是否成功 0 否 1是',
    817. 

  817.   `identify_time` datetime DEFAULT NULL COMMENT '识别时间',
    818. 

  818.   `mark_state` int DEFAULT NULL COMMENT '自动打标状态 0 未打标 1 打标完成',
    819. 

  819.   `create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '创建人',
    820. 

  820.   `create_time` datetime NOT NULL COMMENT '创建时间',
    821. 

  821.   `update_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '修改人',
    822. 

  822.   `update_time` datetime NOT NULL COMMENT '修改时间',
    823. 

  823.   `deleted` timestamp NOT NULL COMMENT '已删除: 操作时间戳',
    824. 

  824.   `platform_id` int unsigned DEFAULT NULL COMMENT '操作终端',
    825. 

  825.   PRIMARY KEY (`id`) USING BTREE,
    826. 

  826.   KEY `picture_uuid` (`picture_uuid`) USING BTREE,
    827. 

  827.   KEY `tl_sn` (`tl_sn`,`house_sn`,`well_sn`) USING BTREE,
    828. 

  828.   KEY `create_time` (`create_time`) USING BTREE,
    829. 

  829.   KEY `update_time` (`update_time`) USING BTREE,
    830. 

  830.   KEY `picture_layer` (`picture_layer`) USING BTREE,
    831. 

  831.   KEY `embryo_id` (`embryo_id`) USING BTREE,
    832. 

  832.   KEY `embryo_culture_record_id` (`embryo_culture_record_id`,`develop_time`,`picture_layer`,`identify_state`) USING BTREE,
    833. 

  833.   KEY `identify_state` (`identify_state`) USING BTREE
    834. 

  834. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='图片识别结果信息表留存';
    835. 

  835. /*!40101 SET character_set_client = @saved_cs_client */;
    836. 

  836. 

  837. --
    838. 

  838. -- Dumping data for table `picture_identify_result_cache`
    839. 

  839. --
    840. 

  840. 

  841. LOCK TABLES `picture_identify_result_cache` WRITE;
    842. 

  842. /*!40000 ALTER TABLE `picture_identify_result_cache` DISABLE KEYS */;
    843. 

  843. /*!40000 ALTER TABLE `picture_identify_result_cache` ENABLE KEYS */;
    844. 

  844. UNLOCK TABLES;
    845. 

  845. 

  846. --
    847. 

  847. -- Table structure for table `software_version`
    848. 

  848. --
    849. 

  849. 

  850. DROP TABLE IF EXISTS `software_version`;
    851. 

  851. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    852. 

  852. /*!50503 SET character_set_client = utf8mb4 */;
    853. 

  853. CREATE TABLE `software_version` (
    854. 

  854.   `id` bigint NOT NULL COMMENT '自增id',
    855. 

  855.   `release_version` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '发布版本',
    856. 

  856.   `run_version` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '运行版本',
    857. 

  857.   `version_log` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '运行版本log',
    858. 

  858.   `state` int NOT NULL COMMENT '状态 0禁用 1启用',
    859. 

  859.   `create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '创建人',
    860. 

  860.   `create_time` datetime NOT NULL COMMENT '创建时间',
    861. 

  861.   `update_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '修改人',
    862. 

  862.   `update_time` datetime NOT NULL COMMENT '修改时间',
    863. 

  863.   `deleted` timestamp NOT NULL COMMENT '已删除: 操作时间戳',
    864. 

  864.   `platform_id` int DEFAULT NULL COMMENT '终端id',
    865. 

  865.   PRIMARY KEY (`id`) USING BTREE
    866. 

  866. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;
    867. 

  867. /*!40101 SET character_set_client = @saved_cs_client */;
    868. 

  868. 

  869. --
    870. 

  870. -- Dumping data for table `software_version`
    871. 

  871. --
    872. 

  872. 

  873. LOCK TABLES `software_version` WRITE;
    874. 

  874. /*!40000 ALTER TABLE `software_version` DISABLE KEYS */;
    875. 

  875. 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);
    876. 

  876. /*!40000 ALTER TABLE `software_version` ENABLE KEYS */;
    877. 

  877. UNLOCK TABLES;
    878. 

  878. 

  879. --
    880. 

  880. -- Table structure for table `video`
    881. 

  881. --
    882. 

  882. 

  883. DROP TABLE IF EXISTS `video`;
    884. 

  884. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    885. 

  885. /*!50503 SET character_set_client = utf8mb4 */;
    886. 

  886. CREATE TABLE `video` (
    887. 

  887.   `id` bigint NOT NULL AUTO_INCREMENT,
    888. 

  888.   `tl_sn` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'tl设备编号',
    889. 

  889.   `house_sn` int NOT NULL COMMENT '仓室编号:1-11(11号仓室为缓冲瓶)',
    890. 

  890.   `embryo_culture_record_id` bigint NOT NULL COMMENT '培养记录id',
    891. 

  891.   `embryo_id` bigint NOT NULL COMMENT '胚胎id',
    892. 

  892.   `well_sn` int NOT NULL COMMENT 'well编号:1-16',
    893. 

  893.   `video_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '视频名',
    894. 

  894.   `video_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '视频地址',
    895. 

  895.   `picture_layer` int NOT NULL COMMENT '合成视频图层',
    896. 

  896.   `fps` int DEFAULT NULL COMMENT '视频帧率',
    897. 

  897.   `create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '创建人',
    898. 

  898.   `create_time` datetime NOT NULL COMMENT '创建时间',
    899. 

  899.   `update_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '修改人',
    900. 

  900.   `update_time` datetime NOT NULL COMMENT '修改时间',
    901. 

  901.   `deleted` timestamp NOT NULL COMMENT '已删除: 操作时间戳',
    902. 

  902.   `platform_id` int DEFAULT NULL COMMENT '操作终端',
    903. 

  903.   `picture_max_uuid` bigint DEFAULT NULL COMMENT '视频合成的最大图片uuid',
    904. 

  904.   PRIMARY KEY (`id`) USING BTREE,
    905. 

  905.   UNIQUE KEY `only_one` (`embryo_culture_record_id`,`embryo_id`,`deleted`,`picture_layer`) USING BTREE COMMENT '联合唯一主键'
    906. 

  906. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='合成视频表： 记录合成视频信息';
    907. 

  907. /*!40101 SET character_set_client = @saved_cs_client */;
    908. 

  908. 

  909. --
    910. 

  910. -- Dumping data for table `video`
    911. 

  911. --
    912. 

  912. 

  913. LOCK TABLES `video` WRITE;
    914. 

  914. /*!40000 ALTER TABLE `video` DISABLE KEYS */;
    915. 

  915. /*!40000 ALTER TABLE `video` ENABLE KEYS */;
    916. 

  916. UNLOCK TABLES;
    917. 

  917. 

  918. --
    919. 

  919. -- Table structure for table `video_pictures`
    920. 

  920. --
    921. 

  921. 

  922. DROP TABLE IF EXISTS `video_pictures`;
    923. 

  923. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    924. 

  924. /*!50503 SET character_set_client = utf8mb4 */;
    925. 

  925. CREATE TABLE `video_pictures` (
    926. 

  926.   `id` bigint NOT NULL AUTO_INCREMENT,
    927. 

  927.   `tl_sn` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'tl设备编号',
    928. 

  928.   `house_sn` int NOT NULL COMMENT '仓室编号:1-11(11号仓室为缓冲瓶)',
    929. 

  929.   `video_id` bigint DEFAULT NULL COMMENT '视频id',
    930. 

  930.   `picture_uuid` bigint DEFAULT NULL COMMENT '图片uuid',
    931. 

  931.   `image_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '图片服务端url',
    932. 

  932.   `image_time` datetime NOT NULL COMMENT '图片时间',
    933. 

  933.   `state` int NOT NULL COMMENT '合成视频状态 0 失败 1成功',
    934. 

  934.   `create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '创建人',
    935. 

  935.   `create_time` datetime NOT NULL COMMENT '创建时间',
    936. 

  936.   `update_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '修改人',
    937. 

  937.   `update_time` datetime NOT NULL COMMENT '修改时间',
    938. 

  938.   `deleted` timestamp NOT NULL COMMENT '已删除: 操作时间戳',
    939. 

  939.   `platform_id` int DEFAULT NULL COMMENT '操作终端',
    940. 

  940.   PRIMARY KEY (`id`) USING BTREE
    941. 

  941. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='合成视频图片表：记录各合成视频所使用的图片信息';
    942. 

  942. /*!40101 SET character_set_client = @saved_cs_client */;
    943. 

  943. 

  944. --
    945. 

  945. -- Dumping data for table `video_pictures`
    946. 

  946. --
    947. 

  947. 

  948. LOCK TABLES `video_pictures` WRITE;
    949. 

  949. /*!40000 ALTER TABLE `video_pictures` DISABLE KEYS */;
    950. 

  950. /*!40000 ALTER TABLE `video_pictures` ENABLE KEYS */;
    951. 

  951. UNLOCK TABLES;
    952. 

  952. 

  953. --
    954. 

  954. -- Table structure for table `video_splice`
    955. 

  955. --
    956. 

  956. 

  957. DROP TABLE IF EXISTS `video_splice`;
    958. 

  958. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    959. 

  959. /*!50503 SET character_set_client = utf8mb4 */;
    960. 

  960. CREATE TABLE `video_splice` (
    961. 

  961.   `id` bigint NOT NULL AUTO_INCREMENT,
    962. 

  962.   `video_id` bigint DEFAULT NULL COMMENT '培养记录id',
    963. 

  963.   `embryo_culture_record_id` bigint DEFAULT NULL COMMENT '需要合成视频的胚胎id',
    964. 

  964.   `embryo_id` bigint DEFAULT NULL COMMENT '需要合成视频的胚胎id',
    965. 

  965.   `create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '创建人',
    966. 

  966.   `create_time` datetime NOT NULL COMMENT '创建时间',
    967. 

  967.   `update_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '修改人',
    968. 

  968.   `update_time` datetime NOT NULL COMMENT '修改时间',
    969. 

  969.   `deleted` timestamp NOT NULL COMMENT '已删除: 操作时间戳',
    970. 

  970.   `platform_id` int DEFAULT NULL COMMENT '操作终端',
    971. 

  971.   PRIMARY KEY (`id`) USING BTREE
    972. 

  972. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='合成视频表： 记录合成视频信息';
    973. 

  973. /*!40101 SET character_set_client = @saved_cs_client */;
    974. 

  974. 

  975. --
    976. 

  976. -- Dumping data for table `video_splice`
    977. 

  977. --
    978. 

  978. 

  979. LOCK TABLES `video_splice` WRITE;
    980. 

  980. /*!40000 ALTER TABLE `video_splice` DISABLE KEYS */;
    981. 

  981. /*!40000 ALTER TABLE `video_splice` ENABLE KEYS */;
    982. 

  982. UNLOCK TABLES;
    983. 

  983. 

  984. --
    985. 

  985. -- Table structure for table `video_update`
    986. 

  986. --
    987. 

  987. 

  988. DROP TABLE IF EXISTS `video_update`;
    989. 

  989. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    990. 

  990. /*!50503 SET character_set_client = utf8mb4 */;
    991. 

  991. CREATE TABLE `video_update` (
    992. 

  992.   `id` bigint NOT NULL AUTO_INCREMENT,
    993. 

  993.   `video_id` bigint NOT NULL COMMENT '视频id',
    994. 

  994.   `video_local_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '视频的存储本地路径',
    995. 

  995.   `fps` int NOT NULL COMMENT '合成视频的fps',
    996. 

  996.   `picture_max_uuid` bigint NOT NULL COMMENT '合成视频的最大图片uuid',
    997. 

  997.   `update_state` int NOT NULL COMMENT '视频上传状态\r\n0 等待上传\r\n1 上传中',
    998. 

  998.   `create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '创建人',
    999. 

  999.   `create_time` datetime NOT NULL COMMENT '创建时间',
    1000. 

  1000.   `update_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '修改人',
    1001. 

  1001.   `update_time` datetime NOT NULL COMMENT '修改时间',
    1002. 

  1002.   `deleted` timestamp NOT NULL COMMENT '已删除: 操作时间戳',
    1003. 

  1003.   `platform_id` int DEFAULT NULL COMMENT '操作终端',
    1004. 

  1004.   PRIMARY KEY (`id`) USING BTREE
    1005. 

  1005. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;
    1006. 

  1006. /*!40101 SET character_set_client = @saved_cs_client */;
    1007. 

  1007. 

  1008. --
    1009. 

  1009. -- Dumping data for table `video_update`
    1010. 

  1010. --
    1011. 

  1011. 

  1012. LOCK TABLES `video_update` WRITE;
    1013. 

  1013. /*!40000 ALTER TABLE `video_update` DISABLE KEYS */;
    1014. 

  1014. /*!40000 ALTER TABLE `video_update` ENABLE KEYS */;
    1015. 

  1015. UNLOCK TABLES;
    1016. 

  1016. /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
    1017. 

  1017. 

  1018. /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
    1019. 

  1019. /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
    1020. 

  1020. /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
    1021. 

  1021. /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
    1022. 

  1022. 

  1023. -- Dump completed on 2026-06-17 14:50:31
    1024.