text: -- MySQL dump 10.13  Distrib 8.0.22, for Win64 (x86_64)
  --
  -- Host: localhost    Database: oomall_other
  -- ------------------------------------------------------
  -- Server version	8.0.22
  
  /*!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 `address`
  --
  
  DROP TABLE IF EXISTS `address`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `address` (
    `id` bigint NOT NULL AUTO_INCREMENT,
    `customer_id` bigint DEFAULT NULL,
    `region_id` bigint DEFAULT NULL,
    `detail` varchar(500) DEFAULT NULL,
    `consignee` varchar(64) DEFAULT NULL,
    `mobile` varchar(128) DEFAULT NULL,
    `be_default` tinyint DEFAULT NULL,
    `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `gmt_modified` datetime DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `advertisement`
  --
  
  DROP TABLE IF EXISTS `advertisement`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `advertisement` (
    `id` bigint NOT NULL AUTO_INCREMENT,
    `seg_id` bigint DEFAULT NULL,
    `link` varchar(255) DEFAULT NULL,
    `content` varchar(500) DEFAULT NULL,
    `image_url` varchar(255) DEFAULT NULL,
    `state` tinyint DEFAULT NULL,
    `weight` int DEFAULT NULL,
    `begin_date` date DEFAULT NULL,
    `end_date` date DEFAULT NULL,
    `repeats` tinyint DEFAULT NULL,
    `message` varchar(500) DEFAULT NULL,
    `be_default` tinyint DEFAULT NULL,
    `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `gmt_modified` datetime DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=149 DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `aftersale_service`
  --
  
  DROP TABLE IF EXISTS `aftersale_service`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `aftersale_service` (
    `id` bigint NOT NULL AUTO_INCREMENT,
    `order_item_id` bigint DEFAULT NULL,
    `customer_id` bigint DEFAULT NULL,
    `shop_id` bigint DEFAULT NULL,
    `service_sn` varchar(128) DEFAULT NULL,
    `type` tinyint DEFAULT NULL,
    `reason` varchar(500) DEFAULT NULL,
    `conclusion` varchar(500) DEFAULT NULL,
    `refund` bigint DEFAULT NULL,
    `quantity` int DEFAULT NULL,
    `region_id` bigint DEFAULT NULL,
    `detail` varchar(500) DEFAULT NULL,
    `consignee` varchar(64) DEFAULT NULL,
    `mobile` varchar(128) DEFAULT NULL,
    `customer_log_sn` varchar(128) DEFAULT NULL,
    `shop_log_sn` varchar(128) DEFAULT NULL,
    `state` tinyint DEFAULT NULL,
    `be_deleted` tinyint DEFAULT NULL,
    `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `gmt_modified` datetime DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `be_share`
  --
  
  DROP TABLE IF EXISTS `be_share`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `be_share` (
    `id` bigint NOT NULL AUTO_INCREMENT,
    `goods_sku_id` bigint DEFAULT NULL,
    `sharer_id` bigint DEFAULT NULL,
    `share_id` bigint DEFAULT NULL,
    `customer_id` bigint DEFAULT NULL,
    `order_id` bigint DEFAULT NULL,
    `rebate` int DEFAULT NULL,
    `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `gmt_modified` datetime DEFAULT NULL,
    `share_activity_id` bigint DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=450533 DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- 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` bigint NOT NULL AUTO_INCREMENT,
    `user_name` varchar(32) DEFAULT NULL,
    `password` varchar(128) DEFAULT NULL,
    `real_name` varchar(32) DEFAULT NULL,
    `gender` tinyint DEFAULT NULL,
    `birthday` date DEFAULT NULL,
    `point` int DEFAULT NULL,
    `state` tinyint DEFAULT NULL,
    `email` varchar(128) DEFAULT NULL,
    `mobile` varchar(128) DEFAULT NULL,
    `be_deleted` tinyint DEFAULT NULL,
    `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `gmt_modified` datetime DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=17330 DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `favourite_goods`
  --
  
  DROP TABLE IF EXISTS `favourite_goods`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `favourite_goods` (
    `id` bigint NOT NULL AUTO_INCREMENT,
    `customer_id` bigint DEFAULT NULL,
    `goods_sku_id` bigint DEFAULT NULL,
    `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `gmt_modified` datetime DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=3833740 DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `foot_print`
  --
  
  DROP TABLE IF EXISTS `foot_print`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `foot_print` (
    `id` bigint NOT NULL AUTO_INCREMENT,
    `customer_id` bigint DEFAULT NULL,
    `goods_sku_id` bigint DEFAULT NULL,
    `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `gmt_modified` datetime DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=1245147 DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `region`
  --
  
  DROP TABLE IF EXISTS `region`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `region` (
    `id` bigint NOT NULL AUTO_INCREMENT,
    `pid` bigint DEFAULT NULL,
    `name` varchar(64) DEFAULT NULL,
    `postal_code` bigint DEFAULT NULL,
    `state` tinyint DEFAULT NULL,
    `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `gmt_modified` datetime DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `share`
  --
  
  DROP TABLE IF EXISTS `share`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `share` (
    `id` bigint NOT NULL AUTO_INCREMENT,
    `sharer_id` bigint DEFAULT NULL,
    `goods_sku_id` bigint DEFAULT NULL,
    `quantity` int DEFAULT NULL,
    `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `gmt_modified` datetime DEFAULT NULL,
    `share_activity_id` bigint DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=458697 DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `share_activity`
  --
  
  DROP TABLE IF EXISTS `share_activity`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `share_activity` (
    `id` bigint NOT NULL AUTO_INCREMENT,
    `shop_id` bigint DEFAULT NULL,
    `goods_sku_id` bigint DEFAULT NULL,
    `begin_time` datetime DEFAULT NULL,
    `end_time` datetime DEFAULT NULL,
    `strategy` varchar(500) DEFAULT NULL,
    `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `gmt_modified` datetime DEFAULT NULL,
    `state` tinyint DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=311259 DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `shopping_cart`
  --
  
  DROP TABLE IF EXISTS `shopping_cart`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `shopping_cart` (
    `id` bigint NOT NULL AUTO_INCREMENT,
    `customer_id` bigint DEFAULT NULL,
    `goods_sku_id` bigint DEFAULT NULL,
    `quantity` int DEFAULT NULL,
    `price` bigint DEFAULT NULL,
    `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `gmt_modified` datetime DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `time_segment`
  --
  
  DROP TABLE IF EXISTS `time_segment`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `time_segment` (
    `id` bigint NOT NULL AUTO_INCREMENT,
    `begin_time` datetime DEFAULT NULL,
    `end_time` datetime DEFAULT NULL,
    `type` tinyint DEFAULT NULL,
    `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `gmt_modified` datetime DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  /*!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 2020-12-07 21:49:07
  