-- MySQL dump 10.13  Distrib 5.5.62, for Win64 (AMD64)
--
-- Host: localhost    Database: cloud_factory
-- ------------------------------------------------------
-- Server version	8.0.25

/*!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 `t_bid`
--

DROP TABLE IF EXISTS `t_bid`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_bid` (
  `b_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `b_factory_id` bigint unsigned NOT NULL,
  `b_order_id` bigint unsigned NOT NULL,
  `b_price` decimal(10,2) NOT NULL,
  `b_accept_num` bigint unsigned NOT NULL,
  `b_win_num` bigint unsigned DEFAULT NULL,
  `b_bid_time` datetime NOT NULL,
  `b_state` varchar(100) NOT NULL,
  `b_win_time` datetime DEFAULT NULL,
  PRIMARY KEY (`b_id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='竞标';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_bid`
--

LOCK TABLES `t_bid` WRITE;
/*!40000 ALTER TABLE `t_bid` DISABLE KEYS */;
INSERT INTO `t_bid` VALUES (1,1,1,12.00,2,2,'2021-07-06 21:38:00','已中标','2021-07-06 22:20:00'),(12,1,2,0.50,10,NULL,'2021-07-19 02:50:31','未中标',NULL),(13,1,10,2.00,1,1,'2021-07-19 03:47:35','已中标','2021-07-19 04:54:16'),(14,28,2,4.58,10,10,'2021-07-19 03:58:04','已中标','2021-07-19 04:54:34'),(15,22,2,2.51,10,NULL,'2021-07-19 03:58:40','未中标',NULL),(16,1,8,2.08,10,NULL,'2021-07-19 12:39:54','已投标',NULL),(17,22,12,45.00,1,1,'2021-07-19 12:42:23','已中标','2021-07-19 12:43:18'),(18,1,14,152.12,15,NULL,'2021-07-19 19:38:07','未中标',NULL),(19,22,14,12.13,15,15,'2021-07-19 19:39:24','已中标','2021-07-19 19:40:16'),(20,1,15,10.56,10,10,'2021-07-19 20:59:32','已中标','2021-07-19 21:00:44'),(21,22,15,13.56,10,NULL,'2021-07-19 21:00:12','未中标',NULL),(22,1,16,15.02,5,5,'2021-07-20 09:03:56','已中标','2021-07-20 09:04:26'),(23,22,17,12.02,15,NULL,'2021-07-20 12:03:00','未中标',NULL),(24,1,17,13.56,15,15,'2021-07-20 12:03:23','已中标','2021-07-20 12:03:47');
/*!40000 ALTER TABLE `t_bid` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t_device`
--

DROP TABLE IF EXISTS `t_device`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_device` (
  `d_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `d_name` varchar(100) NOT NULL,
  `d_spec` varchar(100) NOT NULL,
  `d_describe` varchar(1000) NOT NULL,
  `d_state` varchar(100) NOT NULL,
  `d_dept_name` varchar(100) NOT NULL,
  `d_type_id` bigint unsigned NOT NULL,
  `d_factory_id` bigint unsigned DEFAULT NULL,
  `d_rent_rec_id` bigint unsigned DEFAULT NULL,
  PRIMARY KEY (`d_id`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='设备';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_device`
--

LOCK TABLES `t_device` WRITE;
/*!40000 ALTER TABLE `t_device` DISABLE KEYS */;
INSERT INTO `t_device` VALUES (1,'测试设备','规格','描述','闲置','中心',1,NULL,NULL),(2,'测试设备2','规格','描述','闲置','中心',1,NULL,1),(3,'测试设备3','规格','描述','开机','中心',1,NULL,2),(4,'测试设备4','规格','描述','开机','自有',3,1,NULL),(5,'测试设备5','gg','des','开机','自有',3,1,NULL),(7,'63','6664','66324','开机','中心',1,NULL,NULL),(8,'8','888','88','关机','中心',3,NULL,NULL),(9,'12333','1231','1233','开机','自有',1,1,NULL),(11,'my_device','spec','desc','关机','自有',1,22,NULL),(12,'r1','rr','rr','闲置','中心',1,NULL,21),(13,'r2','rr','rr','闲置','中心',1,NULL,NULL),(14,'r3','rrrr','rr','闲置','中心',1,NULL,NULL),(15,'rrr4','r','r','闲置','中心',1,NULL,NULL),(16,'rrr5','r','rr','闲置','中心',3,NULL,28),(17,'rrrrr6','r','rr','关机','中心',1,NULL,NULL),(18,'rrr7','r','rr','关机','中心',3,NULL,29),(25,'rrr8','spec','detail','闲置','中心',3,NULL,NULL),(26,'张岩自有','规格','自有','开机','自有',1,1,NULL),(27,'张岩租用','规格','描述','开机','中心',3,NULL,31);
/*!40000 ALTER TABLE `t_device` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t_device_capacity`
--

DROP TABLE IF EXISTS `t_device_capacity`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_device_capacity` (
  `c_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `c_device_id` bigint unsigned NOT NULL,
  `c_product_id` bigint unsigned NOT NULL,
  `c_num` bigint unsigned NOT NULL,
  PRIMARY KEY (`c_id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='设备产能';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_device_capacity`
--

LOCK TABLES `t_device_capacity` WRITE;
/*!40000 ALTER TABLE `t_device_capacity` DISABLE KEYS */;
INSERT INTO `t_device_capacity` VALUES (1,1,1,45),(2,2,1,234),(3,4,1,24),(4,1,2,12),(5,2,2,227),(6,3,2,12),(8,5,1,2),(9,5,7,5),(11,19,2,7),(12,11,7,114),(14,11,1,3),(15,18,7,4),(16,18,5,7),(18,26,1,10),(19,27,1,15);
/*!40000 ALTER TABLE `t_device_capacity` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t_device_type`
--

DROP TABLE IF EXISTS `t_device_type`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_device_type` (
  `dt_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `dt_name` varchar(100) NOT NULL,
  PRIMARY KEY (`dt_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='设备类型';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_device_type`
--

LOCK TABLES `t_device_type` WRITE;
/*!40000 ALTER TABLE `t_device_type` DISABLE KEYS */;
INSERT INTO `t_device_type` VALUES (1,'测试设备类型11'),(3,'23334');
/*!40000 ALTER TABLE `t_device_type` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t_factory`
--

DROP TABLE IF EXISTS `t_factory`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_factory` (
  `f_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `f_name` varchar(100) NOT NULL,
  `f_describe` varchar(1000) NOT NULL,
  `f_state` varchar(100) NOT NULL,
  PRIMARY KEY (`f_id`)
) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='工厂';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_factory`
--

LOCK TABLES `t_factory` WRITE;
/*!40000 ALTER TABLE `t_factory` DISABLE KEYS */;
INSERT INTO `t_factory` VALUES (1,'测试工厂','测试工厂描述','正常'),(22,'fac_name223','asff','正常'),(23,'fac_name23','desc','关停'),(24,'facname','desc','正常'),(25,'facname','desc','正常'),(26,'facname','desc','正常'),(27,'facname','desc','正常'),(28,'fac_name','desc','正常'),(29,'facname','desc','正常'),(30,'fac_name','desc','正常'),(34,'fac_name11','123','正常'),(42,'2435','34252','正常'),(46,'adsf','detail','关停');
/*!40000 ALTER TABLE `t_factory` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t_order`
--

DROP TABLE IF EXISTS `t_order`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_order` (
  `o_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `o_state` varchar(100) NOT NULL,
  `o_num` bigint unsigned NOT NULL,
  `o_receiver_name` varchar(100) NOT NULL,
  `o_receiver_tel` varchar(100) NOT NULL,
  `o_receiver_addr` varchar(100) NOT NULL,
  `o_deliver_date` date NOT NULL,
  `o_bid_end_date` date NOT NULL,
  `o_product_id` bigint unsigned NOT NULL,
  `o_user_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`o_id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='订单';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_order`
--

LOCK TABLES `t_order` WRITE;
/*!40000 ALTER TABLE `t_order` DISABLE KEYS */;
INSERT INTO `t_order` VALUES (1,'已生产',10,'name1','contact_here','COOL 1','2022-05-09','2022-05-07',2,13),(2,'已中标',10,'name','hh114514','COOL 2','2022-05-09','2022-05-07',1,13),(3,'未中标',5,'name1','con','addr','2020-07-30','2020-06-15',1,13),(4,'未中标',5,'name2','con2','addr','2020-06-30','2020-05-15',2,13),(5,'已发布',2,'接收人','1112223333','地球','2021-07-11','2021-07-09',1,13),(6,'已发布',2,'接收人','1112223333','地球','2021-07-11','2021-07-09',1,13),(7,'已发布',2,'接收人','1112223333','地球','2021-07-11','2021-07-09',1,13),(8,'已发布',10,'name','hh114514','COOL 33','2022-05-09','2022-05-07',5,13),(10,'已中标',1,'receiver_name','12','122','2021-07-28','2021-07-27',1,13),(12,'已完成',1,'my','mycon','myaddr','2021-07-25','2021-07-19',7,33),(13,'已发布',1,'rec','connnnn','adddreeeee','2021-07-27','2021-07-19',7,13),(14,'已完成',15,'name','conn','addrr','2021-07-28','2021-07-27',5,33),(15,'已完成',10,'ren','114514','address','2021-07-28','2021-07-27',7,13),(16,'已完成',5,'name','contact','addr','2021-07-29','2021-07-21',1,13),(17,'已完成',15,'张岩','11223333','地址','2021-07-28','2021-07-23',1,46);
/*!40000 ALTER TABLE `t_order` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t_product`
--

DROP TABLE IF EXISTS `t_product`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_product` (
  `p_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `p_name` varchar(100) NOT NULL,
  `p_spec` varchar(100) NOT NULL,
  `p_describe` varchar(1000) NOT NULL,
  `p_type_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`p_id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='产品';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_product`
--

LOCK TABLES `t_product` WRITE;
/*!40000 ALTER TABLE `t_product` DISABLE KEYS */;
INSERT INTO `t_product` VALUES (1,'测试产品','测试产品规格','测试产品描述',1),(2,'测试产品2','测试产品规格2a','测试产品描述22b',4),(5,'test_prod_3','spec','des',1),(7,'test_p_4','guige','dec',4);
/*!40000 ALTER TABLE `t_product` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t_product_type`
--

DROP TABLE IF EXISTS `t_product_type`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_product_type` (
  `pt_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `pt_name` varchar(100) NOT NULL,
  PRIMARY KEY (`pt_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='产品类型';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_product_type`
--

LOCK TABLES `t_product_type` WRITE;
/*!40000 ALTER TABLE `t_product_type` DISABLE KEYS */;
INSERT INTO `t_product_type` VALUES (1,'测试产品类型11'),(4,'产品类型22'),(6,'22454a');
/*!40000 ALTER TABLE `t_product_type` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t_rent_rec`
--

DROP TABLE IF EXISTS `t_rent_rec`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_rent_rec` (
  `r_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `r_rent_time` datetime NOT NULL,
  `r_expire_time` datetime NOT NULL,
  `r_recycle_time` datetime DEFAULT NULL,
  `r_device_id` bigint unsigned NOT NULL,
  `r_factory_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`r_id`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='租用记录';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_rent_rec`
--

LOCK TABLES `t_rent_rec` WRITE;
/*!40000 ALTER TABLE `t_rent_rec` DISABLE KEYS */;
INSERT INTO `t_rent_rec` VALUES (1,'2021-07-06 13:27:12','2021-07-09 13:27:12',NULL,2,1),(2,'2021-07-06 13:29:12','2021-07-09 13:29:12',NULL,3,1),(14,'2021-07-01 22:35:00','2021-07-06 22:35:00','2021-07-18 16:39:23',1,22),(20,'2021-07-18 16:06:26','2021-07-20 16:00:00','2021-07-18 16:15:50',19,1),(21,'2021-07-18 16:08:40','2021-07-21 16:00:00',NULL,12,1),(22,'2021-07-18 16:08:54','2021-07-19 16:00:00','2021-07-19 20:36:50',17,1),(23,'2021-07-18 16:16:22','2021-07-20 16:00:00','2021-07-18 16:16:36',19,1),(24,'2021-07-18 16:21:04','2021-07-18 16:00:00','2021-07-18 16:21:16',8,22),(25,'2021-07-19 12:44:40','2021-07-20 16:00:00','2021-07-19 12:44:50',19,22),(26,'2021-07-19 16:58:35','2021-07-28 16:00:00','2021-07-19 18:13:17',19,22),(27,'2021-07-19 17:01:04','2021-07-22 06:00:00','2021-07-19 19:59:31',18,22),(28,'2021-07-19 18:13:15','2021-07-21 00:00:00',NULL,16,22),(29,'2021-07-19 19:59:40','2021-07-20 00:00:00',NULL,18,22),(30,'2021-07-19 21:02:41','2021-07-30 00:00:00','2021-07-19 21:05:56',17,1),(31,'2021-07-20 12:05:33','2021-07-30 00:00:00',NULL,27,1);
/*!40000 ALTER TABLE `t_rent_rec` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t_schedule`
--

DROP TABLE IF EXISTS `t_schedule`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_schedule` (
  `s_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `s_start_time` datetime NOT NULL,
  `s_end_time` datetime NOT NULL,
  `s_device_id` bigint unsigned NOT NULL,
  `s_bid_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`s_id`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='排产计划';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_schedule`
--

LOCK TABLES `t_schedule` WRITE;
/*!40000 ALTER TABLE `t_schedule` DISABLE KEYS */;
INSERT INTO `t_schedule` VALUES (1,'2021-07-06 22:35:00','2021-07-11 22:36:01',1,2),(2,'2021-07-13 22:35:00','2021-07-16 22:36:01',1,15),(21,'2021-07-21 00:00:00','2021-07-22 00:00:00',18,17),(22,'2021-07-22 00:00:00','2021-07-27 00:00:00',18,19),(24,'2021-07-20 00:00:00','2021-07-26 00:00:00',5,20),(25,'2021-07-21 00:00:00','2021-07-27 00:00:00',17,20),(26,'2021-07-21 00:00:00','2021-07-22 00:00:00',4,22),(27,'2021-07-21 00:00:00','2021-07-22 00:00:00',3,1),(28,'2021-07-22 00:00:00','2021-07-23 00:00:00',26,24),(29,'2021-07-21 00:00:00','2021-07-23 00:00:00',27,24),(30,'2021-07-24 00:00:00','2021-07-27 00:00:00',26,24);
/*!40000 ALTER TABLE `t_schedule` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t_user`
--

DROP TABLE IF EXISTS `t_user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_user` (
  `u_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `u_username` varchar(100) NOT NULL,
  `u_password` varchar(100) NOT NULL,
  `u_name` varchar(100) NOT NULL,
  `u_contact` varchar(100) NOT NULL,
  `u_type` varchar(100) NOT NULL,
  `u_factory_id` bigint unsigned DEFAULT NULL,
  PRIMARY KEY (`u_id`),
  UNIQUE KEY `t_user_UN` (`u_username`)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='用户';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_user`
--

LOCK TABLES `t_user` WRITE;
/*!40000 ALTER TABLE `t_user` DISABLE KEYS */;
INSERT INTO `t_user` VALUES (1,'admin','admin','admin2','admin3','超级管理员',NULL),(12,'113','12','name','con','云工厂管理员',22),(13,'11','22','name','con','经销商',NULL),(14,'114','22','name','con','云工厂管理员',23),(20,'acco','pass','name','contact','云工厂管理员',28),(21,'account','pass','name','contact','云工厂管理员',29),(22,'1141','22','name','con','云工厂管理员',30),(23,'name123','123','1233','fdas1','云工厂管理员',34),(31,'45','435','44','44','云工厂管理员',1),(32,'23','2345','4235','2345','云工厂管理员',42),(33,'sad','asd','asd','sad1','经销商',NULL),(34,'dsftest','sd','dsag','asdf','经销商',NULL),(42,'1131','113','name','con','云工厂管理员',46),(43,'admin1','admin','admin','admin','经销商',NULL),(46,'张岩','123','张岩','123','经销商',NULL);
/*!40000 ALTER TABLE `t_user` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping routines for database 'cloud_factory'
--
/*!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-07-28 10:29:58