G01_0350/sql/G01_0350.sql

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