|
- -- MySQL dump 10.13 Distrib 5.7.30, for Linux (x86_64)
- --
- -- Host: localhost Database: pccb
- -- ------------------------------------------------------
- -- Server version 5.7.30-0ubuntu0.18.04.1
-
- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
- /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
- /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
- /*!40101 SET NAMES utf8 */;
- /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
- /*!40103 SET TIME_ZONE='+00:00' */;
- /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
- /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
- /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
- /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
-
- --
- -- Table structure for table `Sheet1`
- --
-
- DROP TABLE IF EXISTS `Sheet1`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `Sheet1` (
- `round` varchar(255) DEFAULT NULL,
- `Precision` varchar(255) DEFAULT NULL,
- `test1` varchar(255) DEFAULT NULL,
- `test2` varchar(255) DEFAULT NULL,
- `Recall` varchar(255) DEFAULT NULL,
- `test11` varchar(255) DEFAULT NULL,
- `test21` varchar(255) DEFAULT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
-
- --
- -- Dumping data for table `Sheet1`
- --
-
- LOCK TABLES `Sheet1` WRITE;
- /*!40000 ALTER TABLE `Sheet1` DISABLE KEYS */;
- INSERT INTO `Sheet1` VALUES ('1.0','0.312634','0.383651','0.281409','0.80964','0.56252','0.837095'),('2.0','0.346252','0.402194','0.32522','0.766558','0.584559','0.840131'),('3.0','0.348606','0.391772','0.329054','0.832529','0.602136','0.892691'),('4.0','0.410085','0.395537','0.406116','0.58473','0.302626','0.589813'),('5.0','0.359294','0.389802','0.344266','0.772388','0.691112','0.825187'),('6.0','0.381374','0.378884','0.407175','0.660895','0.693663','0.564886'),('7.0','0.345397','0.354899','0.343036','0.827573','0.77158','0.800138'),('8.0','0.378182','0.428028','0.332305','0.687104','0.487178','0.804741'),('9.0','0.376162','0.387459','0.370183','0.710414','0.653727','0.742667'),('10.0','0.372366','0.362924','0.397663','0.705084','0.685926','0.634867'),('11.0','0.576933','0.642427','0.558924','0.660364','0.466837','0.691508'),('12.0','0.63465','0.667317','0.612931','0.666364','0.654506','0.645994'),('13.0','0.569351','0.68608','0.42804','0.772683','0.620889','0.851709'),('14.0','0.633361','0.633399','0.659347','0.713193','0.722582','0.620621'),('15.0','0.558248','0.533175','0.567952','0.815239','0.78301','0.822483'),('16.0','0.634076','0.652324','0.589277','0.763869','0.727796','0.791262'),('17.0','0.647637','0.595953','0.673538','0.777446','0.814819','0.696813'),('18.0','0.603552','0.491018','0.644661','0.824934','0.873389','0.742245'),('19.0','0.686989','0.71518','0.63085','0.759436','0.648837','0.814542'),('20.0','0.648572','0.649417','0.644276','0.812581','0.780019','0.815661'),('21.0','0.690221','0.626581','0.745826','0.779663','0.81324','0.680757'),('22.0','0.728912','0.776642','0.688551','0.724232','0.672689','0.748187'),('23.0','0.642733','0.635966','0.651668','0.792112','0.790211','0.761642'),('24.0','0.723318','0.714464','0.691531','0.758149','0.741765','0.768767'),('25.0','0.679981','0.625617','0.683474','0.786222','0.836602','0.725019'),('26.0','0.696084','0.728015','0.660212','0.7438','0.694853','0.760787'),('27.0','0.692806','0.627323','0.729438','0.797283','0.838922','0.730009'),('28.0','0.635955','0.589165','0.687974','0.801351','0.812461','0.763635'),('29.0','0.727566','0.71882','0.712474','0.765642','0.773507','0.737236'),('30.0','0.735845','0.69531','0.762376','0.755427','0.762156','0.74662'),('31.0','0.742134','0.742746','0.745899','0.746484','0.756071','0.733071'),('32.0','0.747169','0.769699','0.718241','0.74024','0.695987','0.740812'),('33.0','0.665348','0.686579','0.622929','0.810315','0.808912','0.806035'),('34.0','0.664885','0.642088','0.691738','0.810337','0.804703','0.801839'),('35.0','0.786473','0.823414','0.740594','0.722998','0.602288','0.783373'),('36.0','0.728775','0.748983','0.666782','0.759967','0.738641','0.730726'),('37.0','0.782288','0.768631','0.790467','0.702358','0.673218','0.726236'),('38.0','0.731465','0.673241','0.773706','0.785015','0.831504','0.752867'),('39.0','0.727499','0.741434','0.712354','0.803133','0.774227','0.802816'),('40.0','0.773518','0.790599','0.72148','0.772801','0.70346','0.796102'),('41.0','0.758133','0.736694','0.78726','0.7686','0.789765','0.747229'),('42.0','0.740087','0.739335','0.741222','0.787786','0.797544','0.778473'),('43.0','0.726304','0.69005','0.77684','0.824883','0.850456','0.745664'),('44.0','0.748231','0.786235','0.699511','0.801643','0.738336','0.828887'),('45.0','0.716225','0.681868','0.717457','0.849766','0.835714','0.812775'),('46.0','0.720418','0.711559','0.710009','0.819218','0.832295','0.803489'),('47.0','0.742656','0.728518','0.738608','0.796693','0.80378','0.788677'),('48.0','0.732236','0.690471','0.764244','0.812954','0.837501','0.75481'),('49.0','0.764881','0.714452','0.770508','0.795606','0.804625','0.760213'),('50.0','0.785341','0.722081','0.824636','0.779872','0.811704','0.716749'),('51.0','0.762239','0.747138','0.77167','0.821926','0.80591','0.786593'),('52.0','0.810748','0.82172','0.781164','0.765435','0.710881','0.790673'),('53.0','0.753126','0.737909','0.723937','0.814463','0.797257','0.794141'),('54.0','0.776199','0.771348','0.768222','0.804954','0.779622','0.816552'),('55.0','0.732143','0.667627','0.768226','0.8251','0.848273','0.782598'),('56.0','0.810121','0.794533','0.8027','0.758988','0.751797','0.740616'),('57.0','0.760459','0.73395','0.78958','0.812833','0.852167','0.766136'),('58.0','0.718549','0.763352','0.652187','0.846319','0.786453','0.848109'),('59.0','0.780325','0.816033','0.73591','0.783096','0.714272','0.823968'),('60.0','0.778578','0.76533','0.791368','0.798708','0.800085','0.797836'),('61.0','0.802458','0.800957','0.810355','0.773605','0.753585','0.759303'),('62.0','0.818913','0.790002','0.842735','0.762729','0.773757','0.740881'),('63.0','0.742146','0.715564','0.76448','0.832316','0.865517','0.776375'),('64.0','0.756884','0.746847','0.749898','0.841001','0.82133','0.832844'),('65.0','0.792999','0.759578','0.830025','0.801742','0.807729','0.756946'),('66.0','0.831533','0.803152','0.854679','0.757635','0.780591','0.68808'),('67.0','0.76537','0.691575','0.820891','0.823148','0.867501','0.75917'),('68.0','0.797209','0.797829','0.800476','0.790704','0.802091','0.781647'),('69.0','0.779029','0.791846','0.759103','0.807602','0.775341','0.818063'),('70.0','0.756473','0.757615','0.744324','0.857945','0.834241','0.822361'),('71.0','0.796935','0.775393','0.820404','0.821714','0.820473','0.758617'),('72.0','0.835827','0.861941','0.801282','0.746963','0.685845','0.761953'),('73.0','0.781027','0.71973','0.825404','0.814604','0.852453','0.773296'),('74.0','0.8164','0.849948','0.781843','0.780341','0.72219','0.814998'),('75.0','0.7759','0.767779','0.770453','0.829838','0.84007','0.812293'),('76.0','0.85679','0.80951','0.884819','0.752186','0.774351','0.691906'),('77.0','0.822342','0.814056','0.808913','0.801921','0.753027','0.808751'),('78.0','0.819512','0.807647','0.834164','0.78494','0.792708','0.759777'),('79.0','0.764598','0.74476','0.762405','0.836852','0.83843','0.851255'),('80.0','0.777788','0.775086','0.758835','0.823909','0.819594','0.79002');
- /*!40000 ALTER TABLE `Sheet1` ENABLE KEYS */;
- UNLOCK TABLES;
-
- --
- -- Table structure for table `agent_docker_port`
- --
-
- DROP TABLE IF EXISTS `agent_docker_port`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `agent_docker_port` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `task_group_id` int(11) DEFAULT NULL,
- `port` varchar(45) DEFAULT NULL COMMENT 'Save the running port of AI agent and delete the entry when AI agent stop for task group.',
- `job_id` varchar(50) DEFAULT NULL,
- `pod_id` varchar(50) DEFAULT NULL,
- `pod_ip` varchar(30) DEFAULT NULL,
- `task_id` int(11) DEFAULT NULL,
- PRIMARY KEY (`id`),
- UNIQUE KEY `idx_agent_docker_port_task_group_id` (`task_group_id`, `task_id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
-
- --
- -- Dumping data for table `agent_docker_port`
- --
-
- LOCK TABLES `agent_docker_port` WRITE;
- /*!40000 ALTER TABLE `agent_docker_port` DISABLE KEYS */;
- INSERT INTO `agent_docker_port` VALUES (1,1,'50053'),(2,2,'50056');
- /*!40000 ALTER TABLE `agent_docker_port` ENABLE KEYS */;
- UNLOCK TABLES;
-
- --
- -- Table structure for table `algorithm`
- --
-
- DROP TABLE IF EXISTS `algorithm`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `algorithm` (
- `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'algorithm ID',
- `name` varchar(200) NOT NULL COMMENT 'Algorithm 名称',
- `version` varchar(20) DEFAULT NULL COMMENT 'version no.',
- `description` varchar(1024) DEFAULT NULL,
- `docker_path` varchar(1024) DEFAULT NULL COMMENT 'Docker path, Client Image for AI',
- `docker_agent_path` varchar(1024) DEFAULT NULL COMMENT 'Docker path, Agent Image for AI',
- `add_date` datetime DEFAULT NULL COMMENT '添加日期',
- `modify_date` datetime DEFAULT NULL COMMENT '修改日期',
- `users_id` int(11) DEFAULT NULL COMMENT 'Created by',
- `classification_id` int(11) DEFAULT NULL COMMENT '算法分类',
- `min_tasks` int(11) DEFAULT '2',
- `max_tasks` int(11) DEFAULT '2',
- `train_count` int(11) DEFAULT NULL COMMENT 'number of train round',
- PRIMARY KEY (`id`),
- KEY `algorithm_users_id_fk` (`users_id`),
- KEY `algorithm_classification_id_fk` (`classification_id`),
- CONSTRAINT `algorithm_classification_id_fk` FOREIGN KEY (`classification_id`) REFERENCES `classification` (`id`),
- CONSTRAINT `algorithm_users_id_fk` FOREIGN KEY (`users_id`) REFERENCES `users` (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
-
- --
- -- Dumping data for table `algorithm`
- --
-
- LOCK TABLES `algorithm` WRITE;
- /*!40000 ALTER TABLE `algorithm` DISABLE KEYS */;
- INSERT INTO `algorithm` VALUES (1,'肿瘤区域识别','1.1.0','','jcce-client:1.1','jcce-agent:1.1','2019-11-11 00:16:45','2019-11-11 00:16:45',6,2,2,2,80),(2,'PDL1定量','1.0.0',NULL,'jcce-client:1.1','jcce-agent:1.1','2019-12-23 12:50:32',NULL,NULL,NULL,2,2,100);
- /*!40000 ALTER TABLE `algorithm` ENABLE KEYS */;
- UNLOCK TABLES;
-
- --
- -- Table structure for table `chain_record`
- --
-
- DROP TABLE IF EXISTS `chain_record`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `chain_record` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `add_date` datetime DEFAULT NULL,
- `block` varchar(255) DEFAULT NULL,
- `hash` varchar(255) DEFAULT NULL,
- `value` varchar(255) DEFAULT NULL,
- `type` int(1) DEFAULT NULL COMMENT '1创建组、2添加/修改使用方、3添加/修改参与方、4修改任务',
- `task_group_id` int(11) DEFAULT NULL,
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
- /*!40101 SET character_set_client = @saved_cs_client */;
-
- --
- -- Dumping data for table `chain_record`
- --
-
- LOCK TABLES `chain_record` WRITE;
- /*!40000 ALTER TABLE `chain_record` DISABLE KEYS */;
- INSERT INTO `chain_record` VALUES (1,'2020-04-22 15:10:25','null','47e4536d80592997f1bcb483554dcd4eab560029587fa61ff30d194828a18c3f',NULL,1,1),(26,'2020-04-22 17:18:14','','d2a57be05885f17da11cd947894365fb15b9a7ee3f3f514d70fa32afa741b03e','',2,1);
- /*!40000 ALTER TABLE `chain_record` ENABLE KEYS */;
- UNLOCK TABLES;
-
- --
- -- Table structure for table `classification`
- --
-
- DROP TABLE IF EXISTS `classification`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `classification` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `name` varchar(200) DEFAULT NULL COMMENT 'classification name',
- `description` varchar(1024) DEFAULT NULL,
- `add_date` datetime DEFAULT NULL COMMENT '添加日期',
- `modify_date` datetime DEFAULT NULL COMMENT '修改日期',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
-
- --
- -- Dumping data for table `classification`
- --
-
- LOCK TABLES `classification` WRITE;
- /*!40000 ALTER TABLE `classification` DISABLE KEYS */;
- INSERT INTO `classification` VALUES (2,'图片','这是属于图片','2019-11-11 00:16:45','2019-11-11 00:16:45'),(3,'视频','这个属于视频','2019-11-11 23:51:17','2019-11-11 23:51:17'),(4,'文本','这个属于文本','2019-11-11 23:51:26','2019-11-11 23:51:26');
- /*!40000 ALTER TABLE `classification` ENABLE KEYS */;
- UNLOCK TABLES;
-
- --
- -- Table structure for table `dataset`
- --
-
- DROP TABLE IF EXISTS `dataset`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `dataset` (
- `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'dataset id',
- `name` varchar(200) NOT NULL COMMENT '数据集名称',
- `size` int(11) NOT NULL COMMENT '数据集大小',
- `classification_id` int(11) DEFAULT NULL COMMENT 'classification id',
- `path` varchar(1024) DEFAULT NULL COMMENT '数据集路径 (Should be network path in case of multiple machine need access)',
- `version` varchar(20) DEFAULT NULL COMMENT '版本',
- `add_date` datetime DEFAULT NULL COMMENT '添加日期',
- `modify_date` datetime DEFAULT NULL COMMENT '修改日期',
- `machine_groups_id` int(11) DEFAULT NULL COMMENT '机器编号',
- `machine_id` int(11) DEFAULT NULL,
- PRIMARY KEY (`id`),
- KEY `dataset_machine_groups_id_fk` (`machine_groups_id`),
- CONSTRAINT `dataset_machine_groups_id_fk` FOREIGN KEY (`machine_groups_id`) REFERENCES `machine_groups` (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
-
- --
- -- Dumping data for table `dataset`
- --
-
- LOCK TABLES `dataset` WRITE;
- /*!40000 ALTER TABLE `dataset` DISABLE KEYS */;
- INSERT INTO `dataset` VALUES (1,'HE肿瘤区域',560,2,'/root/xy/FederalAI/data/part1','v1.0','2019-12-23 19:53:49','2020-05-16 09:20:47',7,NULL),(2,'HE肿瘤区域',560,2,'/root/xy/FederalAI/data/part2','1.00','2019-12-23 12:03:25','2019-12-23 12:03:25',6,NULL),(3,'PDL1数据',600,2,'/root/xy/FederalAI/data/part1','v1.0','2019-12-23 12:52:49','2019-12-23 12:52:49',9,NULL),(4,'PDL1数据集',600,2,'/root/xy/FederalAI/data/part2','1.0.1','2019-12-23 12:53:03','2019-12-23 12:53:03',8,NULL),(5,'TEST',2223,2,'/data','0.1','2020-05-13 10:23:22','2020-05-13 10:23:22',7,NULL);
- /*!40000 ALTER TABLE `dataset` ENABLE KEYS */;
- UNLOCK TABLES;
-
- --
- -- Table structure for table `machine`
- --
-
- DROP TABLE IF EXISTS `machine`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `machine` (
- `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '机器编号',
- `name` varchar(200) NOT NULL COMMENT '机器名称',
- `cpu` int(11) DEFAULT NULL COMMENT 'CPU',
- `gpu` int(11) DEFAULT NULL COMMENT 'GPU',
- `ram` int(11) DEFAULT NULL COMMENT '内存',
- `capacity` int(11) DEFAULT NULL COMMENT 'Hard disk capacity',
- `ip_address` varchar(1024) DEFAULT NULL COMMENT 'list of IP地址 on machine',
- `add_date` datetime DEFAULT NULL COMMENT '添加日期',
- `modify_date` datetime DEFAULT NULL COMMENT '修改日期',
- `machine_groups_id` int(11) NOT NULL COMMENT 'machine group id',
- `online` int(11) DEFAULT NULL COMMENT '0: offline, 1: online',
- `machine_uuid` varchar(256) DEFAULT NULL COMMENT 'UUID',
- `public_ip` varchar(200) DEFAULT NULL COMMENT 'Public IP address',
- `port` varchar(200) DEFAULT NULL COMMENT 'Open port with public IP for Access from internet.',
- PRIMARY KEY (`id`),
- KEY `machine_machine_groups_id_fk` (`machine_groups_id`),
- CONSTRAINT `machine_machine_groups_id_fk` FOREIGN KEY (`machine_groups_id`) REFERENCES `machine_groups` (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
-
- --
- -- Dumping data for table `machine`
- --
-
- LOCK TABLES `machine` WRITE;
- /*!40000 ALTER TABLE `machine` DISABLE KEYS */;
- INSERT INTO `machine` VALUES (1,'协同服务器',16,0,251,142,'192.168.1.250,172.19.0.1,172.17.0.1','2019-12-23 11:49:33','2019-12-23 12:41:46',7,0,NULL,'127.0.0.1','50053'),(2,'GPU服务器',16,0,251,142,'192.168.1.250,172.19.0.1,172.17.0.1','2019-12-23 11:49:48','2019-12-23 12:41:48',6,0,NULL,'',''),(3,'GPU服务器',16,0,251,142,'192.168.1.250,172.19.0.1,172.17.0.1','2019-12-23 11:50:01','2019-12-23 12:41:49',7,0,NULL,'127.0.0.1',''),(4,'GPU服务器',16,0,251,142,'192.168.1.250,172.19.0.1,172.17.0.1','2019-12-23 12:41:38','2019-12-28 08:06:46',8,0,NULL,'',''),(5,'协同服务器',16,0,251,142,'192.168.1.250,172.19.0.1,172.17.0.1','2019-12-23 12:41:51','2019-12-28 08:06:56',9,0,NULL,'127.0.0.1','50056'),(6,'GPU服务器',16,0,251,142,'192.168.1.250,172.19.0.1,172.17.0.1','2019-12-23 12:42:04','2019-12-28 08:06:55',9,0,NULL,'127.0.0.1',''),(7,'demo',NULL,NULL,NULL,NULL,NULL,'2020-05-24 07:10:01','2020-05-22 16:31:26',7,0,NULL,'127.0.0.1','6060');
- /*!40000 ALTER TABLE `machine` ENABLE KEYS */;
- UNLOCK TABLES;
-
- --
- -- Table structure for table `machine_groups`
- --
-
- DROP TABLE IF EXISTS `machine_groups`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `machine_groups` (
- `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Machine Group ID',
- `name` varchar(200) NOT NULL,
- `organization_id` int(11) DEFAULT NULL COMMENT '组织编号',
- `created_by` int(11) DEFAULT NULL COMMENT 'User ID',
- `add_date` datetime DEFAULT NULL COMMENT '添加日期',
- `modify_date` datetime DEFAULT NULL COMMENT '修改日期',
- PRIMARY KEY (`id`),
- UNIQUE KEY `machine_groups_name_unique` (`created_by`,`name`),
- CONSTRAINT `machine_groups_users_id` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
-
- --
- -- Dumping data for table `machine_groups`
- --
-
- LOCK TABLES `machine_groups` WRITE;
- /*!40000 ALTER TABLE `machine_groups` DISABLE KEYS */;
- INSERT INTO `machine_groups` VALUES (6,'信息科机房',2,6,'2019-11-10 21:16:12','2019-11-10 21:16:12'),(7,'信息科机房',1,7,'2019-11-10 21:16:12','2019-11-10 21:16:12'),(8,'信息科机房',3,10,'2019-12-23 12:40:47',NULL),(9,'信息科机房',4,9,'2019-12-23 12:40:56',NULL);
- /*!40000 ALTER TABLE `machine_groups` ENABLE KEYS */;
- UNLOCK TABLES;
-
- --
- -- Table structure for table `model`
- --
-
- DROP TABLE IF EXISTS `model`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `model` (
- `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '型号编号',
- `name` varchar(200) NOT NULL COMMENT '型号名称',
- `version` varchar(20) DEFAULT NULL COMMENT 'version no.',
- `precision` float(8,6) DEFAULT NULL COMMENT 'status of model. ready for training model (0), trained model ready for using(1)',
- `published` int(11) DEFAULT NULL COMMENT 'Not Published(0), Published(1)',
- `description` varchar(1024) DEFAULT NULL,
- `add_date` datetime DEFAULT NULL COMMENT '添加日期',
- `modify_date` datetime DEFAULT NULL COMMENT '修改日期',
- `users_id` int(11) DEFAULT NULL COMMENT 'Created by',
- `classification_id` int(11) DEFAULT NULL COMMENT '算法分类',
- `task_id` int(11) DEFAULT NULL,
- `recall` float(5,2) DEFAULT NULL,
- `round` int(11) DEFAULT NULL,
- PRIMARY KEY (`id`),
- KEY `model_users_id_fk` (`users_id`),
- KEY `model_classification_id_fk` (`classification_id`),
- CONSTRAINT `model_classification_id_fk` FOREIGN KEY (`classification_id`) REFERENCES `classification` (`id`),
- CONSTRAINT `model_users_id_fk` FOREIGN KEY (`users_id`) REFERENCES `users` (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
-
- --
- -- Dumping data for table `model`
- --
-
- LOCK TABLES `model` WRITE;
- /*!40000 ALTER TABLE `model` DISABLE KEYS */;
- INSERT INTO `model` VALUES (3,'New Model','1.0',0.560000,NULL,NULL,'2019-11-12 15:10:33','2019-11-12 15:10:33',6,2,1,0.38,9),(4,'taskB_model','1.0',0.850000,NULL,NULL,'2019-11-12 15:10:33','2019-11-12 15:10:33',8,2,2,0.43,13),(5,'taskAAAAAA','2.0',0.890000,NULL,NULL,'2019-11-13 20:04:22','2019-11-13 20:04:22',6,2,2,0.33,3),(6,'test_publish','1.0.1',0.760213,NULL,NULL,'2019-11-13 20:52:18','2019-11-13 20:52:18',6,2,2,0.77,49);
- /*!40000 ALTER TABLE `model` ENABLE KEYS */;
- UNLOCK TABLES;
-
- --
- -- Table structure for table `model_use_record`
- --
-
- DROP TABLE IF EXISTS `model_use_record`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `model_use_record` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `model_id` int(11) NOT NULL,
- `user_id` int(11) NOT NULL,
- `score` float(5,2) DEFAULT NULL,
- `sample_size` int(11) DEFAULT NULL,
- `spend` decimal(10,2) DEFAULT NULL,
- PRIMARY KEY (`id`) USING BTREE,
- KEY `users_id_fk` (`user_id`) USING BTREE,
- KEY `model_id_fk` (`model_id`) USING BTREE,
- CONSTRAINT `users_id_fk` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
- /*!40101 SET character_set_client = @saved_cs_client */;
-
- --
- -- Dumping data for table `model_use_record`
- --
-
- LOCK TABLES `model_use_record` WRITE;
- /*!40000 ALTER TABLE `model_use_record` DISABLE KEYS */;
- INSERT INTO `model_use_record` VALUES (1,3,6,4.50,8,25.00);
- /*!40000 ALTER TABLE `model_use_record` ENABLE KEYS */;
- UNLOCK TABLES;
-
- --
- -- Table structure for table `organization`
- --
-
- DROP TABLE IF EXISTS `organization`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `organization` (
- `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '组织编号',
- `name` varchar(200) NOT NULL COMMENT '机构名称',
- `area` varchar(200) DEFAULT NULL COMMENT '区域',
- `join_date` datetime DEFAULT NULL COMMENT '参加日期',
- `modify_date` datetime DEFAULT NULL COMMENT '修改日期',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
-
- --
- -- Dumping data for table `organization`
- --
-
- LOCK TABLES `organization` WRITE;
- /*!40000 ALTER TABLE `organization` DISABLE KEYS */;
- INSERT INTO `organization` VALUES (1,'西安唐都医院','西安','2019-11-13 12:05:51','2019-11-13 12:05:53'),(2,'湘雅附二','长沙','2019-12-23 11:38:03',NULL),(3,'广州军区总医院','广州','2019-12-23 11:38:33',NULL),(4,'西安西京医院','西安','2019-11-12 02:01:01','2019-11-12 02:01:01');
- /*!40000 ALTER TABLE `organization` ENABLE KEYS */;
- UNLOCK TABLES;
-
- --
- -- Table structure for table `task_groups`
- --
-
- DROP TABLE IF EXISTS `task_groups`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `task_groups` (
- `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Task group id',
- `name` varchar(30) DEFAULT NULL COMMENT 'Name of task group',
- `algorithm_id` int(11) DEFAULT NULL COMMENT 'Algorithm id for current task group',
- `description` varchar(1024) DEFAULT NULL COMMENT 'Description for task group',
- `users_id` int(11) DEFAULT NULL,
- `status` int(11) DEFAULT NULL COMMENT '状态 Not defined(0), Ready(1) , Training(2), End(3), Error(-1)',
- `classification_id` int(11) DEFAULT NULL COMMENT 'classification',
- `task_count` int(11) DEFAULT NULL COMMENT 'tasks limit',
- `machine_id` int(11) DEFAULT NULL COMMENT 'Machine Id of the machine that will run agent container.',
- `dataset_id` int(11) DEFAULT NULL COMMENT 'data set id for task agent to test',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
-
- --
- -- Dumping data for table `task_groups`
- --
-
- LOCK TABLES `task_groups` WRITE;
- /*!40000 ALTER TABLE `task_groups` DISABLE KEYS */;
- INSERT INTO `task_groups` VALUES (1,'肿瘤区域识别',1,'识别肿瘤区域并分类',7,2,2,2,1),(2,'PDL1定量',2,'',9,2,2,2,5),(3,'图片训练',1,'',7,0,2,3,3);
- /*!40000 ALTER TABLE `task_groups` ENABLE KEYS */;
- UNLOCK TABLES;
-
- --
- -- Table structure for table `task_machines_map`
- --
-
- DROP TABLE IF EXISTS `task_machines_map`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `task_machines_map` (
- `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'task machine map ID',
- `task_id` int(11) DEFAULT NULL,
- `machine_id` int(11) DEFAULT NULL,
- PRIMARY KEY (`id`),
- KEY `task_machines_map_task_id_fk` (`task_id`),
- KEY `task_machines_map_machine_id_fk` (`machine_id`),
- CONSTRAINT `task_machines_map_machine_id_fk` FOREIGN KEY (`machine_id`) REFERENCES `machine` (`id`),
- CONSTRAINT `task_machines_map_task_id_fk` FOREIGN KEY (`task_id`) REFERENCES `tasks` (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
-
- --
- -- Dumping data for table `task_machines_map`
- --
-
- LOCK TABLES `task_machines_map` WRITE;
- /*!40000 ALTER TABLE `task_machines_map` DISABLE KEYS */;
- INSERT INTO `task_machines_map` VALUES (1,1,3),(2,2,2),(3,3,4),(4,4,6),(5,6,1);
- /*!40000 ALTER TABLE `task_machines_map` ENABLE KEYS */;
- UNLOCK TABLES;
-
- --
- -- Table structure for table `task_training_data`
- --
-
- DROP TABLE IF EXISTS `task_training_data`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `task_training_data` (
- `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'task training data ID',
- `recall` float(8,6) DEFAULT NULL COMMENT '进展',
- `precision` float(8,6) DEFAULT NULL COMMENT '精确',
- `round` int(11) DEFAULT NULL COMMENT 'Round No.',
- `start_time` datetime DEFAULT NULL,
- `end_time` datetime DEFAULT NULL,
- `task_id` int(11) DEFAULT '0' COMMENT '任务ID',
- `task_group_id` int(11) DEFAULT NULL COMMENT 'Task group id',
- PRIMARY KEY (`id`),
- KEY `task_training_data_tasks_id_fk_idx` (`task_id`),
- CONSTRAINT `task_training_data_tasks_id_fk` FOREIGN KEY (`task_id`) REFERENCES `tasks` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
- ) ENGINE=InnoDB AUTO_INCREMENT=577 DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
-
- --
- -- Dumping data for table `task_training_data`
- --
-
- LOCK TABLES `task_training_data` WRITE;
- /*!40000 ALTER TABLE `task_training_data` DISABLE KEYS */;
- INSERT INTO `task_training_data` VALUES (1,0.312634,0.809640,1,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,1),(2,0.346252,0.766558,2,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,1),(3,0.348606,0.832529,3,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,1),(4,0.410085,0.584730,4,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,1),(5,0.359294,0.772388,5,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,1),(6,0.381374,0.660895,6,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,1),(7,0.345397,0.827573,7,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,1),(8,0.378182,0.687104,8,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,1),(9,0.376162,0.710414,9,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,1),(10,0.372366,0.705084,10,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,1),(11,0.576933,0.660364,11,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,1),(12,0.634650,0.666364,12,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,1),(13,0.569351,0.772683,13,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,1),(14,0.633361,0.713193,14,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,1),(15,0.558248,0.815239,15,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,1),(16,0.634076,0.763869,16,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,1),(17,0.647637,0.777446,17,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,1),(18,0.603552,0.824934,18,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,1),(19,0.686989,0.759436,19,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,1),(20,0.648572,0.812581,20,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,1),(21,0.690221,0.779663,21,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,1),(22,0.728912,0.724232,22,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,1),(23,0.642733,0.792112,23,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,1),(24,0.723318,0.758149,24,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,1),(25,0.679981,0.786222,25,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,1),(26,0.696084,0.743800,26,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,1),(27,0.692806,0.797283,27,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,1),(28,0.635955,0.801351,28,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,1),(29,0.727566,0.765642,29,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,1),(30,0.735845,0.755427,30,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,1),(31,0.742134,0.746484,31,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,1),(32,0.747169,0.740240,32,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,1),(33,0.665348,0.810315,33,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,1),(34,0.664885,0.810337,34,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,1),(35,0.786473,0.722998,35,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,1),(36,0.728775,0.759967,36,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,1),(37,0.782288,0.702358,37,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,1),(38,0.731465,0.785015,38,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,1),(39,0.727499,0.803133,39,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,1),(40,0.773518,0.772801,40,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,1),(41,0.758133,0.768600,41,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,1),(42,0.740087,0.787786,42,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,1),(43,0.726304,0.824883,43,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,1),(44,0.748231,0.801643,44,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,1),(45,0.716225,0.849766,45,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,1),(46,0.720418,0.819218,46,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,1),(47,0.742656,0.796693,47,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,1),(48,0.732236,0.812954,48,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,1),(49,0.764881,0.795606,49,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,1),(50,0.785341,0.779872,50,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,1),(51,0.762239,0.821926,51,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,1),(52,0.810748,0.765435,52,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,1),(53,0.753126,0.814463,53,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,1),(54,0.776199,0.804954,54,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,1),(55,0.732143,0.825100,55,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,1),(56,0.810121,0.758988,56,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,1),(57,0.760459,0.812833,57,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,1),(58,0.718549,0.846319,58,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,1),(59,0.780325,0.783096,59,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,1),(60,0.778578,0.798708,60,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,1),(61,0.802458,0.773605,61,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,1),(62,0.818913,0.762729,62,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,1),(63,0.742146,0.832316,63,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,1),(64,0.756884,0.841001,64,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,1),(65,0.792999,0.801742,65,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,1),(66,0.831533,0.757635,66,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,1),(67,0.765370,0.823148,67,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,1),(68,0.797209,0.790704,68,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,1),(69,0.779029,0.807602,69,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,1),(70,0.756473,0.857945,70,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,1),(71,0.796935,0.821714,71,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,1),(72,0.835827,0.746963,72,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,1),(73,0.781027,0.814604,73,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,1),(74,0.816400,0.780341,74,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,1),(75,0.775900,0.829838,75,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,1),(76,0.856790,0.752186,76,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,1),(77,0.822342,0.801921,77,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,1),(78,0.819512,0.784940,78,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,1),(79,0.764598,0.836852,79,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,1),(80,0.777788,0.823909,80,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,1),(128,0.383651,0.562520,1,'2019-11-13 18:37:51','2019-11-13 18:37:51',1,1),(129,0.402194,0.584559,2,'2019-11-13 18:37:51','2019-11-13 18:37:51',1,1),(130,0.391772,0.602136,3,'2019-11-13 18:37:51','2019-11-13 18:37:51',1,1),(131,0.395537,0.302626,4,'2019-11-13 18:37:51','2019-11-13 18:37:51',1,1),(132,0.389802,0.691112,5,'2019-11-13 18:37:51','2019-11-13 18:37:51',1,1),(133,0.378884,0.693663,6,'2019-11-13 18:37:51','2019-11-13 18:37:51',1,1),(134,0.354899,0.771580,7,'2019-11-13 18:37:51','2019-11-13 18:37:51',1,1),(135,0.428028,0.487178,8,'2019-11-13 18:37:51','2019-11-13 18:37:51',1,1),(136,0.387459,0.653727,9,'2019-11-13 18:37:51','2019-11-13 18:37:51',1,1),(137,0.362924,0.685926,10,'2019-11-13 18:37:51','2019-11-13 18:37:51',1,1),(138,0.642427,0.466837,11,'2019-11-13 18:37:51','2019-11-13 18:37:51',1,1),(139,0.667317,0.654506,12,'2019-11-13 18:37:51','2019-11-13 18:37:51',1,1),(140,0.686080,0.620889,13,'2019-11-13 18:37:51','2019-11-13 18:37:51',1,1),(141,0.633399,0.722582,14,'2019-11-13 18:37:51','2019-11-13 18:37:51',1,1),(142,0.533175,0.783010,15,'2019-11-13 18:37:51','2019-11-13 18:37:51',1,1),(143,0.652324,0.727796,16,'2019-11-13 18:37:51','2019-11-13 18:37:51',1,1),(144,0.595953,0.814819,17,'2019-11-13 18:37:51','2019-11-13 18:37:51',1,1),(145,0.491018,0.873389,18,'2019-11-13 18:37:51','2019-11-13 18:37:51',1,1),(146,0.715180,0.648837,19,'2019-11-13 18:37:51','2019-11-13 18:37:51',1,1),(147,0.649417,0.780019,20,'2019-11-13 18:37:51','2019-11-13 18:37:51',1,1),(148,0.626581,0.813240,21,'2019-11-13 18:37:51','2019-11-13 18:37:51',1,1),(149,0.776642,0.672689,22,'2019-11-13 18:37:51','2019-11-13 18:37:51',1,1),(150,0.635966,0.790211,23,'2019-11-13 18:37:51','2019-11-13 18:37:51',1,1),(151,0.714464,0.741765,24,'2019-11-13 18:37:51','2019-11-13 18:37:51',1,1),(152,0.625617,0.836602,25,'2019-11-13 18:37:51','2019-11-13 18:37:51',1,1),(153,0.728015,0.694853,26,'2019-11-13 18:37:51','2019-11-13 18:37:51',1,1),(154,0.627323,0.838922,27,'2019-11-13 18:37:51','2019-11-13 18:37:51',1,1),(155,0.589165,0.812461,28,'2019-11-13 18:37:51','2019-11-13 18:37:51',1,1),(156,0.718820,0.773507,29,'2019-11-13 18:37:51','2019-11-13 18:37:51',1,1),(157,0.695310,0.762156,30,'2019-11-13 18:37:51','2019-11-13 18:37:51',1,1),(158,0.742746,0.756071,31,'2019-11-13 18:37:51','2019-11-13 18:37:51',1,1),(159,0.769699,0.695987,32,'2019-11-13 18:37:51','2019-11-13 18:37:51',1,1),(160,0.686579,0.808912,33,'2019-11-13 18:37:51','2019-11-13 18:37:51',1,1),(161,0.642088,0.804703,34,'2019-11-13 18:37:51','2019-11-13 18:37:51',1,1),(162,0.823414,0.602288,35,'2019-11-13 18:37:51','2019-11-13 18:37:51',1,1),(163,0.748983,0.738641,36,'2019-11-13 18:37:51','2019-11-13 18:37:51',1,1),(164,0.768631,0.673218,37,'2019-11-13 18:37:51','2019-11-13 18:37:51',1,1),(165,0.673241,0.831504,38,'2019-11-13 18:37:51','2019-11-13 18:37:51',1,1),(166,0.741434,0.774227,39,'2019-11-13 18:37:51','2019-11-13 18:37:51',1,1),(167,0.790599,0.703460,40,'2019-11-13 18:37:51','2019-11-13 18:37:51',1,1),(168,0.736694,0.789765,41,'2019-11-13 18:37:51','2019-11-13 18:37:51',1,1),(169,0.739335,0.797544,42,'2019-11-13 18:37:51','2019-11-13 18:37:51',1,1),(170,0.690050,0.850456,43,'2019-11-13 18:37:51','2019-11-13 18:37:51',1,1),(171,0.786235,0.738336,44,'2019-11-13 18:37:51','2019-11-13 18:37:51',1,1),(172,0.681868,0.835714,45,'2019-11-13 18:37:51','2019-11-13 18:37:51',1,1),(173,0.711559,0.832295,46,'2019-11-13 18:37:51','2019-11-13 18:37:51',1,1),(174,0.728518,0.803780,47,'2019-11-13 18:37:51','2019-11-13 18:37:51',1,1),(175,0.690471,0.837501,48,'2019-11-13 18:37:51','2019-11-13 18:37:51',1,1),(176,0.714452,0.804625,49,'2019-11-13 18:37:51','2019-11-13 18:37:51',1,1),(177,0.722081,0.811704,50,'2019-11-13 18:37:51','2019-11-13 18:37:51',1,1),(178,0.747138,0.805910,51,'2019-11-13 18:37:51','2019-11-13 18:37:51',1,1),(179,0.821720,0.710881,52,'2019-11-13 18:37:51','2019-11-13 18:37:51',1,1),(180,0.737909,0.797257,53,'2019-11-13 18:37:51','2019-11-13 18:37:51',1,1),(181,0.771348,0.779622,54,'2019-11-13 18:37:51','2019-11-13 18:37:51',1,1),(182,0.667627,0.848273,55,'2019-11-13 18:37:51','2019-11-13 18:37:51',1,1),(183,0.794533,0.751797,56,'2019-11-13 18:37:51','2019-11-13 18:37:51',1,1),(184,0.733950,0.852167,57,'2019-11-13 18:37:51','2019-11-13 18:37:51',1,1),(185,0.763352,0.786453,58,'2019-11-13 18:37:51','2019-11-13 18:37:51',1,1),(186,0.816033,0.714272,59,'2019-11-13 18:37:51','2019-11-13 18:37:51',1,1),(187,0.765330,0.800085,60,'2019-11-13 18:37:51','2019-11-13 18:37:51',1,1),(188,0.800957,0.753585,61,'2019-11-13 18:37:51','2019-11-13 18:37:51',1,1),(189,0.790002,0.773757,62,'2019-11-13 18:37:51','2019-11-13 18:37:51',1,1),(190,0.715564,0.865517,63,'2019-11-13 18:37:51','2019-11-13 18:37:51',1,1),(191,0.746847,0.821330,64,'2019-11-13 18:37:51','2019-11-13 18:37:51',1,1),(192,0.759578,0.807729,65,'2019-11-13 18:37:51','2019-11-13 18:37:51',1,1),(193,0.803152,0.780591,66,'2019-11-13 18:37:51','2019-11-13 18:37:51',1,1),(194,0.691575,0.867501,67,'2019-11-13 18:37:51','2019-11-13 18:37:51',1,1),(195,0.797829,0.802091,68,'2019-11-13 18:37:51','2019-11-13 18:37:51',1,1),(196,0.791846,0.775341,69,'2019-11-13 18:37:51','2019-11-13 18:37:51',1,1),(197,0.757615,0.834241,70,'2019-11-13 18:37:51','2019-11-13 18:37:51',1,1),(198,0.775393,0.820473,71,'2019-11-13 18:37:51','2019-11-13 18:37:51',1,1),(199,0.861941,0.685845,72,'2019-11-13 18:37:51','2019-11-13 18:37:51',1,1),(200,0.719730,0.852453,73,'2019-11-13 18:37:51','2019-11-13 18:37:51',1,1),(201,0.849948,0.722190,74,'2019-11-13 18:37:51','2019-11-13 18:37:51',1,1),(202,0.767779,0.840070,75,'2019-11-13 18:37:51','2019-11-13 18:37:51',1,1),(203,0.809510,0.774351,76,'2019-11-13 18:37:51','2019-11-13 18:37:51',1,1),(204,0.814056,0.753027,77,'2019-11-13 18:37:51','2019-11-13 18:37:51',1,1),(205,0.807647,0.792708,78,'2019-11-13 18:37:51','2019-11-13 18:37:51',1,1),(206,0.744760,0.838430,79,'2019-11-13 18:37:51','2019-11-13 18:37:51',1,1),(207,0.775086,0.819594,80,'2019-11-13 18:37:51','2019-11-13 18:37:51',1,1),(255,0.281409,0.837095,1,'2019-11-13 18:38:08','2019-11-13 18:38:08',2,1),(256,0.325220,0.840131,2,'2019-11-13 18:38:08','2019-11-13 18:38:08',2,1),(257,0.329054,0.892691,3,'2019-11-13 18:38:08','2019-11-13 18:38:08',2,1),(258,0.406116,0.589813,4,'2019-11-13 18:38:08','2019-11-13 18:38:08',2,1),(259,0.344266,0.825187,5,'2019-11-13 18:38:08','2019-11-13 18:38:08',2,1),(260,0.407175,0.564886,6,'2019-11-13 18:38:08','2019-11-13 18:38:08',2,1),(261,0.343036,0.800138,7,'2019-11-13 18:38:08','2019-11-13 18:38:08',2,1),(262,0.332305,0.804741,8,'2019-11-13 18:38:08','2019-11-13 18:38:08',2,1),(263,0.370183,0.742667,9,'2019-11-13 18:38:08','2019-11-13 18:38:08',2,1),(264,0.397663,0.634867,10,'2019-11-13 18:38:08','2019-11-13 18:38:08',2,1),(265,0.558924,0.691508,11,'2019-11-13 18:38:08','2019-11-13 18:38:08',2,1),(266,0.612931,0.645994,12,'2019-11-13 18:38:08','2019-11-13 18:38:08',2,1),(267,0.428040,0.851709,13,'2019-11-13 18:38:08','2019-11-13 18:38:08',2,1),(268,0.659347,0.620621,14,'2019-11-13 18:38:08','2019-11-13 18:38:08',2,1),(269,0.567952,0.822483,15,'2019-11-13 18:38:08','2019-11-13 18:38:08',2,1),(270,0.589277,0.791262,16,'2019-11-13 18:38:08','2019-11-13 18:38:08',2,1),(271,0.673538,0.696813,17,'2019-11-13 18:38:08','2019-11-13 18:38:08',2,1),(272,0.644661,0.742245,18,'2019-11-13 18:38:08','2019-11-13 18:38:08',2,1),(273,0.630850,0.814542,19,'2019-11-13 18:38:08','2019-11-13 18:38:08',2,1),(274,0.644276,0.815661,20,'2019-11-13 18:38:08','2019-11-13 18:38:08',2,1),(275,0.745826,0.680757,21,'2019-11-13 18:38:08','2019-11-13 18:38:08',2,1),(276,0.688551,0.748187,22,'2019-11-13 18:38:08','2019-11-13 18:38:08',2,1),(277,0.651668,0.761642,23,'2019-11-13 18:38:08','2019-11-13 18:38:08',2,1),(278,0.691531,0.768767,24,'2019-11-13 18:38:08','2019-11-13 18:38:08',2,1),(279,0.683474,0.725019,25,'2019-11-13 18:38:08','2019-11-13 18:38:08',2,1),(280,0.660212,0.760787,26,'2019-11-13 18:38:08','2019-11-13 18:38:08',2,1),(281,0.729438,0.730009,27,'2019-11-13 18:38:08','2019-11-13 18:38:08',2,1),(282,0.687974,0.763635,28,'2019-11-13 18:38:08','2019-11-13 18:38:08',2,1),(283,0.712474,0.737236,29,'2019-11-13 18:38:08','2019-11-13 18:38:08',2,1),(284,0.762376,0.746620,30,'2019-11-13 18:38:08','2019-11-13 18:38:08',2,1),(285,0.745899,0.733071,31,'2019-11-13 18:38:08','2019-11-13 18:38:08',2,1),(286,0.718241,0.740812,32,'2019-11-13 18:38:08','2019-11-13 18:38:08',2,1),(287,0.622929,0.806035,33,'2019-11-13 18:38:08','2019-11-13 18:38:08',2,1),(288,0.691738,0.801839,34,'2019-11-13 18:38:08','2019-11-13 18:38:08',2,1),(289,0.740594,0.783373,35,'2019-11-13 18:38:08','2019-11-13 18:38:08',2,1),(290,0.666782,0.730726,36,'2019-11-13 18:38:08','2019-11-13 18:38:08',2,1),(291,0.790467,0.726236,37,'2019-11-13 18:38:08','2019-11-13 18:38:08',2,1),(292,0.773706,0.752867,38,'2019-11-13 18:38:08','2019-11-13 18:38:08',2,1),(293,0.712354,0.802816,39,'2019-11-13 18:38:08','2019-11-13 18:38:08',2,1),(294,0.721480,0.796102,40,'2019-11-13 18:38:08','2019-11-13 18:38:08',2,1),(295,0.787260,0.747229,41,'2019-11-13 18:38:08','2019-11-13 18:38:08',2,1),(296,0.741222,0.778473,42,'2019-11-13 18:38:08','2019-11-13 18:38:08',2,1),(297,0.776840,0.745664,43,'2019-11-13 18:38:08','2019-11-13 18:38:08',2,1),(298,0.699511,0.828887,44,'2019-11-13 18:38:08','2019-11-13 18:38:08',2,1),(299,0.717457,0.812775,45,'2019-11-13 18:38:08','2019-11-13 18:38:08',2,1),(300,0.710009,0.803489,46,'2019-11-13 18:38:08','2019-11-13 18:38:08',2,1),(301,0.738608,0.788677,47,'2019-11-13 18:38:08','2019-11-13 18:38:08',2,1),(302,0.764244,0.754810,48,'2019-11-13 18:38:08','2019-11-13 18:38:08',2,1),(303,0.770508,0.760213,49,'2019-11-13 18:38:08','2019-11-13 18:38:08',2,1),(304,0.824636,0.716749,50,'2019-11-13 18:38:08','2019-11-13 18:38:08',2,1),(305,0.771670,0.786593,51,'2019-11-13 18:38:08','2019-11-13 18:38:08',2,1),(306,0.781164,0.790673,52,'2019-11-13 18:38:08','2019-11-13 18:38:08',2,1),(307,0.723937,0.794141,53,'2019-11-13 18:38:08','2019-11-13 18:38:08',2,1),(308,0.768222,0.816552,54,'2019-11-13 18:38:08','2019-11-13 18:38:08',2,1),(309,0.768226,0.782598,55,'2019-11-13 18:38:08','2019-11-13 18:38:08',2,1),(310,0.802700,0.740616,56,'2019-11-13 18:38:08','2019-11-13 18:38:08',2,1),(311,0.789580,0.766136,57,'2019-11-13 18:38:08','2019-11-13 18:38:08',2,1),(312,0.652187,0.848109,58,'2019-11-13 18:38:08','2019-11-13 18:38:08',2,1),(313,0.735910,0.823968,59,'2019-11-13 18:38:08','2019-11-13 18:38:08',2,1),(314,0.791368,0.797836,60,'2019-11-13 18:38:08','2019-11-13 18:38:08',2,1),(315,0.810355,0.759303,61,'2019-11-13 18:38:08','2019-11-13 18:38:08',2,1),(316,0.842735,0.740881,62,'2019-11-13 18:38:08','2019-11-13 18:38:08',2,1),(317,0.764480,0.776375,63,'2019-11-13 18:38:08','2019-11-13 18:38:08',2,1),(318,0.749898,0.832844,64,'2019-11-13 18:38:08','2019-11-13 18:38:08',2,1),(319,0.830025,0.756946,65,'2019-11-13 18:38:08','2019-11-13 18:38:08',2,1),(320,0.854679,0.688080,66,'2019-11-13 18:38:08','2019-11-13 18:38:08',2,1),(321,0.820891,0.759170,67,'2019-11-13 18:38:08','2019-11-13 18:38:08',2,1),(322,0.800476,0.781647,68,'2019-11-13 18:38:08','2019-11-13 18:38:08',2,1),(323,0.759103,0.818063,69,'2019-11-13 18:38:08','2019-11-13 18:38:08',2,1),(324,0.744324,0.822361,70,'2019-11-13 18:38:08','2019-11-13 18:38:08',2,1),(325,0.820404,0.758617,71,'2019-11-13 18:38:08','2019-11-13 18:38:08',2,1),(326,0.801282,0.761953,72,'2019-11-13 18:38:08','2019-11-13 18:38:08',2,1),(327,0.825404,0.773296,73,'2019-11-13 18:38:08','2019-11-13 18:38:08',2,1),(328,0.781843,0.814998,74,'2019-11-13 18:38:08','2019-11-13 18:38:08',2,1),(329,0.770453,0.812293,75,'2019-11-13 18:38:08','2019-11-13 18:38:08',2,1),(330,0.884819,0.691906,76,'2019-11-13 18:38:08','2019-11-13 18:38:08',2,1),(331,0.808913,0.808751,77,'2019-11-13 18:38:08','2019-11-13 18:38:08',2,1),(332,0.834164,0.759777,78,'2019-11-13 18:38:08','2019-11-13 18:38:08',2,1),(333,0.762405,0.851255,79,'2019-11-13 18:38:08','2019-11-13 18:38:08',2,1),(334,0.758835,0.790020,80,'2019-11-13 18:38:08','2019-11-13 18:38:08',2,1),(337,0.312634,0.809640,1,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(338,0.346252,0.766558,2,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(339,0.348606,0.832529,3,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(340,0.410085,0.584730,4,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(341,0.359294,0.772388,5,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(342,0.381374,0.660895,6,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(343,0.345397,0.827573,7,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(344,0.378182,0.687104,8,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(345,0.376162,0.710414,9,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(346,0.372366,0.705084,10,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(347,0.576933,0.660364,11,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(348,0.634650,0.666364,12,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(349,0.569351,0.772683,13,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(350,0.633361,0.713193,14,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(351,0.558248,0.815239,15,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(352,0.634076,0.763869,16,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(353,0.647637,0.777446,17,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(354,0.603552,0.824934,18,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(355,0.686989,0.759436,19,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(356,0.648572,0.812581,20,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(357,0.690221,0.779663,21,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(358,0.728912,0.724232,22,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(359,0.642733,0.792112,23,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(360,0.723318,0.758149,24,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(361,0.679981,0.786222,25,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(362,0.696084,0.743800,26,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(363,0.692806,0.797283,27,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(364,0.635955,0.801351,28,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(365,0.727566,0.765642,29,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(366,0.735845,0.755427,30,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(367,0.742134,0.746484,31,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(368,0.747169,0.740240,32,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(369,0.665348,0.810315,33,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(370,0.664885,0.810337,34,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(371,0.786473,0.722998,35,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(372,0.728775,0.759967,36,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(373,0.782288,0.702358,37,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(374,0.731465,0.785015,38,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(375,0.727499,0.803133,39,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(376,0.773518,0.772801,40,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(377,0.758133,0.768600,41,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(378,0.740087,0.787786,42,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(379,0.726304,0.824883,43,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(380,0.748231,0.801643,44,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(381,0.716225,0.849766,45,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(382,0.720418,0.819218,46,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(383,0.742656,0.796693,47,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(384,0.732236,0.812954,48,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(385,0.764881,0.795606,49,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(386,0.785341,0.779872,50,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(387,0.762239,0.821926,51,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(388,0.810748,0.765435,52,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(389,0.753126,0.814463,53,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(390,0.776199,0.804954,54,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(391,0.732143,0.825100,55,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(392,0.810121,0.758988,56,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(393,0.760459,0.812833,57,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(394,0.718549,0.846319,58,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(395,0.780325,0.783096,59,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(396,0.778578,0.798708,60,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(397,0.802458,0.773605,61,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(398,0.818913,0.762729,62,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(399,0.742146,0.832316,63,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(400,0.756884,0.841001,64,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(401,0.792999,0.801742,65,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(402,0.831533,0.757635,66,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(403,0.765370,0.823148,67,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(404,0.797209,0.790704,68,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(405,0.779029,0.807602,69,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(406,0.756473,0.857945,70,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(407,0.796935,0.821714,71,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(408,0.835827,0.746963,72,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(409,0.781027,0.814604,73,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(410,0.816400,0.780341,74,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(411,0.775900,0.829838,75,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(412,0.856790,0.752186,76,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(413,0.822342,0.801921,77,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(414,0.819512,0.784940,78,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(415,0.764598,0.836852,79,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(416,0.777788,0.823909,80,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(417,0.383651,0.562520,1,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(418,0.402194,0.584559,2,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(419,0.391772,0.602136,3,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(420,0.395537,0.302626,4,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(421,0.389802,0.691112,5,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(422,0.378884,0.693663,6,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(423,0.354899,0.771580,7,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(424,0.428028,0.487178,8,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(425,0.387459,0.653727,9,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(426,0.362924,0.685926,10,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(427,0.642427,0.466837,11,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(428,0.667317,0.654506,12,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(429,0.686080,0.620889,13,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(430,0.633399,0.722582,14,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(431,0.533175,0.783010,15,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(432,0.652324,0.727796,16,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(433,0.595953,0.814819,17,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(434,0.491018,0.873389,18,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(435,0.715180,0.648837,19,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(436,0.649417,0.780019,20,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(437,0.626581,0.813240,21,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(438,0.776642,0.672689,22,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(439,0.635966,0.790211,23,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(440,0.714464,0.741765,24,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(441,0.625617,0.836602,25,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(442,0.728015,0.694853,26,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(443,0.627323,0.838922,27,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(444,0.589165,0.812461,28,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(445,0.718820,0.773507,29,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(446,0.695310,0.762156,30,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(447,0.742746,0.756071,31,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(448,0.769699,0.695987,32,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(449,0.686579,0.808912,33,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(450,0.642088,0.804703,34,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(451,0.823414,0.602288,35,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(452,0.748983,0.738641,36,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(453,0.768631,0.673218,37,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(454,0.673241,0.831504,38,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(455,0.741434,0.774227,39,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(456,0.790599,0.703460,40,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(457,0.736694,0.789765,41,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(458,0.739335,0.797544,42,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(459,0.690050,0.850456,43,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(460,0.786235,0.738336,44,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(461,0.681868,0.835714,45,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(462,0.711559,0.832295,46,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(463,0.728518,0.803780,47,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(464,0.690471,0.837501,48,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(465,0.714452,0.804625,49,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(466,0.722081,0.811704,50,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(467,0.747138,0.805910,51,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(468,0.821720,0.710881,52,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(469,0.737909,0.797257,53,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(470,0.771348,0.779622,54,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(471,0.667627,0.848273,55,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(472,0.794533,0.751797,56,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(473,0.733950,0.852167,57,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(474,0.763352,0.786453,58,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(475,0.816033,0.714272,59,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(476,0.765330,0.800085,60,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(477,0.800957,0.753585,61,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(478,0.790002,0.773757,62,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(479,0.715564,0.865517,63,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(480,0.746847,0.821330,64,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(481,0.759578,0.807729,65,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(482,0.803152,0.780591,66,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(483,0.691575,0.867501,67,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(484,0.797829,0.802091,68,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(485,0.791846,0.775341,69,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(486,0.757615,0.834241,70,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(487,0.775393,0.820473,71,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(488,0.861941,0.685845,72,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(489,0.719730,0.852453,73,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(490,0.849948,0.722190,74,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(491,0.767779,0.840070,75,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(492,0.809510,0.774351,76,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(493,0.814056,0.753027,77,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(494,0.807647,0.792708,78,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(495,0.744760,0.838430,79,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(496,0.775086,0.819594,80,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(497,0.281409,0.837095,1,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(498,0.325220,0.840131,2,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(499,0.329054,0.892691,3,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(500,0.406116,0.589813,4,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(501,0.344266,0.825187,5,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(502,0.407175,0.564886,6,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(503,0.343036,0.800138,7,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(504,0.332305,0.804741,8,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(505,0.370183,0.742667,9,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(506,0.397663,0.634867,10,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(507,0.558924,0.691508,11,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(508,0.612931,0.645994,12,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(509,0.428040,0.851709,13,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(510,0.659347,0.620621,14,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(511,0.567952,0.822483,15,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(512,0.589277,0.791262,16,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(513,0.673538,0.696813,17,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(514,0.644661,0.742245,18,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(515,0.630850,0.814542,19,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(516,0.644276,0.815661,20,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(517,0.745826,0.680757,21,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(518,0.688551,0.748187,22,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(519,0.651668,0.761642,23,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(520,0.691531,0.768767,24,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(521,0.683474,0.725019,25,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(522,0.660212,0.760787,26,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(523,0.729438,0.730009,27,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(524,0.687974,0.763635,28,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(525,0.712474,0.737236,29,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(526,0.762376,0.746620,30,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(527,0.745899,0.733071,31,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(528,0.718241,0.740812,32,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(529,0.622929,0.806035,33,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(530,0.691738,0.801839,34,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(531,0.740594,0.783373,35,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(532,0.666782,0.730726,36,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(533,0.790467,0.726236,37,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(534,0.773706,0.752867,38,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(535,0.712354,0.802816,39,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(536,0.721480,0.796102,40,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(537,0.787260,0.747229,41,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(538,0.741222,0.778473,42,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(539,0.776840,0.745664,43,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(540,0.699511,0.828887,44,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(541,0.717457,0.812775,45,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(542,0.710009,0.803489,46,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(543,0.738608,0.788677,47,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(544,0.764244,0.754810,48,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(545,0.770508,0.760213,49,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(546,0.824636,0.716749,50,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(547,0.771670,0.786593,51,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(548,0.781164,0.790673,52,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(549,0.723937,0.794141,53,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(550,0.768222,0.816552,54,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(551,0.768226,0.782598,55,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(552,0.802700,0.740616,56,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(553,0.789580,0.766136,57,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(554,0.652187,0.848109,58,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(555,0.735910,0.823968,59,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(556,0.791368,0.797836,60,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(557,0.810355,0.759303,61,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(558,0.842735,0.740881,62,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(559,0.764480,0.776375,63,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(560,0.749898,0.832844,64,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(561,0.830025,0.756946,65,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(562,0.854679,0.688080,66,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(563,0.820891,0.759170,67,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(564,0.800476,0.781647,68,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(565,0.759103,0.818063,69,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(566,0.744324,0.822361,70,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(567,0.820404,0.758617,71,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(568,0.801282,0.761953,72,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(569,0.825404,0.773296,73,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(570,0.781843,0.814998,74,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(571,0.770453,0.812293,75,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(572,0.884819,0.691906,76,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(573,0.808913,0.808751,77,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(574,0.834164,0.759777,78,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(575,0.762405,0.851255,79,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(576,0.758835,0.790020,80,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2);
- /*!40000 ALTER TABLE `task_training_data` ENABLE KEYS */;
- UNLOCK TABLES;
-
- --
- -- Table structure for table `task_training_data1`
- --
-
- DROP TABLE IF EXISTS `task_training_data1`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `task_training_data1` (
- `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'task training data ID',
- `recall` float(8,6) DEFAULT NULL COMMENT '进展',
- `precision` float(8,6) DEFAULT NULL COMMENT '精确',
- `round` int(11) DEFAULT NULL COMMENT 'Round No.',
- `start_time` datetime DEFAULT NULL,
- `end_time` datetime DEFAULT NULL,
- `task_id` int(11) DEFAULT '0' COMMENT '任务ID',
- `task_group_id` int(11) DEFAULT NULL COMMENT 'Task group id',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=335 DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
-
- --
- -- Dumping data for table `task_training_data1`
- --
-
- LOCK TABLES `task_training_data1` WRITE;
- /*!40000 ALTER TABLE `task_training_data1` DISABLE KEYS */;
- INSERT INTO `task_training_data1` VALUES (1,0.312634,0.809640,1,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(2,0.346252,0.766558,2,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(3,0.348606,0.832529,3,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(4,0.410085,0.584730,4,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(5,0.359294,0.772388,5,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(6,0.381374,0.660895,6,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(7,0.345397,0.827573,7,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(8,0.378182,0.687104,8,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(9,0.376162,0.710414,9,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(10,0.372366,0.705084,10,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(11,0.576933,0.660364,11,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(12,0.634650,0.666364,12,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(13,0.569351,0.772683,13,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(14,0.633361,0.713193,14,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(15,0.558248,0.815239,15,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(16,0.634076,0.763869,16,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(17,0.647637,0.777446,17,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(18,0.603552,0.824934,18,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(19,0.686989,0.759436,19,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(20,0.648572,0.812581,20,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(21,0.690221,0.779663,21,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(22,0.728912,0.724232,22,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(23,0.642733,0.792112,23,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(24,0.723318,0.758149,24,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(25,0.679981,0.786222,25,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(26,0.696084,0.743800,26,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(27,0.692806,0.797283,27,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(28,0.635955,0.801351,28,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(29,0.727566,0.765642,29,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(30,0.735845,0.755427,30,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(31,0.742134,0.746484,31,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(32,0.747169,0.740240,32,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(33,0.665348,0.810315,33,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(34,0.664885,0.810337,34,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(35,0.786473,0.722998,35,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(36,0.728775,0.759967,36,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(37,0.782288,0.702358,37,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(38,0.731465,0.785015,38,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(39,0.727499,0.803133,39,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(40,0.773518,0.772801,40,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(41,0.758133,0.768600,41,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(42,0.740087,0.787786,42,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(43,0.726304,0.824883,43,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(44,0.748231,0.801643,44,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(45,0.716225,0.849766,45,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(46,0.720418,0.819218,46,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(47,0.742656,0.796693,47,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(48,0.732236,0.812954,48,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(49,0.764881,0.795606,49,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(50,0.785341,0.779872,50,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(51,0.762239,0.821926,51,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(52,0.810748,0.765435,52,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(53,0.753126,0.814463,53,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(54,0.776199,0.804954,54,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(55,0.732143,0.825100,55,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(56,0.810121,0.758988,56,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(57,0.760459,0.812833,57,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(58,0.718549,0.846319,58,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(59,0.780325,0.783096,59,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(60,0.778578,0.798708,60,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(61,0.802458,0.773605,61,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(62,0.818913,0.762729,62,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(63,0.742146,0.832316,63,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(64,0.756884,0.841001,64,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(65,0.792999,0.801742,65,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(66,0.831533,0.757635,66,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(67,0.765370,0.823148,67,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(68,0.797209,0.790704,68,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(69,0.779029,0.807602,69,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(70,0.756473,0.857945,70,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(71,0.796935,0.821714,71,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(72,0.835827,0.746963,72,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(73,0.781027,0.814604,73,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(74,0.816400,0.780341,74,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(75,0.775900,0.829838,75,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(76,0.856790,0.752186,76,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(77,0.822342,0.801921,77,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(78,0.819512,0.784940,78,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(79,0.764598,0.836852,79,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(80,0.777788,0.823909,80,'2019-11-13 18:36:35','2019-11-13 18:36:35',0,2),(128,0.383651,0.562520,1,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(129,0.402194,0.584559,2,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(130,0.391772,0.602136,3,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(131,0.395537,0.302626,4,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(132,0.389802,0.691112,5,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(133,0.378884,0.693663,6,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(134,0.354899,0.771580,7,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(135,0.428028,0.487178,8,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(136,0.387459,0.653727,9,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(137,0.362924,0.685926,10,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(138,0.642427,0.466837,11,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(139,0.667317,0.654506,12,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(140,0.686080,0.620889,13,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(141,0.633399,0.722582,14,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(142,0.533175,0.783010,15,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(143,0.652324,0.727796,16,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(144,0.595953,0.814819,17,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(145,0.491018,0.873389,18,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(146,0.715180,0.648837,19,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(147,0.649417,0.780019,20,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(148,0.626581,0.813240,21,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(149,0.776642,0.672689,22,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(150,0.635966,0.790211,23,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(151,0.714464,0.741765,24,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(152,0.625617,0.836602,25,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(153,0.728015,0.694853,26,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(154,0.627323,0.838922,27,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(155,0.589165,0.812461,28,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(156,0.718820,0.773507,29,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(157,0.695310,0.762156,30,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(158,0.742746,0.756071,31,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(159,0.769699,0.695987,32,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(160,0.686579,0.808912,33,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(161,0.642088,0.804703,34,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(162,0.823414,0.602288,35,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(163,0.748983,0.738641,36,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(164,0.768631,0.673218,37,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(165,0.673241,0.831504,38,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(166,0.741434,0.774227,39,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(167,0.790599,0.703460,40,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(168,0.736694,0.789765,41,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(169,0.739335,0.797544,42,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(170,0.690050,0.850456,43,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(171,0.786235,0.738336,44,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(172,0.681868,0.835714,45,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(173,0.711559,0.832295,46,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(174,0.728518,0.803780,47,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(175,0.690471,0.837501,48,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(176,0.714452,0.804625,49,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(177,0.722081,0.811704,50,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(178,0.747138,0.805910,51,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(179,0.821720,0.710881,52,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(180,0.737909,0.797257,53,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(181,0.771348,0.779622,54,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(182,0.667627,0.848273,55,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(183,0.794533,0.751797,56,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(184,0.733950,0.852167,57,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(185,0.763352,0.786453,58,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(186,0.816033,0.714272,59,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(187,0.765330,0.800085,60,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(188,0.800957,0.753585,61,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(189,0.790002,0.773757,62,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(190,0.715564,0.865517,63,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(191,0.746847,0.821330,64,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(192,0.759578,0.807729,65,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(193,0.803152,0.780591,66,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(194,0.691575,0.867501,67,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(195,0.797829,0.802091,68,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(196,0.791846,0.775341,69,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(197,0.757615,0.834241,70,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(198,0.775393,0.820473,71,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(199,0.861941,0.685845,72,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(200,0.719730,0.852453,73,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(201,0.849948,0.722190,74,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(202,0.767779,0.840070,75,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(203,0.809510,0.774351,76,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(204,0.814056,0.753027,77,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(205,0.807647,0.792708,78,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(206,0.744760,0.838430,79,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(207,0.775086,0.819594,80,'2019-11-13 18:37:51','2019-11-13 18:37:51',3,2),(255,0.281409,0.837095,1,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(256,0.325220,0.840131,2,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(257,0.329054,0.892691,3,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(258,0.406116,0.589813,4,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(259,0.344266,0.825187,5,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(260,0.407175,0.564886,6,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(261,0.343036,0.800138,7,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(262,0.332305,0.804741,8,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(263,0.370183,0.742667,9,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(264,0.397663,0.634867,10,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(265,0.558924,0.691508,11,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(266,0.612931,0.645994,12,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(267,0.428040,0.851709,13,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(268,0.659347,0.620621,14,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(269,0.567952,0.822483,15,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(270,0.589277,0.791262,16,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(271,0.673538,0.696813,17,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(272,0.644661,0.742245,18,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(273,0.630850,0.814542,19,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(274,0.644276,0.815661,20,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(275,0.745826,0.680757,21,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(276,0.688551,0.748187,22,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(277,0.651668,0.761642,23,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(278,0.691531,0.768767,24,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(279,0.683474,0.725019,25,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(280,0.660212,0.760787,26,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(281,0.729438,0.730009,27,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(282,0.687974,0.763635,28,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(283,0.712474,0.737236,29,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(284,0.762376,0.746620,30,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(285,0.745899,0.733071,31,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(286,0.718241,0.740812,32,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(287,0.622929,0.806035,33,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(288,0.691738,0.801839,34,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(289,0.740594,0.783373,35,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(290,0.666782,0.730726,36,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(291,0.790467,0.726236,37,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(292,0.773706,0.752867,38,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(293,0.712354,0.802816,39,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(294,0.721480,0.796102,40,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(295,0.787260,0.747229,41,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(296,0.741222,0.778473,42,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(297,0.776840,0.745664,43,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(298,0.699511,0.828887,44,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(299,0.717457,0.812775,45,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(300,0.710009,0.803489,46,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(301,0.738608,0.788677,47,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(302,0.764244,0.754810,48,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(303,0.770508,0.760213,49,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(304,0.824636,0.716749,50,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(305,0.771670,0.786593,51,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(306,0.781164,0.790673,52,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(307,0.723937,0.794141,53,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(308,0.768222,0.816552,54,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(309,0.768226,0.782598,55,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(310,0.802700,0.740616,56,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(311,0.789580,0.766136,57,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(312,0.652187,0.848109,58,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(313,0.735910,0.823968,59,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(314,0.791368,0.797836,60,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(315,0.810355,0.759303,61,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(316,0.842735,0.740881,62,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(317,0.764480,0.776375,63,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(318,0.749898,0.832844,64,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(319,0.830025,0.756946,65,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(320,0.854679,0.688080,66,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(321,0.820891,0.759170,67,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(322,0.800476,0.781647,68,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(323,0.759103,0.818063,69,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(324,0.744324,0.822361,70,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(325,0.820404,0.758617,71,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(326,0.801282,0.761953,72,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(327,0.825404,0.773296,73,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(328,0.781843,0.814998,74,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(329,0.770453,0.812293,75,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(330,0.884819,0.691906,76,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(331,0.808913,0.808751,77,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(332,0.834164,0.759777,78,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(333,0.762405,0.851255,79,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2),(334,0.758835,0.790020,80,'2019-11-13 18:38:08','2019-11-13 18:38:08',4,2);
- /*!40000 ALTER TABLE `task_training_data1` ENABLE KEYS */;
- UNLOCK TABLES;
-
- --
- -- Table structure for table `tasks`
- --
-
- DROP TABLE IF EXISTS `tasks`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `tasks` (
- `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '任务ID',
- `name` varchar(200) NOT NULL COMMENT '任务名称',
- `task_type` varchar(20) DEFAULT NULL COMMENT '任务类型',
- `status` int(11) DEFAULT NULL COMMENT '状态 Not defined(0), Ready(1) , Training(2), End(3), Error(-1)',
- `message` varchar(1024) DEFAULT NULL COMMENT 'Messages for task',
- `algorithm_id` int(11) DEFAULT NULL COMMENT '算法模型',
- `dataset_id` int(11) DEFAULT NULL COMMENT 'Dataset ID',
- `add_date` datetime DEFAULT NULL COMMENT '添加日期',
- `modify_date` datetime DEFAULT NULL COMMENT '修改日期',
- `completed_date` datetime DEFAULT NULL COMMENT '完成日期',
- `users_id` int(11) DEFAULT NULL COMMENT '用户身份',
- `classification_id` int(11) DEFAULT NULL,
- `task_group_id` int(11) DEFAULT NULL COMMENT 'ID for task group',
- PRIMARY KEY (`id`),
- KEY `tasks_dataset_id_fk` (`dataset_id`),
- KEY `tasks_users_id_fk` (`users_id`),
- KEY `tasks_algorithm_id_fk_idx` (`algorithm_id`),
- CONSTRAINT `tasks_algorithm_id_fk` FOREIGN KEY (`algorithm_id`) REFERENCES `algorithm` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
- CONSTRAINT `tasks_dataset_id_fk` FOREIGN KEY (`dataset_id`) REFERENCES `dataset` (`id`),
- CONSTRAINT `tasks_users_id_fk` FOREIGN KEY (`users_id`) REFERENCES `users` (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
-
- --
- -- Dumping data for table `tasks`
- --
-
- LOCK TABLES `tasks` WRITE;
- /*!40000 ALTER TABLE `tasks` DISABLE KEYS */;
- INSERT INTO `tasks` VALUES (0,'鹏程云脑',NULL,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(1,'肿瘤区域识别任务',NULL,3,NULL,1,1,'2019-12-23 12:04:46','2019-12-23 12:08:40',NULL,7,2,1),(2,'肿瘤区域识别任务',NULL,3,NULL,1,2,'2019-12-23 12:04:48','2019-12-23 12:04:48',NULL,6,2,1),(3,'PDL1定量任务',NULL,2,NULL,2,4,'2019-12-23 12:53:30','2019-12-23 12:53:30',NULL,10,2,2),(4,'PDL1定量任务',NULL,2,NULL,2,3,'2019-12-23 12:53:33','2019-12-23 12:53:33',NULL,9,2,2),(5,'肿瘤区域识别任务',NULL,NULL,NULL,1,1,'2020-04-22 17:17:16','2020-04-22 17:17:16',NULL,7,2,1),(6,'肿瘤任务识别',NULL,NULL,NULL,1,1,'2020-04-22 17:18:14','2020-04-22 17:18:14',NULL,7,2,1);
- /*!40000 ALTER TABLE `tasks` ENABLE KEYS */;
- UNLOCK TABLES;
-
- --
- -- Table structure for table `training_parameters`
- --
-
- DROP TABLE IF EXISTS `training_parameters`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `training_parameters` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `task_id` int(11) DEFAULT NULL,
- `download_size` int(11) DEFAULT NULL,
- `upload_size` int(11) DEFAULT NULL,
- `received_time` datetime DEFAULT NULL,
- PRIMARY KEY (`id`),
- KEY `training_parameters_tasks_id_fk_idx` (`task_id`),
- CONSTRAINT `training_parameters_tasks_id_fk` FOREIGN KEY (`task_id`) REFERENCES `tasks` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
- ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
-
- --
- -- Dumping data for table `training_parameters`
- --
-
- LOCK TABLES `training_parameters` WRITE;
- /*!40000 ALTER TABLE `training_parameters` DISABLE KEYS */;
- INSERT INTO `training_parameters` VALUES (1,1,123456231,NULL,'2019-11-13 08:53:29'),(2,1,NULL,532342123,'2019-11-13 08:54:52'),(4,2,12312323,22323,'2019-11-13 08:55:10'),(5,2,NULL,13123,'2019-11-13 09:04:03'),(6,3,12378812,NULL,'2019-12-23 13:16:05'),(7,3,NULL,378812,'2019-12-23 13:16:18'),(8,4,23423412,NULL,'2019-12-23 13:16:29'),(9,4,NULL,878812,'2019-12-23 13:16:41');
- /*!40000 ALTER TABLE `training_parameters` ENABLE KEYS */;
- UNLOCK TABLES;
-
- --
- -- Table structure for table `users`
- --
-
- DROP TABLE IF EXISTS `users`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `users` (
- `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户身份',
- `email` varchar(200) NOT NULL COMMENT 'Email',
- `user_name` varchar(20) NOT NULL COMMENT '用户名',
- `password` varchar(500) NOT NULL COMMENT 'Password',
- `join_date` datetime DEFAULT NULL COMMENT '参加日期',
- `modify_date` datetime DEFAULT NULL COMMENT '修改日期',
- `organization_id` int(11) DEFAULT NULL COMMENT '组织编号',
- `token` varchar(500) DEFAULT NULL COMMENT 'sha256(password+modify_date)',
- `role` varchar(20) NOT NULL COMMENT '用户角色',
- `is_enable` int(2) NOT NULL COMMENT '状态(1启用,0禁用)',
- PRIMARY KEY (`id`),
- UNIQUE KEY `phone_no_UNIQUE` (`user_name`),
- UNIQUE KEY `email_UNIQUE` (`email`),
- KEY `users_organization_id_fk` (`organization_id`),
- CONSTRAINT `users_organization_id_fk` FOREIGN KEY (`organization_id`) REFERENCES `organization` (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
-
- --
- -- Dumping data for table `users`
- --
-
- LOCK TABLES `users` WRITE;
- /*!40000 ALTER TABLE `users` DISABLE KEYS */;
- INSERT INTO `users` VALUES (6,'xyf2','admin','ef797c8118f02dfb649607dd5d3f8c7623048c9c063d532cc95c5ed7a898a64f','2019-11-12 02:01:59','2019-11-12 02:01:59',2,'9b97c83e83bd0b1eb89739766bf46e1215f24067071375bbc394244b81f0b8bc','admin',1),(7,'xatd','13787279073','ef797c8118f02dfb649607dd5d3f8c7623048c9c063d532cc95c5ed7a898a64f','2019-11-11 12:02:41','2019-11-13 21:20:49',1,'c45273171877414f764e3bacf944ef04ed3a1fd1218072ae0ef6e45a7fa66110','normal',1),(8,'1261015132@qq.com','18508486527','15e2b0d3c33891ebb0f1ef609ec419420c20e320ce94c65fbc8c3312448eb225','2019-11-13 03:10:21','2019-11-13 03:10:21',1,'1a88ae6a98acc9851b3ef320fed505c915e339fe5338428de446bb6faddb6ed9','normal',1),(9,'xaxjyy','15874160674','ef797c8118f02dfb649607dd5d3f8c7623048c9c063d532cc95c5ed7a898a64f','2019-12-23 12:36:45','2019-12-23 12:36:45',4,'c997d350d213cac693298e11d59a8d17ea5f7606446af7e8039d0a197f6bc72c','normal',1),(10,'yzjqzyy','13142126303','ef797c8118f02dfb649607dd5d3f8c7623048c9c063d532cc95c5ed7a898a64f','2019-12-23 12:37:29','2019-12-23 12:37:29',3,'e2de34849d5f1bdec31f6856cc20930bca9e9a47c4e8f75579691224f4cfb41a','normal',1);
- /*!40000 ALTER TABLE `users` ENABLE KEYS */;
- UNLOCK TABLES;
-
- --
- -- Table structure for table `users_account`
- --
-
- DROP TABLE IF EXISTS `users_account`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `users_account` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `users_id` int(11) DEFAULT NULL,
- `account` decimal(10,2) DEFAULT NULL,
- `name` varchar(50) DEFAULT NULL,
- PRIMARY KEY (`id`),
- KEY `fk_users_account_1_idx` (`users_id`),
- CONSTRAINT `fk_users_account_1` FOREIGN KEY (`users_id`) REFERENCES `users` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
- ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
-
- --
- -- Dumping data for table `users_account`
- --
-
- LOCK TABLES `users_account` WRITE;
- /*!40000 ALTER TABLE `users_account` DISABLE KEYS */;
- INSERT INTO `users_account` VALUES (1,7,123.46,'Main'),(2,6,121.00,'Test'),(3,NULL,NULL,NULL);
- /*!40000 ALTER TABLE `users_account` ENABLE KEYS */;
- UNLOCK TABLES;
-
- --
- -- Table structure for table `users_account_record`
- --
-
- DROP TABLE IF EXISTS `users_account_record`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `users_account_record` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `account_id` int(11) DEFAULT NULL,
- `source` varchar(50) DEFAULT NULL,
- `type` varchar(30) DEFAULT NULL,
- `time` datetime DEFAULT NULL,
- `detail` varchar(512) DEFAULT NULL COMMENT 'Transaction details',
- `chain_txid` varchar(50) DEFAULT NULL COMMENT 'Transaction id on block chain',
- `value` decimal(10,2) DEFAULT NULL,
- PRIMARY KEY (`id`),
- KEY `fk_users_account_record_1_idx` (`account_id`),
- CONSTRAINT `fk_users_account_record_1` FOREIGN KEY (`account_id`) REFERENCES `users_account` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
- ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
-
- --
- -- Dumping data for table `users_account_record`
- --
-
- LOCK TABLES `users_account_record` WRITE;
- /*!40000 ALTER TABLE `users_account_record` DISABLE KEYS */;
- INSERT INTO `users_account_record` VALUES (1,1,'Training',NULL,'2019-11-13 12:00:00','','',100.00),(2,1,'Training',NULL,'2019-11-11 12:00:00',NULL,NULL,50.00),(3,1,'Use',NULL,'2019-11-12 12:00:00',NULL,NULL,26.54);
- /*!40000 ALTER TABLE `users_account_record` ENABLE KEYS */;
- UNLOCK TABLES;
- /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
-
- /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
- /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
- /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
- /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
- /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
- /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
- /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-
- -- Dump completed on 2020-06-24 1:52:25
|