/* SQLyog Ultimate v12.09 (64 bit) MySQL - 5.7.37-log : Database - data_cloud ********************************************************************* */ /*!40101 SET NAMES utf8 */; /*!40101 SET SQL_MODE=''*/; /*!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 */; CREATE DATABASE /*!32312 IF NOT EXISTS*/`data_cloud` /*!40100 DEFAULT CHARACTER SET utf8mb4 */; USE `data_cloud`; /*Table structure for table `dynamic_20201208203549` */ DROP TABLE IF EXISTS `dynamic_20201208203549`; CREATE TABLE `dynamic_20201208203549` ( `id` varchar(20) NOT NULL COMMENT '主键ID', `status` tinyint(4) DEFAULT '1' COMMENT '状态（0禁用，1启用）', `create_by` varchar(20) DEFAULT NULL COMMENT '创建人', `create_time` datetime DEFAULT NULL COMMENT '创建日期', `create_dept` varchar(20) DEFAULT NULL COMMENT '创建人所属部门', `update_by` varchar(20) DEFAULT NULL COMMENT '更新人', `update_time` datetime DEFAULT NULL COMMENT '更新日期', `name` varchar(255) NOT NULL COMMENT '名称', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='测试1102'; /*Data for the table `dynamic_20201208203549` */ insert into `dynamic_20201208203549`(`id`,`status`,`create_by`,`create_time`,`create_dept`,`update_by`,`update_time`,`name`) values ('1336489949670727682',1,'1214835832967581698','2020-12-09 09:56:49','1197789917762031617','1214835832967581698','2020-12-09 09:56:49','名称1'),('1346385919621922818',1,'1214835832967581698','2021-01-05 17:19:53','1197789917762031617','1214835832967581698','2021-01-05 17:19:53','we'); /*Table structure for table `flow_business` */ DROP TABLE IF EXISTS `flow_business`; CREATE TABLE `flow_business` ( `id` varchar(50) NOT NULL COMMENT '主键ID', `status` tinyint(4) DEFAULT NULL COMMENT '状态（0不启用，1启用）', `create_by` varchar(50) DEFAULT NULL COMMENT '创建人', `create_time` datetime DEFAULT NULL COMMENT '创建日期', `create_dept` varchar(50) DEFAULT NULL COMMENT '创建人所属部门', `update_by` varchar(50) DEFAULT NULL COMMENT '更新人', `update_time` datetime DEFAULT NULL COMMENT '更新日期', `remark` varchar(1000) DEFAULT NULL COMMENT '备注', `business_code` varchar(50) DEFAULT NULL COMMENT '业务编码', `business_name` varchar(50) DEFAULT NULL COMMENT '业务名称', `business_component` varchar(255) DEFAULT NULL COMMENT '业务组件', `business_audit_group` varchar(50) DEFAULT NULL COMMENT '业务审核用户组', `process_definition_id` varchar(100) DEFAULT NULL COMMENT '流程定义ID', `business_tempalte` varchar(1000) DEFAULT NULL COMMENT '消息模板', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='业务流程配置表'; /*Data for the table `flow_business` */ insert into `flow_business`(`id`,`status`,`create_by`,`create_time`,`create_dept`,`update_by`,`update_time`,`remark`,`business_code`,`business_name`,`business_component`,`business_audit_group`,`process_definition_id`,`business_tempalte`) values ('1308637919266820098',1,'1214835832967581698','2020-09-23 13:22:48','1197789917762031617','1214835832967581698','2020-09-23 13:23:37',NULL,'5011','数据模型','/masterdata/datamodel/index','1319092939179286529','businessAudit:1:4','业务名称:{businessName},发起人:{nickname},业务编号:{businessKey}'); /*Table structure for table `flow_category` */ DROP TABLE IF EXISTS `flow_category`; CREATE TABLE `flow_category` ( `id` varchar(50) NOT NULL COMMENT '主键ID', `status` tinyint(4) DEFAULT NULL COMMENT '状态（0不启用，1启用）', `create_by` varchar(50) DEFAULT NULL COMMENT '创建人', `create_time` datetime DEFAULT NULL COMMENT '创建日期', `create_dept` varchar(50) DEFAULT NULL COMMENT '创建人所属部门', `update_by` varchar(50) DEFAULT NULL COMMENT '更新人', `update_time` datetime DEFAULT NULL COMMENT '更新日期', `remark` varchar(1000) DEFAULT NULL COMMENT '备注', `name` varchar(50) DEFAULT NULL COMMENT '分类名称', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='流程分类表'; /*Data for the table `flow_category` */ insert into `flow_category`(`id`,`status`,`create_by`,`create_time`,`create_dept`,`update_by`,`update_time`,`remark`,`name`) values ('1304285055312584706',1,'1214835832967581698','2020-09-11 13:06:04','1197789917762031617','1214835832967581698','2020-09-11 13:06:04',NULL,'业务管理'); /*Table structure for table `gen_table` */ DROP TABLE IF EXISTS `gen_table`; CREATE TABLE `gen_table` ( `id` varchar(50) NOT NULL COMMENT '主键ID', `status` tinyint(4) DEFAULT NULL COMMENT '状态（0不启用，1启用）', `create_by` varchar(50) DEFAULT NULL COMMENT '创建人', `create_time` datetime DEFAULT NULL COMMENT '创建日期', `update_by` varchar(50) DEFAULT NULL COMMENT '更新人', `update_time` datetime DEFAULT NULL COMMENT '更新日期', `remark` varchar(1000) DEFAULT NULL COMMENT '备注', `table_name` varchar(255) DEFAULT NULL COMMENT '表名称', `table_comment` varchar(255) DEFAULT NULL COMMENT '表描述', `class_name` varchar(255) DEFAULT NULL COMMENT '实体类名称', `package_name` varchar(255) DEFAULT NULL COMMENT '生成包路径', `module_name` varchar(255) DEFAULT NULL COMMENT '生成模块名', `business_name` varchar(255) DEFAULT NULL COMMENT '生成业务名', `function_name` varchar(255) DEFAULT NULL COMMENT '生成功能名', `function_author` varchar(255) DEFAULT NULL COMMENT '生成功能作者', `column_json` json DEFAULT NULL COMMENT '表字段', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='代码生成信息表'; /*Data for the table `gen_table` */ /*Table structure for table `market_api` */ DROP TABLE IF EXISTS `market_api`; CREATE TABLE `market_api` ( `id` varchar(50) NOT NULL COMMENT '主键ID', `status` tinyint(4) DEFAULT NULL COMMENT '状态（0不启用，1启用）', `create_by` varchar(50) DEFAULT NULL COMMENT '创建人', `create_time` datetime DEFAULT NULL COMMENT '创建日期', `create_dept` varchar(50) DEFAULT NULL COMMENT '创建人所属部门', `update_by` varchar(50) DEFAULT NULL COMMENT '更新人', `update_time` datetime DEFAULT NULL COMMENT '更新日期', `remark` varchar(1000) DEFAULT NULL COMMENT '备注', `api_name` varchar(255) DEFAULT NULL COMMENT 'API名称', `api_version` varchar(10) DEFAULT NULL COMMENT 'API版本', `api_url` varchar(255) DEFAULT NULL COMMENT 'API路径', `req_method` varchar(10) DEFAULT NULL COMMENT '请求方式', `res_type` varchar(10) DEFAULT NULL COMMENT '返回格式', `deny` varchar(2000) DEFAULT NULL COMMENT 'IP黑名单多个，隔开', `limit_json` json DEFAULT NULL COMMENT '限流配置', `config_json` json DEFAULT NULL COMMENT '执行配置', `req_json` json DEFAULT NULL COMMENT '请求参数', `res_json` json DEFAULT NULL COMMENT '返回参数', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='数据API信息表'; /*Data for the table `market_api` */ insert into `market_api`(`id`,`status`,`create_by`,`create_time`,`create_dept`,`update_by`,`update_time`,`remark`,`api_name`,`api_version`,`api_url`,`req_method`,`res_type`,`deny`,`limit_json`,`config_json`,`req_json`,`res_json`) values ('1297816482595483650',3,'1214835832967581698','2020-08-24 16:42:16','1197789917762031617','1214835832967581698','2020-12-09 09:36:58',NULL,'部位信息','v1.0.0','/part/info','GET','JSON',NULL,'{\"times\": 5, \"enable\": \"0\", \"seconds\": 60}','{\"sqlText\": \"SELECT id, part_name FROM robot_symptom_part WHERE 1 = 1 ${AND id = :id}\", \"tableId\": \"1336479264639406082\", \"sourceId\": \"1336474987430793217\", \"tableName\": \"robot_symptom_part\", \"configType\": \"1\", \"fieldParams\": [{\"reqable\": \"1\", \"resable\": \"1\", \"dataType\": \"varchar\", \"columnKey\": \"1\", \"dataScale\": null, \"columnName\": \"id\", \"dataLength\": 50, \"dataDefault\": null, \"columnComment\": \"主键\", \"dataPrecision\": null, \"columnNullable\": \"0\", \"columnPosition\": 1}, {\"reqable\": null, \"resable\": \"1\", \"dataType\": \"varchar\", \"columnKey\": \"0\", \"dataScale\": null, \"columnName\": \"part_name\", \"dataLength\": 255, \"dataDefault\": null, \"columnComment\": \"部位名称\", \"dataPrecision\": null, \"columnNullable\": \"1\", \"columnPosition\": 2}]}','[{\"nullable\": \"0\", \"paramName\": \"id\", \"paramType\": \"1\", \"whereType\": \"1\", \"defaultValue\": \"111\", \"exampleValue\": \"111\", \"paramComment\": \"主键\"}]','[{\"dataType\": \"varchar\", \"fieldName\": \"id\", \"exampleValue\": \"111\", \"fieldComment\": \"主键\", \"fieldAliasName\": null}, {\"dataType\": \"varchar\", \"fieldName\": \"part_name\", \"exampleValue\": \"部位名称\", \"fieldComment\": \"部位名称\", \"fieldAliasName\": null}]'),('1298181433067651074',3,'1214835832967581698','2020-08-25 16:52:27','1197789917762031617','1214835832967581698','2020-12-09 09:38:16',NULL,'症状信息','v1.0.0','/symptom/info','GET','JSON',NULL,'{\"times\": 5, \"enable\": \"0\", \"seconds\": 60}','{\"sqlText\": \"select id, part_id, type_name from robot_symptom_type WHERE 1 = 1 ${AND type_name LIKE :type_name}\", \"tableId\": null, \"sourceId\": \"1336474987430793217\", \"tableName\": null, \"configType\": \"2\", \"fieldParams\": []}','[{\"nullable\": \"0\", \"paramName\": \"type_name\", \"paramType\": \"1\", \"whereType\": \"3\", \"defaultValue\": \"症状名称\", \"exampleValue\": \"症状名称\", \"paramComment\": \"症状名称\"}]','[{\"dataType\": \"varchar\", \"fieldName\": \"id\", \"exampleValue\": \"11\", \"fieldComment\": \"主键\", \"fieldAliasName\": \"\"}, {\"dataType\": \"varchar\", \"fieldName\": \"part_id\", \"exampleValue\": \"所属部位\", \"fieldComment\": \"所属部位\", \"fieldAliasName\": \"\"}, {\"dataType\": \"varchar\", \"fieldName\": \"type_name\", \"exampleValue\": \"症状名称\", \"fieldComment\": \"症状名称\", \"fieldAliasName\": \"\"}]'); /*Table structure for table `market_api_log` */ DROP TABLE IF EXISTS `market_api_log`; CREATE TABLE `market_api_log` ( `id` varchar(50) NOT NULL COMMENT '主键ID', `api_id` varchar(50) DEFAULT NULL COMMENT '调用api', `caller_id` varchar(50) DEFAULT NULL COMMENT '调用者id', `caller_ip` varchar(50) DEFAULT NULL COMMENT '调用者ip', `caller_url` varchar(255) DEFAULT NULL COMMENT '调用url', `caller_params` varchar(2000) DEFAULT NULL COMMENT '调用参数', `caller_date` datetime DEFAULT NULL COMMENT '调用时间', `caller_size` int(11) DEFAULT NULL COMMENT '调用数据量', `time` int(11) DEFAULT NULL COMMENT '调用耗时', `msg` varchar(2000) DEFAULT NULL COMMENT '信息记录', `status` tinyint(4) DEFAULT NULL COMMENT '状态（0失败，1成功）', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='api调用日志信息表'; /*Data for the table `market_api_log` */ insert into `market_api_log`(`id`,`api_id`,`caller_id`,`caller_ip`,`caller_url`,`caller_params`,`caller_date`,`caller_size`,`time`,`msg`,`status`) values ('1277944406174965761','1275774099624386562','1214835832967581698','192.168.0.107','/v1/dept/info','{\"pageNum\":1,\"pageSize\":20,\"id\":\"111\"}','2020-06-30 20:37:44',0,241,NULL,1),('1277945307115659265','1275774099624386562','1214835832967581698','192.168.0.107','/v1/dept/info','{\"pageNum\":1,\"pageSize\":20,\"id\":\"111\"}','2020-06-30 20:41:19',0,28,NULL,1),('1277945401969844225','1275774099624386562','1214835832967581698','192.168.0.107','/v1/dept/info','{\"pageNum\":1,\"pageSize\":20,\"id\":\"1197789917762031617\"}','2020-06-30 20:41:42',1,36,NULL,1),('1278169492177879042','1275774099624386562','1214835832967581698','192.168.0.107','/v1/dept/info','{\"dept_name\":\"xx科技\",\"pageSize\":\"20\",\"pageNum\":\"1\"}','2020-07-01 11:32:09',NULL,151,NULL,1),('1297817787422519297','1297816482595483650','1214835832967581698','192.168.3.36','/services/v1.0.0/part/info','{\"pageSize\":\"20\",\"ID\":\"62207ec3cd713e906c461dfbfddf6504\",\"pageNum\":\"1\"}','2020-08-24 16:47:27',NULL,NULL,'java.lang.String cannot be cast to java.lang.Integer',0),('1297818772886827010','1297816482595483650','1214835832967581698','192.168.3.36','/services/v1.0.0/part/info','{\"pageSize\":\"20\",\"ID\":\"62207ec3cd713e906c461dfbfddf6504\",\"pageNum\":\"1\"}','2020-08-24 16:51:22',NULL,NULL,'java.lang.String cannot be cast to java.lang.Integer',0),('1297819115108478977','1297816482595483650','1214835832967581698','192.168.3.36','/services/v1.0.0/part/info','{\"pageSize\":\"20\",\"ID\":\"62207ec3cd713e906c461dfbfddf6504\",\"pageNum\":\"1\"}','2020-08-24 16:52:44',NULL,NULL,'java.lang.String cannot be cast to java.lang.Integer',0),('1297819887028187138','1297816482595483650','1214835832967581698','192.168.3.36','/services/v1.0.0/part/info','{\"pageSize\":\"20\",\"ID\":\"62207ec3cd713e906c461dfbfddf6504\",\"pageNum\":\"1\"}','2020-08-24 16:55:48',NULL,NULL,'API调用查询数据脱敏出错',0),('1297820525254455298','1297816482595483650','1214835832967581698','192.168.3.36','/services/v1.0.0/part/info','{\"pageSize\":\"20\",\"ID\":\"62207ec3cd713e906c461dfbfddf6504\",\"pageNum\":\"1\"}','2020-08-24 16:58:20',1,1684,NULL,1),('1298182334620733441','1298181433067651074','1214835832967581698','192.168.3.24','/services/v1.0.0/symptom/info','{\"pageSize\":\"20\",\"type_name\":\"肩酸\",\"pageNum\":\"1\"}','2020-08-25 16:56:02',1,1961,NULL,1),('1298182566519607297','1298181433067651074','1214835832967581698','192.168.3.24','/services/v1.0.0/symptom/info','{\"pageSize\":\"20\",\"type_name\":\"肩酸\",\"pageNum\":\"1\"}','2020-08-25 16:56:58',1,168,NULL,1),('1298182705204269058','1298181433067651074','1214835832967581698','192.168.3.24','/services/v1.0.0/symptom/info','{\"pageSize\":\"20\",\"type_name\":\"脑壳痛\",\"pageNum\":\"1\"}','2020-08-25 16:57:31',1,126,NULL,1),('1306888486627872769','1297816482595483650','1214835832967581698','192.168.3.24','/services/v1.0.0/part/info','{\"pageSize\":\"20\",\"ID\":\"ss\",\"pageNum\":\"1\"}','2020-09-18 17:31:11',0,1553,NULL,1),('1336492989958180865',NULL,NULL,'61.164.216.254','/services/v1.0.0/part/info','{\"pageSize\":\"20\",\"id\":\"3244c36870e4a47ef1fc6e2c1acf00a2\",\"pageNum\":\"1\"}','2020-12-09 10:08:54',NULL,NULL,'api_key或secret_key空',0),('1336493024087232514',NULL,NULL,'61.164.216.254','/services/v1.0.0/part/info','{\"pageSize\":\"20\",\"id\":\"3244c36870e4a47ef1fc6e2c1acf00a2\",\"pageNum\":\"1\"}','2020-12-09 10:09:02',NULL,NULL,'api_key或secret_key空',0),('1336493851963150337',NULL,NULL,'61.164.216.254','/services/v1.0.0/part/info','{\"pageSize\":\"20\",\"id\":\"3244c36870e4a47ef1fc6e2c1acf00a2\",\"pageNum\":\"1\"}','2020-12-09 10:12:20',NULL,NULL,'api_key或secret_key空',0),('1336495784656490497','1297816482595483650','1214835832967581698','61.164.216.254','/services/v1.0.0/part/info','{\"pageSize\":\"20\",\"id\":\"3244c36870e4a47ef1fc6e2c1acf00a2\",\"pageNum\":\"1\"}','2020-12-09 10:20:01',1,1283,NULL,1),('1336504430345965570','1297816482595483650','1214835832967581698','61.164.216.254','/services/v1.0.0/part/info','{\"pageSize\":\"20\",\"id\":\"11\",\"pageNum\":\"1\"}','2020-12-09 10:54:22',0,495,NULL,1),('1336522026826977281','1297816482595483650','1214835832967581698','61.164.216.254','/services/v1.0.0/part/info','{\"pageSize\":\"20\",\"pageNum\":\"1\"}','2020-12-09 12:04:17',15,636,NULL,1),('1336522611206770689','1297816482595483650','1214835832967581698','61.164.216.254','/services/v1.0.0/part/info','{\"pageSize\":\"20\",\"pageNum\":\"1\"}','2020-12-09 12:06:36',15,1440,NULL,1),('1336523120294612993','1297816482595483650','1214835832967581698','61.164.216.254','/services/v1.0.0/part/info','{\"pageSize\":\"20\",\"pageNum\":\"1\"}','2020-12-09 12:08:38',15,595,NULL,1),('1336546302409953281','1297816482595483650','1214835832967581698','61.164.216.254','/services/v1.0.0/part/info','{\"pageSize\":\"20\",\"pageNum\":\"1\"}','2020-12-09 13:40:45',15,484,NULL,1),('1336546356252233730','1297816482595483650','1214835832967581698','61.164.216.254','/services/v1.0.0/part/info','{\"pageSize\":\"20\",\"pageNum\":\"1\"}','2020-12-09 13:40:58',15,471,NULL,1),('1336546562481967106','1297816482595483650','1214835832967581698','61.164.216.254','/services/v1.0.0/part/info','{\"pageSize\":\"20\",\"pageNum\":\"1\"}','2020-12-09 13:41:47',15,485,NULL,1),('1339499510509957121','1297816482595483650','1214835832967581698','61.164.216.254','/services/v1.0.0/part/info','{\"pageSize\":\"20\",\"pageNum\":\"1\"}','2020-12-17 17:15:44',NULL,NULL,NULL,0),('1339499534694313986','1297816482595483650','1214835832967581698','61.164.216.254','/services/v1.0.0/part/info','{\"pageSize\":\"20\",\"id\":\"11\",\"pageNum\":\"1\"}','2020-12-17 17:15:50',NULL,NULL,NULL,0),('1339499596816150530','1297816482595483650','1214835832967581698','61.164.216.254','/services/v1.0.0/part/info','{\"pageSize\":\"20\",\"id\":\"11\",\"pageNum\":\"1\"}','2020-12-17 17:16:05',NULL,NULL,NULL,0),('1339501957894729729','1297816482595483650','1214835832967581698','61.164.216.254','/services/v1.0.0/part/info','{\"pageSize\":\"20\",\"id\":\"11\",\"pageNum\":\"1\"}','2020-12-17 17:25:28',NULL,NULL,NULL,0),('1339502935163367426','1297816482595483650','1214835832967581698','61.164.216.254','/services/v1.0.0/part/info','{\"pageSize\":\"20\",\"id\":\"11\",\"pageNum\":\"1\"}','2020-12-17 17:29:21',0,1823,NULL,1),('1339727473700597761','1297816482595483650','1214835832967581698','61.164.216.254','/services/v1.0.0/part/info','{\"pageSize\":\"20\",\"id\":\"11\",\"pageNum\":\"1\"}','2020-12-18 08:21:35',0,701,NULL,1); /*Table structure for table `market_api_mask` */ DROP TABLE IF EXISTS `market_api_mask`; CREATE TABLE `market_api_mask` ( `id` varchar(50) NOT NULL COMMENT '脱敏主键ID', `status` tinyint(4) DEFAULT NULL COMMENT '状态（0不启用，1启用）', `create_by` varchar(50) DEFAULT NULL COMMENT '创建人', `create_time` datetime DEFAULT NULL COMMENT '创建日期', `create_dept` varchar(50) DEFAULT NULL COMMENT '创建人所属部门', `update_by` varchar(50) DEFAULT NULL COMMENT '更新人', `update_time` datetime DEFAULT NULL COMMENT '更新日期', `remark` varchar(1000) DEFAULT NULL COMMENT '备注', `api_id` varchar(50) DEFAULT NULL COMMENT '数据API', `mask_name` varchar(50) DEFAULT NULL COMMENT '脱敏名称', `config_json` json DEFAULT NULL COMMENT '脱敏字段规则配置', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='数据API脱敏信息表'; /*Data for the table `market_api_mask` */ insert into `market_api_mask`(`id`,`status`,`create_by`,`create_time`,`create_dept`,`update_by`,`update_time`,`remark`,`api_id`,`mask_name`,`config_json`) values ('1336507994732597250',1,'1214835832967581698','2020-12-09 11:08:32','1197789917762031617','1214835832967581698','2020-12-09 13:41:31',NULL,'1297816482595483650','1','[{\"cryptType\": \"6\", \"fieldName\": \"id\", \"cipherType\": \"2\"}]'); /*Table structure for table `market_service_integration` */ DROP TABLE IF EXISTS `market_service_integration`; CREATE TABLE `market_service_integration` ( `id` varchar(50) NOT NULL COMMENT '主键ID', `status` tinyint(4) DEFAULT NULL COMMENT '状态（0不启用，1启用）', `create_by` varchar(50) DEFAULT NULL COMMENT '创建人', `create_time` datetime DEFAULT NULL COMMENT '创建日期', `create_dept` varchar(50) DEFAULT NULL COMMENT '创建人所属部门', `update_by` varchar(50) DEFAULT NULL COMMENT '更新人', `update_time` datetime DEFAULT NULL COMMENT '更新日期', `remark` varchar(1000) DEFAULT NULL COMMENT '备注', `service_no` varchar(255) DEFAULT NULL COMMENT '服务编号', `service_name` varchar(255) DEFAULT NULL COMMENT '服务名称', `service_type` tinyint(4) DEFAULT NULL COMMENT '服务类型（1http，2webservice）', `httpservice_json` json DEFAULT NULL COMMENT 'http接口配置', `webservice_json` json DEFAULT NULL COMMENT 'webservice接口配置', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='服务集成表'; /*Data for the table `market_service_integration` */ insert into `market_service_integration`(`id`,`status`,`create_by`,`create_time`,`create_dept`,`update_by`,`update_time`,`remark`,`service_no`,`service_name`,`service_type`,`httpservice_json`,`webservice_json`) values ('1298954518389604354',1,'1214835832967581698','2020-08-27 20:04:25','1197789917762031617','1214835832967581698','2020-08-27 20:04:25',NULL,'20200827001','中英文双向翻译',1,'{\"url\": \"http://fy.webxml.com.cn/webservices/EnglishChinese.asmx/TranslatorString\", \"param\": \"{\\\"wordKey\\\": \\\"我\\\"}\", \"header\": null, \"httpMethod\": \"POST\"}','{\"soap\": null, \"wsdl\": null, \"method\": null, \"targetNamespace\": null}'),('1298954821444845569',1,'1214835832967581698','2020-08-27 20:05:38','1197789917762031617','1214835832967581698','2020-08-27 20:05:38',NULL,'20200827002','简体字转换为繁体字',2,'{\"url\": null, \"param\": null, \"header\": null, \"httpMethod\": null}','{\"soap\": \"\\n\\n \\n \\n ?\\n \\n \\n\", \"wsdl\": \"http://ws.webxml.com.cn/WebServices/TraditionalSimplifiedWebService.asmx?wsdl\", \"method\": \"toTraditionalChinese\", \"targetNamespace\": \"http://webxml.com.cn/\"}'); /*Table structure for table `market_service_log` */ DROP TABLE IF EXISTS `market_service_log`; CREATE TABLE `market_service_log` ( `id` varchar(50) NOT NULL COMMENT '主键ID', `service_id` varchar(50) DEFAULT NULL COMMENT '服务id', `caller_id` varchar(50) DEFAULT NULL COMMENT '调用者id', `caller_ip` varchar(50) DEFAULT NULL COMMENT '调用者ip', `caller_date` datetime DEFAULT NULL COMMENT '调用时间', `caller_header` varchar(1000) DEFAULT NULL COMMENT '调用请求头', `caller_param` varchar(1000) DEFAULT NULL COMMENT '调用请求参数', `caller_soap` varchar(1000) DEFAULT NULL COMMENT '调用报文', `time` int(11) DEFAULT NULL COMMENT '调用耗时', `msg` varchar(2000) DEFAULT NULL COMMENT '信息记录', `status` tinyint(4) DEFAULT NULL COMMENT '状态（0失败，1成功）', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='服务集成调用日志表'; /*Data for the table `market_service_log` */ insert into `market_service_log`(`id`,`service_id`,`caller_id`,`caller_ip`,`caller_date`,`caller_header`,`caller_param`,`caller_soap`,`time`,`msg`,`status`) values ('1296737806386778114','1275774099624386562','1214835832967581698','0:0:0:0:0:0:0:1','2020-08-21 17:16:00',NULL,'{\"wordKey\": \"我\"}',NULL,NULL,'找不到服务：202008210022',0),('1296738063749271553','1275774099624386562','1214835832967581698','0:0:0:0:0:0:0:1','2020-08-21 17:17:01',NULL,'{\"wordKey\": \"我\"}',NULL,146,NULL,1),('1336507495606222850','1298954518389604354','1214835832967581698','61.164.216.254','2020-12-09 11:06:33',NULL,'{\"wordKey\": \"我\"}',NULL,NULL,'找不到服务：20200821002',0),('1336507537746395138','1298954518389604354','1214835832967581698','61.164.216.254','2020-12-09 11:06:43',NULL,'{\"wordKey\": \"我\"}',NULL,438,NULL,1); /*Table structure for table `masterdata_model` */ DROP TABLE IF EXISTS `masterdata_model`; CREATE TABLE `masterdata_model` ( `id` varchar(50) NOT NULL COMMENT '主键ID', `status` tinyint(4) DEFAULT NULL COMMENT '状态（0不启用，1启用）', `create_by` varchar(50) DEFAULT NULL COMMENT '创建人', `create_time` datetime DEFAULT NULL COMMENT '创建日期', `create_dept` varchar(50) DEFAULT NULL COMMENT '创建人所属部门', `update_by` varchar(50) DEFAULT NULL COMMENT '更新人', `update_time` datetime DEFAULT NULL COMMENT '更新日期', `remark` varchar(1000) DEFAULT NULL COMMENT '备注', `model_name` varchar(255) DEFAULT NULL COMMENT '模型名称', `model_logic_table` varchar(255) DEFAULT NULL COMMENT '逻辑表', `model_physical_table` varchar(255) DEFAULT NULL COMMENT '物理表', `is_sync` char(1) DEFAULT NULL COMMENT '是否建模（0否，1是）', `flow_status` char(1) DEFAULT NULL COMMENT '工作流状态（1待提交，2已退回，3审核中，4通过，5不通过，6已撤销）', `process_instance_id` varchar(50) DEFAULT NULL COMMENT '流程实例ID', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='主数据模型表'; /*Data for the table `masterdata_model` */ insert into `masterdata_model`(`id`,`status`,`create_by`,`create_time`,`create_dept`,`update_by`,`update_time`,`remark`,`model_name`,`model_logic_table`,`model_physical_table`,`is_sync`,`flow_status`,`process_instance_id`) values ('1336484666361831426',1,'1214835832967581698','2020-12-09 22:35:50','1197789917762031617','1214835832967581698','2020-12-09 22:55:03',NULL,'测试1102','test_yw','dynamic_20201208203549','1','4','2501'); /*Table structure for table `masterdata_model_column` */ DROP TABLE IF EXISTS `masterdata_model_column`; CREATE TABLE `masterdata_model_column` ( `id` varchar(50) NOT NULL COMMENT '主键ID', `status` tinyint(4) DEFAULT NULL COMMENT '状态（0不启用，1启用）', `create_by` varchar(50) DEFAULT NULL COMMENT '创建人', `create_time` datetime DEFAULT NULL COMMENT '创建日期', `update_by` varchar(50) DEFAULT NULL COMMENT '更新人', `update_time` datetime DEFAULT NULL COMMENT '更新日期', `remark` varchar(1000) DEFAULT NULL COMMENT '备注', `model_id` varchar(50) DEFAULT NULL COMMENT '模型表主键', `column_name` varchar(255) DEFAULT NULL COMMENT '列名称', `column_comment` varchar(255) DEFAULT NULL COMMENT '列描述', `column_type` varchar(255) DEFAULT NULL COMMENT '列类型', `column_length` varchar(255) DEFAULT NULL COMMENT '列长度', `column_scale` varchar(255) DEFAULT NULL COMMENT '列小数位数', `default_value` varchar(255) DEFAULT NULL COMMENT '列默认值', `is_system` char(1) DEFAULT NULL COMMENT '是否系统默认（0否，1是）', `is_pk` char(1) DEFAULT NULL COMMENT '是否主键（0否，1是）', `is_required` char(1) DEFAULT NULL COMMENT '是否必填（0否，1是）', `is_insert` char(1) DEFAULT NULL COMMENT '是否为插入字段（0否，1是）', `is_edit` char(1) DEFAULT NULL COMMENT '是否编辑字段（0否，1是）', `is_detail` char(1) DEFAULT NULL COMMENT '是否详情字段（0否，1是）', `is_list` char(1) DEFAULT NULL COMMENT '是否列表字段（0否，1是）', `is_query` char(1) DEFAULT NULL COMMENT '是否查询字段（0否，1是）', `query_type` varchar(50) DEFAULT NULL COMMENT '查询方式（EQ等于、NE不等于、GT大于、GE大于等于、LT小于、LE小于等于、LIKE模糊、BETWEEN范围）', `is_bind_dict` char(1) DEFAULT NULL COMMENT '是否绑定数据标准（0否，1是）', `bind_dict_type_id` varchar(50) DEFAULT NULL COMMENT '绑定数据标准类别', `bind_dict_column` varchar(50) DEFAULT NULL COMMENT '绑定数据标准字典字段（GB_CODE，GB_NAME）', `html_type` varchar(50) DEFAULT NULL COMMENT '显示类型（input文本框、textarea文本域、select下拉框、checkbox复选框、radio单选框、datetime日期控件）', `sort` int(11) DEFAULT NULL COMMENT '排序', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='主数据模型列信息表'; /*Data for the table `masterdata_model_column` */ insert into `masterdata_model_column`(`id`,`status`,`create_by`,`create_time`,`update_by`,`update_time`,`remark`,`model_id`,`column_name`,`column_comment`,`column_type`,`column_length`,`column_scale`,`default_value`,`is_system`,`is_pk`,`is_required`,`is_insert`,`is_edit`,`is_detail`,`is_list`,`is_query`,`query_type`,`is_bind_dict`,`bind_dict_type_id`,`bind_dict_column`,`html_type`,`sort`) values ('1336484666936451073',1,'1214835832967581698','2020-12-09 09:35:50','1214835832967581698','2020-12-09 09:35:50',NULL,'1336484666361831426','id','主键ID','varchar','20','0',NULL,'1','1','1','0','0','0','0','0',NULL,'0',NULL,NULL,'input',NULL),('1336484667393630210',1,'1214835832967581698','2020-12-09 09:35:50','1214835832967581698','2020-12-09 09:35:50',NULL,'1336484666361831426','status','状态（0禁用，1启用）','tinyint','0','0','1','1','0','0','0','0','0','0','0',NULL,'0',NULL,NULL,'number',NULL),('1336484667741757442',1,'1214835832967581698','2020-12-09 09:35:50','1214835832967581698','2020-12-09 09:35:50',NULL,'1336484666361831426','create_by','创建人','varchar','20','0',NULL,'1','0','0','0','0','0','0','0',NULL,'0',NULL,NULL,'input',NULL),('1336484668085690370',1,'1214835832967581698','2020-12-09 09:35:50','1214835832967581698','2020-12-09 09:35:50',NULL,'1336484666361831426','create_time','创建日期','datetime','0','0',NULL,'1','0','0','0','0','0','0','0',NULL,'0',NULL,NULL,'datetime',NULL),('1336484668438011905',1,'1214835832967581698','2020-12-09 09:35:50','1214835832967581698','2020-12-09 09:35:50',NULL,'1336484666361831426','create_dept','创建人所属部门','varchar','20','0',NULL,'1','0','0','0','0','0','0','0',NULL,'0',NULL,NULL,'input',NULL),('1336484668786139137',1,'1214835832967581698','2020-12-09 09:35:50','1214835832967581698','2020-12-09 09:35:50',NULL,'1336484666361831426','update_by','更新人','varchar','20','0',NULL,'1','0','0','0','0','0','0','0',NULL,'0',NULL,NULL,'input',NULL),('1336484669130072065',1,'1214835832967581698','2020-12-09 09:35:50','1214835832967581698','2020-12-09 09:35:50',NULL,'1336484666361831426','update_time','更新日期','datetime','0','0',NULL,'1','0','0','0','0','0','0','0',NULL,'0',NULL,NULL,'datetime',NULL),('1336484669478199297',1,'1214835832967581698','2020-12-09 09:35:51','1214835832967581698','2020-12-09 09:35:51',NULL,'1336484666361831426','name','名称','varchar','255','0',NULL,'0','0','1','1','1','1','1','0',NULL,'0',NULL,NULL,'input',NULL); /*Table structure for table `metadata_authorize` */ DROP TABLE IF EXISTS `metadata_authorize`; CREATE TABLE `metadata_authorize` ( `id` varchar(50) NOT NULL COMMENT '主键ID', `object_id` varchar(50) NOT NULL COMMENT '目标表主键ID', `role_id` varchar(50) NOT NULL COMMENT '角色ID', `object_type` varchar(10) DEFAULT NULL COMMENT '目标表类型', PRIMARY KEY (`id`,`object_id`,`role_id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='元数据授权信息表'; /*Data for the table `metadata_authorize` */ insert into `metadata_authorize`(`id`,`object_id`,`role_id`,`object_type`) values ('1339728732931301378','1336474987430793217','1319084037507244034','database'),('1339728733359120386','1336479261791473665','1319084037507244034','table'),('1339728733749190658','1336479262852632577','1319084037507244034','column'),('1339728734139260930','1336479263477583874','1319084037507244034','column'),('1339728734529331201','1336479264106729474','1319084037507244034','column'),('1339728734923595777','1336479264639406082','1319084037507244034','table'),('1339728735317860354','1336479265583124482','1319084037507244034','column'),('1339728735707930626','1336479266149355521','1319084037507244034','column'),('1339728736093806593','1336479266728169473','1319084037507244034','table'),('1339728736483876865','1336479267583807489','1319084037507244034','column'),('1339728736878141442','1336479268242313218','1319084037507244034','column'),('1339728737268211713','1336479268821127170','1319084037507244034','column'); /*Table structure for table `metadata_change_record` */ DROP TABLE IF EXISTS `metadata_change_record`; CREATE TABLE `metadata_change_record` ( `id` varchar(50) NOT NULL COMMENT '主键ID', `status` tinyint(4) DEFAULT NULL COMMENT '状态（0不启用，1启用）', `create_by` varchar(50) DEFAULT NULL COMMENT '创建人', `create_time` datetime DEFAULT NULL COMMENT '创建日期', `create_dept` varchar(50) DEFAULT NULL COMMENT '创建人所属部门', `update_by` varchar(50) DEFAULT NULL COMMENT '更新人', `update_time` datetime DEFAULT NULL COMMENT '更新日期', `remark` varchar(1000) DEFAULT NULL COMMENT '备注', `version` tinyint(4) DEFAULT NULL COMMENT '版本号', `object_type` varchar(255) DEFAULT NULL COMMENT '源数据的表名或者能唯一对应的源数据表的标识（可废弃）', `object_id` varchar(255) DEFAULT NULL COMMENT '源数据表主键', `field_name` varchar(255) DEFAULT NULL COMMENT '修改的源数据表的字段名', `field_old_value` varchar(255) DEFAULT NULL COMMENT '该字段原来的值', `field_new_value` varchar(255) DEFAULT NULL COMMENT '该字段最新的值', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='元数据变更记录表'; /*Data for the table `metadata_change_record` */ /*Table structure for table `metadata_column` */ DROP TABLE IF EXISTS `metadata_column`; CREATE TABLE `metadata_column` ( `id` varchar(50) NOT NULL COMMENT '主键ID', `source_id` varchar(255) DEFAULT NULL COMMENT '所属数据源', `table_id` varchar(255) DEFAULT NULL COMMENT '所属数据表', `column_name` varchar(255) DEFAULT NULL COMMENT '字段名称', `column_comment` varchar(255) DEFAULT NULL COMMENT '字段注释', `column_key` varchar(255) DEFAULT NULL COMMENT '字段是否主键(1是0否)', `column_nullable` varchar(255) DEFAULT NULL COMMENT '字段是否允许为空(1是0否)', `column_position` int(11) DEFAULT NULL COMMENT '字段序号', `data_type` varchar(255) DEFAULT NULL COMMENT '数据类型', `data_length` varchar(255) DEFAULT NULL COMMENT '数据长度', `data_precision` varchar(255) DEFAULT NULL COMMENT '数据精度', `data_scale` varchar(255) DEFAULT NULL COMMENT '数据小数位', `data_default` varchar(255) DEFAULT NULL COMMENT '数据默认值', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='元数据信息表'; /*Data for the table `metadata_column` */ insert into `metadata_column`(`id`,`source_id`,`table_id`,`column_name`,`column_comment`,`column_key`,`column_nullable`,`column_position`,`data_type`,`data_length`,`data_precision`,`data_scale`,`data_default`) values ('1336479262852632577','1336474987430793217','1336479261791473665','id','主键','1','0',1,'varchar','50',NULL,NULL,NULL),('1336479263477583874','1336474987430793217','1336479261791473665','patient_name','患者姓名','0','1',2,'varchar','255',NULL,NULL,NULL),('1336479264106729474','1336474987430793217','1336479261791473665','patient_sex','患者性别（1男2女）','0','1',3,'varchar','255',NULL,NULL,NULL),('1336479265583124482','1336474987430793217','1336479264639406082','id','主键','1','0',1,'varchar','50',NULL,NULL,NULL),('1336479266149355521','1336474987430793217','1336479264639406082','part_name','部位名称','0','1',2,'varchar','255',NULL,NULL,NULL),('1336479267583807489','1336474987430793217','1336479266728169473','id','主键','1','0',1,'varchar','50',NULL,NULL,NULL),('1336479268242313218','1336474987430793217','1336479266728169473','part_id','所属部位','0','1',2,'varchar','50',NULL,NULL,NULL),('1336479268821127170','1336474987430793217','1336479266728169473','type_name','症状名称','0','1',3,'varchar','255',NULL,NULL,NULL); /*Table structure for table `metadata_source` */ DROP TABLE IF EXISTS `metadata_source`; CREATE TABLE `metadata_source` ( `id` varchar(50) NOT NULL COMMENT '主键ID', `status` tinyint(4) DEFAULT NULL COMMENT '状态（0不启用，1启用）', `create_by` varchar(50) DEFAULT NULL COMMENT '创建人', `create_time` datetime DEFAULT NULL COMMENT '创建日期', `create_dept` varchar(50) DEFAULT NULL COMMENT '创建人所属部门', `update_by` varchar(50) DEFAULT NULL COMMENT '更新人', `update_time` datetime DEFAULT NULL COMMENT '更新日期', `remark` varchar(1000) DEFAULT NULL COMMENT '备注', `db_type` tinyint(4) DEFAULT NULL COMMENT '数据源类型', `source_name` varchar(50) DEFAULT NULL COMMENT '数据源名称', `is_sync` char(1) DEFAULT NULL COMMENT '元数据同步（0否，1是）', `db_schema` json DEFAULT NULL COMMENT '数据源连接信息', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='数据源信息表'; /*Data for the table `metadata_source` */ insert into `metadata_source`(`id`,`status`,`create_by`,`create_time`,`create_dept`,`update_by`,`update_time`,`remark`,`db_type`,`source_name`,`is_sync`,`db_schema`) values ('1240185865539600385',1,'1214835832967581698','2020-03-19 03:58:47','1197789917762031617','1214835832967581698','2020-12-09 21:51:01',NULL,1,'mysql数据库','0','{\"sid\": null, \"host\": \"localhost\", \"port\": 3306, \"dbName\": \"foodmart2\", \"password\": \"1234@abcd\", \"username\": \"root\"}'),('1336474987430793217',1,'1214835832967581698','2020-12-09 21:57:22','1197789917762031617','1214835832967581698','2020-12-09 21:57:22',NULL,1,'robot数据库','2','{\"sid\": null, \"host\": \"localhost\", \"port\": 3306, \"dbName\": \"robot\", \"password\": \"1234@abcd\", \"username\": \"root\"}'); /*Table structure for table `metadata_table` */ DROP TABLE IF EXISTS `metadata_table`; CREATE TABLE `metadata_table` ( `id` varchar(50) NOT NULL COMMENT '主键ID', `source_id` varchar(255) DEFAULT NULL COMMENT '所属数据源', `table_name` varchar(255) DEFAULT NULL COMMENT '表名', `table_comment` varchar(255) DEFAULT NULL COMMENT '表注释', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='数据库表信息表'; /*Data for the table `metadata_table` */ insert into `metadata_table`(`id`,`source_id`,`table_name`,`table_comment`) values ('1336479261791473665','1336474987430793217','robot_patient','患者表'),('1336479264639406082','1336474987430793217','robot_symptom_part','部位表'),('1336479266728169473','1336474987430793217','robot_symptom_type','症状表'); /*Table structure for table `oauth_client_details` */ DROP TABLE IF EXISTS `oauth_client_details`; CREATE TABLE `oauth_client_details` ( `client_id` varchar(255) NOT NULL, `resource_ids` varchar(255) DEFAULT NULL, `client_secret` varchar(255) DEFAULT NULL, `scope` varchar(255) DEFAULT NULL, `authorized_grant_types` varchar(255) DEFAULT NULL, `web_server_redirect_uri` varchar(255) DEFAULT NULL, `authorities` varchar(255) DEFAULT NULL, `access_token_validity` int(11) DEFAULT NULL, `refresh_token_validity` int(11) DEFAULT NULL, `additional_information` varchar(255) DEFAULT NULL, `autoapprove` varchar(255) DEFAULT NULL, PRIMARY KEY (`client_id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='终端信息表'; /*Data for the table `oauth_client_details` */ insert into `oauth_client_details`(`client_id`,`resource_ids`,`client_secret`,`scope`,`authorized_grant_types`,`web_server_redirect_uri`,`authorities`,`access_token_validity`,`refresh_token_validity`,`additional_information`,`autoapprove`) values ('datax',NULL,'$2a$10$3rV8TA7XlfVkZrP0kA0t7OqKoQa93Mw/VZii6nP62pqiD.AjKSUja','all','password,refresh_token,client_credentials,authorization_code','http://baidu.com',NULL,86400,604800,NULL,'true'),('normal-app',NULL,'$2a$10$tF1Qh5IU3BLXkt/rwhZ1x.sBnnFi7ZDIZ4VJawiSH2Ad26YE1U9nC','all','password,refresh_token',NULL,NULL,86400,604800,NULL,'true'),('trusted-app',NULL,'$2a$10$F2KzyEy9MeFLz.ic2wvJDegLFjG9xzo7n7s.TE7zdI6fWeIieVV1G','all','password,refresh_token',NULL,NULL,0,0,NULL,'true'); /*Table structure for table `qrtz_job` */ DROP TABLE IF EXISTS `qrtz_job`; CREATE TABLE `qrtz_job` ( `id` varchar(50) NOT NULL COMMENT '主键ID', `status` tinyint(4) DEFAULT NULL COMMENT '状态（0不启用，1启用）', `create_by` varchar(50) DEFAULT NULL COMMENT '创建人', `create_time` datetime DEFAULT NULL COMMENT '创建日期', `create_dept` varchar(50) DEFAULT NULL COMMENT '创建人所属部门', `update_by` varchar(50) DEFAULT NULL COMMENT '更新人', `update_time` datetime DEFAULT NULL COMMENT '更新日期', `remark` varchar(1000) DEFAULT NULL COMMENT '备注', `job_name` varchar(255) DEFAULT NULL COMMENT '任务名称', `bean_name` varchar(255) DEFAULT NULL COMMENT 'Spring Bean名称', `method_name` varchar(255) DEFAULT NULL COMMENT '方法名称', `method_params` varchar(255) DEFAULT NULL COMMENT '方法参数', `cron_expression` varchar(255) DEFAULT NULL COMMENT 'cron表达式', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='定时任务信息表'; /*Data for the table `qrtz_job` */ insert into `qrtz_job`(`id`,`status`,`create_by`,`create_time`,`create_dept`,`update_by`,`update_time`,`remark`,`job_name`,`bean_name`,`method_name`,`method_params`,`cron_expression`) values ('1346347501890191362',0,'1214835832967581698','2021-01-05 14:47:13','1197789917762031617','1214835832967581698','2021-01-05 14:47:13',NULL,'测试无参数任务','quartzTask','withoutParams',NULL,'30 * * * * ?'),('1346347612309438465',0,'1214835832967581698','2021-01-05 14:47:39','1197789917762031617','1214835832967581698','2021-01-05 14:47:39',NULL,'测试有参数任务','quartzTask','withParams','我是参数','45 * * * * ?'); /*Table structure for table `qrtz_job_log` */ DROP TABLE IF EXISTS `qrtz_job_log`; CREATE TABLE `qrtz_job_log` ( `id` varchar(50) NOT NULL COMMENT '数据源主键ID', `status` tinyint(4) DEFAULT NULL COMMENT '状态（0不启用，1启用）', `create_time` datetime DEFAULT NULL COMMENT '创建日期', `job_id` varchar(255) DEFAULT NULL COMMENT '任务ID', `msg` varchar(2000) DEFAULT NULL COMMENT '信息记录', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='定时任务日志信息表'; /*Data for the table `qrtz_job_log` */ insert into `qrtz_job_log`(`id`,`status`,`create_time`,`job_id`,`msg`) values ('1346347573382103042',1,'2021-01-05 14:47:30','1346347501890191362','【测试无参数任务】任务执行结束，总共耗时：2毫秒'),('1346347636053393409',1,'2021-01-05 14:47:45','1346347612309438465','【测试有参数任务】任务执行结束，总共耗时：0毫秒'); /*Table structure for table `quality_check_report` */ DROP TABLE IF EXISTS `quality_check_report`; CREATE TABLE `quality_check_report` ( `id` varchar(50) NOT NULL COMMENT '主键ID', `check_rule_id` varchar(50) DEFAULT NULL COMMENT '核查规则主键', `check_date` datetime DEFAULT NULL COMMENT '核查时间', `check_result` varchar(1000) DEFAULT NULL COMMENT '核查结果', `check_total_count` int(11) DEFAULT NULL COMMENT '核查数量', `check_error_count` int(11) DEFAULT NULL COMMENT '不合规数量', `check_batch` varchar(50) DEFAULT NULL COMMENT '核查批次号', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='核查报告信息表'; /*Data for the table `quality_check_report` */ insert into `quality_check_report`(`id`,`check_rule_id`,`check_date`,`check_result`,`check_total_count`,`check_error_count`,`check_batch`) values ('1340552514231197698','1318749656079646721','2020-12-20 15:00:00',NULL,3,0,'20201220020000'),('1340552515288162306','1318749963664736258','2020-12-20 15:00:00',NULL,3,3,'20201220020000'),('1340552516336738305','1318750378762420225','2020-12-20 15:00:00',NULL,3,0,'20201220020000'),('1340552517389508610','1336564556213846017','2020-12-20 15:00:00',NULL,4,0,'20201220020000'),('1346879442167140353','1318749656079646721','2021-01-07 02:00:04',NULL,3,0,'20210107020000'),('1346879443857444865','1318749963664736258','2021-01-07 02:00:04',NULL,3,3,'20210107020000'),('1346879445505806338','1318750378762420225','2021-01-07 02:00:04',NULL,3,0,'20210107020000'),('1346879447082864641','1336564556213846017','2021-01-07 02:00:04',NULL,4,0,'20210107020000'); /*Table structure for table `quality_check_rule` */ DROP TABLE IF EXISTS `quality_check_rule`; CREATE TABLE `quality_check_rule` ( `id` varchar(50) NOT NULL COMMENT '主键ID', `status` tinyint(4) DEFAULT NULL COMMENT '状态（0不启用，1启用）', `create_by` varchar(50) DEFAULT NULL COMMENT '创建人', `create_time` datetime DEFAULT NULL COMMENT '创建日期', `create_dept` varchar(50) DEFAULT NULL COMMENT '创建人所属部门', `update_by` varchar(50) DEFAULT NULL COMMENT '更新人', `update_time` datetime DEFAULT NULL COMMENT '更新日期', `remark` varchar(1000) DEFAULT NULL COMMENT '备注', `rule_name` varchar(50) DEFAULT NULL COMMENT '规则名称', `rule_type_id` varchar(50) DEFAULT NULL COMMENT '规则类型', `rule_item_id` varchar(50) DEFAULT NULL COMMENT '核查类型', `rule_level_id` varchar(50) DEFAULT NULL COMMENT '规则级别', `rule_db_type` varchar(50) DEFAULT NULL COMMENT '数据源类型', `rule_source_id` varchar(50) DEFAULT NULL COMMENT '数据源主键', `rule_source` varchar(50) DEFAULT NULL COMMENT '数据源', `rule_table_id` varchar(50) DEFAULT NULL COMMENT '数据表主键', `rule_table` varchar(50) DEFAULT NULL COMMENT '数据表', `rule_table_comment` varchar(50) DEFAULT NULL COMMENT '数据表名称', `rule_column_id` varchar(50) DEFAULT NULL COMMENT '字段主键', `rule_column` varchar(50) DEFAULT NULL COMMENT '字段', `rule_column_comment` varchar(50) DEFAULT NULL COMMENT '字段名称', `config_json` json DEFAULT NULL COMMENT '核查配置', `rule_sql` varchar(1000) DEFAULT NULL COMMENT '核查脚本', `last_check_batch` varchar(50) DEFAULT NULL COMMENT '最近核查批次号（关联确定唯一核查报告）', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='核查规则信息表'; /*Data for the table `quality_check_rule` */ insert into `quality_check_rule`(`id`,`status`,`create_by`,`create_time`,`create_dept`,`update_by`,`update_time`,`remark`,`rule_name`,`rule_type_id`,`rule_item_id`,`rule_level_id`,`rule_db_type`,`rule_source_id`,`rule_source`,`rule_table_id`,`rule_table`,`rule_table_comment`,`rule_column_id`,`rule_column`,`rule_column_comment`,`config_json`,`rule_sql`,`last_check_batch`) values ('1318749656079646721',1,'1214835832967581698','2020-10-21 11:03:14','1197789917762031617','1214835832967581698','2020-12-09 09:32:19',NULL,'唯一校验','1310055102039498754','1316555325628764161','1316243646609117186','1','1336474987430793217','robot数据库','1336479261791473665','robot_patient','患者表','1336479262852632577','id','主键','{\"accuracy\": {\"maxLength\": null}, \"relevance\": {\"relatedTable\": null, \"relatedColumn\": null, \"relatedTableId\": null, \"relatedColumnId\": null, \"relatedTableComment\": null, \"relatedColumnComment\": null}, \"consistent\": {\"gbTypeId\": null, \"gbTypeCode\": null, \"gbTypeName\": null, \"bindGbColumn\": null}, \"timeliness\": {\"threshold\": null}, \"ruleItemCode\": \"unique_key\"}','SELECT totalCount - errorCount AS errorCount, totalCount FROM (SELECT COUNT(DISTINCT id) AS errorCount, COUNT(*) AS totalCount FROM robot_patient) TEMP','20210107020000'),('1318749963664736258',1,'1214835832967581698','2020-10-21 11:04:27','1197789917762031617','1214835832967581698','2020-12-09 10:23:54',NULL,'完整校验','1310055106909085697','1316555332956213250','1316243649473826818','1','1336474987430793217','robot数据库','1336479261791473665','robot_patient','患者表','1336479262852632577','id','主键','{\"accuracy\": {\"maxLength\": null}, \"relevance\": {\"relatedTable\": null, \"relatedColumn\": null, \"relatedTableId\": null, \"relatedColumnId\": null, \"relatedTableComment\": null, \"relatedColumnComment\": null}, \"consistent\": {\"gbTypeId\": null, \"gbTypeCode\": null, \"gbTypeName\": null, \"bindGbColumn\": null}, \"timeliness\": {\"threshold\": null}, \"ruleItemCode\": \"integrity_key\"}','SELECT SUM(CASE WHEN id IS NOT NULL AND TRIM(id) != \'\' THEN 0 ELSE 1 END), COUNT(*) FROM robot_patient','20210107020000'),('1318750378762420225',1,'1214835832967581698','2020-10-21 11:06:06','1197789917762031617','1214835832967581698','2020-12-09 09:33:04',NULL,'一致校验','1310055114131677186','1316555329772736514','1316243646609117186','1','1336474987430793217','robot数据库','1336479261791473665','robot_patient','患者表','1336479264106729474','patient_sex','患者性别（1男2女）','{\"accuracy\": {\"maxLength\": null}, \"relevance\": {\"relatedTable\": null, \"relatedColumn\": null, \"relatedTableId\": null, \"relatedColumnId\": null, \"relatedTableComment\": null, \"relatedColumnComment\": null}, \"consistent\": {\"gbTypeId\": \"1303245849463218178\", \"gbTypeCode\": \"GB/T 2261.1-2003\", \"gbTypeName\": \"人的性别代码\", \"bindGbColumn\": \"gb_code\"}, \"timeliness\": {\"threshold\": null}, \"ruleItemCode\": \"consistent_key\"}','SELECT SUM(CASE WHEN patient_sex NOT IN (\'0\',\'1\',\'2\',\'9\') THEN 1 ELSE 0 END), COUNT(*) FROM robot_patient','20210107020000'),('1336564556213846017',1,'1214835832967581698','2020-12-09 14:53:17','1197789917762031617','1214835832967581698','2020-12-09 14:53:17',NULL,'关联性校验','1310055118023991297','1316555336190021633','1316243646609117186','1','1336474987430793217','robot数据库','1336479266728169473','robot_symptom_type','症状表','1336479268242313218','part_id','所属部位','{\"accuracy\": {\"maxLength\": null}, \"relevance\": {\"relatedTable\": \"robot_symptom_part\", \"relatedColumn\": \"id\", \"relatedTableId\": \"1336479264639406082\", \"relatedColumnId\": \"1336479265583124482\", \"relatedTableComment\": \"部位表\", \"relatedColumnComment\": \"主键\"}, \"consistent\": {\"gbTypeId\": null, \"gbTypeCode\": null, \"gbTypeName\": null, \"bindGbColumn\": null}, \"timeliness\": {\"threshold\": null}, \"ruleItemCode\": \"relevance_key\"}','SELECT SUM(errorCount) AS errorCount, SUM(totalCount) AS totalCount FROM (SELECT COUNT(*) AS errorCount, 0 AS totalCount FROM robot_symptom_type a WHERE NOT EXISTS (SELECT 1 FROM robot_symptom_part b WHERE a.part_id = b.id)UNION SELECT 0 AS errorCount, COUNT(*) AS totalCount FROM robot_symptom_type) TEMP','20210107020000'); /*Table structure for table `quality_rule_item` */ DROP TABLE IF EXISTS `quality_rule_item`; CREATE TABLE `quality_rule_item` ( `id` varchar(50) NOT NULL COMMENT '主键ID', `rule_type_id` varchar(50) DEFAULT NULL COMMENT '规则类型', `item_code` varchar(50) DEFAULT NULL COMMENT '核查项编码', `item_explain` varchar(1000) DEFAULT NULL COMMENT '核查项解释', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='规则核查类型信息表'; /*Data for the table `quality_rule_item` */ insert into `quality_rule_item`(`id`,`rule_type_id`,`item_code`,`item_explain`) values ('1316555325628764161','1310055102039498754','unique_key','字段唯一性'),('1316555329772736514','1310055114131677186','consistent_key','字典一致性'),('1316555332956213250','1310055106909085697','integrity_key','非空完整性'),('1316555336190021633','1310055118023991297','relevance_key','字段关联性'),('1316555339457384449','1310055122348318721','timeliness_key','字段及时性'),('1316555342435340289','1310055110574907393','accuracy_key_length','长度准确性'); /*Table structure for table `quality_rule_level` */ DROP TABLE IF EXISTS `quality_rule_level`; CREATE TABLE `quality_rule_level` ( `id` varchar(50) NOT NULL COMMENT '主键ID', `code` varchar(50) DEFAULT NULL COMMENT '规则级别编码', `name` varchar(50) DEFAULT NULL COMMENT '规则级别名称', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='规则级别信息表'; /*Data for the table `quality_rule_level` */ insert into `quality_rule_level`(`id`,`code`,`name`) values ('1316243642557419521','1','低'),('1316243646609117186','2','中'),('1316243649473826818','3','高'); /*Table structure for table `quality_rule_type` */ DROP TABLE IF EXISTS `quality_rule_type`; CREATE TABLE `quality_rule_type` ( `id` varchar(50) NOT NULL COMMENT '主键ID', `name` varchar(50) DEFAULT NULL COMMENT '类型名称', `code` varchar(50) DEFAULT NULL COMMENT '类型编码', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='规则类型信息表'; /*Data for the table `quality_rule_type` */ insert into `quality_rule_type`(`id`,`name`,`code`) values ('1310055102039498754','唯一性校验','unique'),('1310055106909085697','完整性校验','integrity'),('1310055110574907393','准确性校验','accuracy'),('1310055114131677186','一致性校验','consistent'),('1310055118023991297','关联性校验','relevance'),('1310055122348318721','及时性校验','timeliness'); /*Table structure for table `quality_schedule_job` */ DROP TABLE IF EXISTS `quality_schedule_job`; CREATE TABLE `quality_schedule_job` ( `id` varchar(50) NOT NULL COMMENT '主键ID', `job_name` varchar(100) DEFAULT NULL COMMENT '任务名称', `bean_name` varchar(100) DEFAULT NULL COMMENT 'bean名称', `method_name` varchar(100) DEFAULT NULL COMMENT '方法名称', `method_params` varchar(255) DEFAULT NULL COMMENT '方法参数', `cron_expression` varchar(255) DEFAULT NULL COMMENT 'cron表达式', `status` tinyint(4) DEFAULT NULL COMMENT '状态（1运行 0暂停）', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='数据质量监控任务信息表'; /*Data for the table `quality_schedule_job` */ insert into `quality_schedule_job`(`id`,`job_name`,`bean_name`,`method_name`,`method_params`,`cron_expression`,`status`) values ('1310823026538962945','数据质量监控任务','qualityTask','task',NULL,'0 0 2 * * ?',1); /*Table structure for table `quality_schedule_log` */ DROP TABLE IF EXISTS `quality_schedule_log`; CREATE TABLE `quality_schedule_log` ( `id` varchar(50) NOT NULL COMMENT '主键ID', `status` char(1) DEFAULT NULL COMMENT '状态（1成功 0失败）', `execute_job_id` varchar(50) DEFAULT NULL COMMENT '执行任务主键', `execute_rule_id` varchar(50) DEFAULT NULL COMMENT '执行规则主键', `execute_date` datetime DEFAULT NULL COMMENT '执行时间', `execute_result` varchar(1000) DEFAULT NULL COMMENT '执行结果', `execute_batch` varchar(50) DEFAULT NULL COMMENT '执行批次号', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='数据质量监控任务日志信息表'; /*Data for the table `quality_schedule_log` */ insert into `quality_schedule_log`(`id`,`status`,`execute_job_id`,`execute_rule_id`,`execute_date`,`execute_result`,`execute_batch`) values ('1340552514940035074','1','1310823026538962945','1318749656079646721','2020-12-20 15:00:00',NULL,'20201220020000'),('1340552515988611073','1','1310823026538962945','1318749963664736258','2020-12-20 15:00:00',NULL,'20201220020000'),('1340552517041381378','1','1310823026538962945','1318750378762420225','2020-12-20 15:00:00',NULL,'20201220020000'),('1340552518194814978','1','1310823026538962945','1336564556213846017','2020-12-20 15:00:00',NULL,'20201220020000'),('1346516951155232769','0','1310823026538962945','1318749656079646721','2021-01-06 02:00:03','获取数据源接口出错','20210106020000'),('1346516953088806914','0','1310823026538962945','1318749963664736258','2021-01-06 02:00:03','获取数据源接口出错','20210106020000'),('1346516953143332866','0','1310823026538962945','1318750378762420225','2021-01-06 02:00:03','获取数据源接口出错','20210106020000'),('1346516953336270850','0','1310823026538962945','1336564556213846017','2021-01-06 02:00:03','获取数据源接口出错','20210106020000'),('1346879443580620802','1','1310823026538962945','1318749656079646721','2021-01-07 02:00:04',NULL,'20210107020000'),('1346879444222349313','1','1310823026538962945','1318749963664736258','2021-01-07 02:00:04',NULL,'20210107020000'),('1346879446915092482','1','1310823026538962945','1318750378762420225','2021-01-07 02:00:04',NULL,'20210107020000'),('1346879447737176066','1','1310823026538962945','1336564556213846017','2021-01-07 02:00:04',NULL,'20210107020000'); /*Table structure for table `standard_contrast` */ DROP TABLE IF EXISTS `standard_contrast`; CREATE TABLE `standard_contrast` ( `id` varchar(50) NOT NULL COMMENT '主键ID', `status` tinyint(4) DEFAULT NULL COMMENT '状态（0不启用，1启用）', `create_by` varchar(50) DEFAULT NULL COMMENT '创建人', `create_time` datetime DEFAULT NULL COMMENT '创建日期', `create_dept` varchar(50) DEFAULT NULL COMMENT '创建人所属部门', `update_by` varchar(50) DEFAULT NULL COMMENT '更新人', `update_time` datetime DEFAULT NULL COMMENT '更新日期', `remark` varchar(1000) DEFAULT NULL COMMENT '备注', `source_id` varchar(50) DEFAULT NULL COMMENT '数据源主键', `source_name` varchar(50) DEFAULT NULL COMMENT '数据源', `table_id` varchar(50) DEFAULT NULL COMMENT '数据表主键', `table_name` varchar(50) DEFAULT NULL COMMENT '数据表', `table_comment` varchar(50) DEFAULT NULL COMMENT '数据表名称', `column_id` varchar(50) DEFAULT NULL COMMENT '字段主键', `column_name` varchar(50) DEFAULT NULL COMMENT '字段', `column_comment` varchar(50) DEFAULT NULL COMMENT '字段名称', `gb_type_id` varchar(50) DEFAULT NULL COMMENT '标准类别主键', `bind_gb_column` varchar(50) DEFAULT NULL COMMENT '绑定标准字段', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='对照表信息表'; /*Data for the table `standard_contrast` */ insert into `standard_contrast`(`id`,`status`,`create_by`,`create_time`,`create_dept`,`update_by`,`update_time`,`remark`,`source_id`,`source_name`,`table_id`,`table_name`,`table_comment`,`column_id`,`column_name`,`column_comment`,`gb_type_id`,`bind_gb_column`) values ('1336483007929868290',1,'1214835832967581698','2020-12-09 09:29:14','1197789917762031617','1214835832967581698','2020-12-09 09:29:14',NULL,'1336474987430793217','robot数据库','1336479261791473665','robot_patient','患者表','1336479264106729474','patient_sex','患者性别（1男2女）','1303245849463218178','gb_code'); /*Table structure for table `standard_contrast_dict` */ DROP TABLE IF EXISTS `standard_contrast_dict`; CREATE TABLE `standard_contrast_dict` ( `id` varchar(50) NOT NULL COMMENT '主键ID', `status` tinyint(4) DEFAULT NULL COMMENT '状态（0未对照，1已对照）', `create_by` varchar(50) DEFAULT NULL COMMENT '创建人', `create_time` datetime DEFAULT NULL COMMENT '创建日期', `create_dept` varchar(50) DEFAULT NULL COMMENT '创建人所属部门', `update_by` varchar(50) DEFAULT NULL COMMENT '更新人', `update_time` datetime DEFAULT NULL COMMENT '更新日期', `remark` varchar(1000) DEFAULT NULL COMMENT '备注', `contrast_id` varchar(50) DEFAULT NULL COMMENT '字典对照主键', `col_code` varchar(50) DEFAULT NULL COMMENT '字典编码', `col_name` varchar(50) DEFAULT NULL COMMENT '字典名称', `contrast_gb_id` varchar(50) DEFAULT NULL COMMENT '对照的标准字典', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='字典对照信息表'; /*Data for the table `standard_contrast_dict` */ insert into `standard_contrast_dict`(`id`,`status`,`create_by`,`create_time`,`create_dept`,`update_by`,`update_time`,`remark`,`contrast_id`,`col_code`,`col_name`,`contrast_gb_id`) values ('1336483232853614594',1,'1214835832967581698','2020-12-09 09:30:08','1197789917762031617','1214835832967581698','2020-12-09 09:30:08',NULL,'1336483007929868290','1','男','1303247360368926722'),('1336483277371957249',1,'1214835832967581698','2020-12-10 11:30:19','1197789917762031617','1214835832967581698','2020-12-10 11:30:19',NULL,'1336483007929868290','2','女','1303247362688376833'); /*Table structure for table `standard_dict` */ DROP TABLE IF EXISTS `standard_dict`; CREATE TABLE `standard_dict` ( `id` varchar(50) NOT NULL COMMENT '主键ID', `status` tinyint(4) DEFAULT NULL COMMENT '状态（0不启用，1启用）', `create_by` varchar(50) DEFAULT NULL COMMENT '创建人', `create_time` datetime DEFAULT NULL COMMENT '创建日期', `create_dept` varchar(50) DEFAULT NULL COMMENT '创建人所属部门', `update_by` varchar(50) DEFAULT NULL COMMENT '更新人', `update_time` datetime DEFAULT NULL COMMENT '更新日期', `remark` varchar(1000) DEFAULT NULL COMMENT '备注', `type_id` varchar(255) DEFAULT NULL COMMENT '所属类别', `gb_code` varchar(255) DEFAULT NULL COMMENT '标准编码', `gb_name` varchar(255) DEFAULT NULL COMMENT '标准名称', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='数据标准字典表'; /*Data for the table `standard_dict` */ insert into `standard_dict`(`id`,`status`,`create_by`,`create_time`,`create_dept`,`update_by`,`update_time`,`remark`,`type_id`,`gb_code`,`gb_name`) values ('1303247357105758209',1,'1214835832967581698','2020-09-08 16:16:38','1197789917762031617','1214835832967581698','2020-09-08 16:16:38',NULL,'1303245849463218178','0','未知的性别'),('1303247360368926722',1,'1214835832967581698','2020-09-08 16:16:38','1197789917762031617','1214835832967581698','2020-09-08 16:16:38',NULL,'1303245849463218178','1','男性'),('1303247362688376833',1,'1214835832967581698','2020-09-08 16:16:38','1197789917762031617','1214835832967581698','2020-09-08 16:16:38',NULL,'1303245849463218178','2','女性'),('1303247366693937153',1,'1214835832967581698','2020-09-08 16:16:38','1197789917762031617','1214835832967581698','2020-09-08 16:16:38',NULL,'1303245849463218178','9','未说明的性别'),('1303249289220210689',1,'1214835832967581698','2020-09-08 16:17:02','1197789917762031617','1214835832967581698','2020-09-08 16:17:02',NULL,'1303245946938843137','10','未婚'),('1303249292659539970',1,'1214835832967581698','2020-09-08 16:17:02','1197789917762031617','1214835832967581698','2020-09-08 16:17:02',NULL,'1303245946938843137','20','已婚'),('1303249295721381890',1,'1214835832967581698','2020-09-08 16:17:02','1197789917762031617','1214835832967581698','2020-09-08 16:17:02',NULL,'1303245946938843137','21','初婚'),('1303249298619645953',1,'1214835832967581698','2020-09-08 16:17:02','1197789917762031617','1214835832967581698','2020-09-08 16:17:02',NULL,'1303245946938843137','22','再婚'),('1303249302188998658',1,'1214835832967581698','2020-09-08 16:17:02','1197789917762031617','1214835832967581698','2020-09-08 16:17:02',NULL,'1303245946938843137','23','复婚'),('1303249306152615937',1,'1214835832967581698','2020-09-08 16:17:02','1197789917762031617','1214835832967581698','2020-09-08 16:17:02',NULL,'1303245946938843137','30','丧偶'),('1303249308417540097',1,'1214835832967581698','2020-09-08 16:17:02','1197789917762031617','1214835832967581698','2020-09-08 16:17:02',NULL,'1303245946938843137','40','离婚'),('1303249312116916225',1,'1214835832967581698','2020-09-08 16:17:02','1197789917762031617','1214835832967581698','2020-09-08 16:17:02',NULL,'1303245946938843137','90','未说明的婚姻状况'),('1303250886239223810',1,'1214835832967581698','2020-09-08 16:17:48','1197789917762031617','1214835832967581698','2020-09-08 16:17:48',NULL,'1303246143370682369','11','国家公务员'),('1303250889280094210',1,'1214835832967581698','2020-09-08 16:17:48','1197789917762031617','1214835832967581698','2020-09-08 16:17:48',NULL,'1303246143370682369','13','国家公务员'),('1303250891419189250',1,'1214835832967581698','2020-09-08 16:17:48','1197789917762031617','1214835832967581698','2020-09-08 16:17:48',NULL,'1303246143370682369','17','职员'),('1303250895265366018',1,'1214835832967581698','2020-09-08 16:17:48','1197789917762031617','1214835832967581698','2020-09-08 16:17:48',NULL,'1303246143370682369','21','企业管理人员'),('1303250898415288322',1,'1214835832967581698','2020-09-08 16:17:48','1197789917762031617','1214835832967581698','2020-09-08 16:17:48',NULL,'1303246143370682369','24','工 人'),('1303250902022389761',1,'1214835832967581698','2020-09-08 16:17:48','1197789917762031617','1214835832967581698','2020-09-08 16:17:48',NULL,'1303246143370682369','27','农民'),('1303250904572526594',1,'1214835832967581698','2020-09-08 16:17:48','1197789917762031617','1214835832967581698','2020-09-08 16:17:48',NULL,'1303246143370682369','31','学生'),('1303250907172995074',1,'1214835832967581698','2020-09-08 16:17:48','1197789917762031617','1214835832967581698','2020-09-08 16:17:48',NULL,'1303246143370682369','37','现役军人'),('1303250910394220545',1,'1214835832967581698','2020-09-08 16:17:48','1197789917762031617','1214835832967581698','2020-09-08 16:17:48',NULL,'1303246143370682369','51','自由职业者'),('1303250914454306817',1,'1214835832967581698','2020-09-08 16:17:48','1197789917762031617','1214835832967581698','2020-09-08 16:17:48',NULL,'1303246143370682369','54','个体经营者'),('1303250918308872194',1,'1214835832967581698','2020-09-08 16:17:48','1197789917762031617','1214835832967581698','2020-09-08 16:17:48',NULL,'1303246143370682369','70','无业 人员'),('1303250920888369153',1,'1214835832967581698','2020-09-08 16:17:48','1197789917762031617','1214835832967581698','2020-09-08 16:17:48',NULL,'1303246143370682369','80','退（离）休人员'),('1303250924432556033',1,'1214835832967581698','2020-09-08 16:17:48','1197789917762031617','1214835832967581698','2020-09-08 16:17:48',NULL,'1303246143370682369','90','其他'),('1303252645292556289',1,'1214835832967581698','2020-09-08 16:18:13','1197789917762031617','1214835832967581698','2020-09-08 16:18:13',NULL,'1303246245158051841','1','香港同胞亲属'),('1303252649616883713',1,'1214835832967581698','2020-09-08 16:18:13','1197789917762031617','1214835832967581698','2020-09-08 16:18:13',NULL,'1303246245158051841','2','澳门同胞亲属'),('1303252652871663617',1,'1214835832967581698','2020-09-08 16:18:13','1197789917762031617','1214835832967581698','2020-09-08 16:18:13',NULL,'1303246245158051841','3','台湾同胞亲属'),('1303252656952721409',1,'1214835832967581698','2020-09-08 16:18:13','1197789917762031617','1214835832967581698','2020-09-08 16:18:13',NULL,'1303246245158051841','4','海外侨胞亲属'),('1303253227483033601',1,'1214835832967581698','2020-09-08 16:18:50','1197789917762031617','1214835832967581698','2020-09-08 16:18:50',NULL,'1303246401513316353','1','两院院士'),('1303253232226791425',1,'1214835832967581698','2020-09-08 16:18:50','1197789917762031617','1214835832967581698','2020-09-08 16:18:50',NULL,'1303246401513316353','2','中国科学院院士'),('1303253234995032066',1,'1214835832967581698','2020-09-08 16:18:50','1197789917762031617','1214835832967581698','2020-09-08 16:18:50',NULL,'1303246401513316353','3','中国工程院院士'); /*Table structure for table `standard_type` */ DROP TABLE IF EXISTS `standard_type`; CREATE TABLE `standard_type` ( `id` varchar(50) NOT NULL COMMENT '主键ID', `status` tinyint(4) DEFAULT NULL COMMENT '状态（0不启用，1启用）', `create_by` varchar(50) DEFAULT NULL COMMENT '创建人', `create_time` datetime DEFAULT NULL COMMENT '创建日期', `create_dept` varchar(50) DEFAULT NULL COMMENT '创建人所属部门', `update_by` varchar(50) DEFAULT NULL COMMENT '更新人', `update_time` datetime DEFAULT NULL COMMENT '更新日期', `remark` varchar(1000) DEFAULT NULL COMMENT '备注', `gb_type_code` varchar(255) DEFAULT NULL COMMENT '标准类别编码', `gb_type_name` varchar(255) DEFAULT NULL COMMENT '标准类别名称', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='数据标准类别表'; /*Data for the table `standard_type` */ insert into `standard_type`(`id`,`status`,`create_by`,`create_time`,`create_dept`,`update_by`,`update_time`,`remark`,`gb_type_code`,`gb_type_name`) values ('1303245849463218178',1,'1214835832967581698','2020-09-08 16:16:38','1197789917762031617','1214835832967581698','2020-09-08 16:16:38',NULL,'GB/T 2261.1-2003','人的性别代码'),('1303245946938843137',1,'1214835832967581698','2020-09-08 16:17:02','1197789917762031617','1214835832967581698','2020-09-08 16:17:02',NULL,'GB/T 2261.2-2003','婚姻状况代码'),('1303246143370682369',1,'1214835832967581698','2020-09-08 16:17:48','1197789917762031617','1214835832967581698','2020-09-08 16:17:48',NULL,'GB/T 2261.4-2003','从业状况(个人身份)代码'),('1303246245158051841',1,'1214835832967581698','2020-09-08 16:18:13','1197789917762031617','1214835832967581698','2020-09-08 16:18:13',NULL,'GB/T 2261.5-2003','港澳台侨属代码'),('1303246401513316353',1,'1214835832967581698','2020-09-08 16:18:50','1197789917762031617','1214835832967581698','2020-09-08 16:18:50',NULL,'GB/T 2261.7-2003','院士代码'); /*Table structure for table `sys_config` */ DROP TABLE IF EXISTS `sys_config`; CREATE TABLE `sys_config` ( `id` varchar(50) NOT NULL COMMENT '主键ID', `status` tinyint(4) DEFAULT NULL COMMENT '状态（0不启用，1启用）', `create_by` varchar(50) DEFAULT NULL COMMENT '创建人', `create_time` datetime DEFAULT NULL COMMENT '创建日期', `update_by` varchar(50) DEFAULT NULL COMMENT '更新人', `update_time` datetime DEFAULT NULL COMMENT '更新日期', `remark` varchar(1000) DEFAULT NULL COMMENT '备注', `config_name` varchar(255) DEFAULT NULL COMMENT '参数名称', `config_key` varchar(255) DEFAULT NULL COMMENT '参数键名', `config_value` varchar(255) DEFAULT NULL COMMENT '参数键值', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='系统参数配置信息表'; /*Data for the table `sys_config` */ insert into `sys_config`(`id`,`status`,`create_by`,`create_time`,`update_by`,`update_time`,`remark`,`config_name`,`config_key`,`config_value`) values ('1265635179754459137',1,'1214835832967581698','2020-05-27 21:25:16','1214835832967581698','2020-07-06 10:47:20','','初始化密码','sys.user.password','123456'); /*Table structure for table `sys_dept` */ DROP TABLE IF EXISTS `sys_dept`; CREATE TABLE `sys_dept` ( `id` varchar(50) NOT NULL COMMENT '主键ID', `parent_id` varchar(50) DEFAULT NULL COMMENT '父部门ID', `dept_name` varchar(50) DEFAULT NULL COMMENT '部门名称', `dept_no` varchar(50) DEFAULT NULL COMMENT '部门编码（数据权限）', `status` tinyint(4) DEFAULT NULL COMMENT '状态（0不启用，1启用）', `create_by` varchar(50) DEFAULT NULL COMMENT '创建人', `create_time` datetime DEFAULT NULL COMMENT '创建日期', `update_by` varchar(50) DEFAULT NULL COMMENT '更新人', `update_time` datetime DEFAULT NULL COMMENT '更新日期', `remark` varchar(1000) DEFAULT NULL COMMENT '备注', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='部门信息表'; /*Data for the table `sys_dept` */ insert into `sys_dept`(`id`,`parent_id`,`dept_name`,`dept_no`,`status`,`create_by`,`create_time`,`update_by`,`update_time`,`remark`) values ('1197789917762031617','0','xx科技','10',1,'1','2019-11-22 16:12:25','1214835832967581698','2021-01-05 21:29:07','1'),('1197790192543469570','1197789917762031617','研发部门','10001',1,'1','2019-11-22 16:13:30','1','2019-11-22 16:13:30',NULL),('1197790560782389250','1197789917762031617','市场部门','10002',1,'1','2019-11-22 16:14:58','1','2019-11-22 16:14:58',NULL); /*Table structure for table `sys_dept_relation` */ DROP TABLE IF EXISTS `sys_dept_relation`; CREATE TABLE `sys_dept_relation` ( `id` varchar(50) NOT NULL COMMENT '部门关系主键ID', `ancestor` varchar(50) NOT NULL COMMENT '祖先节点', `descendant` varchar(50) NOT NULL COMMENT '后代节点', PRIMARY KEY (`id`,`ancestor`,`descendant`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='部门关系表'; /*Data for the table `sys_dept_relation` */ insert into `sys_dept_relation`(`id`,`ancestor`,`descendant`) values ('1197790192677687298','1197790192543469570','1197790192543469570'),('1197790560828526593','1197790560782389250','1197790560782389250'),('1346448644767150081','1197789917762031617','1197789917762031617'); /*Table structure for table `sys_dict` */ DROP TABLE IF EXISTS `sys_dict`; CREATE TABLE `sys_dict` ( `id` varchar(50) NOT NULL COMMENT '主键ID', `status` tinyint(4) DEFAULT NULL COMMENT '状态（0不启用，1启用）', `create_by` varchar(50) DEFAULT NULL COMMENT '创建人', `create_time` datetime DEFAULT NULL COMMENT '创建日期', `update_by` varchar(50) DEFAULT NULL COMMENT '更新人', `update_time` datetime DEFAULT NULL COMMENT '更新日期', `remark` varchar(1000) DEFAULT NULL COMMENT '备注', `dict_name` varchar(50) DEFAULT NULL COMMENT '字典名称', `dict_code` varchar(50) DEFAULT NULL COMMENT '字典编码', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='字典编码信息表'; /*Data for the table `sys_dict` */ insert into `sys_dict`(`id`,`status`,`create_by`,`create_time`,`update_by`,`update_time`,`remark`,`dict_name`,`dict_code`) values ('1254701165563764738',1,'1214835832967581698','2020-04-27 17:17:24','1214835832967581698','2020-04-27 17:17:24',NULL,'菜单类型','sys_menu_type'),('1254701402755850241',1,'1214835832967581698','2020-04-27 17:18:20','1214835832967581698','2020-04-27 17:18:20',NULL,'数据状态','sys_common_status'),('1255033722255945729',1,'1214835832967581698','2020-04-28 15:18:51','1214835832967581698','2020-04-28 15:18:51',NULL,'数据范围','sys_data_scope'),('1255037349741703169',1,'1214835832967581698','2020-04-28 15:33:16','1214835832967581698','2020-04-28 15:33:16',NULL,'数据库类型','data_db_type'),('1255047550985297922',1,'1214835832967581698','2020-04-28 16:13:48','1214835832967581698','2020-04-28 16:13:48',NULL,'是否','sys_yes_no'),('1255047909942222850',1,'1214835832967581698','2020-04-28 16:15:14','1214835832967581698','2020-04-28 16:15:14',NULL,'请求方式','data_req_method'),('1255048146102509569',1,'1214835832967581698','2020-04-28 16:16:10','1214835832967581698','2020-04-28 16:16:10',NULL,'返回格式','data_res_type'),('1255049472299491329',1,'1214835832967581698','2020-04-28 16:21:27','1214835832967581698','2020-04-28 16:21:27',NULL,'配置方式','data_config_type'),('1255049868610887682',1,'1214835832967581698','2020-04-28 16:23:01','1214835832967581698','2020-04-28 16:23:01',NULL,'SQL操作符','data_where_type'),('1255050897825980418',1,'1214835832967581698','2020-04-28 16:27:06','1214835832967581698','2020-04-28 16:27:06',NULL,'参数类型','data_param_type'),('1255052030422278145',1,'1214835832967581698','2020-04-28 16:31:36','1214835832967581698','2020-04-28 16:31:36',NULL,'脱敏类型','data_cipher_type'),('1255054338933645314',1,'1214835832967581698','2020-04-28 16:40:47','1214835832967581698','2020-04-28 16:40:47',NULL,'正则规则类型','data_regex_crypto'),('1255054468176928770',1,'1214835832967581698','2020-04-28 16:41:18','1214835832967581698','2020-04-28 16:41:18',NULL,'加密规则类型','data_algorithm_crypto'),('1275048574979174401',1,'1214835832967581698','2020-06-22 20:50:44','1214835832967581698','2020-06-22 20:50:44',NULL,'任务状态','sys_job_status'),('1275054601837506561',1,'1214835832967581698','2020-06-22 21:14:41','1214835832967581698','2020-06-22 21:14:41',NULL,'系统状态','sys_normal_status'),('1280793187027292161',1,'1214835832967581698','2020-07-08 17:17:46','1214835832967581698','2020-07-08 17:17:46',NULL,'API状态','data_api_status'),('1285923703451848705',1,'1214835832967581698','2020-07-22 21:04:37','1214835832967581698','2020-07-22 21:04:37',NULL,'聚合函数','data_aggregate_type'),('1296680107225706498',1,'1296680107225706498','2020-08-21 21:04:37','1214835832967581698','2020-08-21 21:04:37',NULL,'服务类型','data_service_type'),('1300344099387244546',1,'1296680107225706498','2020-08-21 21:04:37','1214835832967581698','2020-08-21 21:04:37',NULL,'查询方式','data_query_type'),('1300344451876577281',1,'1296680107225706498','2020-08-21 21:04:37','1214835832967581698','2020-08-21 21:04:37',NULL,'显示类型','data_html_type'),('1300708138781016066',1,'1296680107225706498','2020-08-21 21:04:37','1214835832967581698','2020-08-21 21:04:37',NULL,'ORACLE数据类型','data_type_oracle'),('1301041843055632386',1,'1296680107225706498','2020-08-21 21:04:37','1214835832967581698','2020-08-21 21:04:37',NULL,'MYSQL数据类型','data_type_mysql'),('1309001146932670465',1,'1296680107225706498','2020-08-21 21:04:37','1214835832967581698','2020-08-21 21:04:37',NULL,'流程状态','sys_flow_status'),('1310494826919211009',1,'1296680107225706498','2020-08-21 21:04:37','1214835832967581698','2020-08-21 21:04:37',NULL,'字典对照状态','data_contrast_status'); /*Table structure for table `sys_dict_item` */ DROP TABLE IF EXISTS `sys_dict_item`; CREATE TABLE `sys_dict_item` ( `id` varchar(50) NOT NULL COMMENT '主键ID', `status` tinyint(4) DEFAULT NULL COMMENT '状态（0不启用，1启用）', `create_by` varchar(50) DEFAULT NULL COMMENT '创建人', `create_time` datetime DEFAULT NULL COMMENT '创建日期', `update_by` varchar(50) DEFAULT NULL COMMENT '更新人', `update_time` datetime DEFAULT NULL COMMENT '更新日期', `remark` varchar(1000) DEFAULT NULL COMMENT '备注', `dict_id` varchar(50) DEFAULT NULL COMMENT '字典id', `item_text` varchar(50) DEFAULT NULL COMMENT '字典项文本', `item_value` varchar(50) DEFAULT NULL COMMENT '字典项值', `item_sort` int(11) DEFAULT NULL COMMENT '排序', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='字典项信息表'; /*Data for the table `sys_dict_item` */ insert into `sys_dict_item`(`id`,`status`,`create_by`,`create_time`,`update_by`,`update_time`,`remark`,`dict_id`,`item_text`,`item_value`,`item_sort`) values ('1254702149128052737',1,'1214835832967581698','2020-04-27 17:21:18','1214835832967581698','2020-04-27 17:21:18',NULL,'1254701165563764738','0','模块',1),('1254702177166974977',1,'1214835832967581698','2020-04-27 17:21:25','1214835832967581698','2020-04-27 17:21:25',NULL,'1254701165563764738','1','菜单',2),('1254702210272616449',1,'1214835832967581698','2020-04-27 17:21:33','1214835832967581698','2020-04-27 17:21:33',NULL,'1254701165563764738','2','按钮',3),('1254702351834570753',1,'1214835832967581698','2020-04-27 17:22:07','1214835832967581698','2020-04-27 17:22:07',NULL,'1254701402755850241','0','禁用',1),('1254702385279950850',1,'1214835832967581698','2020-04-27 17:22:15','1214835832967581698','2020-04-27 17:22:15',NULL,'1254701402755850241','1','启用',2),('1255034071784075266',1,'1214835832967581698','2020-04-28 15:20:15','1214835832967581698','2020-04-28 15:20:15',NULL,'1255033722255945729','1','全部数据权限',1),('1255034118043054082',1,'1214835832967581698','2020-04-28 15:20:26','1214835832967581698','2020-04-28 15:20:26',NULL,'1255033722255945729','2','自定义数据权限',2),('1255034148703416321',1,'1214835832967581698','2020-04-28 15:20:33','1214835832967581698','2020-04-28 15:20:33',NULL,'1255033722255945729','3','本部门数据权限',3),('1255034178491363329',1,'1214835832967581698','2020-04-28 15:20:40','1214835832967581698','2020-04-28 15:20:40',NULL,'1255033722255945729','4','本部门及以下数据权限',4),('1255034207415283713',1,'1214835832967581698','2020-04-28 15:20:47','1214835832967581698','2020-04-28 15:20:47',NULL,'1255033722255945729','5','仅本人数据权限',5),('1255037454632857602',1,'1214835832967581698','2020-04-28 15:33:41','1214835832967581698','2020-04-28 15:33:41',NULL,'1255037349741703169','1','MySql数据库',1),('1255037499587407874',1,'1214835832967581698','2020-04-28 15:33:52','1214835832967581698','2020-04-28 15:33:52',NULL,'1255037349741703169','2','MariaDB数据库',2),('1255037543732457474',1,'1214835832967581698','2020-04-28 15:34:03','1214835832967581698','2020-04-28 15:34:03',NULL,'1255037349741703169','3','Oracle11g及以下数据库',3),('1255037611558547458',1,'1214835832967581698','2020-04-28 15:34:19','1214835832967581698','2020-04-28 15:34:19',NULL,'1255037349741703169','4','Oracle12c+数据库',4),('1255037682886881282',1,'1214835832967581698','2020-04-28 15:34:36','1214835832967581698','2020-04-28 15:34:36',NULL,'1255037349741703169','5','PostgreSql数据库',5),('1255037722741157890',1,'1214835832967581698','2020-04-28 15:34:45','1214835832967581698','2020-04-28 15:34:45',NULL,'1255037349741703169','6','SQLServer2008及以下数据库',6),('1255037772984725506',1,'1214835832967581698','2020-04-28 15:34:57','1214835832967581698','2020-04-28 15:34:57',NULL,'1255037349741703169','7','SQLServer2012+数据库',7),('1255037816378994690',1,'1214835832967581698','2020-04-28 15:35:08','1214835832967581698','2020-04-28 15:35:08',NULL,'1255037349741703169','8','其他数据库',8),('1255047584040607746',1,'1214835832967581698','2020-04-28 16:13:56','1214835832967581698','2020-04-28 16:13:56',NULL,'1255047550985297922','0','否',1),('1255047616940728322',1,'1214835832967581698','2020-04-28 16:14:04','1214835832967581698','2020-04-28 16:14:04',NULL,'1255047550985297922','1','是',2),('1255048026803920898',1,'1214835832967581698','2020-04-28 16:15:42','1214835832967581698','2020-04-28 16:15:42',NULL,'1255047909942222850','GET','GET',1),('1255048059242668033',1,'1214835832967581698','2020-04-28 16:15:50','1214835832967581698','2020-04-28 16:15:50',NULL,'1255047909942222850','POST','POST',2),('1255048227744636929',1,'1214835832967581698','2020-04-28 16:16:30','1214835832967581698','2020-04-28 16:16:30',NULL,'1255048146102509569','JSON','JSON',1),('1255049535197274113',1,'1214835832967581698','2020-04-28 16:21:42','1214835832967581698','2020-04-28 16:21:42',NULL,'1255049472299491329','1','表引导模式',1),('1255049562602856449',1,'1214835832967581698','2020-04-28 16:21:48','1214835832967581698','2020-04-28 16:21:48',NULL,'1255049472299491329','2','脚本模式',2),('1255049937749794817',1,'1214835832967581698','2020-04-28 16:23:18','1214835832967581698','2020-04-28 16:23:18',NULL,'1255049868610887682','1','等于',1),('1255049969106411521',1,'1214835832967581698','2020-04-28 16:23:25','1214835832967581698','2020-04-28 16:23:25',NULL,'1255049868610887682','2','不等于',2),('1255049996876898306',1,'1214835832967581698','2020-04-28 16:23:32','1214835832967581698','2020-04-28 16:23:32',NULL,'1255049868610887682','3','全模糊查询',3),('1255050281636585473',1,'1214835832967581698','2020-04-28 16:24:40','1214835832967581698','2020-04-28 16:24:40',NULL,'1255049868610887682','4','左模糊查询',4),('1255050325618057217',1,'1214835832967581698','2020-04-28 16:24:50','1214835832967581698','2020-04-28 16:24:50',NULL,'1255049868610887682','5','右模糊查询',5),('1255050357075337217',1,'1214835832967581698','2020-04-28 16:24:57','1214835832967581698','2020-04-28 16:24:57',NULL,'1255049868610887682','6','大于',6),('1255050386712289281',1,'1214835832967581698','2020-04-28 16:25:05','1214835832967581698','2020-04-28 16:25:05',NULL,'1255049868610887682','7','大于等于',7),('1255050425413132290',1,'1214835832967581698','2020-04-28 16:25:14','1214835832967581698','2020-04-28 16:25:14',NULL,'1255049868610887682','8','小于',8),('1255050459407966210',1,'1214835832967581698','2020-04-28 16:25:22','1214835832967581698','2020-04-28 16:25:22',NULL,'1255049868610887682','9','小于等于',9),('1255050508485517313',1,'1214835832967581698','2020-04-28 16:25:34','1214835832967581698','2020-04-28 16:25:34',NULL,'1255049868610887682','10','是否为空',10),('1255050549505810433',1,'1214835832967581698','2020-04-28 16:25:43','1214835832967581698','2020-04-28 16:25:43',NULL,'1255049868610887682','11','是否不为空',11),('1255050756901560321',1,'1214835832967581698','2020-04-28 16:26:33','1214835832967581698','2020-04-28 16:26:33',NULL,'1255049868610887682','12','IN',12),('1255051004805898241',1,'1214835832967581698','2020-04-28 16:27:32','1214835832967581698','2020-04-28 16:27:32',NULL,'1255050897825980418','1','字符串',1),('1255051030818971649',1,'1214835832967581698','2020-04-28 16:27:38','1214835832967581698','2020-04-28 16:27:38',NULL,'1255050897825980418','2','整型',2),('1255051062423052289',1,'1214835832967581698','2020-04-28 16:27:46','1214835832967581698','2020-04-28 16:27:46',NULL,'1255050897825980418','3','浮点型',3),('1255051089870577665',1,'1214835832967581698','2020-04-28 16:27:52','1214835832967581698','2020-04-28 16:27:52',NULL,'1255050897825980418','4','时间',4),('1255051121646624770',1,'1214835832967581698','2020-04-28 16:28:00','1214835832967581698','2020-04-28 16:28:00',NULL,'1255050897825980418','5','集合',5),('1255052103847763970',1,'1214835832967581698','2020-04-28 16:31:54','1214835832967581698','2020-04-28 16:31:54',NULL,'1255052030422278145','1','正则替换',1),('1255052128799678465',1,'1214835832967581698','2020-04-28 16:32:00','1214835832967581698','2020-04-28 16:32:00',NULL,'1255052030422278145','2','加密算法',2),('1255054729293324290',1,'1214835832967581698','2020-04-28 16:42:20','1214835832967581698','2020-04-28 16:42:20',NULL,'1255054338933645314','1','中文姓名',1),('1255054769277624322',1,'1214835832967581698','2020-04-28 16:42:29','1214835832967581698','2020-04-28 16:42:29',NULL,'1255054338933645314','2','身份证号',2),('1255054810838982657',1,'1214835832967581698','2020-04-28 16:42:39','1214835832967581698','2020-04-28 16:42:39',NULL,'1255054338933645314','3','固定电话',3),('1255054840111030274',1,'1214835832967581698','2020-04-28 16:42:46','1214835832967581698','2020-04-28 16:42:46',NULL,'1255054338933645314','4','手机号码',4),('1255054878862204929',1,'1214835832967581698','2020-04-28 16:42:56','1214835832967581698','2020-04-28 16:42:56',NULL,'1255054338933645314','5','地址',5),('1255054911183511553',1,'1214835832967581698','2020-04-28 16:43:03','1214835832967581698','2020-04-28 16:43:03',NULL,'1255054338933645314','6','电子邮箱',6),('1255054941030178817',1,'1214835832967581698','2020-04-28 16:43:10','1214835832967581698','2020-04-28 16:43:10',NULL,'1255054338933645314','7','银行卡号',7),('1255054975704489986',1,'1214835832967581698','2020-04-28 16:43:19','1214835832967581698','2020-04-28 16:43:19',NULL,'1255054338933645314','8','公司开户银行联号',8),('1255055043568328706',1,'1214835832967581698','2020-04-28 16:43:35','1214835832967581698','2020-04-28 16:43:35',NULL,'1255054468176928770','1','BASE64加密',1),('1255055072123150338',1,'1214835832967581698','2020-04-28 16:43:42','1214835832967581698','2020-04-28 16:43:42',NULL,'1255054468176928770','2','MD5加密',2),('1255055103777562626',1,'1214835832967581698','2020-04-28 16:43:49','1214835832967581698','2020-04-28 16:43:49',NULL,'1255054468176928770','3','SHA_1加密',3),('1255055137550098434',1,'1214835832967581698','2020-04-28 16:43:57','1214835832967581698','2020-04-28 16:43:57',NULL,'1255054468176928770','4','SHA_256加密',4),('1255055168852189186',1,'1214835832967581698','2020-04-28 16:44:05','1214835832967581698','2020-04-28 16:44:05',NULL,'1255054468176928770','5','AES加密',5),('1255055201391599617',1,'1214835832967581698','2020-04-28 16:44:12','1214835832967581698','2020-04-28 16:44:12',NULL,'1255054468176928770','6','DES加密',6),('1275048742365458434',1,'1214835832967581698','2020-06-22 20:51:24','1214835832967581698','2020-06-22 20:51:24',NULL,'1275048574979174401','0','暂停',1),('1275048809193304065',1,'1214835832967581698','2020-06-22 20:51:40','1214835832967581698','2020-06-22 20:51:40',NULL,'1275048574979174401','1','运行',2),('1275054736508219394',1,'1214835832967581698','2020-06-22 21:15:13','1214835832967581698','2020-06-22 21:15:13',NULL,'1275054601837506561','0','失败',1),('1275054803906490370',1,'1214835832967581698','2020-06-22 21:15:29','1214835832967581698','2020-06-22 21:15:29',NULL,'1275054601837506561','1','成功',2),('1280793322234875905',1,'1214835832967581698','2020-07-08 17:18:19','1214835832967581698','2020-07-08 17:18:19',NULL,'1280793187027292161','1','待发布',1),('1280793374244245505',1,'1214835832967581698','2020-07-08 17:18:31','1214835832967581698','2020-07-08 17:18:31',NULL,'1280793187027292161','2','已发布',2),('1280793418611593218',1,'1214835832967581698','2020-07-08 17:18:42','1214835832967581698','2020-07-08 17:18:42',NULL,'1280793187027292161','3','已下线',3),('1285924274212737026',1,'1214835832967581698','2020-07-22 21:06:53','1214835832967581698','2020-07-22 21:06:53',NULL,'1285923703451848705','AVG','平均值',1),('1285924403900616706',1,'1214835832967581698','2020-07-22 21:07:24','1214835832967581698','2020-07-22 21:07:24',NULL,'1285923703451848705','COUNT','计数',2),('1285924488742998018',1,'1214835832967581698','2020-07-22 21:07:44','1214835832967581698','2020-07-22 21:07:44',NULL,'1285923703451848705','MAX','最大值',3),('1285924564915752961',1,'1214835832967581698','2020-07-22 21:08:02','1214835832967581698','2020-07-22 21:08:02',NULL,'1285923703451848705','MIN','最小值',4),('1285924644037103617',1,'1214835832967581698','2020-07-22 21:08:21','1214835832967581698','2020-07-22 21:08:21',NULL,'1285923703451848705','SUM','求和',5),('1296680479872815106',1,'1296680107225706498','2020-08-21 21:04:37','1296680107225706498','2020-08-21 21:04:37',NULL,'1296680107225706498','1','http接口',1),('1296680800095338497',1,'1296680107225706498','2020-08-21 21:04:37','1296680107225706498','2020-08-21 21:04:37',NULL,'1296680107225706498','2','webservice接口',2),('1300344676871569410',1,'1296680107225706498','2020-08-21 21:04:37','1296680107225706498','2020-08-21 21:04:37',NULL,'1300344099387244546','eq','=',1),('1300344719984926721',1,'1296680107225706498','2020-08-21 21:04:37','1296680107225706498','2020-08-21 21:04:37',NULL,'1300344099387244546','ne','!=',2),('1300344887987683330',1,'1296680107225706498','2020-08-21 21:04:37','1296680107225706498','2020-08-21 21:04:37',NULL,'1300344099387244546','gt','>',3),('1300344940169011202',1,'1296680107225706498','2020-08-21 21:04:37','1296680107225706498','2020-08-21 21:04:37',NULL,'1300344099387244546','ge','>=',4),('1300344991276687361',1,'1296680107225706498','2020-08-21 21:04:37','1296680107225706498','2020-08-21 21:04:37',NULL,'1300344099387244546','lt','<',5),('1300345039674744833',1,'1296680107225706498','2020-08-21 21:04:37','1296680107225706498','2020-08-21 21:04:37',NULL,'1300344099387244546','le','<=',6),('1300345083937226754',1,'1296680107225706498','2020-08-21 21:04:37','1296680107225706498','2020-08-21 21:04:37',NULL,'1300344099387244546','like','like',7),('1300345183094763522',1,'1296680107225706498','2020-08-21 21:04:37','1296680107225706498','2020-08-21 21:04:37',NULL,'1300344099387244546','between','between',8),('1300345958537633794',1,'1296680107225706498','2020-08-21 21:04:37','1296680107225706498','2020-08-21 21:04:37',NULL,'1300344451876577281','input','文本框',1),('1300345964648734722',1,'1296680107225706498','2020-08-21 21:04:37','1296680107225706498','2020-08-21 21:04:37',NULL,'1300344451876577281','textarea','文本域',2),('1300345968855621633',1,'1296680107225706498','2020-08-21 21:04:37','1296680107225706498','2020-08-21 21:04:37',NULL,'1300344451876577281','select','下拉框',3),('1300345973049925633',1,'1296680107225706498','2020-08-21 21:04:37','1296680107225706498','2020-08-21 21:04:37',NULL,'1300344451876577281','radio','单选框',4),('1300345977248423937',1,'1296680107225706498','2020-08-21 21:04:37','1296680107225706498','2020-08-21 21:04:37',NULL,'1300344451876577281','checkbox','复选框',5),('1300345981438533633',1,'1296680107225706498','2020-08-21 21:04:37','1296680107225706498','2020-08-21 21:04:37',NULL,'1300344451876577281','datetime','日期控件',6),('1300708143558328322',1,'1296680107225706498','2020-08-21 21:04:37','1296680107225706498','2020-08-21 21:04:37',NULL,'1300708138781016066','char','字符串',1),('1300708156141240321',1,'1296680107225706498','2020-08-21 21:04:37','1296680107225706498','2020-08-21 21:04:37',NULL,'1300708138781016066','number','数值',2),('1300708160343932930',1,'1296680107225706498','2020-08-21 21:04:37','1296680107225706498','2020-08-21 21:04:37',NULL,'1300708138781016066','date','日期',3),('1300708164542431234',1,'1296680107225706498','2020-08-21 21:04:37','1296680107225706498','2020-08-21 21:04:37',NULL,'1300708138781016066','clob','长文本',4),('1301041851154833410',1,'1296680107225706498','2020-08-21 21:04:37','1296680107225706498','2020-08-21 21:04:37',NULL,'1301041843055632386','tinyint','tinyint整型',1),('1301041854644494338',1,'1296680107225706498','2020-08-21 21:04:37','1296680107225706498','2020-08-21 21:04:37',NULL,'1301041843055632386','int','int整型',2),('1301041857957994497',1,'1296680107225706498','2020-08-21 21:04:37','1296680107225706498','2020-08-21 21:04:37',NULL,'1301041843055632386','bigint','bigint整型',3),('1301041860990476290',1,'1296680107225706498','2020-08-21 21:04:37','1296680107225706498','2020-08-21 21:04:37',NULL,'1301041843055632386','float','单精度',4),('1301041864538857474',1,'1296680107225706498','2020-08-21 21:04:37','1296680107225706498','2020-08-21 21:04:37',NULL,'1301041843055632386','double','双精度',5),('1301041867428732929',1,'1296680107225706498','2020-08-21 21:04:37','1296680107225706498','2020-08-21 21:04:37',NULL,'1301041843055632386','decimal','定点数',6),('1301041870465409025',1,'1296680107225706498','2020-08-21 21:04:37','1296680107225706498','2020-08-21 21:04:37',NULL,'1301041843055632386','char','定长字符串',7),('1301041873263009793',1,'1296680107225706498','2020-08-21 21:04:37','1296680107225706498','2020-08-21 21:04:37',NULL,'1301041843055632386','varchar','变长字符串',8),('1301041875733454849',1,'1296680107225706498','2020-08-21 21:04:37','1296680107225706498','2020-08-21 21:04:37',NULL,'1301041843055632386','text','长文本',9),('1301041878837239810',1,'1296680107225706498','2020-08-21 21:04:37','1296680107225706498','2020-08-21 21:04:37',NULL,'1301041843055632386','date','date日期',10),('1301041882624696322',1,'1296680107225706498','2020-08-21 21:04:37','1296680107225706498','2020-08-21 21:04:37',NULL,'1301041843055632386','time','time日期',11),('1301041884780568578',1,'1296680107225706498','2020-08-21 21:04:37','1296680107225706498','2020-08-21 21:04:37',NULL,'1301041843055632386','year','year日期',12),('1301041887540420609',1,'1296680107225706498','2020-08-21 21:04:37','1296680107225706498','2020-08-21 21:04:37',NULL,'1301041843055632386','datetime','datetime日期',13),('1302079329039069185',1,'1296680107225706498','2020-08-21 21:04:37','1296680107225706498','2020-08-21 21:04:37',NULL,'1300344451876577281','number','数字值',7),('1309001150548160514',1,'1296680107225706498','2020-08-21 21:04:37','1296680107225706498','2020-08-21 21:04:37',NULL,'1309001146932670465','1','待提交',1),('1309001154742464514',1,'1296680107225706498','2020-08-21 21:04:37','1296680107225706498','2020-08-21 21:04:37',NULL,'1309001146932670465','2','已退回',2),('1309001158517338114',1,'1296680107225706498','2020-08-21 21:04:37','1296680107225706498','2020-08-21 21:04:37',NULL,'1309001146932670465','3','审核中',3),('1309001162443206658',1,'1296680107225706498','2020-08-21 21:04:37','1296680107225706498','2020-08-21 21:04:37',NULL,'1309001146932670465','4','通过',4),('1309001165593128962',1,'1296680107225706498','2020-08-21 21:04:37','1296680107225706498','2020-08-21 21:04:37',NULL,'1309001146932670465','5','不通过',5),('1309001167749001218',1,'1296680107225706498','2020-08-21 21:04:37','1296680107225706498','2020-08-21 21:04:37',NULL,'1309001146932670465','6','已撤销',6),('1310494837983784962',1,'1296680107225706498','2020-08-21 21:04:37','1296680107225706498','2020-08-21 21:04:37',NULL,'1310494826919211009','0','未对照',1),('1310494841284702210',1,'1296680107225706498','2020-08-21 21:04:37','1296680107225706498','2020-08-21 21:04:37',NULL,'1310494826919211009','1','已对照',2); /*Table structure for table `sys_log` */ DROP TABLE IF EXISTS `sys_log`; CREATE TABLE `sys_log` ( `id` varchar(50) NOT NULL COMMENT '日志主键ID', `module` varchar(50) DEFAULT NULL COMMENT '所属模块', `title` varchar(50) DEFAULT NULL COMMENT '日志标题', `user_id` varchar(50) DEFAULT NULL COMMENT '用户ID', `user_name` varchar(50) DEFAULT NULL COMMENT '用户名称', `remote_addr` varchar(50) DEFAULT NULL COMMENT '请求IP', `request_uri` varchar(50) DEFAULT NULL COMMENT '请求URI', `class_name` varchar(255) DEFAULT NULL COMMENT '方法类名', `method_name` varchar(50) DEFAULT NULL COMMENT '方法名称', `params` varchar(2000) DEFAULT NULL COMMENT '请求参数', `time` varchar(50) DEFAULT NULL COMMENT '请求耗时', `browser` varchar(50) DEFAULT NULL COMMENT '浏览器名称', `os` varchar(50) DEFAULT NULL COMMENT '操作系统', `ex_code` varchar(255) DEFAULT NULL COMMENT '错误类型', `ex_msg` varchar(2000) DEFAULT NULL COMMENT '错误信息', `create_time` datetime DEFAULT NULL COMMENT '创建日期', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='日志信息表'; /*Data for the table `sys_log` */ insert into `sys_log`(`id`,`module`,`title`,`user_id`,`user_name`,`remote_addr`,`request_uri`,`class_name`,`method_name`,`params`,`time`,`browser`,`os`,`ex_code`,`ex_msg`,`create_time`) values ('1265261406136143873','datax-service-system','根据id获取用户详细信息','1214835832967581698','admin','192.168.0.107','/users/1214835832967581698','cn.datax.service.system.controller.UserController','getUserById','','15','Chrome','Windows 10 or Windows Server 2016',NULL,NULL,'2020-05-26 20:40:01'),('1265261962695118849','datax-service-system','根据id获取用户详细信息','1214835832967581698','admin','192.168.0.107','/users/1214835832967581698','cn.datax.service.system.controller.UserController','getUserById','','16','Chrome','Windows 10 or Windows Server 2016',NULL,NULL,'2020-05-26 20:42:14'),('1265263362518913026','datax-service-system','根据id获取用户详细信息','1214835832967581698','admin','192.168.0.107','/users/1214835832967581698','cn.datax.service.system.controller.UserController','getUserById','','32','Chrome','Windows 10 or Windows Server 2016',NULL,NULL,'2020-05-26 20:47:48'),('1265263766308753410','datax-service-system','根据id获取用户详细信息','1214835832967581698','admin','192.168.0.107','/users/1214835832967581698','cn.datax.service.system.controller.UserController','getUserById','','11','Chrome','Windows 10 or Windows Server 2016',NULL,NULL,'2020-05-26 20:49:24'),('1265263890720198657','datax-service-system','根据id获取用户详细信息','1214835832967581698','admin','192.168.0.107','/users/1214835832967581698','cn.datax.service.system.controller.UserController','getUserById','','15','Chrome','Windows 10 or Windows Server 2016',NULL,NULL,'2020-05-26 20:49:54'),('1265265416712851457','datax-service-system','根据id获取用户详细信息','1214835832967581698','admin','192.168.0.107','/users/1214835832967581698','cn.datax.service.system.controller.UserController','getUserById','','14','Chrome','Windows 10 or Windows Server 2016',NULL,NULL,'2020-05-26 20:55:57'),('1265265809526198274','datax-service-system','根据id获取用户详细信息','1214835832967581698','admin','192.168.0.107','/users/1214835832967581698','cn.datax.service.system.controller.UserController','getUserById','','20','Chrome','Windows 10 or Windows Server 2016',NULL,NULL,'2020-05-26 20:57:31'),('1265267017112457218','datax-service-system','根据id获取用户详细信息','1214835832967581698','admin','192.168.0.107','/users/1214835832967581698','cn.datax.service.system.controller.UserController','getUserById','','20','Chrome','Windows 10 or Windows Server 2016',NULL,NULL,'2020-05-26 21:02:19'),('1265267219084972034','datax-service-system','根据id获取用户详细信息','1214835832967581698','admin','192.168.0.107','/users/1214835832967581698','cn.datax.service.system.controller.UserController','getUserById','','28','Chrome','Windows 10 or Windows Server 2016',NULL,NULL,'2020-05-26 21:03:07'),('1265267267982168065','datax-service-system','根据id获取用户详细信息','1214835832967581698','admin','192.168.0.107','/users/1214835832967581698','cn.datax.service.system.controller.UserController','getUserById','','19','Chrome','Windows 10 or Windows Server 2016',NULL,NULL,'2020-05-26 21:03:19'),('1265267809718472706','datax-service-system','根据id获取用户详细信息','1214835832967581698','admin','192.168.0.107','/users/1214835832967581698','cn.datax.service.system.controller.UserController','getUserById','','12','Chrome','Windows 10 or Windows Server 2016',NULL,NULL,'2020-05-26 21:05:28'),('1265268643084734465','datax-service-system','根据id获取用户详细信息','1214835832967581698','admin','192.168.0.107','/users/1214835832967581698','cn.datax.service.system.controller.UserController','getUserById','','21','Chrome','Windows 10 or Windows Server 2016',NULL,NULL,'2020-05-26 21:08:47'),('1265270421033422849','datax-service-system','根据id获取用户详细信息','1214835832967581698','admin','192.168.0.107','/users/1214835832967581698','cn.datax.service.system.controller.UserController','getUserById','','15','Chrome','Windows 10 or Windows Server 2016',NULL,NULL,'2020-05-26 21:15:51'),('1265272879650541569','datax-service-system','根据id获取用户详细信息','1214835832967581698','admin','192.168.0.107','/users/1214835832967581698','cn.datax.service.system.controller.UserController','getUserById','','18','Chrome','Windows 10 or Windows Server 2016',NULL,NULL,'2020-05-26 21:25:37'),('1265273650702028802','datax-service-system','根据id获取用户详细信息','1214835832967581698','admin','192.168.0.107','/users/1214835832967581698','cn.datax.service.system.controller.UserController','getUserById','','22','Chrome','Windows 10 or Windows Server 2016',NULL,NULL,'2020-05-26 21:28:41'),('1265273816318316546','datax-service-system','根据id获取用户详细信息','1214835832967581698','admin','192.168.0.107','/users/1214835832967581698','cn.datax.service.system.controller.UserController','getUserById','','15','Chrome','Windows 10 or Windows Server 2016',NULL,NULL,'2020-05-26 21:29:20'),('1265274458134908929','datax-service-system','根据id获取用户详细信息','1214835832967581698','admin','192.168.0.107','/users/1214835832967581698','cn.datax.service.system.controller.UserController','getUserById','','19','Chrome','Windows 10 or Windows Server 2016',NULL,NULL,'2020-05-26 21:31:53'),('1265274502791663618','datax-service-system','根据id获取用户详细信息','1214835832967581698','admin','192.168.0.107','/users/1214835832967581698','cn.datax.service.system.controller.UserController','getUserById','','31','Chrome','Windows 10 or Windows Server 2016',NULL,NULL,'2020-05-26 21:32:04'),('1265274557405696002','datax-service-system','根据id获取用户详细信息','1214835832967581698','admin','192.168.0.107','/users/1214835832967581698','cn.datax.service.system.controller.UserController','getUserById','','8','Chrome','Windows 10 or Windows Server 2016',NULL,NULL,'2020-05-26 21:32:17'),('1265274576221343745','datax-service-system','根据id获取用户详细信息','1214835832967581698','admin','192.168.0.107','/users/1214835832967581698','cn.datax.service.system.controller.UserController','getUserById','','13','Chrome','Windows 10 or Windows Server 2016',NULL,NULL,'2020-05-26 21:32:21'),('1265274629749051393','datax-service-system','根据id获取用户详细信息','1214835832967581698','admin','192.168.0.107','/users/1214835832967581698','cn.datax.service.system.controller.UserController','getUserById','','97','Chrome','Windows 10 or Windows Server 2016',NULL,NULL,'2020-05-26 21:32:34'),('1265274945081020418','datax-service-system','根据id获取用户详细信息','1214835832967581698','admin','192.168.0.107','/users/1265274861165580290','cn.datax.service.system.controller.UserController','getUserById','','17','Chrome','Windows 10 or Windows Server 2016',NULL,NULL,'2020-05-26 21:33:49'),('1265627232303353857','datax-service-system','根据id获取用户详细信息','1214835832967581698','admin','192.168.0.107','/users/1214835832967581698','cn.datax.service.system.controller.UserController','getUserById','','14','Chrome','Windows 10 or Windows Server 2016',NULL,NULL,'2020-05-27 20:53:41'),('1265632019614830594','datax-service-system','根据id获取用户详细信息','1214835832967581698','admin','192.168.0.107','/users/1214835832967581698','cn.datax.service.system.controller.UserController','getUserById','','17','Chrome','Windows 10 or Windows Server 2016',NULL,NULL,'2020-05-27 21:12:42'),('1265637282912702465','datax-service-system','根据id获取用户详细信息','1214835832967581698','admin','192.168.0.107','/users/1214835832967581698','cn.datax.service.system.controller.UserController','getUserById','','26','Chrome','Windows 10 or Windows Server 2016',NULL,NULL,'2020-05-27 21:33:37'),('1265640522375008258','datax-service-system','根据id获取用户详细信息','1214835832967581698','admin','192.168.0.107','/users/1214835832967581698','cn.datax.service.system.controller.UserController','getUserById','','19','Chrome','Windows 10 or Windows Server 2016',NULL,NULL,'2020-05-27 21:46:30'),('1265976846751682562','datax-service-system','根据id获取用户详细信息','1214835832967581698','admin','192.168.0.107','/users/1265274861165580290','cn.datax.service.system.controller.UserController','getUserById','','15','Chrome','Windows 10 or Windows Server 2016',NULL,NULL,'2020-05-28 20:02:56'),('1265978978921926658','datax-service-system','根据id获取用户详细信息','1214835832967581698','admin','192.168.0.107','/users/1265274861165580290','cn.datax.service.system.controller.UserController','getUserById','','16','Chrome','Windows 10 or Windows Server 2016',NULL,NULL,'2020-05-28 20:11:24'),('1265979289124261890','datax-service-system','根据id获取用户详细信息','1214835832967581698','admin','192.168.0.107','/users/1214835832967581698','cn.datax.service.system.controller.UserController','getUserById','','18','Chrome','Windows 10 or Windows Server 2016',NULL,NULL,'2020-05-28 20:12:38'),('1265979380824330242','datax-service-system','根据id获取用户详细信息','1214835832967581698','admin','192.168.0.107','/users/1214835832967581698','cn.datax.service.system.controller.UserController','getUserById','','24','Chrome','Windows 10 or Windows Server 2016',NULL,NULL,'2020-05-28 20:13:00'),('1265980102571773954','datax-service-system','根据id获取用户详细信息','1214835832967581698','admin','192.168.0.107','/users/1214835832967581698','cn.datax.service.system.controller.UserController','getUserById','','19','Chrome','Windows 10 or Windows Server 2016',NULL,NULL,'2020-05-28 20:15:52'),('1265980125481062402','datax-service-system','根据id获取用户详细信息','1214835832967581698','admin','192.168.0.107','/users/1214835832967581698','cn.datax.service.system.controller.UserController','getUserById','','31','Chrome','Windows 10 or Windows Server 2016',NULL,NULL,'2020-05-28 20:15:57'),('1265980311502639105','datax-service-system','根据id获取用户详细信息','1214835832967581698','admin','192.168.0.107','/users/1214835832967581698','cn.datax.service.system.controller.UserController','getUserById','','29','Chrome','Windows 10 or Windows Server 2016',NULL,NULL,'2020-05-28 20:16:42'),('1265980577702531074','datax-service-system','根据id获取用户详细信息','1214835832967581698','admin','192.168.0.107','/users/1214835832967581698','cn.datax.service.system.controller.UserController','getUserById','','21','Chrome','Windows 10 or Windows Server 2016',NULL,NULL,'2020-05-28 20:17:45'),('1265981370732171265','datax-service-system','根据id获取用户详细信息','1214835832967581698','admin','192.168.0.107','/users/1214835832967581698','cn.datax.service.system.controller.UserController','getUserById','','14','Chrome','Windows 10 or Windows Server 2016',NULL,NULL,'2020-05-28 20:20:54'),('1265981831040258049','datax-service-system','根据id获取用户详细信息','1214835832967581698','admin','192.168.0.107','/users/1214835832967581698','cn.datax.service.system.controller.UserController','getUserById','','13','Chrome','Windows 10 or Windows Server 2016',NULL,NULL,'2020-05-28 20:22:44'),('1265981907770855426','datax-service-system','根据id获取用户详细信息','1214835832967581698','admin','192.168.0.107','/users/1265274861165580290','cn.datax.service.system.controller.UserController','getUserById','','23','Chrome','Windows 10 or Windows Server 2016',NULL,NULL,'2020-05-28 20:23:02'),('1265982263682715650','datax-service-system','根据id获取用户详细信息','1214835832967581698','admin','192.168.0.107','/users/1265274861165580290','cn.datax.service.system.controller.UserController','getUserById','','19','Chrome','Windows 10 or Windows Server 2016',NULL,NULL,'2020-05-28 20:24:27'),('1265982404875571202','datax-service-system','根据id获取用户详细信息','1214835832967581698','admin','192.168.0.107','/users/1265274861165580290','cn.datax.service.system.controller.UserController','getUserById','','18','Chrome','Windows 10 or Windows Server 2016',NULL,NULL,'2020-05-28 20:25:01'),('1265982486152794113','datax-service-system','根据id获取用户详细信息','1214835832967581698','admin','192.168.0.107','/users/1265274861165580290','cn.datax.service.system.controller.UserController','getUserById','','34','Chrome','Windows 10 or Windows Server 2016',NULL,NULL,'2020-05-28 20:25:20'),('1265982592616812545','datax-service-system','根据id获取用户详细信息','1214835832967581698','admin','192.168.0.107','/users/1265274861165580290','cn.datax.service.system.controller.UserController','getUserById','','19','Chrome','Windows 10 or Windows Server 2016',NULL,NULL,'2020-05-28 20:25:46'),('1266361799507185665','datax-service-system','根据id获取用户详细信息','1214835832967581698','admin','192.168.0.107','/users/1214835832967581698','cn.datax.service.system.controller.UserController','getUserById','','14','Chrome','Windows 10 or Windows Server 2016',NULL,NULL,'2020-05-29 21:32:36'),('1267085228254515202','datax-service-system','根据id获取用户详细信息','1214835832967581698','admin','192.168.0.107','/users/1214835832967581698','cn.datax.service.system.controller.UserController','getUserById','','23','Chrome','Windows 10 or Windows Server 2016',NULL,NULL,'2020-05-31 21:27:14'),('1272863883182260226','datax-service-system','根据id获取用户详细信息','1214835832967581698','admin','192.168.0.107','/users/1214835832967581698','cn.datax.service.system.controller.UserController','getUserById','','14','Chrome','Windows 10 or Windows Server 2016',NULL,NULL,'2020-06-16 20:09:33'),('1272863961049513985','datax-service-system','根据id获取用户详细信息','1214835832967581698','admin','192.168.0.107','/users/1214835832967581698','cn.datax.service.system.controller.UserController','getUserById','','20','Chrome','Windows 10 or Windows Server 2016',NULL,NULL,'2020-06-16 20:09:52'),('1273599081343668226','datax-service-system','根据id获取用户详细信息','1214835832967581698','admin','192.168.0.107','/users/1214835832967581698','cn.datax.service.system.controller.UserController','getUserById','','15','Chrome','Windows 10 or Windows Server 2016',NULL,NULL,'2020-06-18 20:50:58'),('1278163103812476930','datax-service-system','根据id获取用户详细信息','1214835832967581698','admin','192.168.0.107','/users/1214835832967581698','cn.datax.service.system.controller.UserController','getUserById','{\"id\":\"1214835832967581698\"}','14','Chrome','Windows 10 or Windows Server 2016',NULL,NULL,'2020-07-01 11:06:46'),('1278516062761086977','datax-service-system','根据id获取用户详细信息','1214835832967581698','admin','192.168.0.107','/users/1214835832967581698','cn.datax.service.system.controller.UserController','getUserById','{\"id\":\"1214835832967581698\"}','16','Chrome','Windows 10 or Windows Server 2016',NULL,NULL,'2020-07-02 10:29:18'),('1278520069550338050','datax-service-system','根据id获取用户详细信息','1214835832967581698','admin','192.168.0.107','/users/1214835832967581698','cn.datax.service.system.controller.UserController','getUserById','{\"id\":\"1214835832967581698\"}','16','Chrome','Windows 10 or Windows Server 2016',NULL,NULL,'2020-07-02 10:45:13'),('1319093199947554818','datax-service-system','根据id获取用户详细信息','1319084968579817473','ls','192.168.2.187','/users/1319084615276814337','cn.datax.service.system.controller.UserController','getUserById','{\"id\":\"1319084615276814337\"}','30','Chrome','Windows 10 or Windows Server 2016',NULL,NULL,'2020-10-22 09:48:21'),('1321736221868789762','datax-service-system','根据id获取用户详细信息','1214835832967581698','admin','192.168.2.187','/users/1214835832967581698','cn.datax.service.system.controller.UserController','getUserById','{\"id\":\"1214835832967581698\"}','81','Chrome','Windows 10 or Windows Server 2016',NULL,NULL,'2020-10-29 16:50:47'),('1321736248678780929','datax-service-system','根据id获取用户详细信息','1214835832967581698','admin','192.168.2.187','/users/1214835832967581698','cn.datax.service.system.controller.UserController','getUserById','{\"id\":\"1214835832967581698\"}','31','Chrome','Windows 10 or Windows Server 2016',NULL,NULL,'2020-10-29 16:50:53'),('1321736734307880961','datax-service-system','根据id获取用户详细信息','1214835832967581698','admin','192.168.2.187','/users/1214835832967581698','cn.datax.service.system.controller.UserController','getUserById','{\"id\":\"1214835832967581698\"}','34','Chrome','Windows 10 or Windows Server 2016',NULL,NULL,'2020-10-29 16:52:49'),('1335762100828164097','datax-service-system','根据id获取用户详细信息','1214835832967581698','admin','192.168.30.11','/users/1335761402136809473','cn.datax.service.system.controller.UserController','getUserById','{\"id\":\"1335761402136809473\"}','96','Chrome','Windows 10 or Windows Server 2016',NULL,NULL,'2020-12-07 09:44:37'),('1335762124542758914','datax-service-system','根据id获取用户详细信息','1214835832967581698','admin','192.168.30.11','/users/1335761402136809473','cn.datax.service.system.controller.UserController','getUserById','{\"id\":\"1335761402136809473\"}','103','Chrome','Windows 10 or Windows Server 2016',NULL,NULL,'2020-12-07 09:44:42'),('1335762217010384897','datax-service-system','根据id获取用户详细信息','1214835832967581698','admin','192.168.30.11','/users/1335761402136809473','cn.datax.service.system.controller.UserController','getUserById','{\"id\":\"1335761402136809473\"}','102','Chrome','Windows 10 or Windows Server 2016',NULL,NULL,'2020-12-07 09:45:04'); /*Table structure for table `sys_login_log` */ DROP TABLE IF EXISTS `sys_login_log`; CREATE TABLE `sys_login_log` ( `id` varchar(50) NOT NULL COMMENT '主键ID', `op_os` varchar(255) DEFAULT NULL COMMENT '操作系统', `op_browser` varchar(255) DEFAULT NULL COMMENT '浏览器类型', `op_ip` varchar(255) DEFAULT NULL COMMENT '登录IP地址', `op_date` datetime DEFAULT NULL COMMENT '登录时间', `user_id` varchar(50) DEFAULT NULL COMMENT '登录用户ID', `user_name` varchar(50) DEFAULT NULL COMMENT '登录用户名称', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='登录日志信息表'; /*Data for the table `sys_login_log` */ insert into `sys_login_log`(`id`,`op_os`,`op_browser`,`op_ip`,`op_date`,`user_id`,`user_name`) values ('1346331863834681345','Windows 10','Chrome 8','0:0:0:0:0:0:0:1%0','2021-01-05 13:45:05','1214835832967581698','admin'),('1346375822271246337','Windows 10','Chrome 8','127.0.0.1','2021-01-05 16:39:45','1214835832967581698','admin'),('1346377057556688898','Windows 10','Chrome 8','0:0:0:0:0:0:0:1%0','2021-01-05 16:44:40','1214835832967581698','admin'),('1346377788481269761','Windows 10','Chrome 8','0:0:0:0:0:0:0:1%0','2021-01-05 16:47:34','1214835832967581698','admin'),('1346386803638595585','Mac OS X','Chrome 8','127.0.0.1','2021-01-05 17:23:23','1214835832967581698','admin'),('1346388199251308545','Mac OS X','Chrome 8','0:0:0:0:0:0:0:1%0','2021-01-05 17:28:56','1214835832967581698','admin'),('1346770486128177154','Mac OS X','Chrome 8','0:0:0:0:0:0:0:1%0','2021-01-06 18:48:00','1214835832967581698','admin'),('1779710405793603586','Windows 10','Chrome 12','127.0.0.1','2024-04-15 11:16:41','1214835832967581698','admin'); /*Table structure for table `sys_menu` */ DROP TABLE IF EXISTS `sys_menu`; CREATE TABLE `sys_menu` ( `id` varchar(50) NOT NULL COMMENT '主键ID', `parent_id` varchar(50) DEFAULT NULL COMMENT '父资源ID', `menu_name` varchar(255) DEFAULT NULL COMMENT '资源名称', `menu_path` varchar(255) DEFAULT NULL COMMENT '对应路由path', `menu_component` varchar(255) DEFAULT NULL COMMENT '对应路由组件component', `menu_redirect` varchar(255) DEFAULT NULL COMMENT '对应路由默认跳转地址redirect', `menu_perms` varchar(255) DEFAULT NULL COMMENT '权限标识', `menu_icon` varchar(255) DEFAULT NULL COMMENT '图标', `menu_type` tinyint(4) DEFAULT NULL COMMENT '类型（0模块，1菜单，2按钮）', `menu_code` varchar(255) DEFAULT NULL COMMENT '资源编码', `menu_hidden` tinyint(4) DEFAULT NULL COMMENT '资源隐藏（0否，1是）', `menu_sort` int(11) DEFAULT NULL COMMENT '排序', `status` tinyint(4) DEFAULT NULL COMMENT '状态（0不启用，1启用）', `create_by` varchar(50) DEFAULT NULL COMMENT '创建人', `create_time` datetime DEFAULT NULL COMMENT '创建日期', `update_by` varchar(50) DEFAULT NULL COMMENT '更新人', `update_time` datetime DEFAULT NULL COMMENT '更新日期', `remark` varchar(1000) DEFAULT NULL COMMENT '备注', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='资源权限信息表'; /*Data for the table `sys_menu` */ insert into `sys_menu`(`id`,`parent_id`,`menu_name`,`menu_path`,`menu_component`,`menu_redirect`,`menu_perms`,`menu_icon`,`menu_type`,`menu_code`,`menu_hidden`,`menu_sort`,`status`,`create_by`,`create_time`,`update_by`,`update_time`,`remark`) values ('1323439314692685825','0','平台基础设置','/basic','Layout','/basic/index',NULL,'form',0,'10',0,1,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323439318413033473','1323439314692685825','看板','index','/basic/index',NULL,NULL,'form',1,NULL,1,1,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323439321634258945','1323439314692685825','系统管理','system','/basic/system/index','/basic/system/post',NULL,'form',0,'1010',0,2,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323439323769159681','1323439321634258945','岗位管理','post','/basic/system/post/index',NULL,NULL,'form',1,'1011',0,1,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323439327296569346','1323439323769159681','岗位新增',NULL,NULL,NULL,'system:post:add',NULL,2,NULL,0,1,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323439329708294145','1323439323769159681','岗位修改',NULL,NULL,NULL,'system:post:edit',NULL,2,NULL,0,2,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323439332476534786','1323439323769159681','岗位详情',NULL,NULL,NULL,'system:post:detail',NULL,2,NULL,0,3,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323439336071053314','1323439323769159681','岗位删除',NULL,NULL,NULL,'system:post:remove',NULL,2,NULL,0,4,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323439338231119873','1323439321634258945','部门管理','dept','/basic/system/dept/index',NULL,NULL,'form',1,'1012',0,2,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323439341569785858','1323439338231119873','部门新增',NULL,NULL,NULL,'system:dept:add',NULL,2,NULL,0,1,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323439344791011329','1323439338231119873','部门修改',NULL,NULL,NULL,'system:dept:edit',NULL,2,NULL,0,2,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323439348771405826','1323439338231119873','部门详情',NULL,NULL,NULL,'system:dept:detail',NULL,2,NULL,0,3,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323439351912939522','1323439338231119873','部门删除',NULL,NULL,NULL,'system:dept:remove',NULL,2,NULL,0,4,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323439355318714370','1323439321634258945','菜单管理','menu','/basic/system/menu/index',NULL,NULL,'form',1,'1013',0,3,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323439359127142401','1323439355318714370','菜单新增',NULL,NULL,NULL,'system:menu:add',NULL,2,NULL,0,1,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323439362759409666','1323439355318714370','菜单修改',NULL,NULL,NULL,'system:menu:edit',NULL,2,NULL,0,2,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323439365372461057','1323439355318714370','菜单详情',NULL,NULL,NULL,'system:menu:detail',NULL,2,NULL,0,3,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323439367612219394','1323439355318714370','菜单删除',NULL,NULL,NULL,'system:menu:remove',NULL,2,NULL,0,4,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323439371785551873','1323439321634258945','角色管理','role','/basic/system/role/index',NULL,NULL,'form',1,'1014',0,4,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323439375539453953','1323439371785551873','角色新增',NULL,NULL,NULL,'system:role:add',NULL,2,NULL,0,1,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323439378580324354','1323439371785551873','角色修改',NULL,NULL,NULL,'system:role:edit',NULL,2,NULL,0,2,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323439381906407425','1323439371785551873','角色详情',NULL,NULL,NULL,'system:role:detail',NULL,2,NULL,0,3,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323439384934694913','1323439371785551873','角色删除',NULL,NULL,NULL,'system:role:remove',NULL,2,NULL,0,4,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323439387669381121','1323439321634258945','用户管理','user','/basic/system/user/index',NULL,NULL,'form',1,'1015',0,5,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323439390789943298','1323439387669381121','用户新增',NULL,NULL,NULL,'system:user:add',NULL,2,NULL,0,1,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323439393298137089','1323439387669381121','用户修改',NULL,NULL,NULL,'system:user:edit',NULL,2,NULL,0,2,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323439396758437890','1323439387669381121','用户详情',NULL,NULL,NULL,'system:user:detail',NULL,2,NULL,0,3,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323439399979663361','1323439387669381121','用户删除',NULL,NULL,NULL,'system:user:remove',NULL,2,NULL,0,4,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323439402764681218','1323439387669381121','重置密码',NULL,NULL,NULL,'system:user:reset:password',NULL,2,NULL,0,5,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323439406451474434','1323439321634258945','参数管理','config','/basic/system/config/index',NULL,NULL,'form',1,'1016',0,6,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323439408812867585','1323439406451474434','参数新增',NULL,NULL,NULL,'system:config:add',NULL,2,NULL,0,1,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323439412055064578','1323439406451474434','参数修改',NULL,NULL,NULL,'system:config:edit',NULL,2,NULL,0,2,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323439415838326785','1323439406451474434','参数详情',NULL,NULL,NULL,'system:config:detail',NULL,2,NULL,0,3,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323439419256684545','1323439406451474434','参数删除',NULL,NULL,NULL,'system:config:remove',NULL,2,NULL,0,4,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323439423211913218','1323439406451474434','刷新缓存',NULL,NULL,NULL,'system:config:refresh',NULL,2,NULL,0,5,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323439426693185537','1323439321634258945','字典管理','dict','/basic/system/dict/index',NULL,NULL,'form',1,'1017',0,7,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323439428819697665','1323439426693185537','字典新增',NULL,NULL,NULL,'system:dict:add',NULL,2,NULL,0,1,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323439431755710465','1323439426693185537','字典修改',NULL,NULL,NULL,'system:dict:edit',NULL,2,NULL,0,2,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323439434893049857','1323439426693185537','字典详情',NULL,NULL,NULL,'system:dict:detail',NULL,2,NULL,0,3,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323439437258637313','1323439426693185537','字典删除',NULL,NULL,NULL,'system:dict:remove',NULL,2,NULL,0,4,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323439440840572930','1323439426693185537','刷新缓存',NULL,NULL,NULL,'system:dict:refresh',NULL,2,NULL,0,5,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323439444309262337','1323439314692685825','系统监控','monitor','/basic/monitor/index','/basic/monitor/loginlog',NULL,'form',0,'1020',0,3,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323439447442407426','1323439444309262337','登录日志','loginlog','/basic/monitor/loginlog/index',NULL,NULL,'form',1,'1021',0,1,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323439450667827202','1323439447442407426','日志详情',NULL,NULL,NULL,'monitor:loginlog:detail',NULL,2,NULL,0,1,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323439454547558402','1323439447442407426','日志删除',NULL,NULL,NULL,'monitor:loginlog:remove',NULL,2,NULL,0,2,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323439457684897793','1323439444309262337','操作日志','operlog','/basic/monitor/operlog/index',NULL,NULL,'form',1,'1022',0,2,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323439461132615682','1323439457684897793','日志详情',NULL,NULL,NULL,'monitor:operlog:detail',NULL,2,NULL,0,1,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323439463754055682','1323439457684897793','日志删除',NULL,NULL,NULL,'monitor:operlog:remove',NULL,2,NULL,0,2,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323446715848216577','1323439314692685825','任务调度','scheduler','/basic/scheduler/index','/basic/scheduler/job',NULL,'form',0,'1030',0,4,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323446719488872450','1323446715848216577','任务管理','taskjob','/basic/scheduler/taskjob/index',NULL,NULL,'form',1,'1031',0,1,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323446723389575170','1323446719488872450','任务新增',NULL,NULL,NULL,'scheduler:job:add',NULL,2,NULL,0,1,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323446727512576001','1323446719488872450','任务修改',NULL,NULL,NULL,'scheduler:job:edit',NULL,2,NULL,0,2,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323446731551690753','1323446719488872450','任务详情',NULL,NULL,NULL,'scheduler:job:detail',NULL,2,NULL,0,3,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323446733736923137','1323446719488872450','任务删除',NULL,NULL,NULL,'scheduler:job:remove',NULL,2,NULL,0,4,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323446737285304322','1323446719488872450','任务暂停',NULL,NULL,NULL,'scheduler:job:pause',NULL,2,NULL,0,5,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323446741144064001','1323446719488872450','任务恢复',NULL,NULL,NULL,'scheduler:job:resume',NULL,2,NULL,0,6,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323446745309007873','1323446719488872450','立即执行',NULL,NULL,NULL,'scheduler:job:run',NULL,2,NULL,0,7,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323446748291158018','1323446715848216577','日志管理','tasklog','/basic/scheduler/tasklog/index',NULL,NULL,'form',1,'1032',0,2,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323446755090124802','1323446748291158018','日志详情',NULL,NULL,NULL,'scheduler:log:detail',NULL,2,NULL,0,1,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323446758726586370','1323446748291158018','日志删除',NULL,NULL,NULL,'scheduler:log:remove',NULL,2,NULL,0,2,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323446761884897282','0','元数据管理','/metadata','Layout','/metadata/index',NULL,'form',0,'20',0,2,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323446765831737346','1323446761884897282','看板','index','/metadata/index',NULL,NULL,'form',1,NULL,1,1,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323446768281210882','1323446761884897282','数据源','datasource','/metadata/datasource/index',NULL,NULL,'form',1,'2011',0,2,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323446772064473090','1323446768281210882','数据源新增',NULL,NULL,NULL,'metadata:datasource:add',NULL,2,NULL,0,1,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323446774992097282','1323446768281210882','数据源修改',NULL,NULL,NULL,'metadata:datasource:edit',NULL,2,NULL,0,2,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323446778368512002','1323446768281210882','数据源详情',NULL,NULL,NULL,'metadata:datasource:detail',NULL,2,NULL,0,3,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323446782034333697','1323446768281210882','数据源删除',NULL,NULL,NULL,'metadata:datasource:remove',NULL,2,NULL,0,4,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323446785037455362','1323446768281210882','刷新缓存',NULL,NULL,NULL,'metadata:datasource:refresh',NULL,2,NULL,0,5,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323446788590030850','1323446768281210882','元数据同步',NULL,NULL,NULL,'metadata:datasource:sync',NULL,2,NULL,0,6,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323446792067108865','1323446768281210882','数据库文档',NULL,NULL,NULL,'metadata:datasource:word',NULL,2,NULL,0,7,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323446796131389441','1323446768281210882','连通性检测',NULL,NULL,NULL,'metadata:datasource:connect',NULL,2,NULL,0,8,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323446800178892801','1323446761884897282','元数据','datacolumn','/metadata/datacolumn/index',NULL,NULL,'form',1,'2012',0,3,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323446803093934082','1323446800178892801','元数据详情',NULL,NULL,NULL,'metadata:datacolumn:detail',NULL,2,NULL,0,1,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323446806457765890','1323446761884897282','数据授权','dataauthorize','/metadata/dataauthorize/index',NULL,NULL,'form',1,'2013',0,4,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323446810152947713','1323446806457765890','授权修改',NULL,NULL,NULL,'metadata:dataauthorize:edit',NULL,2,NULL,0,1,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323446812367540226','1323446806457765890','刷新缓存',NULL,NULL,NULL,'metadata:dataauthorize:refresh',NULL,2,NULL,0,2,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323446814506635265','1323446761884897282','变更记录','changerecord','/metadata/changerecord/index',NULL,NULL,'form',1,'2014',0,5,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323446818050822146','1323446814506635265','变更记录新增',NULL,NULL,NULL,'metadata:changerecord:add',NULL,2,NULL,0,1,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323446821838278657','1323446814506635265','变更记录修改',NULL,NULL,NULL,'metadata:changerecord:edit',NULL,2,NULL,0,2,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323446824904314882','1323446814506635265','变更记录详情',NULL,NULL,NULL,'metadata:changerecord:detail',NULL,2,NULL,0,3,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323446828507222018','1323446814506635265','变更记录删除',NULL,NULL,NULL,'metadata:changerecord:remove',NULL,2,NULL,0,4,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323446830755368961','1323446761884897282','数据检索','datasearch','/metadata/datasearch/index',NULL,NULL,'form',1,'2015',0,6,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323446833439723522','1323446761884897282','数据地图','datamap','/metadata/datamap/index',NULL,NULL,'form',1,'2016',0,7,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323446835830476801','1323446761884897282','血缘流向','datablood','/metadata/datablood/index',NULL,NULL,'form',1,'2017',0,8,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323446838196064257','1323446761884897282','SQL工作台','sqlconsole','/metadata/sqlconsole/index',NULL,NULL,'form',1,'2018',0,9,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323446842084184065','0','数据标准管理','/standard','Layout','/standard/index',NULL,'form',0,'30',0,3,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323446844382662657','1323446842084184065','看板','index','/standard/index',NULL,NULL,'form',1,NULL,1,1,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323446848434360322','1323446842084184065','标准字典','datadict','/standard/datadict/index',NULL,NULL,'form',1,'3011',0,2,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323446851588476930','1323446848434360322','标准类别新增',NULL,NULL,NULL,'standard:type:add',NULL,2,NULL,0,1,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323446854285414401','1323446848434360322','标准类别修改',NULL,NULL,NULL,'standard:type:edit',NULL,2,NULL,0,2,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323446856474841089','1323446848434360322','标准类别详情',NULL,NULL,NULL,'standard:type:detail',NULL,2,NULL,0,3,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323446858899148801','1323446848434360322','标准类别删除',NULL,NULL,NULL,'standard:type:remove',NULL,2,NULL,0,4,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323446861998739458','1323446848434360322','标准字典新增',NULL,NULL,NULL,'standard:dict:add',NULL,2,NULL,0,5,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323446864804728834','1323446848434360322','标准字典修改',NULL,NULL,NULL,'standard:dict:edit',NULL,2,NULL,0,6,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323446867434557441','1323446848434360322','标准字典详情',NULL,NULL,NULL,'standard:dict:detail',NULL,2,NULL,0,7,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323446871129739266','1323446848434360322','标准字典删除',NULL,NULL,NULL,'standard:dict:remove',NULL,2,NULL,0,8,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323446872239749167','1323446848434360322','刷新缓存',NULL,NULL,NULL,'standard:dict:refresh',NULL,2,NULL,0,9,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323446873914757121','1323446842084184065','对照表','dictcontrast','/standard/dictcontrast/index',NULL,NULL,'form',1,'3012',0,3,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323457155479363586','1323446873914757121','对照表新增',NULL,NULL,NULL,'standard:contrast:add',NULL,2,NULL,0,1,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323457160046960641','1323446873914757121','对照表修改',NULL,NULL,NULL,'standard:contrast:edit',NULL,2,NULL,0,2,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323457163289157633','1323446873914757121','对照表详情',NULL,NULL,NULL,'standard:contrast:detail',NULL,2,NULL,0,3,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323457168091635713','1323446873914757121','对照表删除',NULL,NULL,NULL,'standard:contrast:remove',NULL,2,NULL,0,4,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323457171208003585','1323446873914757121','对照字典新增',NULL,NULL,NULL,'standard:contrast:dict:add',NULL,2,NULL,0,5,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323457174412451841','1323446873914757121','对照字典修改',NULL,NULL,NULL,'standard:contrast:dict:edit',NULL,2,NULL,0,6,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323457176954200065','1323446873914757121','对照字典详情',NULL,NULL,NULL,'standard:contrast:dict:detail',NULL,2,NULL,0,7,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323457180657770497','1323446873914757121','对照字典删除',NULL,NULL,NULL,'standard:contrast:dict:remove',NULL,2,NULL,0,8,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323457183010775041','1323446842084184065','字典对照','dictmapping','/standard/dictmapping/index',NULL,NULL,'form',1,'3013',0,4,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323457185179230209','1323457183010775041','自动对照',NULL,NULL,NULL,'standard:mapping:auto',NULL,2,NULL,0,1,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323457188840857601','1323457183010775041','手动对照',NULL,NULL,NULL,'standard:mapping:manual',NULL,2,NULL,0,2,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323457190950592513','1323457183010775041','取消对照',NULL,NULL,NULL,'standard:mapping:cancel',NULL,2,NULL,0,3,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323457193882411009','1323446842084184065','对照统计','contraststat','/standard/contraststat/index',NULL,NULL,'form',1,'3014',0,5,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323457195987951617','0','数据质量管理','/quality','Layout','/quality/index',NULL,'form',0,'40',0,4,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323457199494389762','1323457195987951617','看板','index','/quality/index',NULL,NULL,'form',1,NULL,1,1,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323457202715615233','1323457195987951617','规则配置','checkrule','/quality/checkrule/index',NULL,NULL,'form',1,'4011',0,2,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323457206838616066','1323457202715615233','规则新增',NULL,NULL,NULL,'quality:rule:add',NULL,2,NULL,0,1,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323457210680598530','1323457202715615233','规则修改',NULL,NULL,NULL,'quality:rule:edit',NULL,2,NULL,0,2,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323457213478199298','1323457202715615233','规则详情',NULL,NULL,NULL,'quality:rule:detail',NULL,2,NULL,0,3,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323457216112222210','1323457202715615233','规则删除',NULL,NULL,NULL,'quality:rule:remove',NULL,2,NULL,0,4,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323457220054867969','1323457195987951617','问题统计','checkstat','/quality/checkstat/index',NULL,NULL,'form',1,'4012',0,3,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323457223376756738','1323457195987951617','质量报告','checkreport','/quality/checkreport/index',NULL,NULL,'form',1,'4013',0,4,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323457226472153090','1323457195987951617','定时任务','checkjob','/quality/checkjob/index',NULL,NULL,'form',1,'4014',0,5,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323457229768876033','1323457226472153090','任务暂停',NULL,NULL,NULL,'quality:job:pause',NULL,2,NULL,0,1,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323457232570671106','1323457226472153090','任务恢复',NULL,NULL,NULL,'quality:job:resume',NULL,2,NULL,0,2,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323457235842228226','1323457195987951617','任务日志','checklog','/quality/checklog/index',NULL,NULL,'form',1,'4015',0,6,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323457239495467009','0','主数据管理','/masterdata','Layout','/masterdata/index',NULL,'form',0,'50',0,5,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323457241680699394','1323457239495467009','看板','index','/masterdata/index',NULL,NULL,'form',1,NULL,1,1,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323457245346521089','1323457239495467009','数据模型','datamodel','/masterdata/datamodel/index',NULL,NULL,'form',1,'5011',0,2,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323457248882319361','1323457245346521089','模型新增',NULL,NULL,NULL,'masterdata:model:add',NULL,2,NULL,0,1,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323457252309065730','1323457245346521089','模型修改',NULL,NULL,NULL,'masterdata:model:edit',NULL,2,NULL,0,2,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323457256096522241','1323457245346521089','模型详情',NULL,NULL,NULL,'masterdata:model:detail',NULL,2,NULL,0,3,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323457259636514817','1323457245346521089','模型删除',NULL,NULL,NULL,'masterdata:model:remove',NULL,2,NULL,0,4,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323457262379589633','1323457245346521089','模型提交',NULL,NULL,NULL,'masterdata:model:submit',NULL,2,NULL,0,5,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323457265072332802','1323457245346521089','数据建模',NULL,NULL,NULL,'masterdata:model:create',NULL,2,NULL,0,6,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323457267387588610','1323457239495467009','数据管理','datamanage','/masterdata/datamanage/index',NULL,NULL,'form',1,'5012',0,3,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323457271124713473','1323457267387588610','数据新增',NULL,NULL,NULL,'masterdata:data:add',NULL,2,NULL,0,1,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323457273783902210','1323457267387588610','数据修改',NULL,NULL,NULL,'masterdata:data:edit',NULL,2,NULL,0,2,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323457276178849794','1323457267387588610','数据详情',NULL,NULL,NULL,'masterdata:data:detail',NULL,2,NULL,0,3,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323457280285073410','1323457267387588610','数据删除',NULL,NULL,NULL,'masterdata:data:remove',NULL,2,NULL,0,4,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323457284382908418','0','数据集市管理','/market','Layout','/market/index',NULL,'form',0,'60',0,6,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323457288312971266','1323457284382908418','看板','index','/market/index',NULL,NULL,'form',1,NULL,1,1,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323457290468843522','1323457284382908418','数据服务','dataapi','/market/dataapi/index',NULL,NULL,'form',1,'6011',0,2,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323457293983670274','1323457290468843522','数据服务新增',NULL,NULL,NULL,'market:api:add',NULL,2,NULL,0,1,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323457297620131842','1323457290468843522','数据服务修改',NULL,NULL,NULL,'market:api:edit',NULL,2,NULL,0,2,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323457300937826305','1323457290468843522','数据服务详情',NULL,NULL,NULL,'market:api:detail',NULL,2,NULL,0,3,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323457303185973249','1323457290468843522','数据服务删除',NULL,NULL,NULL,'market:api:remove',NULL,2,NULL,0,4,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323465292143890434','1323457290468843522','数据服务提交',NULL,NULL,NULL,'market:api:submit',NULL,2,NULL,0,5,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323465296644378625','1323457290468843522','数据服务拷贝',NULL,NULL,NULL,'market:api:copy',NULL,2,NULL,0,6,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323465300733825026','1323457290468843522','数据服务发布',NULL,NULL,NULL,'market:api:release',NULL,2,NULL,0,7,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323465303497871361','1323457290468843522','数据服务注销',NULL,NULL,NULL,'market:api:cancel',NULL,2,NULL,0,8,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323465306433884161','1323457290468843522','数据服务文档',NULL,NULL,NULL,'market:api:word',NULL,2,NULL,0,9,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323465310024208386','1323457290468843522','数据服务示例',NULL,NULL,NULL,'market:api:example',NULL,2,NULL,0,10,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323465313249628161','1323457284382908418','数据脱敏','apimask','/market/apimask/index',NULL,NULL,'form',1,'6012',0,3,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323465316550545409','1323465313249628161','数据脱敏新增',NULL,NULL,NULL,'market:mask:add',NULL,2,NULL,0,1,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323465319444615170','1323465313249628161','数据脱敏修改',NULL,NULL,NULL,'market:mask:edit',NULL,2,NULL,0,2,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323465322640674817','1323465313249628161','数据脱敏详情',NULL,NULL,NULL,'market:mask:detail',NULL,2,NULL,0,3,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323465324955930625','1323465313249628161','数据脱敏删除',NULL,NULL,NULL,'market:mask:remove',NULL,2,NULL,0,4,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323465328038744065','1323457284382908418','接口日志','apilog','/market/apilog/index',NULL,NULL,'form',1,'6013',0,4,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323465331868143617','1323465328038744065','日志详情',NULL,NULL,NULL,'market:api:log:detail',NULL,2,NULL,0,1,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323465335894675457','1323465328038744065','日志删除',NULL,NULL,NULL,'market:api:log:remove',NULL,2,NULL,0,2,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323465338889408514','1323457284382908418','服务集成','dataservice','/market/dataservice/index',NULL,NULL,'form',1,'6014',0,5,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323465341871558657','1323465338889408514','服务集成新增',NULL,NULL,NULL,'market:service:add',NULL,2,NULL,0,1,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323465345898090498','1323465338889408514','服务集成修改',NULL,NULL,NULL,'market:service:edit',NULL,2,NULL,0,2,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323465349958176769','1323465338889408514','服务集成详情',NULL,NULL,NULL,'market:service:detail',NULL,2,NULL,0,3,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323465352999047170','1323465338889408514','服务集成删除',NULL,NULL,NULL,'market:service:remove',NULL,2,NULL,0,4,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323465356161552386','1323457284382908418','服务日志','servicelog','/market/servicelog/index',NULL,NULL,'form',1,'6015',0,6,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323465359139508225','1323465356161552386','日志详情',NULL,NULL,NULL,'market:service:log:detail',NULL,2,NULL,0,1,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323465362562060290','1323465356161552386','日志删除',NULL,NULL,NULL,'market:service:log:remove',NULL,2,NULL,0,2,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323465364864733186','0','可视化管理','/visual','Layout','/visual/index',NULL,'form',0,'70',0,7,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323465367142240257','1323465364864733186','看板','index','/visual/index',NULL,NULL,'form',1,NULL,1,1,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323465369847566337','1323465364864733186','数据集','dataset','/visual/dataset/index',NULL,NULL,'form',1,'7011',0,2,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323465372125073409','1323465369847566337','数据集新增',NULL,NULL,NULL,'visual:set:add',NULL,2,NULL,0,1,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323465374515826690','1323465369847566337','数据集修改',NULL,NULL,NULL,'visual:set:edit',NULL,2,NULL,0,2,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323465378643021825','1323465369847566337','数据集详情',NULL,NULL,NULL,'visual:set:detail',NULL,2,NULL,0,3,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323465380983443458','1323465369847566337','数据集删除',NULL,NULL,NULL,'visual:set:remove',NULL,2,NULL,0,4,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323465383680380930','1323465369847566337','数据预览',NULL,NULL,NULL,'visual:set:preview',NULL,2,NULL,0,5,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323465385953693697','1323465364864733186','图表配置','datachart','/visual/datachart/index',NULL,NULL,'form',1,'7012',0,3,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323465389925699585','1323465385953693697','图表新增',NULL,NULL,NULL,'visual:chart:add',NULL,2,NULL,0,1,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323465393704767490','1323465385953693697','图表修改',NULL,NULL,NULL,'visual:chart:edit',NULL,2,NULL,0,2,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323465396888244225','1323465385953693697','图表配置',NULL,NULL,NULL,'visual:chart:build',NULL,2,NULL,0,3,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323465400029777921','1323465385953693697','图表删除',NULL,NULL,NULL,'visual:chart:remove',NULL,2,NULL,0,4,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323465401029783632','1323465385953693697','图表拷贝',NULL,NULL,NULL,'visual:chart:copy',NULL,2,NULL,0,5,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323465402781241346','1323465364864733186','看板配置','databoard','/visual/databoard/index',NULL,NULL,'form',1,'7013',0,4,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323465405113274369','1323465402781241346','看板新增',NULL,NULL,NULL,'visual:board:add',NULL,2,NULL,0,1,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323465407613079553','1323465402781241346','看板修改',NULL,NULL,NULL,'visual:board:edit',NULL,2,NULL,0,2,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323465408371552934','1323465402781241346','看板配置',NULL,NULL,NULL,'visual:board:build',NULL,2,NULL,0,3,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323465410377125889','1323465402781241346','看板预览',NULL,NULL,NULL,'visual:board:preview',NULL,2,NULL,0,4,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323465414361714689','1323465402781241346','看板删除',NULL,NULL,NULL,'visual:board:remove',NULL,2,NULL,0,5,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323465415426742390','1323465402781241346','看板拷贝',NULL,NULL,NULL,'visual:board:copy',NULL,2,NULL,0,6,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323465416611367426','1323465364864733186','酷屏配置','datascreen','/visual/datascreen/index',NULL,NULL,'form',1,'7014',0,5,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323465416705008130','1323465416611367426','酷屏新增',NULL,NULL,NULL,'visual:screen:add',NULL,2,NULL,0,1,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323465417236419686','1323465416611367426','酷屏修改',NULL,NULL,NULL,'visual:screen:edit',NULL,2,NULL,0,2,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323465417607196160','1323465416611367426','酷屏配置',NULL,NULL,NULL,'visual:screen:build',NULL,2,NULL,0,3,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323465417802278401','1323465416611367426','酷屏预览',NULL,NULL,NULL,'visual:screen:preview',NULL,2,NULL,0,4,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323465418100034561','1323465416611367426','酷屏删除',NULL,NULL,NULL,'visual:screen:remove',NULL,2,NULL,0,5,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323465418218860801','1323465416611367426','酷屏拷贝',NULL,NULL,NULL,'visual:screen:copy',NULL,2,NULL,0,6,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323465418392440833','0','流程管理','/workflow','Layout','/workflow/index',NULL,'form',0,'80',0,8,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323465421974376449','1323465418392440833','看板','index','/workflow/index',NULL,NULL,'form',1,NULL,1,1,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323465424239300610','1323465418392440833','流程定义','definition','/workflow/definition/index',NULL,NULL,'form',1,'8011',0,2,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323465428202917890','1323465424239300610','流程分类新增',NULL,NULL,NULL,'workflow:definition:type:add',NULL,2,NULL,0,1,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323465431923265538','1323465424239300610','流程分类修改',NULL,NULL,NULL,'workflow:definition:type:edit',NULL,2,NULL,0,2,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323465434813140993','1323465424239300610','流程分类详情',NULL,NULL,NULL,'workflow:definition:type:detail',NULL,2,NULL,0,3,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323465438407659522','1323465424239300610','流程分类删除',NULL,NULL,NULL,'workflow:definition:type:remove',NULL,2,NULL,0,4,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323465442094452738','1323465424239300610','流程定义导入',NULL,NULL,NULL,'workflow:definition:import',NULL,2,NULL,0,5,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323465445244375042','1323465424239300610','流程定义流程图',NULL,NULL,NULL,'workflow:definition:resource',NULL,2,NULL,0,6,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323465448629178369','1323465424239300610','流程定义激活',NULL,NULL,NULL,'workflow:definition:activate',NULL,2,NULL,0,7,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323491848870330369','1323465424239300610','流程定义挂起',NULL,NULL,NULL,'workflow:definition:suspend',NULL,2,NULL,0,8,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323491854062878722','1323465424239300610','流程定义删除',NULL,NULL,NULL,'workflow:definition:remove',NULL,2,NULL,0,9,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323491858198462465','1323465418392440833','流程实例','instance','/workflow/instance/index','/workflow/instance/running',NULL,'form',0,'8020',0,3,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323491860798930945','1323491858198462465','运行中的流程','running','/workflow/instance/running/index',NULL,NULL,'form',1,'8021',0,1,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323491863856578561','1323491860798930945','流程追踪',NULL,NULL,NULL,'workflow:instance:track',NULL,2,NULL,0,1,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323491866775814145','1323491860798930945','流程激活',NULL,NULL,NULL,'workflow:instance:running:activate',NULL,2,NULL,0,2,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323491870609408001','1323491860798930945','流程挂起',NULL,NULL,NULL,'workflow:instance:running:suspend',NULL,2,NULL,0,3,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323491873587363842','1323491860798930945','流程删除',NULL,NULL,NULL,'workflow:instance:running:remove',NULL,2,NULL,0,4,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323491877102190593','1323491858198462465','我发起的流程','mystarted','/workflow/instance/mystarted/index',NULL,NULL,'form',1,'8022',0,2,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323491881074196481','1323491858198462465','我参与的流程','myinvolved','/workflow/instance/myinvolved/index',NULL,NULL,'form',1,'8023',0,3,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323491884450611202','1323465418392440833','流程任务','task','/workflow/task/index','/workflow/task/todo',NULL,'form',0,'8030',0,4,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323491888380674050','1323491884450611202','待办任务','todo','/workflow/task/todo/index',NULL,NULL,'form',1,'8031',0,1,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323491891807420417','1323491888380674050','任务签收',NULL,NULL,NULL,'workflow:task:caim',NULL,2,NULL,0,1,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323491895217389569','1323491888380674050','任务反签收',NULL,NULL,NULL,'workflow:task:unclaim',NULL,2,NULL,0,2,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323491898304397313','1323491888380674050','任务委派',NULL,NULL,NULL,'workflow:task:delegate',NULL,2,NULL,0,3,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323491900485435393','1323491888380674050','任务转办',NULL,NULL,NULL,'workflow:task:assignee',NULL,2,NULL,0,4,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323491903840878594','1323491888380674050','任务审核',NULL,NULL,NULL,'workflow:task:exam',NULL,2,NULL,0,5,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323491906328100865','1323491884450611202','已办任务','done','/workflow/task/done/index',NULL,NULL,'form',1,'8032',0,2,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323491908735631361','1323465418392440833','业务配置','business','/workflow/business/index',NULL,NULL,'form',1,'8041',0,5,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323491911856193538','1323491908735631361','业务配置新增',NULL,NULL,NULL,'workflow:business:add',NULL,2,NULL,0,1,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323491915605901314','1323491908735631361','业务配置新增',NULL,NULL,NULL,'workflow:business:edit',NULL,2,NULL,0,2,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323491918722269185','1323491908735631361','业务配置新增',NULL,NULL,NULL,'workflow:business:detail',NULL,2,NULL,0,3,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323491921226268673','1323491908735631361','业务配置新增',NULL,NULL,NULL,'workflow:business:remove',NULL,2,NULL,0,4,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL),('1323491925059862529','1323491908735631361','刷新缓存',NULL,NULL,NULL,'workflow:business:refresh',NULL,2,NULL,0,5,1,'1214835832967581698','2020-11-03 13:32:40','1214835832967581698','2020-11-03 13:32:40',NULL); /*Table structure for table `sys_post` */ DROP TABLE IF EXISTS `sys_post`; CREATE TABLE `sys_post` ( `id` varchar(50) NOT NULL COMMENT '主键ID', `post_name` varchar(50) DEFAULT NULL COMMENT '岗位名称', `status` tinyint(4) DEFAULT NULL COMMENT '状态（0不启用，1启用）', `create_by` varchar(50) DEFAULT NULL COMMENT '创建人', `create_time` datetime DEFAULT NULL COMMENT '创建日期', `update_by` varchar(50) DEFAULT NULL COMMENT '更新人', `update_time` datetime DEFAULT NULL COMMENT '更新日期', `remark` varchar(1000) DEFAULT NULL COMMENT '备注', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='岗位信息表'; /*Data for the table `sys_post` */ insert into `sys_post`(`id`,`post_name`,`status`,`create_by`,`create_time`,`update_by`,`update_time`,`remark`) values ('1214825605782228993','项目经理',1,'1','2020-01-08 16:26:09','1','2020-01-08 16:26:09',NULL),('1214825677672599554','普通员工',1,'1','2020-01-08 16:26:27','1','2020-01-08 16:26:27',NULL); /*Table structure for table `sys_role` */ DROP TABLE IF EXISTS `sys_role`; CREATE TABLE `sys_role` ( `id` varchar(50) NOT NULL COMMENT '主键ID', `role_name` varchar(50) DEFAULT NULL COMMENT '角色名称', `role_code` varchar(50) DEFAULT NULL COMMENT '角色编码', `data_scope` tinyint(4) DEFAULT NULL COMMENT '数据范围（1：全部数据权限 2：自定数据权限 3：本部门数据权限 4：本部门及以下数据权限 5：仅本人数据权限）', `status` tinyint(4) DEFAULT NULL COMMENT '状态（0不启用，1启用）', `create_by` varchar(50) DEFAULT NULL COMMENT '创建人', `create_time` datetime DEFAULT NULL COMMENT '创建日期', `update_by` varchar(50) DEFAULT NULL COMMENT '更新人', `update_time` datetime DEFAULT NULL COMMENT '更新日期', `remark` varchar(1000) DEFAULT NULL COMMENT '备注', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='角色信息表'; /*Data for the table `sys_role` */ insert into `sys_role`(`id`,`role_name`,`role_code`,`data_scope`,`status`,`create_by`,`create_time`,`update_by`,`update_time`,`remark`) values ('1214826565321543682','管理员','admin',1,1,'1','2020-01-08 16:29:58','1214835832967581698','2020-12-03 10:44:06',NULL),('1319084037507244034','普通用户','simple',1,1,'1214835832967581698','2020-10-22 09:11:57','1214835832967581698','2020-12-18 08:28:55',NULL),('1319092939179286529','审核用户','audit',1,1,'1319084968579817473','2020-10-22 09:47:19','1214835832967581698','2020-11-03 16:07:36',NULL); /*Table structure for table `sys_role_dept` */ DROP TABLE IF EXISTS `sys_role_dept`; CREATE TABLE `sys_role_dept` ( `id` varchar(50) NOT NULL COMMENT '角色部门主键ID', `role_id` varchar(50) NOT NULL COMMENT '角色ID', `dept_id` varchar(50) NOT NULL COMMENT '部门ID', PRIMARY KEY (`id`,`role_id`,`dept_id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='角色和部门关联表'; /*Data for the table `sys_role_dept` */ /*Table structure for table `sys_role_menu` */ DROP TABLE IF EXISTS `sys_role_menu`; CREATE TABLE `sys_role_menu` ( `id` varchar(50) NOT NULL COMMENT '角色菜单主键ID', `role_id` varchar(50) DEFAULT NULL COMMENT '角色ID', `menu_id` varchar(50) DEFAULT NULL COMMENT '菜单ID', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='角色和资源关联表'; /*Data for the table `sys_role_menu` */ insert into `sys_role_menu`(`id`,`role_id`,`menu_id`) values ('1323537293931868161','1319092939179286529','1323465418392440833'),('1323537293931868162','1319092939179286529','1323465421974376449'),('1323537293931868163','1319092939179286529','1323465424239300610'),('1323537293931868164','1319092939179286529','1323465428202917890'),('1323537293931868165','1319092939179286529','1323465431923265538'),('1323537293931868166','1319092939179286529','1323465434813140993'),('1323537293931868167','1319092939179286529','1323465438407659522'),('1323537293931868168','1319092939179286529','1323465442094452738'),('1323537293931868169','1319092939179286529','1323465445244375042'),('1323537293931868170','1319092939179286529','1323465448629178369'),('1323537293931868171','1319092939179286529','1323491848870330369'),('1323537293931868172','1319092939179286529','1323491854062878722'),('1323537293931868173','1319092939179286529','1323491858198462465'),('1323537293931868174','1319092939179286529','1323491860798930945'),('1323537293931868175','1319092939179286529','1323491863856578561'),('1323537293931868176','1319092939179286529','1323491866775814145'),('1323537293931868177','1319092939179286529','1323491870609408001'),('1323537293931868178','1319092939179286529','1323491873587363842'),('1323537293931868179','1319092939179286529','1323491877102190593'),('1323537293931868180','1319092939179286529','1323491881074196481'),('1323537293931868181','1319092939179286529','1323491884450611202'),('1323537293931868182','1319092939179286529','1323491888380674050'),('1323537293931868183','1319092939179286529','1323491891807420417'),('1323537293931868184','1319092939179286529','1323491895217389569'),('1323537293931868185','1319092939179286529','1323491898304397313'),('1323537293931868186','1319092939179286529','1323491900485435393'),('1323537293931868187','1319092939179286529','1323491903840878594'),('1323537293931868188','1319092939179286529','1323491906328100865'),('1323537293931868189','1319092939179286529','1323491908735631361'),('1323537293931868190','1319092939179286529','1323491911856193538'),('1323537293931868191','1319092939179286529','1323491915605901314'),('1323537293931868192','1319092939179286529','1323491918722269185'),('1323537293931868193','1319092939179286529','1323491921226268673'),('1323537293931868194','1319092939179286529','1323491925059862529'),('1338734330062684161','1214826565321543682','1323439314692685825'),('1338734330062684162','1214826565321543682','1323439318413033473'),('1338734330062684163','1214826565321543682','1323439321634258945'),('1338734330062684164','1214826565321543682','1323439323769159681'),('1338734330062684165','1214826565321543682','1323439327296569346'),('1338734330062684166','1214826565321543682','1323439329708294145'),('1338734330062684167','1214826565321543682','1323439332476534786'),('1338734330062684168','1214826565321543682','1323439336071053314'),('1338734330062684169','1214826565321543682','1323439338231119873'),('1338734330062684170','1214826565321543682','1323439341569785858'),('1338734330062684171','1214826565321543682','1323439344791011329'),('1338734330062684172','1214826565321543682','1323439348771405826'),('1338734330062684173','1214826565321543682','1323439351912939522'),('1338734330062684174','1214826565321543682','1323439355318714370'),('1338734330062684175','1214826565321543682','1323439359127142401'),('1338734330062684176','1214826565321543682','1323439362759409666'),('1338734330062684177','1214826565321543682','1323439365372461057'),('1338734330062684178','1214826565321543682','1323439367612219394'),('1338734330062684179','1214826565321543682','1323439371785551873'),('1338734330062684180','1214826565321543682','1323439375539453953'),('1338734330062684181','1214826565321543682','1323439378580324354'),('1338734330062684182','1214826565321543682','1323439381906407425'),('1338734330062684183','1214826565321543682','1323439384934694913'),('1338734330062684184','1214826565321543682','1323439387669381121'),('1338734330062684185','1214826565321543682','1323439390789943298'),('1338734330062684186','1214826565321543682','1323439393298137089'),('1338734330062684187','1214826565321543682','1323439396758437890'),('1338734330062684188','1214826565321543682','1323439399979663361'),('1338734330062684189','1214826565321543682','1323439402764681218'),('1338734330062684190','1214826565321543682','1323439406451474434'),('1338734330062684191','1214826565321543682','1323439408812867585'),('1338734330062684192','1214826565321543682','1323439412055064578'),('1338734330062684193','1214826565321543682','1323439415838326785'),('1338734330062684194','1214826565321543682','1323439419256684545'),('1338734330062684195','1214826565321543682','1323439423211913218'),('1338734330062684196','1214826565321543682','1323439426693185537'),('1338734330062684197','1214826565321543682','1323439428819697665'),('1338734330062684198','1214826565321543682','1323439431755710465'),('1338734330062684199','1214826565321543682','1323439434893049857'),('1338734330062684200','1214826565321543682','1323439437258637313'),('1338734330062684201','1214826565321543682','1323439440840572930'),('1338734330062684202','1214826565321543682','1323439444309262337'),('1338734330062684203','1214826565321543682','1323439447442407426'),('1338734330062684204','1214826565321543682','1323439450667827202'),('1338734330062684205','1214826565321543682','1323439454547558402'),('1338734330062684206','1214826565321543682','1323439457684897793'),('1338734330062684207','1214826565321543682','1323439461132615682'),('1338734330062684208','1214826565321543682','1323439463754055682'),('1338734330062684209','1214826565321543682','1323446715848216577'),('1338734330062684210','1214826565321543682','1323446719488872450'),('1338734330062684211','1214826565321543682','1323446723389575170'),('1338734330062684212','1214826565321543682','1323446727512576001'),('1338734330062684213','1214826565321543682','1323446731551690753'),('1338734330062684214','1214826565321543682','1323446733736923137'),('1338734330062684215','1214826565321543682','1323446737285304322'),('1338734330062684216','1214826565321543682','1323446741144064001'),('1338734330062684217','1214826565321543682','1323446745309007873'),('1338734330062684218','1214826565321543682','1323446748291158018'),('1338734330062684219','1214826565321543682','1323446755090124802'),('1338734330062684220','1214826565321543682','1323446758726586370'),('1338734330062684221','1214826565321543682','1323446761884897282'),('1338734330062684222','1214826565321543682','1323446765831737346'),('1338734330062684223','1214826565321543682','1323446768281210882'),('1338734330062684224','1214826565321543682','1323446772064473090'),('1338734330062684225','1214826565321543682','1323446774992097282'),('1338734330062684226','1214826565321543682','1323446778368512002'),('1338734330062684227','1214826565321543682','1323446782034333697'),('1338734330062684228','1214826565321543682','1323446785037455362'),('1338734330062684229','1214826565321543682','1323446788590030850'),('1338734330062684230','1214826565321543682','1323446792067108865'),('1338734330062684231','1214826565321543682','1323446796131389441'),('1338734330062684232','1214826565321543682','1323446800178892801'),('1338734330062684233','1214826565321543682','1323446803093934082'),('1338734330062684234','1214826565321543682','1323446806457765890'),('1338734330062684235','1214826565321543682','1323446810152947713'),('1338734330062684236','1214826565321543682','1323446812367540226'),('1338734330062684237','1214826565321543682','1323446814506635265'),('1338734330062684238','1214826565321543682','1323446818050822146'),('1338734330062684239','1214826565321543682','1323446821838278657'),('1338734330062684240','1214826565321543682','1323446824904314882'),('1338734330062684241','1214826565321543682','1323446828507222018'),('1338734330062684242','1214826565321543682','1323446830755368961'),('1338734330062684243','1214826565321543682','1323446833439723522'),('1338734330062684244','1214826565321543682','1323446835830476801'),('1338734330062684245','1214826565321543682','1323446838196064257'),('1338734330062684246','1214826565321543682','1323446842084184065'),('1338734330062684247','1214826565321543682','1323446844382662657'),('1338734330062684248','1214826565321543682','1323446848434360322'),('1338734330062684249','1214826565321543682','1323446851588476930'),('1338734330062684250','1214826565321543682','1323446854285414401'),('1338734330062684251','1214826565321543682','1323446856474841089'),('1338734330062684252','1214826565321543682','1323446858899148801'),('1338734330062684253','1214826565321543682','1323446861998739458'),('1338734330062684254','1214826565321543682','1323446864804728834'),('1338734330062684255','1214826565321543682','1323446867434557441'),('1338734330062684256','1214826565321543682','1323446871129739266'),('1338734330062684257','1214826565321543682','1323446872239749167'),('1338734330062684258','1214826565321543682','1323446873914757121'),('1338734330062684259','1214826565321543682','1323457155479363586'),('1338734330062684260','1214826565321543682','1323457160046960641'),('1338734330062684261','1214826565321543682','1323457163289157633'),('1338734330062684262','1214826565321543682','1323457168091635713'),('1338734330062684263','1214826565321543682','1323457171208003585'),('1338734330062684264','1214826565321543682','1323457174412451841'),('1338734330062684265','1214826565321543682','1323457176954200065'),('1338734330062684266','1214826565321543682','1323457180657770497'),('1338734330062684267','1214826565321543682','1323457183010775041'),('1338734330062684268','1214826565321543682','1323457185179230209'),('1338734330062684269','1214826565321543682','1323457188840857601'),('1338734330062684270','1214826565321543682','1323457190950592513'),('1338734330062684271','1214826565321543682','1323457193882411009'),('1338734330062684272','1214826565321543682','1323457195987951617'),('1338734330062684273','1214826565321543682','1323457199494389762'),('1338734330062684274','1214826565321543682','1323457202715615233'),('1338734330062684275','1214826565321543682','1323457206838616066'),('1338734330062684276','1214826565321543682','1323457210680598530'),('1338734330062684277','1214826565321543682','1323457213478199298'),('1338734330062684278','1214826565321543682','1323457216112222210'),('1338734330062684279','1214826565321543682','1323457220054867969'),('1338734330062684280','1214826565321543682','1323457223376756738'),('1338734330062684281','1214826565321543682','1323457226472153090'),('1338734330062684282','1214826565321543682','1323457229768876033'),('1338734330062684283','1214826565321543682','1323457232570671106'),('1338734330062684284','1214826565321543682','1323457235842228226'),('1338734330062684285','1214826565321543682','1323457239495467009'),('1338734330062684286','1214826565321543682','1323457241680699394'),('1338734330062684287','1214826565321543682','1323457245346521089'),('1338734330062684288','1214826565321543682','1323457248882319361'),('1338734330062684289','1214826565321543682','1323457252309065730'),('1338734330062684290','1214826565321543682','1323457256096522241'),('1338734330062684291','1214826565321543682','1323457259636514817'),('1338734330062684292','1214826565321543682','1323457262379589633'),('1338734330062684293','1214826565321543682','1323457265072332802'),('1338734330062684294','1214826565321543682','1323457267387588610'),('1338734330062684295','1214826565321543682','1323457271124713473'),('1338734330062684296','1214826565321543682','1323457273783902210'),('1338734330062684297','1214826565321543682','1323457276178849794'),('1338734330062684298','1214826565321543682','1323457280285073410'),('1338734330062684299','1214826565321543682','1323457284382908418'),('1338734330062684300','1214826565321543682','1323457288312971266'),('1338734330062684301','1214826565321543682','1323457290468843522'),('1338734330062684302','1214826565321543682','1323457293983670274'),('1338734330062684303','1214826565321543682','1323457297620131842'),('1338734330062684304','1214826565321543682','1323457300937826305'),('1338734330062684305','1214826565321543682','1323457303185973249'),('1338734330062684306','1214826565321543682','1323465292143890434'),('1338734330062684307','1214826565321543682','1323465296644378625'),('1338734330062684308','1214826565321543682','1323465300733825026'),('1338734330062684309','1214826565321543682','1323465303497871361'),('1338734330062684310','1214826565321543682','1323465306433884161'),('1338734330062684311','1214826565321543682','1323465310024208386'),('1338734330062684312','1214826565321543682','1323465313249628161'),('1338734330062684313','1214826565321543682','1323465316550545409'),('1338734330062684314','1214826565321543682','1323465319444615170'),('1338734330062684315','1214826565321543682','1323465322640674817'),('1338734330062684316','1214826565321543682','1323465324955930625'),('1338734330062684317','1214826565321543682','1323465328038744065'),('1338734330062684318','1214826565321543682','1323465331868143617'),('1338734330062684319','1214826565321543682','1323465335894675457'),('1338734330062684320','1214826565321543682','1323465338889408514'),('1338734330062684321','1214826565321543682','1323465341871558657'),('1338734330062684322','1214826565321543682','1323465345898090498'),('1338734330062684323','1214826565321543682','1323465349958176769'),('1338734330062684324','1214826565321543682','1323465352999047170'),('1338734330062684325','1214826565321543682','1323465356161552386'),('1338734330062684326','1214826565321543682','1323465359139508225'),('1338734330062684327','1214826565321543682','1323465362562060290'),('1338734330062684328','1214826565321543682','1323465364864733186'),('1338734330062684329','1214826565321543682','1323465367142240257'),('1338734330062684330','1214826565321543682','1323465369847566337'),('1338734330062684331','1214826565321543682','1323465372125073409'),('1338734330062684332','1214826565321543682','1323465374515826690'),('1338734330062684333','1214826565321543682','1323465378643021825'),('1338734330062684334','1214826565321543682','1323465380983443458'),('1338734330062684335','1214826565321543682','1323465383680380930'),('1338734330062684336','1214826565321543682','1323465385953693697'),('1338734330062684337','1214826565321543682','1323465389925699585'),('1338734330062684338','1214826565321543682','1323465393704767490'),('1338734330062684339','1214826565321543682','1323465396888244225'),('1338734330062684340','1214826565321543682','1323465400029777921'),('1338734330062684341','1214826565321543682','1323465401029783632'),('1338734330062684342','1214826565321543682','1323465402781241346'),('1338734330062684343','1214826565321543682','1323465405113274369'),('1338734330062684344','1214826565321543682','1323465407613079553'),('1338734330062684345','1214826565321543682','1323465408371552934'),('1338734330062684346','1214826565321543682','1323465410377125889'),('1338734330062684347','1214826565321543682','1323465414361714689'),('1338734330062684348','1214826565321543682','1323465415426742390'),('1338734330062684349','1214826565321543682','1323465416611367426'),('1338734330062684350','1214826565321543682','1323465416705008130'),('1338734330062684351','1214826565321543682','1323465417236419686'),('1338734330062684352','1214826565321543682','1323465417607196160'),('1338734330062684353','1214826565321543682','1323465417802278401'),('1338734330062684354','1214826565321543682','1323465418100034561'),('1338734330062684355','1214826565321543682','1323465418218860801'),('1338734330062684356','1214826565321543682','1323465418392440833'),('1338734330062684357','1214826565321543682','1323465421974376449'),('1338734330062684358','1214826565321543682','1323465424239300610'),('1338734330062684359','1214826565321543682','1323465428202917890'),('1338734330062684360','1214826565321543682','1323465431923265538'),('1338734330062684361','1214826565321543682','1323465434813140993'),('1338734330062684362','1214826565321543682','1323465438407659522'),('1338734330062684363','1214826565321543682','1323465442094452738'),('1338734330062684364','1214826565321543682','1323465445244375042'),('1338734330062684365','1214826565321543682','1323465448629178369'),('1338734330062684366','1214826565321543682','1323491848870330369'),('1338734330062684367','1214826565321543682','1323491854062878722'),('1338734330062684368','1214826565321543682','1323491858198462465'),('1338734330062684369','1214826565321543682','1323491860798930945'),('1338734330062684370','1214826565321543682','1323491863856578561'),('1338734330062684371','1214826565321543682','1323491866775814145'),('1338734330062684372','1214826565321543682','1323491870609408001'),('1338734330062684373','1214826565321543682','1323491873587363842'),('1338734330062684374','1214826565321543682','1323491877102190593'),('1338734330062684375','1214826565321543682','1323491881074196481'),('1338734330062684376','1214826565321543682','1323491884450611202'),('1338734330062684377','1214826565321543682','1323491888380674050'),('1338734330062684378','1214826565321543682','1323491891807420417'),('1338734330062684379','1214826565321543682','1323491895217389569'),('1338734330062684380','1214826565321543682','1323491898304397313'),('1338734330062684381','1214826565321543682','1323491900485435393'),('1338734330062684382','1214826565321543682','1323491903840878594'),('1338734330062684383','1214826565321543682','1323491906328100865'),('1338734330062684384','1214826565321543682','1323491908735631361'),('1338734330062684385','1214826565321543682','1323491911856193538'),('1338734330062684386','1214826565321543682','1323491915605901314'),('1338734330062684387','1214826565321543682','1323491918722269185'),('1338734330062684388','1214826565321543682','1323491921226268673'),('1338734330062684389','1214826565321543682','1323491925059862529'),('1339729316279271426','1319084037507244034','1323446761884897282'),('1339729316279271427','1319084037507244034','1323446765831737346'),('1339729316279271428','1319084037507244034','1323446768281210882'),('1339729316279271429','1319084037507244034','1323446772064473090'),('1339729316279271430','1319084037507244034','1323446774992097282'),('1339729316279271431','1319084037507244034','1323446778368512002'),('1339729316279271432','1319084037507244034','1323446782034333697'),('1339729316279271433','1319084037507244034','1323446785037455362'),('1339729316279271434','1319084037507244034','1323446788590030850'),('1339729316279271435','1319084037507244034','1323446792067108865'),('1339729316279271436','1319084037507244034','1323446796131389441'),('1339729316279271437','1319084037507244034','1323446800178892801'),('1339729316279271438','1319084037507244034','1323446803093934082'),('1339729316279271439','1319084037507244034','1323446806457765890'),('1339729316279271440','1319084037507244034','1323446810152947713'),('1339729316283465730','1319084037507244034','1323446812367540226'),('1339729316283465731','1319084037507244034','1323446814506635265'),('1339729316283465732','1319084037507244034','1323446818050822146'),('1339729316283465733','1319084037507244034','1323446821838278657'),('1339729316283465734','1319084037507244034','1323446824904314882'),('1339729316283465735','1319084037507244034','1323446828507222018'),('1339729316283465736','1319084037507244034','1323446830755368961'),('1339729316283465737','1319084037507244034','1323446833439723522'),('1339729316283465738','1319084037507244034','1323446835830476801'),('1339729316283465739','1319084037507244034','1323446838196064257'),('1339729316283465740','1319084037507244034','1323446842084184065'),('1339729316283465741','1319084037507244034','1323446844382662657'),('1339729316283465742','1319084037507244034','1323446848434360322'),('1339729316283465743','1319084037507244034','1323446851588476930'),('1339729316283465744','1319084037507244034','1323446854285414401'),('1339729316283465745','1319084037507244034','1323446856474841089'),('1339729316283465746','1319084037507244034','1323446858899148801'),('1339729316283465747','1319084037507244034','1323446861998739458'),('1339729316287660034','1319084037507244034','1323446864804728834'),('1339729316287660035','1319084037507244034','1323446867434557441'),('1339729316287660036','1319084037507244034','1323446871129739266'),('1339729316287660037','1319084037507244034','1323446872239749167'),('1339729316287660038','1319084037507244034','1323446873914757121'),('1339729316287660039','1319084037507244034','1323457155479363586'),('1339729316287660040','1319084037507244034','1323457160046960641'),('1339729316287660041','1319084037507244034','1323457163289157633'),('1339729316287660042','1319084037507244034','1323457168091635713'),('1339729316287660043','1319084037507244034','1323457171208003585'),('1339729316287660044','1319084037507244034','1323457174412451841'),('1339729316287660045','1319084037507244034','1323457176954200065'),('1339729316291854338','1319084037507244034','1323457180657770497'),('1339729316291854339','1319084037507244034','1323457183010775041'),('1339729316291854340','1319084037507244034','1323457185179230209'),('1339729316291854341','1319084037507244034','1323457188840857601'),('1339729316291854342','1319084037507244034','1323457190950592513'),('1339729316291854343','1319084037507244034','1323457193882411009'),('1339729316291854344','1319084037507244034','1323457195987951617'),('1339729316291854345','1319084037507244034','1323457199494389762'),('1339729316291854346','1319084037507244034','1323457202715615233'),('1339729316291854347','1319084037507244034','1323457206838616066'),('1339729316291854348','1319084037507244034','1323457210680598530'),('1339729316291854349','1319084037507244034','1323457213478199298'),('1339729316291854350','1319084037507244034','1323457216112222210'),('1339729316291854351','1319084037507244034','1323457220054867969'),('1339729316291854352','1319084037507244034','1323457223376756738'),('1339729316291854353','1319084037507244034','1323457226472153090'),('1339729316291854354','1319084037507244034','1323457229768876033'),('1339729316291854355','1319084037507244034','1323457232570671106'),('1339729316291854356','1319084037507244034','1323457235842228226'),('1339729316291854357','1319084037507244034','1323457239495467009'),('1339729316291854358','1319084037507244034','1323457241680699394'),('1339729316291854359','1319084037507244034','1323457245346521089'),('1339729316291854360','1319084037507244034','1323457248882319361'),('1339729316291854361','1319084037507244034','1323457252309065730'),('1339729316291854362','1319084037507244034','1323457256096522241'),('1339729316291854363','1319084037507244034','1323457259636514817'),('1339729316291854364','1319084037507244034','1323457262379589633'),('1339729316291854365','1319084037507244034','1323457265072332802'),('1339729316291854366','1319084037507244034','1323457267387588610'),('1339729316291854367','1319084037507244034','1323457271124713473'),('1339729316291854368','1319084037507244034','1323457273783902210'),('1339729316296048641','1319084037507244034','1323457276178849794'),('1339729316296048642','1319084037507244034','1323457280285073410'),('1339729316296048643','1319084037507244034','1323457284382908418'),('1339729316296048644','1319084037507244034','1323457288312971266'),('1339729316296048645','1319084037507244034','1323457290468843522'),('1339729316296048646','1319084037507244034','1323457293983670274'),('1339729316296048647','1319084037507244034','1323457297620131842'),('1339729316296048648','1319084037507244034','1323457300937826305'),('1339729316296048649','1319084037507244034','1323457303185973249'),('1339729316296048650','1319084037507244034','1323465292143890434'),('1339729316296048651','1319084037507244034','1323465296644378625'),('1339729316296048652','1319084037507244034','1323465300733825026'),('1339729316296048653','1319084037507244034','1323465303497871361'),('1339729316296048654','1319084037507244034','1323465306433884161'),('1339729316300242945','1319084037507244034','1323465310024208386'),('1339729316300242946','1319084037507244034','1323465313249628161'),('1339729316300242947','1319084037507244034','1323465316550545409'),('1339729316300242948','1319084037507244034','1323465319444615170'),('1339729316300242949','1319084037507244034','1323465322640674817'),('1339729316300242950','1319084037507244034','1323465324955930625'),('1339729316300242951','1319084037507244034','1323465328038744065'),('1339729316300242952','1319084037507244034','1323465331868143617'),('1339729316300242953','1319084037507244034','1323465335894675457'),('1339729316300242954','1319084037507244034','1323465338889408514'),('1339729316300242955','1319084037507244034','1323465341871558657'),('1339729316300242956','1319084037507244034','1323465345898090498'),('1339729316300242957','1319084037507244034','1323465349958176769'),('1339729316300242958','1319084037507244034','1323465352999047170'),('1339729316300242959','1319084037507244034','1323465356161552386'),('1339729316300242960','1319084037507244034','1323465359139508225'),('1339729316300242961','1319084037507244034','1323465362562060290'),('1339729316300242962','1319084037507244034','1323465364864733186'),('1339729316300242963','1319084037507244034','1323465367142240257'),('1339729316300242964','1319084037507244034','1323465369847566337'),('1339729316300242965','1319084037507244034','1323465372125073409'),('1339729316300242966','1319084037507244034','1323465374515826690'),('1339729316304437249','1319084037507244034','1323465378643021825'),('1339729316304437250','1319084037507244034','1323465380983443458'),('1339729316304437251','1319084037507244034','1323465383680380930'),('1339729316304437252','1319084037507244034','1323465385953693697'),('1339729316304437253','1319084037507244034','1323465389925699585'),('1339729316304437254','1319084037507244034','1323465393704767490'),('1339729316304437255','1319084037507244034','1323465396888244225'),('1339729316304437256','1319084037507244034','1323465400029777921'),('1339729316304437257','1319084037507244034','1323465401029783632'),('1339729316304437258','1319084037507244034','1323465402781241346'),('1339729316304437259','1319084037507244034','1323465405113274369'),('1339729316304437260','1319084037507244034','1323465407613079553'),('1339729316304437261','1319084037507244034','1323465408371552934'),('1339729316304437262','1319084037507244034','1323465410377125889'),('1339729316304437263','1319084037507244034','1323465414361714689'),('1339729316304437264','1319084037507244034','1323465415426742390'),('1339729316304437265','1319084037507244034','1323465416611367426'),('1339729316304437266','1319084037507244034','1323465416705008130'),('1339729316304437267','1319084037507244034','1323465417236419686'),('1339729316304437268','1319084037507244034','1323465417607196160'),('1339729316304437269','1319084037507244034','1323465417802278401'),('1339729316304437270','1319084037507244034','1323465418100034561'),('1339729316304437271','1319084037507244034','1323465418218860801'); /*Table structure for table `sys_user` */ DROP TABLE IF EXISTS `sys_user`; CREATE TABLE `sys_user` ( `id` varchar(50) NOT NULL COMMENT '主键ID', `username` varchar(50) DEFAULT NULL COMMENT '用户名', `nickname` varchar(50) DEFAULT NULL COMMENT '昵称', `password` varchar(255) DEFAULT NULL COMMENT '密码', `email` varchar(50) DEFAULT NULL COMMENT '电子邮件', `phone` varchar(50) DEFAULT NULL COMMENT '手机号码', `birthday` date DEFAULT NULL COMMENT '出生日期', `dept_id` varchar(50) DEFAULT NULL COMMENT '部门', `status` tinyint(4) DEFAULT NULL COMMENT '状态（0不启用，1启用）', `create_by` varchar(50) DEFAULT NULL COMMENT '创建人', `create_time` datetime DEFAULT NULL COMMENT '创建日期', `update_by` varchar(50) DEFAULT NULL COMMENT '更新人', `update_time` datetime DEFAULT NULL COMMENT '更新日期', `remark` varchar(1000) DEFAULT NULL COMMENT '备注', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='用户信息表'; /*Data for the table `sys_user` */ insert into `sys_user`(`id`,`username`,`nickname`,`password`,`email`,`phone`,`birthday`,`dept_id`,`status`,`create_by`,`create_time`,`update_by`,`update_time`,`remark`) values ('1214835832967581698','admin','管理员','$2a$10$TmZTXiXLdS9Y1OOFHeAt4uVIMwh0B.zyqOcGBDYOz5QL6o6qa2YTa','xxx@qq.com','136xxx','1992-12-03','1197789917762031617',1,'1214835832967581698','2020-01-08 17:06:48','1214835832967581698','2020-01-08 17:06:48',NULL),('1319084615276814337','zs','张三','$2a$10$lsPhICj3H/tspyXXwgFfcO.wbasZZp8eGBZKGfxxxmeAGOvzrhjaK','xxx@qq.com','136xxx','1995-09-30','1197790192543469570',1,'1214835832967581698','2020-10-22 09:14:14','1214835832967581698','2020-10-22 09:14:14',NULL),('1319084968579817473','ls','李四','$2a$10$/OdCjDYY/.gHNNHNQDmD0.8eY14hnG5OOhwfxKKNHbDml7Wzn2c6a','xxx@qq.com','136xxx','1993-06-11','1197790560782389250',1,'1214835832967581698','2020-10-22 09:15:39','1214835832967581698','2020-10-22 09:15:39',NULL),('1319093485260890113','ww','王五','$2a$10$zukr/0wKIaeN8dw3X.biAudTDDRmqTI5EeoeriIjug.Ntj2ro7w8m','xxx@qq.com','136xxx','1994-11-21','1197790192543469570',1,'1319084968579817473','2020-10-22 09:49:29','1319084968579817473','2020-10-22 09:49:29',NULL),('1319093610569916418','zl','赵六','$2a$10$veZ.csljplWVeYnk6n1AGO7bJq19HZMu9abB5IWQ0J9X5rqXpPpFK','xxx@qq.com','136xxx','1991-03-04','1197790192543469570',1,'1319084968579817473','2020-10-22 09:49:59','1319084968579817473','2020-10-22 09:49:59',NULL); /*Table structure for table `sys_user_post` */ DROP TABLE IF EXISTS `sys_user_post`; CREATE TABLE `sys_user_post` ( `id` varchar(50) NOT NULL COMMENT '用户岗位主键ID', `user_id` varchar(50) NOT NULL COMMENT '用户ID', `post_id` varchar(50) NOT NULL COMMENT '岗位ID', PRIMARY KEY (`id`,`user_id`,`post_id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='用户和岗位关联表'; /*Data for the table `sys_user_post` */ insert into `sys_user_post`(`id`,`user_id`,`post_id`) values ('1214835833017913346','1214835832967581698','1214825605782228993'),('1319084615348117505','1319084615276814337','1214825677672599554'),('1319084968676286466','1319084968579817473','1214825677672599554'),('1319093485327998977','1319093485260890113','1214825677672599554'),('1319093610611859458','1319093610569916418','1214825677672599554'),('1335762265819500546','1335761402136809473','1214825605782228993'); /*Table structure for table `sys_user_role` */ DROP TABLE IF EXISTS `sys_user_role`; CREATE TABLE `sys_user_role` ( `id` varchar(50) NOT NULL COMMENT '用户角色主键ID', `user_id` varchar(50) NOT NULL COMMENT '用户ID', `role_id` varchar(50) NOT NULL COMMENT '角色ID', PRIMARY KEY (`id`,`user_id`,`role_id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='用户和角色关联表'; /*Data for the table `sys_user_role` */ insert into `sys_user_role`(`id`,`user_id`,`role_id`) values ('1214835832975970305','1214835832967581698','1214826565321543682'),('1319084615310368770','1319084615276814337','1319084037507244034'),('1319084968609177601','1319084968579817473','1319084037507244034'),('1319093485302833153','1319093485260890113','1319092939179286529'),('1319093610590887938','1319093610569916418','1319092939179286529'); /*Table structure for table `tbl_email` */ DROP TABLE IF EXISTS `tbl_email`; CREATE TABLE `tbl_email` ( `id` varchar(50) NOT NULL COMMENT '主键ID', `status` tinyint(4) DEFAULT NULL COMMENT '状态（0不启用，1启用）', `create_by` varchar(50) DEFAULT NULL COMMENT '创建人', `create_time` datetime DEFAULT NULL COMMENT '创建日期', `create_dept` varchar(50) DEFAULT NULL COMMENT '创建人所属部门', `update_by` varchar(50) DEFAULT NULL COMMENT '更新人', `update_time` datetime DEFAULT NULL COMMENT '更新日期', `remark` varchar(1000) DEFAULT NULL COMMENT '备注', `subject` varchar(255) DEFAULT NULL COMMENT '标题', `text` varchar(2000) DEFAULT NULL COMMENT '内容', `tos` json DEFAULT NULL COMMENT '接收人', `ccs` json DEFAULT NULL COMMENT '抄送人', `bccs` json DEFAULT NULL COMMENT '密送人', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC; /*Data for the table `tbl_email` */ /*Table structure for table `tbl_file` */ DROP TABLE IF EXISTS `tbl_file`; CREATE TABLE `tbl_file` ( `id` varchar(50) NOT NULL COMMENT '主键ID', `original_filename` varchar(255) DEFAULT NULL COMMENT '文件原始名称', `file_name` varchar(255) DEFAULT NULL COMMENT '文件名称', `file_size` int(11) DEFAULT NULL COMMENT '文件大小', `file_path` varchar(255) DEFAULT NULL COMMENT '访问路径', `content_type` varchar(50) DEFAULT NULL COMMENT '文件类型', `file_type` varchar(50) DEFAULT NULL COMMENT '文件来源', `status` tinyint(4) DEFAULT NULL COMMENT '状态（0不启用，1启用）', `create_by` varchar(50) DEFAULT NULL COMMENT '创建人', `create_time` datetime DEFAULT NULL COMMENT '创建日期', `update_by` varchar(50) DEFAULT NULL COMMENT '更新人', `update_time` datetime DEFAULT NULL COMMENT '更新日期', `remark` varchar(1000) DEFAULT NULL COMMENT '备注', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='文件信息表'; /*Data for the table `tbl_file` */ /*Table structure for table `visual_board` */ DROP TABLE IF EXISTS `visual_board`; CREATE TABLE `visual_board` ( `id` varchar(50) NOT NULL COMMENT '主键ID', `status` tinyint(4) DEFAULT NULL COMMENT '状态（0不启用，1启用）', `create_by` varchar(50) DEFAULT NULL COMMENT '创建人', `create_time` datetime DEFAULT NULL COMMENT '创建日期', `create_dept` varchar(50) DEFAULT NULL COMMENT '创建人所属部门', `update_by` varchar(50) DEFAULT NULL COMMENT '更新人', `update_time` datetime DEFAULT NULL COMMENT '更新日期', `remark` varchar(1000) DEFAULT NULL COMMENT '备注', `board_name` varchar(255) DEFAULT NULL COMMENT '看板名称', `board_thumbnail` text CHARACTER SET utf16le COMMENT '看板缩略图(图片base64)', `board_json` json DEFAULT NULL COMMENT '看板配置', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='可视化看板配置信息表'; /*Data for the table `visual_board` */ insert into `visual_board`(`id`,`status`,`create_by`,`create_time`,`create_dept`,`update_by`,`update_time`,`remark`,`board_name`,`board_thumbnail`,`board_json`) values ('1346371838462574593',1,'1214835832967581698','2021-01-05 16:23:55','1197789917762031617','1214835832967581698','2021-01-05 16:25:05',NULL,'看板名称20210105','data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQABAAD/2wBDAAYEBQYFBAYGBQYHBwYIChAKCgkJChQODwwQFxQYGBcUFhYaHSUfGhsjHBYWICwgIyYnKSopGR8tMC0oMCUoKSj/2wBDAQcHBwoIChMKChMoGhYaKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCj/wAARCACWAPoDASIAAhEBAxEB/8QAHAAAAgIDAQEAAAAAAAAAAAAAAwQCBQABBgcI/8QAORAAAgIABQIEBQIFAgcBAQAAAQIDEQAEEiExBUETIlFhBjJxgZEUoSNCscHwB/EVJDNSYnLh0YL/xAAZAQEBAQEBAQAAAAAAAAAAAAACAwEEAAX/xAAkEQEBAQEAAgIBBAMBAAAAAAABAAIRAyESMUETIlFhBHGBMv/aAAwDAQACEQMRAD8A+dVDvPpBayaAw5m807RQ5dldDBa1rse+2ISSJKdMjMoj2Whz64jJCgjjdJRIzfMtG1x0hcqxszmWnZG0qmlQtIKuu/1xBC3/AHH84GBgsY2wz3TYqMwPzN+cMKWP8x/OAIMHjBxSGmKmsdz+cFW9rJ/ONoPLXc9sGSOjhBTW0t3dmyeMGMZZfUY2sd4ay1C1YemGQWrzEeAMTzcMYeOKDUZCAGBH8xA2u9979MWJhZd1oEe14Vmhret8LjH5VTNCyhWINHABA0jUpBYmgvc4ulJSS0iWRdNFHXXY7+477iiPXC+cjZOoxqSMwqsEXRR1hW0jj1r/AC8Z8ZfKqY4ySCwOi9JPbDJybyIZoIW/TqBZJs1YF/kgY2mrLZgieEMRqBjexTURdDuDvv6bgjbEYmZZFEbEBSaIJ2Hc4zlvYuVyfiTQtLmEhhZwsjiyYVJHmI7gX96wOaFCrPl5Q6kDUGXToJPA3425/YYzMSqXYRIUiJ4vn64i8hkKlybCqoN3QG2N4WdtQ5gRCRBEPDdAsi6vmojv9Rf+2GFyqPUykHK0q0TuDptq27EEffvgKuiyJ5dJF+dGNk9j9vasHysWWaCVMxKyMq+Ihuwdj5du5sfjtjEt7KZiTxERaUIi0B3Pff3wOElJVLKJFQ6vDbce/wDTFnloBnJZsusBfNTyKsDaiX1lq086Ter0uwKI3tLMSHwIUG5Uk6jd1xXNVt6dz7YKctGBPlUjEbpMkqsuo6AbU/8AabxuNllcEgiTg+4wHSyPqWxR5wZysiawI0ZQE0KDbbbtgzGn1GOHQPBVkcGmU8H3wgxI78bYO0jJG0e9nm8X3RenibpyieNHV3LRhSAzECiCewwWQ3LICdthZ5ONupikKmiR6cHDRfcw3phLelkffG85lxHI6AFio2auR64E+ycrNI+qU7kVtgUfnYISaJ5GNuSdsR0XvdUL32wUkME6i9CyTsMYLHODOyJRisPsQwPy+2A3e5wWpWqIZVfRHZTzMR2Hrg2WzISaUxwRkSoUCEXpvuPfAspKYpZqBOtGSh7jDOXZI50OURmYKdZI1fcDDIMtW+4xNReDz0IoVKASEFiwPzAnbBcjFE7kTMVGkkEC962GFTfVLJZN8yXEdeRC5JNbDEoECsC4On2waFljnjeNNlrUG3Bw8YZJMt/CljKSkuY12IP+DDKbJljLKWIAvsOMMxC9saykAaQaz5RZNbGgLwfLxq0lElV33q8VCmsVIiDeGY4NXHODxZWRVQyKPP8AKLFnjtyLvb1xb5MS5PLSeBmnjMw8OSKNmXUu9huxG3HuPerZx2hrVXwxAqU2Zx3B2wNskzNpUb1i4/SoNMkQYHby8jgb39bxYQ5H9TCWQAEDcHFPh2i+TlxXgrEXDLeoEX6A9x74SzmSlfKSZhaKhqfzW/8A7Eelmrx3Wa6OzqzogLkgKqgWSf8Ax7/0wpn+hTZGWwWSVlUo8RYEahZHau4+2McWnmLz7Kw6mdWCfLyWoruNx6nt98SkyJXw6kQo7UG3G+3N/XF5HkkbNqrJLJKzUd9zf1784s5um10RYngaBBMx8RqZCwG4DXdc8WCQOew+E/1rjFy007UhshSwF9tyf7nBc1kp4cmjFWFsysFfUNIog16WW34/GOlyvTsjl2SWdv1Ee5kSEMSVFbAla3sC+29ji1YukKzCVJSid1bzEAV81bgUea7YPxtPKfm53Jhf1Mfixo6G1Idyg3B3vtXP274ms0kXiSQTeAsgYeErE0pBFb+xIvFtnsrEmUbxIalY+XShDLvvfYgjfk9sVEmuOKSFQ1Fg7A1RoHevaz+TjE5UNDBDGV5DNJTOC7PJbEmifrZ/v98QKrepH8hJUdmodyO13/XDSztLoWd55IAU8QhvNpUaQN9thsL4vAjBIoBKMBp1WRtR4/OCzGVYFgVG4B5ON5cDxgPL/wD1xhxYlmlijy6PLRoqq0W9+TvyPsMAaIq5VlKuDRvtgclbkV3zjNOmuRjZBNnfEYYizpGDZZtIs0MEzKMiQu2rUwsNquwNh9KrA80py86cA6VbZr5F4KTGyfIBHkRpkMqSFSF3BHqDgnWGT/lPAdZAqaSwQqTR7774G6RSZdXjkd5m1GRCtBR2N98I+K6jSGNe+DyoQgVDlnAI32OIFSQAfl5wTxBqBKgm8EzkkM8rNCmhDwl8YCWlXyg3RFEbYHxiwXJy5oyGNLKLZa9vuThPQfTA5VK6YJlhK6lrYUliueTiCaTHGYNYkAOuv64Vlcu5skizzgkJZVZlbT2+uGU2NZZiSbJ5OHY4guXDuHDMfIa2I74Tiqxjos7DBHDlo4JY50HmMi2ORdEHjGkGXOWkgij8zDxlBK1W2LmGM/oJJfHAWIhYo2q2Pex9DhHpkRzzSFhIdJWlRSdr49sWOePhjyKfCjfTGr86fpziuaTVt6ifKoJN2NsMwRHUNHPviMEZNEg6ScWeXiVWJG60RYBr6jFsnaOmNlU3Lzl0tSyEL857fa/74uunQIkUcma2jdWKqPmc8A/Sx+xxDpkJky86MyxgAFgwsVuCftew98NRRa5wyKfBB0qO4XHRkuXeq1iyxnDTJHGsVhRGv8o9vxyfXHQ9D6Ki6p31MNgI1F7Hlm9ht23vAPhvISySEKBoXdr/AM53GPS8rkYRlAAxkZlHiIxqqH+23sMLejBcG9q8qWfoGWcBumJrmAYxsTRe9gw2FUT/AJeON+IunzwZ+DIsJ5SoATRdyAkMQu38xOxF8jHrOSB6ZLHHEy6XYdzyK529T+94F1+fLwj9VkcplpJcm5V2mjB0Dbz7HeiAa58pqiRjlPNoec6XT4/Eay67y+cPjvo7dGnjeT9RGuYAcJJGNTEorE3e4Dc+npjmznozNqKSpIDQBW1FAbkE82Nx/wDlY9L+K4sznfhrM0JlysmqPX4iaFVDqCsTxbkGgSdKrQx5XnolykSxpN49CvkZaYmyVDUa8vNe1Yr2eTpWyyibMNLl8tIMmpZmWMiNVGob22qtit2TyN9xddDmE6h1SfSlCZmMaCRU00LGo6QK2HGnjthCSYRGpUEiMwJjc+YabABbkbbUK7egqz+CslJ1fr0OWQ5cShbXxYSyEDYhgoJ4veie+3IxZ/HhdTnemTSastDmDMQxOY8wK2RpVqBtSDS7gA7CiDvxudikyk0kUUavDIpiLbNrXWDyD/3LyD7Y7qLpLS5YeLC8GrVImvLB1kQKx8zAWpsNyBtV8bU+bygyWYOUlyjCEsrozxU1adwKNMpJ5vegdrrHvuGdpca8cC5aNssk6H5Zi7hlY7EADSK3BO5Pb0wXpOV8aeRPBOYqJmEY1UQBZJIIrSLazYGncEXi66v0fMRPG80TLqB0ehUem3YVz7Yqs0ptCSWdhptj6bD+2Dy6s76Usxk4jlFzonjViQjwA0zGzZAoeWvS+4OKjMFWkDBTTGqu8NaWlljhCq7OAqnVWkk33/H3wnIo0KxkU67BUA2tcE7Vv7X3wdVBaGYkVgCI1W2LeUng9tydhX13wvJ5lDEUL5rE5YXEYkK+QnSG7XjI5hphjlaUxI+oqp4uroeu39MS1VKeXlSBDmdmmQgLGVtSO94rJG1sSdr9MMTSkvoQnw9RKg84DPEYpWQlWI7qbGBVJdsQsg7YIVxkTKj6nUPXCng4D92xc6M1ABkpLULTaKo2Re/5wITEADSu2AtIxk16jqHfGud8Tao8nGQhyK3vB8vA0h0KpLncb+mBMS0ps98MZZfNbkhb/OGU1sTkbcYuEzSt0tMqPE1iTWdxp4/N4rnQJK6LuAaHfD2XgBS9JIqycMIaa++EPFyvU8oyArJJIumztV1vhjrmbJ6jOilyrgLyRtsTz9Biu6I6Q5pWmB8MWD5Q1X3okYazzr+smJQKQRSntige6awMvIFcA89rxbZPSUPmokbAi+4/z7YrATI4YKq0K5Jvf3Pv+2LUsD4YiQABbNDuef8AP9h0YufddxJpy8KrMHViW0KDS7D178jb0xfdGyRnmREFFiBfYe59MczEksUummXST5G3ZfY7DcfTtj0P4MjZ8zEvhHxIR4rmxVXsQe3I234+wsJk7cXlF9F23w305Dk0eONkkZgokEe3NEhq54Ht9zjrMjlIcrnIcs9zyOh1yOWAPBoep7/Y4XXNSzvLkumtAk6kKviUBY3Ygd606ft2xZZDM+FBnMznmhhEMpR3Umiq8E++4x87zeXWu3T/AI3+Lj5C+/756/v+pieOJMwIA6q0xPlLeaq3q/fHF9dyZnzrQFNWYQH9OoYgMLqu5YjcntySCAcZ8f8AxPH8L/EHTgZomObDlzMf+gAUAZTVcMx3vvzxgXSP9Ruk9alXJxzrlMxNGRDm5ApXxSgF0aKmydu4770D4jeT5B2t58+PenC843lH+s0UPw5n+mdPgMzSGI5mXx3Z0YliEJS6sBRuB2Fg48lkzsuanvNTB5ASgd1B2ZmLMTRPLE3ud/YY6P8A1B6p1PqnxNm/+JTNNm8vqhNuaQJd6bPB5/OKGHNZjLSvm4dCsyFiApIIJKt9Ls+g/YY7s94d+7m9d/b9SMs5zkjNOIVYBiCkaxi7LbhV37gem3AGGchOciuvLkiZoxqSW11bk2pFbUF2PNn2woWKI6J8rH5qokC/8r2GMKBkMmtFN7rweewx7lt2OS+Lmgyci5pFafNLc5Md6zrDKStgVR4qiNq74674Zkyc/RoZAcvmczlg0ZymYXUWiDM5mgr00EEURyK338ebQ+vwoyiqdRYksa2G5Ar9hz9MXHR+szxssXjLGyyeLA+n5W40g/ygj9wPrjH3Fz+S7v43zHTuozRvk2WKFYjIzqzHU5uyNZs2wO3P9vOuoRNDO0MpVnTa0cMoPsRYOO9zOYEuVik6dl451nAdYGjJMcnlaRVvcraccDUfqeU+IskMpnZIT5Z0fTpClbWhpOkiwebv1Hvj3fV7x+mo81ljCtCaF7AYhH4tQ39627g+1o6GcaY7NKWIo7Vz+2HJDqZtQBZjew3vCzM0RJG1gqdvUbjAbqIGs+E0bsxj3ZV9GrnC7qqowYMJQfsB3w04jKmpDoBYINI1H0sXtf3wsxV9IoJSmyb8x3P/AMxNq5gMAfrieai/TSXExeMjZyO9bjEZo3TTqUrqAYX3HrhtZVGSEOajZk0lo9BohuxPtgVBqluMCbjBmG2AtxgLOEcbBxjY2F25/bEkmM4JKd9gbsb4Plcy0DhkO/HF7YWClZiGHOCxIWkpReGRStCInmjeB7DC2BWtJ7j6Ytek5vLrDP4s7QFgF0hdWoXv9OBim6fmlyhnDwJKJF0DUd19xgr5UOss0BPhqRQo8fXDyw0VplWVs1Hcnhxlh5iLoetYazCLHMtyq6OLDqbxQxiovM/muq9PfDkbv4cauS0atZAPOKjSSuFMQf8AhFtOwBetzW/74uenZhSkqylX2tbY7tfPuaJ5/wB+cDBygj1INTEW1ijwNgPf/wCYcgjIRQ+mM0Ws6rIoV9vT64vl5c+s9u0yE4KbRq8rHYlrsG9q7mz+2PV/9LI8nmXzULxKHljKEpYoUNvbgmx3+2PCOmFlki1SsFUgmjRG44Pb8Y9K+Gw3T8lmHg6lLAmYWMadW5EikUfSrO/r6dn5O6wlzh8Nmm7OPMw5DPO0C5qTMN5Y4WY/xVtlOo+hFt9a9Ti1h6HJ0qLppzOdOVywmZCsZCM5bzMp33DGNar+UbjckUPUclnsrlW6r0zrAzD5WNcsSHFsrJWm2DDUC2qhtQ7HHm/xV1bqfXs0z5vMugCkGBHOg1pUVf8AN5TfutitQGIGXyfX/bT4+M9/8s/1MzUDfFHVxJmjm5oiIWkYGORjwwAAogFSCe9iscblpoB1FJhIIkVvEpY+KF0BuORW/qL74t/in4ezGQ6/mMm4zE2bMwUMI/mLcgADeySBR/lO2+1OmRkkHiTa1Xi9J3Ncf0/OL4PQFLb7VpdQzEeeyWYzUuTE2cLEzZgytrtqAf05Bv3bttXNOyknQmkaQDZvehZ/I/fHo/SPhSTqPQesyQRTCaHLrKJHZUjVA4LE3vxvtjhpMvEkEc8jpJr1AqDRUg9++4/rjX16tw+qu2Datx3FdjiG2mmv7YYkLTAhP+nGCVDEeUXdfvhXexXPOMq2FAzMYy2izz2WxRNfXEsjC0+ZCKRVEsSAaFbnfBskjZmaXxJWVWFyFSAWF7ckX5tP9e2On6Ln/h/pGWzb/oM5mc4wkgWU5oIArcOF0GyKrc1v32oSrDqM+bhy6TLCxyGZZwsumzGGYO21nSaYbirs7miMB+IIZZ8jk89mWz0s8zkTSZndZJA1alks6wADd8X3vHTdC6tL8TdVSPLwzZqaSnXKzzBIiFVr16QBWtthtsSO+EPjDrvS0yOS6TloJGy+VMjEq5uVmYgNuDto0mxzeN5A+7zYwNbMbAXG85DNLGjuynxGJVVIq/c3zt33w7m+pJNAkT6j4flW0GwsnnnknbAv+I5H9OkcuVlLqp86ShTq1gg/Kf5bHfkG9qwELoFqRoCVJVh5RbA7d+3rhdk9cXD5nLHLaEhqWg3ilyTtqsADajY5s+XkWcVkkiYk1ijDl3nJpwCtAaj6msHzmZ/VTRRukEJjGhnRfm9zXOFg6hqN0calEazMY28SIGg1VeJ1M0JMhL4MkqqdEYBbVsd/Qd8IMlY6P4gzsE8WTRDm/FiiCuJyNj/40OMUuezcmaYPMVJGw0qF/pgpUgDJzvCsqRlkYlQR3IG+2ICCWh5G/GN+O66dLVpO1YP+smO5kbfAf7ll5TcCww1a2Jv0waFgBIQlqvLHDMOXFRtsxN0t9/7YkzwymNUOg7pJQ5U8Y0vJ2SLh6pQB7YfgzLwB4ss8gR10sCOfb9sVxISVlBBo0CMWKpJniGgS5FUl6obDvhn8w1TlcSTalLGwL1c39sN5SNpH0JblQWKr6AWT+AcI6vD0mPykrpYYNluQdR9MUzSaxjY6gLAANnYHD+XdVkZWkuNboEXt7A1zhCSeOWbWmy6QPkAOy0OBXbnv35OGun539NIWaOOeIjeJx5X7dtxte43GK5+6GitckeT4bMlEftz9uftjv+mdTTK9OdHy0StJGrKs1EjYjWpoWLIIHYg++PNclmCvzAVpYea97FftdjFr09ZyyofOAAACdQrn+/bFxobL3/p/VcnJ0+C8xJH02Vj48MSiM6iFAJI4FhjsdzXrWOU6TBl838Q5nqGgiEuW8y+JqLMbBHoQW59rsnez/wBP8pk2jbK5+XTAIy4CklVYLTWQTQNg+hO3th+Z06T1Nsr0lY8w7SAMwaidQBpiN99vTv6bTz8c61n83N5XWsCPq7XqvRst1fo40StkiJfF8UHw2sbc8g9r5GPOM10rrHSoIp45cpE0UaQwMriSQIWYBbA4PmNC/tWCfFOY6vH01clnZpkzp+TLu3kk37bbm+Dd3tXr5F8WZzqOXnkSOeUxAeVjY0qSQNu10aPfGeHx/Ef3dP8AVXyeT9RP28efz+f9Vl8edfy+Q6Weh9KzHiNLvnGCjSQCGVAQTwRZr0HcEY87S5DEs7yLlidRI3IF0SB67AfbAsxHmFKPNFIBINSFlIDCyLHruD+MDjhkL6TC8jMLUId/6H0P+DFe25yBwosOFWyzdq/pjSIX8qA6zsBXb1vti9+F/h3MdakZFeKBCjMk0sixqNNX81X6cjfvti4y/wAPQ9LEjdT8T9UEWZUVvK4J2UntYF2CbB2we2ugqvoOSTp8ozWfjQqG07myosWygEW3IG/qT649l+BM38J9V/5HI/DsAzBiaYoWZtemw25oIaJo6iADXJx47+kk0zz+PA2ggsDRclr4Fb13rYbYsPgjqGYyfxR0yXKOcu3iCF3Rjbhm3u7HBqqrYWObO8/IjjaPbp+pZfoxyci9KEkOamXwVQADynZgNidyFrfgEbWb4PrnSZsvn82k2Y1yIxG1G2sWLB+v4xaZ7PZZusssM6Q5YT1HKwLKI9RpuNWwrkXvijnzck5klZtRJLMfXfc/vhPPxPA1Zm8pJCG1DUKADKbF0Cd/7Yr8xFLExEiMp9CMdAmcQRqjIgOoU41al3vUN6vauOPffCWcnMzoXCtIq6WaiS25Nm+SLr7DAQr5apHiMNICkQ21hQfye42wvMqFz4Bd0CgkstG632BO14emjS301XuN69cA0BQBA0gdxpYDuD2xHRWzIPp8M2Tq7emBFT4ZcHyg1hmSE3p5w3kOmtmYZtU8UWldYVzu30xNqlW+Nr1me5HYABmJJGASxOAWHmUVbDgXiUi0TeBrrOoA+Xki8FmQHBB3wyseX0i52B/9cQlAktyRZwC8TZl02ZaPNv4MAWWXykuBp3qqwmsskBmhCIGZqY81/wDMA6dP+lzsUwa1B84A/bDPUFYGSQoEVja6SOCe9YReZMeVjhqKYxxkaQdXfuMKxNpbgE++JoSTueMIYVnms3+qECogXw0CcAWfXEYGYKQbKg3WB5RQHTxdo3NX/fFgIzRsOdOxY+nbFCmxZEjCCSESKDXkamo1vvttxW39N7DLQGY5ZGkjTV3qwtmrat/27DAsrIsOW0qqvt/E1Dbc0K359+dz6YlqVJAA3kIsMfT7XipR1dT0HL5MwlM8jpDPqJn0giPTRtBtZFsKvfUNhW54p2y5j/glF1VbClv3P9vTHPRZxzl42YqWjUaEBDahZ+YXtW21b7bd8NwsJY1abMrDExFxkuxABoXQo1jpELm1nv3dl0brE/issbiSFVVmEiDT8tEad7Ivn/xvbt6ZB1rIf8Mkmy+ZL5sxaZHkiH8UeUDuNNNtQvbT6Y8Ki6hHEXRFDLr8jHbYXyON9vxixzHVymRGjxjld1YrtRNWpatxWoD3O49TsNUTLl9fV6J8WZs57puV6bldIaOMQ5l5CJY3qxqB1alCjWT33XHkfVc6c1mc5KsksgZ9QV9h5gaIAY1R99vQ4BlcxmZHaJc14MDJrMktgaQb2H5274VOYiSNIEjTw9QZmZfM1e/NUeBjDgerPf5rLJ5rLTyiDNO0SjTGP4IABPd1vSVotv8ANvfArEetQ5FJMrlw+WIgkMcv6cGIttV6mvzAj6bj3xUKAF7qzEm72wHqUucp1ziIzQaYl1+VowL2CgjbY3savsTvq25Pd6Z8HTNF8D9R6UJ0M0LnOJFIhUsoAWVD77iqN7HjFKfGyqCQtKEmYaHAJVq5FEeYg13/AK4l/o3n1PX4sp1iUDpMqPAzSnaIuAPKTxZoenBx3vx70ODJZZchknzmbbLIZAsbuVjdjZffaiLFr3G+CaDXx/m9vD/6vKcwmmdkbWXRtI7Ggf274ayGd6f0/K9RbNZWZs8V0Zd0caEbULLb9gNqG5J9Bhr/AIq/SsqcuD4czAyMyipFZht5u400djvdbi747Nyo6yMwbxS1je9t7v33H4xurfHn8wMwZC6ouwvZb8ouh/bEM1mmCJATIvhli6l9S6ydyoHGwUd7088AGmaHKyZjL5isxJHMFEkUgMbKLDUe97UfT64r5kTyhKJvdu29f03xNbpyUhOwIIO+JTZoiUyLK6yn+YeUm7ve/wDfCOpkax29sZNM8gUSNekEKD2F3Q9Nyfzg9qcjy5ln+Zix0hbbc0OB+wwDWAeMCaRioBJocDGBhYAFnAWYTMWZdEkCqp1roOoA7Xe2GsnnJ+kwGVWKmcVpsUy7ggjnCUQ1SaTQs0Bi7+K1ihXLZWKMM0EKiRigFE78jnnE1qZuSmIZyQKvtiMb+FIH0K9fysNsTKbEnjAmrSbu+2A1KGYMLODEjRqFFgtqtu5wIR2OcSJGoEdvXDK5dyAaG+/OAzGCBcbEKbDbn2w9lFDZeRG1MXHlA9cGiyjpMcrmJEQ/MpJ8tEXzjMpm1hzXieHqjTaid6x7NuoRjjkYiEsqqv8AOe/fGoQoUgiyeDfGHMz/AAVPhEjxeVYbkYSDhf8A2GHTZz5kBu659sMRShQyuA5NU18YRjBla28q8s3oO5wVnjQlVDNYoFtvvhjBKxCk5gxhxGtWGk22xKKdvD0KQVN89sV6MzIAx2BsYaZgFUx1RG/1xTLTScifRuOR3wy2bZmc/wDduRwPxxipWQg3jbT/AMNwrVtuD3xQ1ym5rbMZ6MC2VgOHjRtJsDY739T96rsnk+qy5fM6wxCPepQBRHpXB+mKxpqexdVW53xpJQguMFZAwYOCbFY98mPwLqR18yEpBGrBCvhK1qxG2oAA0LrjsPU74DmEBhglY+GH1DxGBCMR2XbsCCefmGOaDktZ5waVyqKzKrFxYIa63I3A4O3f6435U9eIr7LNFJJriMbhANSWQW7bA7knnb9sbz+WycmTbMJmtJBWoinmY7aq9AL5J3+uKbLZgMgV9QdBSyA2FG/I+p5HHvi8611aVunx5eCdWgUowZWLNrEYVvMyhqJs1xRresb8ofp8e1Z0jMLl8w0hUO4+WyRR9djyPxj3b4h6n+ry+Tz0jFXzUC+KYyQqrX8wq6Dbkd+LBx4d098r4kIBaIuoVpG+VSeWPc1zQ5/r13Sup/quiHKmcuYDYG9E+ov129NlGHhOx82O8al+Jp3fPSOxDCRiSQCADe/9b++KRpAwYEAmqs9sXXWJRNHGFWgoN7khmN71exqh9hjnnYuwFAEbYOvupg9QpG574GzMhoggHeiO2JSHc4gwULqeyxHlAPHufwdtu2J1gtSFCq+HqBrz2eTZ4222r1wtITeNs3mu8RYg4Cz5RDUd8Z4oVgw5HGIPwcbijZyojoMdtzgVArXp+QOcyr5uZ9CqxVSTpUmr5xUzzToXSR5AWrUG7+mG2zvhwRxPlk8Gj5QSNR41E4q5pXlctIxZuLOC1ApmUMlEkG/2xGZlYgAgAbXgJNYgxwOyIhdEBCgOx7ntiQlahuPxjSZOeQArGdJUtqPAHrgy5JCo/wCdyo27uf8A8wJhMZlxmczPM8gUB/KKokH0HtWBTKwZdS0WFj3Hrh3qDZVc2qQFly8g1+G1jR7X3+uEiwlyJ1EmSM0ttQC329cb21Kzjy5zAggMyIhAKuwqz9cBzGTOTzRvzxKbDHv74rctmpctIHjO4FUdxhrO5v8AVupC6ABxd798IglOXMPLpVn1BeKFDGBra2O+FVNcYIH33wiDNK+CK5qgdsKkgHymxjRkoc4Y8gky03YY1HmGRZFGkh10nUoJqwdr4O3I35Hc4V1jGw1435R5HDajgkc7xqyqRuCu4ugea9MLxyNG6vGzK6mwymiD64yySWYk2eT64Q2cjhgEoHnc7Yd6eIpA0EkijxvINVKFavKxYmgL2N9iTisLdsSQM10CQBZrthdikdg0TsjbMDRo2PyOcFZz4DjsSMFkjfMZfLkgCcLQvbxEBoEepBBH0HthaUhUIVw42NgHuON/TjGw5SSeWMsNbC001ZGxxdfDOYYZwRIGZ3oBQLs+mOb1bmzh7LyGJ4ZK2bizZoHGjxvOenK+6jcc8iMNLA8VWKSYMZRpBJPFYts8wciQEUReKzMMvhELYY/5zhaY5JJzTEXxiLMEcNHe2+/rgbGrBxvxP4ZWgdt8SWsEI40VIAJNfXGicD1miBvgMgt7sNwa9cRfcEBqUce+G8lGcxmoYUFs7AafXDfXcrNlHlikyaxKlcWdF+/c4PZlRuTQs8YE2JsbwNsFmUGOJRVrssBpFixdn0xBjgkmqGLwmVbanvuMTWYTM+YzU+WlntUipY3CbavTbFdYxgLMdC2e9YaVsoFAZWLVuQcHtS6vXlZMlPFHGySwBvDYqDtV0T9cVPUIYplyWbCeGso0Oinuu1/fGYzG2EpNciqmmMaSfMBufqcD8JlJFjGYzGxaXhsOaxIIfbGYzDp2G8ROMxmHY2sSBIxmMx6NItW2JqdsZjMbFtk+uJKxW6POMxmNjTWVgykEijYwxMVmhEiKEbUFYDgn1xmMwu2JKvwp9Rgr/wANIqIII1fLR9P7YzGY9GvOlQSdQkgysRVZJWCgsdrPriukO2MxmFaSM2zbYHq8pFbk84zGYm/cyGx2OMirVRHOMxmDMmchmRk+pJmPDDrG/wAp7431rq2Y6hLIZDpiZgwjHAoUP2xmMwdSKpPGIHfGYzBkUGBxFwQavGYzAqESXLvl8tBPq/616dJ3FGjeFcZjMTWV/9k=','{\"layout\": [{\"h\": 9, \"i\": \"1333650881518469122\", \"w\": 12, \"x\": 0, \"y\": 0}, {\"h\": 9, \"i\": \"1333651268543676418\", \"w\": 12, \"x\": 12, \"y\": 0}, {\"h\": 9, \"i\": \"1333660540300132354\", \"w\": 24, \"x\": 0, \"y\": 18}, {\"h\": 9, \"i\": \"1333660560139190274\", \"w\": 24, \"x\": 0, \"y\": 9}], \"interval\": []}'); /*Table structure for table `visual_board_chart` */ DROP TABLE IF EXISTS `visual_board_chart`; CREATE TABLE `visual_board_chart` ( `id` varchar(50) NOT NULL COMMENT '主键ID', `board_id` varchar(50) DEFAULT NULL COMMENT '看板ID', `chart_id` varchar(50) DEFAULT NULL COMMENT '图表ID', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='可视化看板和图表关联表'; /*Data for the table `visual_board_chart` */ insert into `visual_board_chart`(`id`,`board_id`,`chart_id`) values ('1336562972499181570','1333648415657787393','1333646285127524354'),('1336562972499181571','1333648415657787393','1333651268543676418'),('1336562972499181572','1333648415657787393','1333660540300132354'),('1339501061634871298','1339500743673073665','1333646285127524354'),('1339501061634871299','1339500743673073665','1333650881518469122'),('1339501061634871300','1339500743673073665','1333651268543676418'),('1346372133523472385','1346371838462574593','1333650881518469122'),('1346372133523472386','1346371838462574593','1333651268543676418'),('1346372133523472387','1346371838462574593','1333660540300132354'),('1346372133523472388','1346371838462574593','1333660560139190274'); /*Table structure for table `visual_chart` */ DROP TABLE IF EXISTS `visual_chart`; CREATE TABLE `visual_chart` ( `id` varchar(50) NOT NULL COMMENT '主键ID', `status` tinyint(4) DEFAULT NULL COMMENT '状态（0不启用，1启用）', `create_by` varchar(50) DEFAULT NULL COMMENT '创建人', `create_time` datetime DEFAULT NULL COMMENT '创建日期', `create_dept` varchar(50) DEFAULT NULL COMMENT '创建人所属部门', `update_by` varchar(50) DEFAULT NULL COMMENT '更新人', `update_time` datetime DEFAULT NULL COMMENT '更新日期', `remark` varchar(1000) DEFAULT NULL COMMENT '备注', `chart_name` varchar(255) DEFAULT NULL COMMENT '图表名称', `chart_thumbnail` text CHARACTER SET utf16le COMMENT '图表缩略图(图片base64)', `chart_json` text COMMENT '图表配置', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='可视化图表配置信息表'; /*Data for the table `visual_chart` */ insert into `visual_chart`(`id`,`status`,`create_by`,`create_time`,`create_dept`,`update_by`,`update_time`,`remark`,`chart_name`,`chart_thumbnail`,`chart_json`) values ('1333650881518469122',1,'1214835832967581698','2020-12-01 13:55:23','1197789917762031617','1214835832967581698','2021-01-06 16:51:16',NULL,'图表名称20201123',NULL,'{\"dataSetId\":\"1326047453933334529\",\"chartType\":\"table\",\"rows\":[],\"columns\":[],\"measures\":[],\"filters\":[],\"options\":{\"title\":{\"show\":false,\"text\":\"\",\"subtext\":\"\",\"left\":\"0%\",\"leftVal\":0,\"top\":\"0%\",\"topVal\":0,\"textStyle\":{\"fontSize\":18,\"color\":\"#333\"},\"subtextStyle\":{\"fontSize\":12,\"color\":\"#aaa\"}},\"legend\":{\"show\":true,\"type\":\"plain\",\"left\":\"0%\",\"leftVal\":0,\"top\":\"0%\",\"topVal\":0,\"orient\":\"horizontal\"}},\"theme\":\"default\",\"seriesType\":\"line\"}'),('1333651268543676418',1,'1214835832967581698','2020-12-01 13:56:55','1197789917762031617','1214835832967581698','2020-12-01 13:57:44',NULL,'图表名称20201124',NULL,'{\"dataSetId\":\"1326047453933334529\",\"chartType\":\"scatter\",\"rows\":[{\"col\":\"SALES_COUNTRY\",\"alias\":\"城市\"},{\"col\":\"SALES_REGION\",\"alias\":\"区域\"}],\"columns\":[{\"col\":\"SALES_DISTRICT\",\"alias\":\"地区\"}],\"measures\":[{\"col\":\"store_cost\",\"alias\":\"cost\",\"aggregateType\":\"sum\"},{\"col\":\"store_sales\",\"alias\":\"\",\"aggregateType\":\"min\"},{\"col\":\"unit_sales\",\"alias\":\"\",\"aggregateType\":\"count\"}],\"filters\":[],\"options\":{\"title\":{\"show\":false,\"text\":\"\",\"subtext\":\"\",\"left\":\"0%\",\"leftVal\":0,\"top\":\"0%\",\"topVal\":0,\"textStyle\":{\"fontSize\":18,\"color\":\"#333\"},\"subtextStyle\":{\"fontSize\":12,\"color\":\"#aaa\"}},\"legend\":{\"show\":false,\"type\":\"plain\",\"left\":\"0%\",\"leftVal\":0,\"top\":\"0%\",\"topVal\":0,\"orient\":\"horizontal\",\"data\":[\"Salem\",\"Seattle\",\"Tacoma\",\"Hidalgo\",\"Bellingham\",\"Orizaba\",\"Los Angeles\",\"Portland\",\"Yakima\",\"Marida\",\"Mexico City\",\"San Diego\",\"Spokane\",\"Bremerton\",\"Vancouver\",\"Walla Walla\",\"Victoria\",\"Acapulco\",\"Guadalajara\"]}},\"theme\":\"default\"}'),('1333660540300132354',1,'1214835832967581698','2020-12-01 14:33:46','1197789917762031617','1214835832967581698','2020-12-01 15:52:45',NULL,'图表名称20201125',NULL,'{\"dataSetId\":\"1326047453933334529\",\"chartType\":\"sankey\",\"rows\":[{\"col\":\"SALES_COUNTRY\",\"alias\":\"城市\"},{\"col\":\"SALES_REGION\",\"alias\":\"区域\"}],\"columns\":[{\"col\":\"SALES_DISTRICT\",\"alias\":\"地区\"}],\"measures\":[{\"col\":\"store_cost\",\"alias\":\"cost\",\"aggregateType\":\"sum\"}],\"filters\":[],\"options\":{\"title\":{\"show\":false,\"text\":\"\",\"subtext\":\"\",\"left\":\"0%\",\"leftVal\":0,\"top\":\"0%\",\"topVal\":0,\"textStyle\":{\"fontSize\":18,\"color\":\"#333\"},\"subtextStyle\":{\"fontSize\":12,\"color\":\"#aaa\"}},\"legend\":{\"show\":false,\"type\":\"plain\",\"left\":\"0%\",\"leftVal\":0,\"top\":\"0%\",\"topVal\":0,\"orient\":\"horizontal\"}},\"theme\":\"default\"}'),('1333660560139190274',1,'1214835832967581698','2020-12-01 14:33:50','1197789917762031617','1214835832967581698','2020-12-01 15:36:18',NULL,'图表名称20201126',NULL,'{\"dataSetId\":\"1326047453933334529\",\"chartType\":\"radar\",\"rows\":[{\"col\":\"SALES_COUNTRY\",\"alias\":\"城市\"},{\"col\":\"SALES_REGION\",\"alias\":\"区域\"}],\"columns\":[{\"col\":\"SALES_DISTRICT\",\"alias\":\"地区\"}],\"measures\":[{\"col\":\"store_cost\",\"alias\":\"cost\",\"aggregateType\":\"sum\"}],\"filters\":[],\"options\":{\"title\":{\"show\":false,\"text\":\"\",\"subtext\":\"\",\"left\":\"0%\",\"leftVal\":0,\"top\":\"0%\",\"topVal\":0,\"textStyle\":{\"fontSize\":18,\"color\":\"#333\"},\"subtextStyle\":{\"fontSize\":12,\"color\":\"#aaa\"}},\"legend\":{\"show\":false,\"type\":\"plain\",\"left\":\"0%\",\"leftVal\":0,\"top\":\"0%\",\"topVal\":0,\"orient\":\"horizontal\",\"data\":[\"Salem-store_cost\",\"Seattle-store_cost\",\"Tacoma-store_cost\",\"Hidalgo-store_cost\",\"Bellingham-store_cost\",\"Orizaba-store_cost\",\"Los Angeles-store_cost\",\"Portland-store_cost\",\"Yakima-store_cost\",\"Marida-store_cost\",\"Mexico City-store_cost\",\"San Diego-store_cost\",\"Spokane-store_cost\",\"Bremerton-store_cost\",\"Vancouver-store_cost\",\"Walla Walla-store_cost\",\"Victoria-store_cost\",\"Acapulco-store_cost\",\"Guadalajara-store_cost\"]}},\"theme\":\"default\",\"seriesType\":\"radar\"}'),('1333967577806409730',1,'1214835832967581698','2020-12-02 10:53:49','1197789917762031617','1214835832967581698','2020-12-02 10:54:20',NULL,'图表名称20201127',NULL,'{\"dataSetId\":\"1326047453933334529\",\"chartType\":\"map\",\"rows\":[{\"col\":\"SALES_COUNTRY\",\"alias\":\"城市\"},{\"col\":\"SALES_REGION\",\"alias\":\"区域\"}],\"columns\":[{\"col\":\"SALES_DISTRICT\",\"alias\":\"地区\"}],\"measures\":[{\"col\":\"store_cost\",\"alias\":\"cost\",\"aggregateType\":\"sum\"}],\"filters\":[],\"options\":{\"title\":{\"show\":false,\"text\":\"\",\"subtext\":\"\",\"left\":\"0%\",\"leftVal\":0,\"top\":\"0%\",\"topVal\":0,\"textStyle\":{\"fontSize\":18,\"color\":\"#333\"},\"subtextStyle\":{\"fontSize\":12,\"color\":\"#aaa\"}},\"legend\":{\"show\":false,\"type\":\"plain\",\"left\":\"0%\",\"leftVal\":0,\"top\":\"0%\",\"topVal\":0,\"orient\":\"horizontal\"}},\"theme\":\"default\"}'),('1346383803050278913',1,'1214835832967581698','2021-01-05 17:11:28','1197789917762031617','1214835832967581698','2021-01-05 17:11:28',NULL,'qqq',NULL,NULL); /*Table structure for table `visual_data_set` */ DROP TABLE IF EXISTS `visual_data_set`; CREATE TABLE `visual_data_set` ( `id` varchar(50) NOT NULL COMMENT '主键ID', `status` tinyint(4) DEFAULT NULL COMMENT '状态（0不启用，1启用）', `create_by` varchar(50) DEFAULT NULL COMMENT '创建人', `create_time` datetime DEFAULT NULL COMMENT '创建日期', `create_dept` varchar(50) DEFAULT NULL COMMENT '创建人所属部门', `update_by` varchar(50) DEFAULT NULL COMMENT '更新人', `update_time` datetime DEFAULT NULL COMMENT '更新日期', `remark` varchar(1000) DEFAULT NULL COMMENT '备注', `source_id` varchar(50) DEFAULT NULL COMMENT '数据源', `set_name` varchar(50) DEFAULT NULL COMMENT '数据集名称', `set_sql` varchar(4000) DEFAULT NULL COMMENT '数据集sql', `schema_json` json DEFAULT NULL COMMENT '数据模型定义', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='可视化数据集信息表'; /*Data for the table `visual_data_set` */ insert into `visual_data_set`(`id`,`status`,`create_by`,`create_time`,`create_dept`,`update_by`,`update_time`,`remark`,`source_id`,`set_name`,`set_sql`,`schema_json`) values ('1326047453933334529',1,'1214835832967581698','2020-11-10 14:22:04','1197789917762031617','1214835832967581698','2020-11-10 14:22:05',NULL,'1240185865539600385','Bubble','SELECT\n b.the_year + 5 AS the_year,\n b.month_of_year,\n b.day_of_month,\n date_add(b.the_date, interval 5 year) AS the_date,\n r.SALES_DISTRICT,\n r.SALES_REGION,\n r.SALES_COUNTRY,\n d.yearly_income,\n d.total_children,\n d.member_card,\n d.num_cars_owned,\n d.gender,\n a.store_sales,\n a.store_cost,\n a.unit_sales\nFROM\n foodmart2.sales_fact_sample a\n JOIN foodmart2.time_by_day b ON a.time_id = b.time_id\n JOIN foodmart2.store c ON a.store_id = c.store_id\n JOIN foodmart2.region r ON c.REGION_ID = r.REGION_ID\n JOIN foodmart2.customer d ON a.CUSTOMER_ID = d.CUSTOMER_ID\nWHERE\n SALES_COUNTRY IS NOT NULL','{\"columns\": [\"the_year\", \"month_of_year\", \"day_of_month\", \"the_date\", \"SALES_DISTRICT\", \"SALES_REGION\", \"SALES_COUNTRY\", \"yearly_income\", \"total_children\", \"member_card\", \"num_cars_owned\", \"gender\", \"store_sales\", \"store_cost\", \"unit_sales\"], \"measures\": [{\"col\": \"store_cost\", \"alias\": \"cost\"}, {\"col\": \"store_sales\", \"alias\": \"\"}, {\"col\": \"unit_sales\", \"alias\": \"\"}], \"dimensions\": [{\"col\": \"SALES_DISTRICT\", \"alias\": \"地区\"}, {\"col\": \"SALES_REGION\", \"alias\": \"区域\"}, {\"col\": \"SALES_COUNTRY\", \"alias\": \"城市\"}]}'); /*Table structure for table `visual_screen` */ DROP TABLE IF EXISTS `visual_screen`; CREATE TABLE `visual_screen` ( `id` varchar(50) NOT NULL COMMENT '主键ID', `status` tinyint(4) DEFAULT NULL COMMENT '状态（0不启用，1启用）', `create_by` varchar(50) DEFAULT NULL COMMENT '创建人', `create_time` datetime DEFAULT NULL COMMENT '创建日期', `create_dept` varchar(50) DEFAULT NULL COMMENT '创建人所属部门', `update_by` varchar(50) DEFAULT NULL COMMENT '更新人', `update_time` datetime DEFAULT NULL COMMENT '更新日期', `remark` varchar(1000) DEFAULT NULL COMMENT '备注', `screen_name` varchar(255) DEFAULT NULL COMMENT '酷屏名称', `screen_thumbnail` text CHARACTER SET utf16le COMMENT '酷屏缩略图(图片base64)', `screen_json` json DEFAULT NULL COMMENT '酷屏配置', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='可视化酷屏配置信息表'; /*Data for the table `visual_screen` */ insert into `visual_screen`(`id`,`status`,`create_by`,`create_time`,`create_dept`,`update_by`,`update_time`,`remark`,`screen_name`,`screen_thumbnail`,`screen_json`) values ('1339756691096424450',1,'1319084615276814337','2020-12-18 10:17:41','1197790192543469570','1319084615276814337','2020-12-18 10:19:39',NULL,'酷屏名称20201215','data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQABAAD/2wBDAAYEBQYFBAYGBQYHBwYIChAKCgkJChQODwwQFxQYGBcUFhYaHSUfGhsjHBYWICwgIyYnKSopGR8tMC0oMCUoKSj/2wBDAQcHBwoIChMKChMoGhYaKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCj/wAARCACWAPoDASIAAhEBAxEB/8QAGwAAAgMBAQEAAAAAAAAAAAAAAAECAwQFBgf/xAA7EAABAwEHAQUFBgYCAwAAAAABAAIRAwQSITFBUWEFBhNxkfAUIjKB0UJSYqHB4QcVI3Kx8TOSFlNj/8QAGQEAAwEBAQAAAAAAAAAAAAAAAQIDAAQF/8QAJxEAAwACAwACAgEEAwAAAAAAAAECAxESITFBUQQTYQUUIpEyQqH/2gAMAwEAAhEDEQA/APiEoBUUL3TkJgpquVIGUdmJIQhUTMCYShOI1CvjCkyQKkoBaqNAvIL8AchqV1I6Y7K6dN1QwMtTstAaGNut+Z3Uz7ougQBogMJ0TbKMqLUrqv7vcohozW2Az3UwxXEjZKToAFjFfd+KIa1SMlKFgkCdgq3EnMq4tUCER0VpKZaoLGaEonNWsYXOjLxVncMMYmdcRwlbQjhvwylRK0vZTBgST4+KfcNwnfflK2SeJvpGVCvFJuH18FF1IaFSpNk3hoqQm4QYSXPRJrXQJpJpDFSUqRaUiwgYgKfCvowlJri0yEgAMz5KYDSQAXEniEVLRl70O+SIQptpgCYPn+yfduGOA1xHrZUUNlHFPtlYBcYAJJ0C0MstQxeF0bnCENc9pF0kxvl5KFxzyHOcT4rpx40vWFY9eo1U6NKkcarC7fNX02MJxLyZ1CxgS4m7+XB44WlgIcBGu3Pgr/HR045RpaZBw+Z+X1VVS+Phm7GcIp4gYbacDhW/Zy0/Q8IeFGkzMQ7Wfmpd3hN4LS5gccRr9eE2sAwj8vDhbkDgYy2Dhii6tRpCCYPoeCj3PKPIHBme6i6r3UiDAg/5TpU5kkFbYj2jPcUCxdB1JuOB9TwqzRE6+o4WVGXIxspFxJiQNyo1KZggNeDnEYDNajSEYF3n+yTg7HLy8eFtll5ozNBLBevxnJPIyQXuDPdDp+Y25Uu5PvAnAmNcp8FS9zmMEET4cDhb0FPSK21nsJBk+JPrVXUqveSPtTOu6jVZfZJF08jx4WenhVGIiYlbSZB3WNr6NQm6M9N+FF5MYzlzygkBoJgDD9OFS+pOAU6aQ1ZVPpB+Lz4pJlpzKS5K9OOt77BNJNDQCBB3Sc4kQTgpo+SVw16bbKwwnTBaaLGNAJdLtvmoiHAiCm1kb5pphLsvjnT2iVN8HACdCm7F0kyf9qLcBgmc9fUqstlpWl2PVNhEeuFHGdUNy19QqpjsukcegVc0i9pnxv4rPJjX89irmk3tc+d1VAl9l1IjDLTbZvKtBF3T0Dys9Jxwz032arQ43dcudis0VTRoBF7TP6pOqNa7E+sEgTe1z53KorQHGM0qW2anpF3ehwhok6zhoh1YCYElZ2VC0EDVK9JTcSbt6Jl5LpyPCsouaJvZ6KmVJpg5ptHPd67NFSqASAJM/VQFVriBkZ25CpeVRUdC3AEZWbCRxlxsOVW4j3stdvxcqqlWviJJIGMShzjLs9d/xJdaOxUmgrk92bsEzxusEnIzGy3Fx5z53VTheuzOEHXYLJ6J5Vy8ZGpTgxTMN1xHPKykFriNQVse4ic/z5WeqQ6TkZ1zWb0iGVL1EXvLmgEZKKELlutnO232wQhCTRgTSTTpaBsRQujUsjXtvUHXhsFk9ncXQuu8M14IqfjIQGic0SdRrstJYGyBkP35Vb2g57+tVCsX0di7XRUCCAMNk7sHA+sUrohNsNJA9ZqXF77Ck9rkSgShsR64SLseEBwwVU0UdIsAEaegeFYAL2Qz2G/gqb3rz5Vgf72fqfFVTF2WMjYabbN4UnOApzAOHGx4VAfHrw5Q6p7mO36HlHaCr0WvtQDQ5gzOoHKi+tdaC6LxP0WNri34TCRxMnErK5JPO2ae/CYrhZIRARWSRXlZubWB1U++G657QrWDAlXhKu0ef+TnqTQ+sFlqVCUlEpbpQNhqqW2XWRwlwdmRh6hXuiXYDXbnhYlaKhOef+1zvImz0MV/DL8J0z438EgBhl6jhVOqREKPeEtIy8EvNb0UvIl0Ko+XYCAFBCElWcjbfbBCEKPpgQhMKsyBsSaEp5RekD0m1zmOlpLTwttktL3XhVAdyBis7mh4vMVQJY6Rmu7StbRGL4V2dJ5aSSZA3xjVVuZexaZE5jxCyGu6SQAD4eP1U6ZFTE+46RiNVJpo7Yqa8BzDdGBy/QKpwM8/7Vri9rRN0iMxCg5wJOnoqNaZVfTIkxuq03GThkkuW62+iGStssafdxOX7qN8l0yUhghWltpCO34WTIwPrBVEk5mVMgFkhF2G8o3NNh5OiCEyDKUKDTQGCEICC3sDGFoDYs5duqWCXALdaWXLO1q9XCuMo838mt1r6MBUSpFJc35G+R2Yn/ihIQULib7LIczmEyMiCohSGatO2uwu2+hY7JKwpEApqjfhT9e10QQgiEBTmWSfQBNCre/QKtUoXYEtg90YDNQSJRK4bt29sY0AlpkGCrA4P+LA7qsg7FJdeOsmN9CVKr0m5pGalQnvRG4nzVYcRhmFdZzFVpBwkT5runJORfTJLljr+C0Xg0QTlvwOVCq1pBkQePnytJb7ozy/QcLHaj/UujTNTqdo7Oa0VlhuyMQoqVRwIaBkAlO+K5awL4JvXwIJoAByMeKd0jTDdVwRS6ZK2kAn5FE8QhXUqbXUy4zI+i6qx7RKMm64lQY46QjGDIWwtx9bnhRuTgR6w4UXiXwdK1rpmKE1J7broSAkpMeDvsld8V2aun0r9WSMAttvZ7kbKzpVC6ySM1O3twcu3eno8yny238nBdmkpOEEhRKnlx77O3De5SBCE4XNH4+2WrIpXYkwYMoKSpkjj4CK32WROM+sUw316KVESHetCtDW4/P9fBLK2dk11spybOn+uVSVbUqC7dA+fkszyUmWlj99I1XJ9A92yqlMpQvPu3T2zCKaUKUJAmhHgU4RC9X+1Zz/ALp+xSdUSfQThIhK/wAe14xlllmhlse1oDmsdGpCrc9rySWCTsVWhUjnPvYafIl7mzh80iG6E+SPFMNnIyrceXgnPXogB94DxUmS0y1w81EtIzQAmiWmSy3NL02U6bXjENncFWmz3WEM139cqFjaC0ytraeCen8HHP2c91OsDMZbBOm8H4hB2jw+i3XCDmUg10obTHm6n5OQ+XOJhaLHRvVAStXcNmboWyy08QAIWbSXQG6r/kzfYqN2meAsdtbgV3qVnuWK9uuNam+8Qpy9s2jg1qUkmFmIK7NRmGSzeztJmFVNP0VNy9owspucYAVj6VwLosohjcBCrqMDs1lWjVuvTmEQktbrPJzwSNnawS90BalLLY6uV4RoM9wkxj+6K1QNlrYJ/wAYqx1QNs4uYAiMdc1iKje0ujtmtpISREpoXnXjbeypAsSuKxCn+thK7hTuKaaH6mY6Rsg5S9kHK6TWHZWspA5he1yZ4ukcc2TlRNk5XfFla7JBsJ0C37A8TzrrK5UvpOYcQvSOsbhoqX2Q7I80FOl4zz107IhderYNmqg2T5JlUm5WYQ85OEhWNDHHOPFahZQUeyYECZW2gPk/SVnF2IXRpMmNllsllcMMSvQ9NsDqwADSSp1WhtHLdSxUO5Mr2Lez9SowEMM+CuZ2TtLyLtN3kpftRujw3dGcl0emWU1KzQBqvWjsRbiZFF0f2rrdL7LVrI4OfRdI4S1mnXTNtI5NusYpWFjQMQJK8faqZvnBfU7b0yq6m5ppnyXmbZ0GqLxFM+SWLSAqTPC1KZlRZRcTlgvUDoVYvxYfJW1+k9zSwbirc0bo8nUbAWN7oOC69ts5DiAFz3UHB2IKdMOiiDdw+JZa1B+Lnm8ugW3c1ktlQhkDMpp9DT2uzCX+6W5hVFSKRC1rZ04GlOhIQhc7g60wQhTZSc84BZY9gq1PpBODstlKyxi5aO6aqKJRJ5afiOo2o3dXMqt4XDDqg+OpTadpkqxlamPjrOdw0Qn4nnbO6K7ApNtgHwrkU7dZ6Y/4g87vcf0V7OtFhHcsoM5FMT5lK5YeR16NSpWMMpOd4NldGz9LtVYibOWjdwgLzzuvW6o2HWqrd2DiAqv5jVdm9x+aRwxkz2dPs2ajoqVrLTG76zR9VsZ2M6VVA9o63ZaZ1uy5eDZb3/eK0M6g8faKVxX2Hb+j6LZexfZJgHtHWKtU/gbC6tn7NdhqUS6tWP4nFfLafU6g+0Vqp9VePtKVYaftMDq/jR9aodO7F0Y7uxMd/dJXRoV+zdCBQsdFvg1fHqfWXDVaGdbO6k/xt+t/7EbyfwfZGdW6S34KLB8lfT69YW/Cxo+S+NN65yrB17kpH+FD92LvMvNH2tnamg1pa2ADwFU/tDZnnEBfGf5/yUf+Q8lIv6fjXgzyfkP1n2F3WbE7NjVWep9Od8VJh8QF8hPaI7/moO7RO3PmnX4UrzYu8v8AB9f9s6Q74qNLyCqqfyCsP6lGnjwvkDu0L9HfmqX9fqH7SK/E+m/9hX7PnR9VtHQuyVpm/Sa0n7roWCt2I7KVge7tNSkT+OV8zd12r98+aqd1usftu806/HteWx07+ke3t/8AC/pleTY+uMYdBUAK851L+EfUoJsfUbFaBoL8Fcg9crf+x3mgdfrg4VX/APZWmcs/9v8AwzbfqRzuo/w67SWKSenurNGtIh3+F5y19J6hY3EWqxWikR9+mQvcs7TWxnw2mq3wcVcO19viHWl7hs7FWV5PnTAm12kfMywg4gqdOzvfk1fQq/XqdpxtVjslY7vpCVgrWjplXOwtpn/5uIT8/wCCiy38nmKViAxfiVoDWMGi6dSlYng93UqsPMFYLRYXH/itFN39wIQ22UmpM1SsAMFn9oG6K1itQJll4btMqj2esM6T/wDqU2kWTlkcd0sUIT7OdxP0PHdMEhCEyIVKRYx7hkVop1Cc0IQaJp6L2uKsa4oQpsuixryrW1HIQgEmKrlIVXIQg0YkKrt0d67dCEAh3jt0jUduhCxiJqO3UTUduhCKQBGo7dQNR26EImImo7dRNRyELAZA1Como5CETEHViFU60u0QhMkiVU0QNqfsom0vQhPpC8mR9oqfeUhaqg1QhbSDtk22yoFYLc9CEGkDkz//2Q==','{\"scale\": 100, \"width\": 1920, \"height\": 1080, \"layout\": [{\"h\": 280, \"i\": \"1333650881518469122\", \"w\": 300, \"x\": 440, \"y\": 100}, {\"h\": 280, \"i\": \"1333651268543676418\", \"w\": 280, \"x\": 80, \"y\": 100}], \"property\": [{\"id\": \"1333651268543676418\", \"border\": \"BorderBox1\", \"chartName\": \"图表名称20201124\", \"milliseconds\": 0, \"backgroundColor\": \"rgba(255, 255, 255, 0.1)\"}, {\"id\": \"1333650881518469122\", \"border\": \"BorderBox3\", \"chartName\": \"图表名称20201123\", \"milliseconds\": 0, \"backgroundColor\": \"rgba(255, 255, 255, 0.1)\"}], \"backgroundImage\": \"images/bg8.jpg\"}'); /*Table structure for table `visual_screen_chart` */ DROP TABLE IF EXISTS `visual_screen_chart`; CREATE TABLE `visual_screen_chart` ( `id` varchar(50) NOT NULL COMMENT '主键ID', `screen_id` varchar(50) DEFAULT NULL COMMENT '酷屏ID', `chart_id` varchar(50) DEFAULT NULL COMMENT '图表ID', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='可视化酷屏和图表关联表'; /*Data for the table `visual_screen_chart` */ insert into `visual_screen_chart`(`id`,`screen_id`,`chart_id`) values ('1339757185336430593','1339756691096424450','1333650881518469122'),('1339757185336430594','1339756691096424450','1333651268543676418'); /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;