-- MySQL dump 10.13 Distrib 8.0.26, for Win64 (x86_64) -- -- Host: localhost Database: G01_0350 -- ------------------------------------------------------ -- Server version 8.0.26 /*!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 */; /*!50503 SET NAMES utf8mb4 */; /*!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 `order_tbl` -- DROP TABLE IF EXISTS `order_tbl`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `order_tbl` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `order_num` varchar(30) NOT NULL, `product_idx` int NOT NULL, `product_name` varchar(30) NOT NULL, `batch` varchar(10) NOT NULL, `team` varchar(2) NOT NULL, `ok` int NOT NULL, `ng` int NOT NULL, `targe` int NOT NULL, `snp` int NOT NULL, `begin_time` bigint NOT NULL, `end_time` bigint DEFAULT NULL, `stat` tinyint(1) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `order_tbl` -- LOCK TABLES `order_tbl` WRITE; /*!40000 ALTER TABLE `order_tbl` DISABLE KEYS */; INSERT INTO `order_tbl` VALUES (1,'2GN20211008095506A01',0,'17700 20-31PA-H020-M','LX08','A',13,1,14,0,1633658109,1633747618,1),(2,'2GN20211009104653A01',0,'17700-TLA-X010','LX09','A',8,0,8,0,1633747618,1633920025,1),(3,'2GN20211011104019A01',0,'17700-TLA-X010','LX11','A',2,0,2,0,1633920025,NULL,0); /*!40000 ALTER TABLE `order_tbl` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `product_data_tbl` -- DROP TABLE IF EXISTS `product_data_tbl`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `product_data_tbl` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `batch` varchar(20) NOT NULL, `serial` varchar(20) NOT NULL, `product_name` varchar(30) NOT NULL, `testok` tinyint(1) NOT NULL, `data_17700` varchar(50) NOT NULL, `data_17720` varchar(50) NOT NULL, `team` varchar(2) NOT NULL, `tester` varchar(10) NOT NULL, `begin_time` bigint NOT NULL, `end_time` bigint NOT NULL, `stat` tinyint(1) NOT NULL, PRIMARY KEY (`id`), KEY `batch_index` (`batch`(12)) ) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `product_data_tbl` -- LOCK TABLES `product_data_tbl` WRITE; /*!40000 ALTER TABLE `product_data_tbl` DISABLE KEYS */; INSERT INTO `product_data_tbl` VALUES (1,'2GNLX080001A','2021100800001','17700 20-31PA-H020-M',1,'<02>:0.200 MPa:(OK):0.084 ml/min','<02>:0.500 MPa:(OK):0.259 ml/min','A','tester',1633659014,1633659086,1),(2,'2GNLX080002A','2021100800002','17700 20-31PA-H020-M',1,'<02>:0.200 MPa:(OK):-0.060 ml/min','<02>:0.500 MPa:(OK):0.053 ml/min','A','tester',1633659430,1633659536,1),(3,'2GNLX080003A','2021100800003','17700 20-31PA-H020-M',1,'<02>:0.200 MPa:(OK):-0.060 ml/min','<02>:0.500 MPa:(OK):0.107 ml/min','A','tester',1633659843,1633659863,1),(4,'NULL','2021100800004','17700 20-31PA-H020-M',0,'NULL','NULL','A','tester',1633660051,1633660051,1),(5,'2GNLX080004A','2021100800005','17700 20-31PA-H020-M',1,'<02>:0.200 MPa:(OK):0.084 ml/min','<02>:0.500 MPa:(OK):0.097 ml/min','A','tester',1633660139,1633660165,1),(6,'2GNLX080005A','2021100800006','17700 20-31PA-H020-M',1,'<02>:0.200 MPa:(OK):0.109 ml/min','<02>:0.500 MPa:(OK):0.215 ml/min','A','tester',1633660595,1633660602,1),(7,'2GNLX080006A','2021100800007','17700 20-31PA-H020-M',1,'<02>:0.200 MPa:(OK):-0.085 ml/min','<02>:0.500 MPa:(OK):0.039 ml/min','A','tester',1633660719,1633660728,1),(8,'2GNLX080007A','2021100800008','17700 20-31PA-H020-M',1,'<02>:0.200 MPa:(OK):0.016 ml/min','<02>:0.499 MPa:(OK):0.141 ml/min','A','tester',1633660814,1633660822,1),(9,'2GNLX080008A','2021100800009','17700 20-31PA-H020-M',1,'<02>:0.200 MPa:(OK):0.042 ml/min','<02>:0.499 MPa:(OK):0.195 ml/min','A','tester',1633661056,1633661063,1),(10,'2GNLX080009A','2021100800010','17700 20-31PA-H020-M',1,'<02>:0.200 MPa:(OK):-0.068 ml/min','<02>:0.500 MPa:(OK):0.122 ml/min','A','tester',1633661224,1633661231,1),(11,'2GNLX080010A','2021100800011','17700 20-31PA-H020-M',1,'<02>:0.200 MPa:(OK):0.016 ml/min','<02>:0.500 MPa:(OK):0.171 ml/min','A','tester',1633662707,1633662716,1),(12,'2GNLX080011A','2021100800012','17700 20-31PA-H020-M',1,'<02>:0.200 MPa:(OK):0.008 ml/min','<02>:0.499 MPa:(OK):0.156 ml/min','A','tester',1633663308,1633663317,1),(13,'2GNLX080012A','2021100800013','17700 20-31PA-H020-M',1,'<02>:0.200 MPa:(OK):-0.043 ml/min','<02>:0.500 MPa:(OK):0.068 ml/min','A','tester',1633663731,1633663783,1),(14,'2GNLX080013A','2021100800014','17700 20-31PA-H020-M',1,'<02>:0.211 MPa:(OK):0.015 ml/min','<02>:0.520 MPa:(OK):0.210 ml/min','A','tester',1633678504,1633678512,1),(15,'NULL','2021100800015','17700 20-31PA-H020-M',0,'NULL','NULL','A','tester',1633678552,1633678552,0),(16,'2GNLX090001A','2021100900001','17750-31PA-H020-M1',1,'<02>:0.210 MPa:(OK):0.190 ml/min','<02>:0.520 MPa:(OK):0.371 ml/min','A','tester',1633748095,1633748103,1),(17,'2GNLX090002A','2021100900002','17750-31PA-H020-M1',1,'<02>:0.210 MPa:(OK):-0.016 ml/min','<02>:0.520 MPa:(OK):0.127 ml/min','A','tester',1633759064,1633759072,1),(18,'2GNLX090003A','2021100900003','17750-31PA-H020-M1',1,'<02>:0.210 MPa:(OK):-0.069 ml/min','<02>:0.520 MPa:(OK):-0.005 ml/min','A','tester',1633759109,1633759230,1),(19,'2GNLX090004A','2021100900004','17750-31PA-H020-M1',1,'<02>:0.210 MPa:(OK):-0.069 ml/min','<02>:0.520 MPa:(OK):-0.005 ml/min','A','tester',1633759230,1633759231,1),(20,'2GNLX090005A','2021100900005','17750-31PA-H020-M1',1,'<02>:0.210 MPa:(OK):-0.069 ml/min','<02>:0.520 MPa:(OK):-0.005 ml/min','A','tester',1633759231,1633759232,1),(21,'2GNLX090006A','2021100900006','17750-31PA-H020-M1',1,'<02>:0.210 MPa:(OK):-0.069 ml/min','<02>:0.520 MPa:(OK):-0.005 ml/min','A','tester',1633759232,1633759234,1),(22,'2GNLX090007A','2021100900007','17750-31PA-H020-M1',1,'<02>:0.210 MPa:(OK):-0.069 ml/min','<02>:0.520 MPa:(OK):-0.005 ml/min','A','tester',1633759234,1633759235,1),(23,'2GNLX090008A','2021100900008','17750-31PA-H020-M1',1,'<02>:0.210 MPa:(OK):-0.069 ml/min','<02>:0.520 MPa:(OK):-0.005 ml/min','A','tester',1633759235,1633759236,1),(24,'NULL','2021100900009','17750-31PA-H020-M1',0,'NULL','NULL','A','tester',1633759237,1633759237,0),(25,'2GNLX110001A','2021101100001','17750-31PA-H020-M1',1,'<02>:0.209 MPa:(OK):0.045 ml/min','<02>:0.521 MPa:(OK):0.229 ml/min','A','tester',1633931879,1633931887,1),(26,'2GNLX110002A','2021101100002','17750-31PA-H020-M1',1,'<02>:0.209 MPa:(OK):-0.008 ml/min','<02>:0.520 MPa:(OK):0.087 ml/min','A','tester',1633931985,1633931995,1); /*!40000 ALTER TABLE `product_data_tbl` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `product_param_tbl` -- DROP TABLE IF EXISTS `product_param_tbl`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `product_param_tbl` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `product_idx` int NOT NULL, `product_name` varchar(30) NOT NULL, `param_type` int NOT NULL, `startuptime` varchar(10) DEFAULT NULL, `airtime` varchar(10) DEFAULT NULL, `presstime` varchar(10) DEFAULT NULL, `testtime` varchar(10) DEFAULT NULL, `exhaust` varchar(10) DEFAULT NULL, `maxpress` varchar(10) DEFAULT NULL, `minpress` varchar(10) DEFAULT NULL, `setpress` varchar(10) DEFAULT NULL, `capacity` varchar(10) DEFAULT NULL, `posthreshold` varchar(10) DEFAULT NULL, `pnegthreshold` varchar(10) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `product_param_tbl` -- LOCK TABLES `product_param_tbl` WRITE; /*!40000 ALTER TABLE `product_param_tbl` DISABLE KEYS */; INSERT INTO `product_param_tbl` VALUES (1,1,'17700 20-31PA-H020-M',17700,'0','0','0','0','0','0','0','0','0','0','0'),(2,1,'17700 20-31PA-H020-M',17720,'0','0','0','0','0','0','0','0','0','0','0'),(3,1,'17700-TLA-X010',17700,'0','0','0','0','0','0','0','0','0','0','0'),(4,1,'17700-TLA-X010',17720,'0','0','0','0','0','0','0','0','0','0','0'),(5,0,'17750-31PA-H020-M1',17700,'0','8','20','10','1','600','0','500','105','0.5','-0.5'),(6,0,'17750-31PA-H020-M1',17720,'0','8','20','10','1','250','0','200','105','0.1','-0.1'); /*!40000 ALTER TABLE `product_param_tbl` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `product_tbl` -- DROP TABLE IF EXISTS `product_tbl`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `product_tbl` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `product_idx` int NOT NULL, `product_name` varchar(30) NOT NULL, `17700_name` varchar(30) NOT NULL, `17720_name` varchar(30) NOT NULL, `stat` tinyint(1) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `product_tbl` -- LOCK TABLES `product_tbl` WRITE; /*!40000 ALTER TABLE `product_tbl` DISABLE KEYS */; INSERT INTO `product_tbl` VALUES (1,0,'17750-31PA-H020-M1','17700-31PA','17720-31PA',1); /*!40000 ALTER TABLE `product_tbl` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `user_tbl` -- DROP TABLE IF EXISTS `user_tbl`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `user_tbl` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `name` varchar(20) NOT NULL, `password` varchar(100) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `user_tbl` -- LOCK TABLES `user_tbl` WRITE; /*!40000 ALTER TABLE `user_tbl` DISABLE KEYS */; INSERT INTO `user_tbl` VALUES (1,'admin','123456'); /*!40000 ALTER TABLE `user_tbl` 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 2021-10-11 17:55:34