软件工程各种图表.7z

-- MySQL dump 10.13 Distrib 8.0.31, for Win64 (x86_64) -- -- Host: 127.0.0.1 Database: dkd -- ------------------------------------------------------ -- Server version 8.0.31 /*!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 `gen_table` -- DROP TABLE IF EXISTS `gen_table`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `gen_table` ( `table_id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号', `table_name` varchar(200) DEFAULT '' COMMENT '表名称', `table_comment` varchar(500) DEFAULT '' COMMENT '表描述', `sub_table_name` varchar(64) DEFAULT NULL COMMENT '关联子表的表名', `sub_table_fk_name` varchar(64) DEFAULT NULL COMMENT '子表关联的外键名', `class_name` varchar(100) DEFAULT '' COMMENT '实体类名称', `tpl_category` varchar(200) DEFAULT 'crud' COMMENT '使用的模板（crud单表操作 tree树表操作）', `tpl_web_type` varchar(30) DEFAULT '' COMMENT '前端模板类型（element-ui模版 element-plus模版）', `package_name` varchar(100) DEFAULT NULL COMMENT '生成包路径', `module_name` varchar(30) DEFAULT NULL COMMENT '生成模块名', `business_name` varchar(30) DEFAULT NULL COMMENT '生成业务名', `function_name` varchar(50) DEFAULT NULL COMMENT '生成功能名', `function_author` varchar(50) DEFAULT NULL COMMENT '生成功能作者', `gen_type` char(1) DEFAULT '0' COMMENT '生成代码方式（0zip压缩包 1自定义路径）', `gen_path` varchar(200) DEFAULT '/' COMMENT '生成路径（不填默认项目路径）', `options` varchar(1000) DEFAULT NULL COMMENT '其它生成选项', `create_by` varchar(64) DEFAULT '' COMMENT '创建者', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `update_by` varchar(64) DEFAULT '' COMMENT '更新者', `update_time` datetime DEFAULT NULL COMMENT '更新时间', `remark` varchar(500) DEFAULT NULL COMMENT '备注', PRIMARY KEY (`table_id`) ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='代码生成业务表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `gen_table` -- LOCK TABLES `gen_table` WRITE; /*!40000 ALTER TABLE `gen_table` DISABLE KEYS */; INSERT INTO `gen_table` VALUES (1,'tb_node','点位表',NULL,NULL,'Node','crud','element-plus','com.dkd.manage','manage','node','点位管理','itheima','0','/','{\"parentMenuId\":2000}','admin','2024-06-05 11:11:35','','2024-06-05 11:32:17',NULL),(2,'tb_partner','合作商表',NULL,NULL,'Partner','crud','element-plus','com.dkd.manage','manage','partner','合作商管理','itheima','0','/','{\"parentMenuId\":2000}','admin','2024-06-05 11:11:35','','2024-06-05 11:22:11',NULL),(3,'tb_region','区域表',NULL,NULL,'Region','crud','element-plus','com.dkd.manage','manage','region','区域管理','itheima','0','/','{\"parentMenuId\":2000}','admin','2024-06-05 11:11:35','','2024-06-05 11:17:53',NULL),(4,'tb_emp','工单员工表',NULL,NULL,'Emp','crud','element-plus','com.dkd.manage','manage','emp','人员列表','itheima','0','/','{\"parentMenuId\":2019}','admin','2024-06-15 10:21:43','','2024-06-15 10:31:17',NULL),(5,'tb_role','工单角色表',NULL,NULL,'Role','crud','element-plus','com.dkd.manage','manage','role','工单角色','itheima','0','/','{\"parentMenuId\":2019}','admin','2024-06-15 10:21:50','','2024-06-15 10:32:52',NULL),(6,'tb_vending_machine','设备表',NULL,NULL,'VendingMachine','crud','element-plus','com.dkd.manage','manage','vm','设备管理','itheima','0','/','{\"parentMenuId\":2026}','admin','2024-06-21 10:36:16','','2024-06-21 11:00:39',NULL),(7,'tb_vm_type','设备类型表',NULL,NULL,'VmType','crud','element-plus','com.dkd.manage','manage','vmType','设备类型管理','itheima','0','/','{\"parentMenuId\":2026}','admin','2024-06-21 10:36:16','','2024-06-21 10:45:07',NULL),(8,'tb_channel','售货机货道表',NULL,NULL,'Channel','crud','element-plus','com.dkd.manage','manage','channel','售货机货道','itheima','0','/','{\"parentMenuId\":2026}','admin','2024-06-21 10:37:22','','2024-06-21 11:03:08',NULL),(9,'tb_policy','策略表',NULL,NULL,'Policy','crud','element-plus','com.dkd.manage','manage','policy','策略管理','itheima','0','/','{\"parentMenuId\":2042}','admin','2024-07-12 09:44:48','','2024-07-12 09:48:14',NULL),(10,'tb_sku_class','商品类型表',NULL,NULL,'SkuClass','crud','element-plus','com.dkd.manage','manage','skuClass','商品类型','itheima','0','/','{\"parentMenuId\":\"2049\"}','admin','2024-07-15 11:10:11','','2024-07-15 15:37:29',NULL),(11,'tb_sku','商品表',NULL,NULL,'Sku','crud','element-plus','com.dkd.manage','manage','sku','商品管理','itheima','0','/','{\"parentMenuId\":2049}','admin','2024-07-15 11:10:23','','2024-07-15 11:23:07',NULL),(12,'tb_task','工单表',NULL,NULL,'Task','crud','element-plus','com.dkd.manage','manage','task','工单','itheima','0','/','{\"parentMenuId\":2062}','admin','2024-07-24 10:27:08','','2024-07-24 10:31:16',NULL),(13,'tb_task_details','工单详情，只有补货工单才有',NULL,NULL,'TaskDetails','crud','element-plus','com.dkd.manage','manage','taskDeatils','工单详情','itheima','0','/','{\"parentMenuId\":2062}','admin','2024-07-24 10:27:08','','2024-07-24 10:33:25',NULL),(14,'tb_task_type','工单类型',NULL,NULL,'TaskType','crud','element-plus','com.dkd.manage','manage','taskType','工单类型','itheima','0','/','{\"parentMenuId\":2062}','admin','2024-07-24 10:27:08','','2024-07-24 10:34:36',NULL),(15,'tb_job','自动补货任务',NULL,NULL,'Job','crud','element-plus','com.dkd.manage','manage','job','自动补货任务','itheima','0','/','{\"parentMenuId\":2062}','admin','2024-07-24 10:27:33','','2024-07-24 10:35:49',NULL),(16,'tb_order','订单表',NULL,NULL,'Order','crud','element-plus','com.dkd.manage','manage','order','订单管理','itheima','0','/','{\"parentMenuId\":2067}','admin','2024-08-01 10:15:02','','2024-08-01 10:15:27',NULL),(19,'tb_task_collect','工单按日统计表',NULL,NULL,'TaskCollect','crud','','com.dkd.manage','manage','collect','工单按日统计','itheima','0','/',NULL,'admin','2024-08-08 10:44:35','',NULL,NULL),(20,'tb_vendout_running','出货流水',NULL,NULL,'VendoutRunning','crud','','com.dkd.manage','manage','running','出货流水','itheima','0','/',NULL,'admin','2024-08-08 10:44:35','',NULL,NULL); /*!40000 ALTER TABLE `gen_table` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `gen_table_column` -- DROP TABLE IF EXISTS `gen_table_column`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `gen_table_column` ( `column_id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号', `table_id` bigint DEFAULT NULL COMMENT '归属表编号', `column_name` varchar(200) DEFAULT NULL COMMENT '列名称', `column_comment` varchar(500) DEFAULT NULL COMMENT '列描述', `column_type` varchar(100) DEFAULT NULL COMMENT '列类型', `java_type` varchar(500) DEFAULT NULL COMMENT 'JAVA类型', `java_field` varchar(200) DEFAULT NULL COMMENT 'JAVA字段名', `is_pk` char(1) DEFAULT NULL COMMENT '是否主键（1是）', `is_increment` char(1) DEFAULT NULL COMMENT '是否自增（1是）', `is_required` char(1) DEFAULT NULL COMMENT '是否必填（1是）', `is_insert` char(1) DEFAULT NULL COMMENT '是否为插入字段（1是）