|
- CREATE DATABASE IF NOT EXISTS `pccb` /*!40100 DEFAULT CHARACTER SET utf8 */;
- USE `pccb`;
- -- MySQL dump 10.13 Distrib 5.7.27, for Linux (x86_64)
- --
- -- Host: 192.168.14.245 Database: pccb
- -- ------------------------------------------------------
- -- Server version 5.7.27-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 `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',
- `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=2 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','','http://sss.com','2019-11-11 00:16:45','2019-11-11 00:16:45',6,2,2,2,100);
- /*!40000 ALTER TABLE `algorithm` 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=6 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'),(5,'图片','这是图片','2019-11-12 02:06:58','2019-11-12 02:06:58');
- /*!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 '机器编号',
- 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=12 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,'test',1024,2,'/root/thgy','1.1','2019-11-09 22:04:28','2019-11-12 19:24:34',1),(2,'test1',1024,2,'http://sssdddfff.com','1.0','2019-11-12 01:00:34','2019-11-12 01:00:34',6),(3,'test2',2048,2,'http://uuu.com','1.0','2019-11-12 01:02:07','2019-11-12 01:02:07',1),(4,'test3',1024,4,'http://ooo.com','1.0','2019-11-12 01:03:33','2019-11-12 01:03:33',1),(5,'test4',1024,3,'http://ooo.com','1.0','2019-11-12 01:04:23','2019-11-12 01:04:23',1),(6,'test6',1024,3,'http://dasda.com','2.0','2019-11-12 01:08:59','2019-11-12 01:08:59',6),(7,'test7',10240,3,'http://jioj.com','1.1','2019-11-12 01:09:37','2019-11-12 01:09:37',6),(8,'testtt',1024,4,'http://dasidsajioa.com','2.0.1','2019-11-12 01:21:30','2019-11-12 01:21:30',6),(9,'testt',1024,3,'http://djasi.com','1.0.1','2019-11-12 01:23:11','2019-11-12 01:23:11',1),(10,'test10',1024,4,'http://jdiasoda.com','1.0','2019-11-12 01:24:59','2019-11-12 01:24:59',6),(11,'文本1',1024,4,'http://jjjii.com','1.0','2019-11-12 01:26:02','2019-11-12 01:26:02',6);
- /*!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(200) 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',
- `tflops_fp32` decimal(10,2) DEFAULT NULL COMMENT 'TFLOPS FP32 for GPU',
- `tflops_fp16` decimal(10,2) DEFAULT NULL COMMENT 'TFLOPS FP16 for GPU',
- 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,'thgy',4,4,16,102400,'192.168.14.245','2019-11-11 16:04:28','2019-11-11 16:04:28',1,NULL),(2,'测试1',4,4,16,102400,'192.168.14.246','2019-11-11 02:36:19','2019-11-11 02:36:19',1,NULL),(3,'测试二',4,4,16,102400,'192.168.14.247','2019-11-11 19:57:26','2019-11-11 19:57:26',6,NULL),(4,'测试三',NULL,NULL,NULL,NULL,NULL,'2019-11-11 19:58:31','2019-11-11 19:58:31',6,NULL),(5,'机器1',NULL,NULL,NULL,NULL,NULL,'2019-11-12 02:05:10','2019-11-12 02:05:10',1,NULL),(6,'机器2',NULL,NULL,NULL,NULL,NULL,'2019-11-12 02:05:15','2019-11-12 02:05:15',1,NULL),(7,'机器3',NULL,NULL,NULL,NULL,NULL,'2019-11-12 02:05:21','2019-11-12 02:05:21',6,NULL);
- /*!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=7 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 (1,'国防科大',4,6,'2019-11-10 21:05:10','2019-11-10 21:05:10'),(6,'计算中心',4,6,'2019-11-10 21:16:12','2019-11-10 21:16:12');
- /*!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.',
- `status` int(11) 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,
- 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=3 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 (2,'model1','1.0',1,NULL,'Example','2019-11-12 15:10:33','2019-11-12 15:10:33',6,2,1);
- /*!40000 ALTER TABLE `model` 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'),(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',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=2 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,'DEMO',1,'演示系统功能任务组,提供对真实训练数据的训练。');
- /*!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=15 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,1),(4,5,1),(5,1,2),(6,1,3),(7,8,1),(8,8,2),(9,9,1),(10,9,2),(11,9,3),(12,13,3),(13,13,4),(14,2,4);
- /*!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(5,2) DEFAULT NULL COMMENT '进展',
- `precision` float(5,2) 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 NULL 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=20 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,9.00,9.00,1,'2019-11-13 15:10:33','2019-11-13 15:10:33',1,1),(2,9.10,9.20,1,'2019-11-13 13:19:10','2019-11-13 13:19:13',2,1),(3,9.20,9.30,2,'2019-11-13 13:19:29','2019-11-13 13:19:32',1,1),(4,9.20,9.20,2,'2019-11-13 13:19:47','2019-11-13 13:19:50',2,1),(5,9.30,9.30,3,'2019-11-13 13:20:13','2019-11-13 13:20:15',1,1),(6,9.40,9.20,3,'2019-11-13 13:20:27','2019-11-13 13:20:29',2,1),(7,9.50,9.30,4,'2019-11-13 13:20:42','2019-11-13 13:20:44',1,1),(8,9.50,9.40,4,'2019-11-13 13:20:58','2019-11-13 13:21:00',2,1),(9,9.50,9.50,5,'2019-11-13 13:21:12','2019-11-13 13:21:16',1,1),(10,9.60,9.50,5,'2019-11-13 13:21:34','2019-11-13 13:21:31',2,1),(12,9.20,9.20,1,'2019-11-13 13:25:21','2019-11-13 13:25:18',NULL,1),(13,9.30,9.30,2,'2019-11-13 13:25:56','2019-11-13 13:26:00',NULL,1),(14,9.40,9.30,3,'2019-11-13 13:26:16','2019-11-13 13:26:18',NULL,1),(15,9.50,9.30,4,'2019-11-13 13:26:32','2019-11-13 13:26:35',NULL,1),(16,9.60,9.50,5,'2019-11-13 13:26:45','2019-11-13 13:26:47',NULL,1),(17,9.70,9.50,6,'2019-11-13 13:27:00','2019-11-13 13:27:02',1,1),(18,9.70,9.60,6,'2019-11-13 13:27:13','2019-11-13 13:27:15',2,1),(19,9.70,9.60,6,'2019-11-13 13:27:30','2019-11-13 13:27:32',NULL,1);
- /*!40000 ALTER TABLE `task_training_data` ENABLE KEYS */;
- UNLOCK TABLES;
-
- --
- -- Table structure for table `task_training_time`
- --
- DROP TABLE IF EXISTS `task_training_time`;
- CREATE TABLE `task_training_time` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `task_id` int(11) NOT NULL COMMENT '所训练任务',
- `task_group_id` int(11) NOT NULL COMMENT '所训练任务组',
- `round` int(11) NOT NULL COMMENT '所训练轮次',
- `pull_time` int(11) NULL COMMENT '拉取时间(ms)',
- `train_time` int(11) NULL COMMENT '训练时间(ms)',
- `communication_time` int(11) NULL COMMENT '通讯时间(ms)',
- PRIMARY KEY (`id`),
- UNIQUE INDEX `idx_task_train_time_key`(`task_id`, `round`) USING BTREE
- )ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8;
-
- --
- -- 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=3 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 (1,'TaskA',NULL,3,NULL,1,1,NULL,NULL,NULL,7,2,1),(2,'TaskB',NULL,3,NULL,1,2,NULL,NULL,NULL,6,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=6 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');
- /*!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',
- `phone_no` varchar(20) NOT NULL COMMENT 'Phone no.',
- `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)',
- PRIMARY KEY (`id`),
- UNIQUE KEY `phone_no_UNIQUE` (`phone_no`),
- 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=8 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,'cj@example.com','13787081615','ef797c8118f02dfb649607dd5d3f8c7623048c9c063d532cc95c5ed7a898a64f','2019-11-12 02:01:59','2019-11-12 02:01:59',4,'9b97c83e83bd0b1eb89739766bf46e1215f24067071375bbc394244b81f0b8bc'),(7,'ys@example.com','13787279073','959e124c7187cbedf4dac46873101167f95f6441d2539982872524f4006541b0','2019-11-12 02:02:41','2019-11-12 02:02:41',1,'ddc3a4aedc8b17c31a916a014fcc3ab0b433066d47d22673e7e927ccbe9aadd3');
- /*!40000 ALTER TABLE `users` 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 2019-11-13 14:21:28
|