end-of-software-architecture-assignment
/
shop.sql

-- MySQL dump 10.13  Distrib 8.0.30, for Win64 (x86_64)
--
-- Host: 127.0.0.1    Database: shop
-- ------------------------------------------------------
-- Server version	8.0.30

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

DROP TABLE IF EXISTS `business`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `business` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `create_time` datetime(6) NOT NULL,
  `update_time` datetime(6) DEFAULT NULL,
  `deleted_time` datetime(6) DEFAULT NULL,
  `is_deleted` int NOT NULL DEFAULT '0',
  `name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `business`
--

LOCK TABLES `business` WRITE;
/*!40000 ALTER TABLE `business` DISABLE KEYS */;
INSERT INTO `business` VALUES (4,'2023-01-04 18:10:11.000000','2023-01-04 18:10:15.000000',NULL,0,'xyc');
/*!40000 ALTER TABLE `business` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `customer`
--

DROP TABLE IF EXISTS `customer`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `customer` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `create_time` datetime(6) NOT NULL,
  `update_time` datetime(6) DEFAULT NULL,
  `deleted_time` datetime(6) DEFAULT NULL,
  `is_deleted` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `customer`
--

LOCK TABLES `customer` WRITE;
/*!40000 ALTER TABLE `customer` DISABLE KEYS */;
INSERT INTO `customer` VALUES (3,'2023-01-08 20:44:56.000000','2023-01-08 20:45:00.000000',NULL,0);
/*!40000 ALTER TABLE `customer` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `item`
--

DROP TABLE IF EXISTS `item`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `item` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `create_time` datetime(6) NOT NULL,
  `update_time` datetime(6) DEFAULT NULL,
  `deleted_time` datetime(6) DEFAULT NULL,
  `is_deleted` int NOT NULL DEFAULT '0',
  `name` varchar(255) DEFAULT NULL,
  `price` double NOT NULL,
  `line_item_id` bigint DEFAULT NULL,
  PRIMARY KEY (`Id`),
  KEY `FK99dea9pgxhbq69c4kkva59o3y` (`line_item_id`),
  CONSTRAINT `FK99dea9pgxhbq69c4kkva59o3y` FOREIGN KEY (`line_item_id`) REFERENCES `line_item` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `item`
--

LOCK TABLES `item` WRITE;
/*!40000 ALTER TABLE `item` DISABLE KEYS */;
INSERT INTO `item` VALUES (1,'2023-01-06 22:20:52.638000','2023-01-06 22:20:52.638000',NULL,0,'衣服',100,NULL),(3,'2023-01-06 22:22:37.059000','2023-01-06 22:22:37.059000',NULL,0,'鸿星尔克运动鞋',300,NULL),(4,'2023-01-06 22:23:14.183000','2023-01-06 22:23:14.183000',NULL,0,'香水',500,NULL),(5,'2023-01-06 22:44:31.902000','2023-01-06 22:44:31.902000',NULL,0,'洗面奶',120,NULL),(6,'2023-01-06 23:35:00.594000','2023-01-06 23:35:00.594000',NULL,0,'蚕丝皂',150,NULL),(7,'2023-01-09 22:38:22.000000','2023-01-09 22:38:26.000000',NULL,0,'哇哈哈',20,NULL),(8,'2023-01-09 22:46:23.482000','2023-01-09 22:46:23.482000',NULL,0,'七匹狼',20,NULL),(9,'2023-01-09 22:46:46.363000','2023-01-09 22:46:46.363000',NULL,0,'花露水',30,NULL),(10,'2023-01-09 22:47:07.819000','2023-01-09 22:47:07.819000',NULL,0,'围巾',66,NULL);
/*!40000 ALTER TABLE `item` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `line_item`
--

DROP TABLE IF EXISTS `line_item`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `line_item` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `create_time` datetime(6) NOT NULL,
  `update_time` datetime(6) DEFAULT NULL,
  `deleted_time` datetime(6) DEFAULT NULL,
  `is_deleted` int NOT NULL DEFAULT '0',
  `order_id` int NOT NULL,
  `quantity` double DEFAULT NULL,
  `item_id` int NOT NULL,
  `price` double DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FKktf4dtpwa1ndqmjit4qir1fsi` (`item_id`),
  KEY `FKlfuo9o3keu9a7mlxumaqoylgu` (`order_id`),
  CONSTRAINT `FKktf4dtpwa1ndqmjit4qir1fsi` FOREIGN KEY (`item_id`) REFERENCES `item` (`Id`),
  CONSTRAINT `FKlfuo9o3keu9a7mlxumaqoylgu` FOREIGN KEY (`order_id`) REFERENCES `orders` (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `line_item`
--

LOCK TABLES `line_item` WRITE;
/*!40000 ALTER TABLE `line_item` DISABLE KEYS */;
INSERT INTO `line_item` VALUES (1,'2023-01-07 11:24:46.000000','2023-01-07 11:24:50.000000',NULL,0,1,2,5,120),(2,'2023-01-09 02:11:04.000000','2023-01-09 02:11:08.000000',NULL,0,1,1,1,100);
/*!40000 ALTER TABLE `line_item` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `orders`
--

DROP TABLE IF EXISTS `orders`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `orders` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `create_time` datetime(6) NOT NULL,
  `update_time` datetime(6) DEFAULT NULL,
  `deleted_time` datetime(6) DEFAULT NULL,
  `is_deleted` int NOT NULL DEFAULT '0',
  `status` int DEFAULT NULL,
  `customer_id` bigint DEFAULT NULL,
  `shop_id` int DEFAULT NULL,
  PRIMARY KEY (`Id`),
  UNIQUE KEY `orders_Id_uindex` (`Id`),
  KEY `FK14n2jkmoyhpimhracvcdy7sst` (`customer_id`),
  KEY `FKqn03kko0738sehaal2gr2uxl6` (`shop_id`),
  CONSTRAINT `FKqn03kko0738sehaal2gr2uxl6` FOREIGN KEY (`shop_id`) REFERENCES `shop` (`Id`),
  CONSTRAINT `FKsjfs85qf6vmcurlx43cnc16gy` FOREIGN KEY (`customer_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `orders`
--

LOCK TABLES `orders` WRITE;
/*!40000 ALTER TABLE `orders` DISABLE KEYS */;
INSERT INTO `orders` VALUES (1,'2023-01-06 23:44:32.951000','2023-01-06 23:44:32.951000',NULL,0,0,1,1),(2,'2023-01-06 23:48:09.966000','2023-01-06 23:48:09.966000',NULL,0,0,1,1),(3,'2023-01-06 23:48:41.282000','2023-01-06 23:48:41.282000',NULL,0,0,1,1),(5,'2023-01-08 21:05:12.772000','2023-01-08 21:05:12.772000',NULL,0,0,1,1),(6,'2023-01-08 22:01:59.885000','2023-01-08 22:01:59.885000',NULL,0,0,1,1),(7,'2023-01-08 22:04:31.626000','2023-01-09 01:25:24.077000',NULL,0,0,1,1);
/*!40000 ALTER TABLE `orders` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `shop`
--

DROP TABLE IF EXISTS `shop`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `shop` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `create_time` datetime(6) NOT NULL,
  `update_time` datetime(6) DEFAULT NULL,
  `deleted_time` datetime(6) DEFAULT NULL,
  `is_deleted` int NOT NULL DEFAULT '0',
  `name` varchar(255) DEFAULT NULL,
  `business_id` bigint DEFAULT NULL,
  PRIMARY KEY (`Id`),
  KEY `FK2h5hv23h3it2mermnwg1qldf9` (`business_id`),
  CONSTRAINT `FK1fy11o1gnuwuv9j1litc5yqn5` FOREIGN KEY (`business_id`) REFERENCES `user` (`id`),
  CONSTRAINT `FK2h5hv23h3it2mermnwg1qldf9` FOREIGN KEY (`business_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `shop`
--

LOCK TABLES `shop` WRITE;
/*!40000 ALTER TABLE `shop` DISABLE KEYS */;
INSERT INTO `shop` VALUES (1,'2023-01-04 19:01:10.996000','2023-01-04 19:01:10.996000',NULL,0,'一号铺',4),(2,'2023-01-06 22:05:01.834000','2023-01-06 22:05:01.834000',NULL,0,'二号铺',NULL),(3,'2023-01-06 22:14:26.205000','2023-01-06 22:14:26.205000',NULL,0,'三号铺',4),(4,'2023-01-07 23:39:42.135000','2023-01-07 23:39:42.135000',NULL,0,'四号铺',4);
/*!40000 ALTER TABLE `shop` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `shop_item`
--

DROP TABLE IF EXISTS `shop_item`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `shop_item` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `create_time` datetime(6) NOT NULL,
  `update_time` datetime(6) DEFAULT NULL,
  `deleted_time` datetime(6) DEFAULT NULL,
  `is_deleted` int NOT NULL DEFAULT '0',
  `name` varchar(255) DEFAULT NULL,
  `price` double DEFAULT NULL,
  `status` int DEFAULT NULL,
  `item_id` bigint DEFAULT NULL,
  `shop_id` bigint DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `shop_item`
--

LOCK TABLES `shop_item` WRITE;
/*!40000 ALTER TABLE `shop_item` DISABLE KEYS */;
INSERT INTO `shop_item` VALUES (1,'2023-01-06 22:45:04.083000','2023-01-06 22:45:04.083000',NULL,0,'洗面奶',120,0,5,1),(2,'2023-01-06 22:45:04.152000','2023-01-06 22:45:04.152000',NULL,0,'洗面奶',120,0,5,1),(3,'2023-01-07 23:45:23.951000','2023-01-07 23:45:23.951000',NULL,0,'洗面奶',120,0,5,1);
/*!40000 ALTER TABLE `shop_item` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `user`
--

DROP TABLE IF EXISTS `user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `user` (
  `type` int NOT NULL,
  `id` bigint NOT NULL AUTO_INCREMENT,
  `create_time` datetime(6) NOT NULL,
  `update_time` datetime(6) DEFAULT NULL,
  `deleted_time` datetime(6) DEFAULT NULL,
  `is_deleted` int NOT NULL DEFAULT '0',
  `password` varchar(255) DEFAULT NULL,
  `username` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `user`
--

LOCK TABLES `user` WRITE;
/*!40000 ALTER TABLE `user` DISABLE KEYS */;
INSERT INTO `user` VALUES (1,3,'2023-01-04 16:04:17.000000','2023-01-04 16:04:23.000000',NULL,0,'123456','hsw','hsw'),(2,4,'2023-01-04 18:01:56.000000','2023-01-04 18:01:59.000000',NULL,0,'123456','xyc','xyc');
/*!40000 ALTER TABLE `user` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `users` (
  `type` varchar(31) NOT NULL,
  `id` bigint NOT NULL AUTO_INCREMENT,
  `create_time` datetime(6) NOT NULL,
  `update_time` datetime(6) DEFAULT NULL,
  `deleted_time` datetime(6) DEFAULT NULL,
  `is_deleted` int NOT NULL DEFAULT '0',
  `password` varchar(255) DEFAULT NULL,
  `username` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!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 ('1',1,'2023-01-04 18:00:13.551000','2023-01-04 18:00:13.551000',NULL,0,'123456xyc','xyc',NULL),('2',4,'2023-01-04 19:00:32.000000','2023-01-04 19:00:39.000000',NULL,0,'123456','xyc','xyc'),('1',5,'2023-01-06 23:28:31.094000','2023-01-06 23:28:31.094000',NULL,0,'123456','hsw',NULL),('1',6,'2023-01-08 21:20:00.693000','2023-01-08 21:20:00.693000',NULL,0,'123456','cus',NULL);
/*!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 2023-01-09 23:13:58