pd之数据模型

最新推荐文章于 2022-08-28 19:16:37 发布

归去来兮★

最新推荐文章于 2022-08-28 19:16:37 发布

阅读量896

点赞数

分类专栏：品达通用权限项目文章标签：数据库服务器 database

本文链接：https://blog.csdn.net/zhouhe_/article/details/125055487

版权

品达通用权限项目专栏收录该内容

4 篇文章 0 订阅

订阅专栏

数据模型

数据模型
导入实体类
- 认证和鉴权流程
- - 认证流程
  - 鉴权流程

数据模型

权限数据模型介绍

在项目中要进行权限控制，需要有一套权限相关的数据表来提供支持，这是整个权限控制的基础。本系统采用的权限数据模型是在经典的RBAC权限数据模型的基础之上进行的改进，共涉及到如下9张表：

pd_core_org----------------组织表
pd_core_station------------岗位表
pd_auth_user---------------用户表
pd_auth_role---------------角色表
pd_auth_resource-----------资源表
pd_auth_menu---------------菜单表
pd_auth_user_role----------用户角色关系表
pd_auth_role_authority-----角色权限关系表
pd_auth_role_org-----------角色组织关系表

需要说明的是菜单和资源其实都属于权限，是两种不同类型的权限，即菜单权限和资源权限。具体说明如下：

菜单权限：对应的是系统的菜单，不同的用户可能拥有不同的菜单权限，这样登录系统后看到的菜单也不同
资源权限：对应的是某个功能的访问接口，拥有权限则可以访问此接口，没有权限则禁止访问此接口

导入表结构

在MySQL中创建pd-auth数据库，在此数据库中执行授课资料中的"pd_auth.sql"脚本即可。执行完后可以看到如下11张表：

pd_common_login_log表

pd_common_login_log为用户登录日志表，具体的字段如下：

字段名	类型	说明
id	bigint	主键
request_ip	varchar	操作IP
user_id	bigint	登录人ID
user_name	varchar	登录人姓名
account	varchar	登录人账号
description	varchar	登录描述
login_date	date	登录时间
ua	varchar	浏览器请求头
browser	varchar	浏览器名称
browser_version	varchar	浏览器版本
operating_system	varchar	操作系统
location	varchar	登录地点
create_time	datetime	创建时间
create_user	bigint	创建人ID

pd_common_opt_log表

pd_common_opt_log为用户操作日志表，具体字段如下：

字段名	类型	说明
id	bigint	主键
request_ip	varchar	操作IP
type	varchar	日志类型 OPT:操作类型 EX:异常类型
user_name	varchar	操作人
description	varchar	操作描述
class_path	varchar	类路径
action_method	varchar	请求方法
request_uri	varchar	请求地址
http_method	varchar	请求类型 GET:GET请求;POST:POST请求;PUT:PUT请求;DELETE:DELETE请求;PATCH:PATCH请求;TRACE:TRACE请求;HEAD:HEAD请求;OPTIONS:OPTIONS请求
params	longtext	请求参数
result	longtext	返回值
ex_desc	longtext	异常详情信息
ex_detail	longtext	异常描述
start_time	timestamp	开始时间
finish_time	timestamp	完成时间
consuming_time	bigint	消耗时间
ua	varchar	浏览器请求头
create_time	datetime	创建时间
create_user	bigint	创建人ID

pd_auth_menu表

pd_auth_menu为菜单表，具体字段如下：

字段名	类型	说明
id	bigint	主键
name	varchar	菜单名称
describe_	varchar	功能描述
is_public	bit	是否是公开菜单
path	varchar	对应路由path
component	varchar	对应路由组件component
is_enable	bit	是否启用
sort_value	int	排序
icon	varchar	菜单图标
group_	varchar	菜单分组
parent_id	bigint	父级菜单id
create_user	bigint	创建人id
create_time	datetime	创建时间
update_user	bigint	更新人id
update_time	datetime	更新时间

pd_auth_resource表

pd_auth_resource为资源表，具体字段如下：

字段名	类型	说明
id	bigint	主键
code	varchar	资源编码
name	varchar	接口名称
menu_id	bigint	菜单ID
method	varchar	HTTP请求方式
url	varchar	接口请求url
describe_	varchar	接口描述
create_user	bigint	创建人id
create_time	datetime	创建时间
update_user	bigint	更新人id
update_time	datetime	更新时间

pd_auth_role表

pd_auth_role为角色表，具体字段如下：

字段名称	类型	说明
id	bigint	主键
name	varchar	角色名称
code	varchar	角色编码
describe_	varchar	角色描述
status	bit	是否启用状态
readonly	bit	是否内置角色
create_user	bigint	创建人id
create_time	datetime	创建时间
update_user	bigint	更新人id
update_time	datetime	更新时间

pd_auth_user表

pd_auth_user表为用户表，具体字段如下：

字段名	类型	说明
id	bigint	主键
account	varchar	账号
name	varchar	姓名
org_id	bigint	组织ID
station_id	bigint	岗位ID
email	varchar	邮箱
mobile	varchar	手机号
sex	varchar	性别
status	bit	启用状态
avatar	varchar	头像
work_describe	varchar	工作描述
password_error_last_time	datetime	最后一次输错密码时间
password_error_num	int	密码错误次数
password_expire_time	datetime	密码过期时间
password	varchar	密码
last_login_time	datetime	最后登录时间
create_user	bigint	创建人id
create_time	datetime	创建时间
update_user	bigint	更新人id
update_time	datetime	更新时间

pd_core_station表

pd_core_station表为岗位表，具体字段如下：

字段名称	类型	说明
id	bigint	主键
name	varchar	岗位名称
org_id	bigint	组织ID
status	bit	是否启用状态
describe_	varchar	描述
create_time	datetime	创建时间
create_user	bigint	创建人ID
update_time	datetime	更新时间
update_user	bigint	更新人ID

pd_core_org表

pd_core_org表为组织表，具体字段如下：

字段名称	类型	说明
id	bigint	主键
name	varchar	组织名称
abbreviation	varchar	简称
parent_id	bigint	父ID
tree_path	varchar	树结构
sort_value	int	排序
status	bit	状态
describe_	varchar	描述
create_time	datetime	创建时间
create_user	bigint	创建人ID
update_time	datetime	更新时间
update_user	bigint	更新人ID

pd_auth_user_role表

pd_auth_user_role为用户角色关系表，具体字段为：

字段名称	类型	说明
id	bigint	主键
role_id	bigint	角色ID
user_id	bigint	用户ID
create_user	bigint	创建人ID
create_time	datetime	创建时间

pd_auth_role_org表

pd_auth_role_org为角色组织关系表，具体字段为：

字段名称	类型	说明
id	bigint	主键
role_id	bigint	角色ID
org_id	bigint	组织ID
create_time	datetime	创建时间
create_user	bigint	创建人ID

pd_auth_role_authority表

pd_auth_role_authority为角色权限关系表，具体字段为：

字段名称	类型	说明
id	bigint	主键
authority_id	bigint	权限ID
authority_type	varchar	权限类型 MENU:菜单 RESOURCE:资源
role_id	bigint	角色ID
create_time	datetime	创建时间
create_user	bigint	创建人ID

/*
Navicat MySQL Data Transfer

Source Server         : 本地MySQL数据库
Source Server Version : 50728
Source Host           : localhost:3306
Source Database       : pd_auth

Target Server Type    : MYSQL
Target Server Version : 50728
File Encoding         : 65001

Date: 2020-03-23 12:02:03
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `pd_auth_menu`
-- ----------------------------
DROP TABLE IF EXISTS `pd_auth_menu`;
CREATE TABLE `pd_auth_menu` (
  `id` bigint(20) NOT NULL COMMENT '主键',
  `name` varchar(20) NOT NULL DEFAULT '' COMMENT '菜单名称',
  `describe_` varchar(200) DEFAULT '' COMMENT '功能描述',
  `is_public` bit(1) DEFAULT b'0' COMMENT '是否公开菜单\r\n就是无需分配就可以访问的。所有人可见',
  `path` varchar(255) DEFAULT '' COMMENT '对应路由path',
  `component` varchar(255) DEFAULT NULL COMMENT '对应路由组件component',
  `is_enable` bit(1) DEFAULT b'1' COMMENT '状态',
  `sort_value` int(11) DEFAULT '1' COMMENT '排序',
  `icon` varchar(255) DEFAULT '' COMMENT '菜单图标',
  `group_` varchar(20) DEFAULT '' COMMENT '菜单分组',
  `parent_id` bigint(20) DEFAULT '0' COMMENT '父级菜单id',
  `create_user` bigint(20) DEFAULT NULL COMMENT '创建人id',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_user` bigint(20) DEFAULT NULL COMMENT '更新人id',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `INX_STATUS` (`is_enable`,`is_public`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='菜单';

-- ----------------------------
-- Records of pd_auth_menu
-- ----------------------------
INSERT INTO `pd_auth_menu` VALUES ('101', '系统管理', '系统管理', '\0', '/user', 'pinda/user/Index', '', '0', 'el-icon-user-solid', '', '0', '1', '2019-07-25 15:35:12', '3', '2020-01-09 19:23:12');
INSERT INTO `pd_auth_menu` VALUES ('104', '监控管理', '开发者', '\0', '/developer', 'pinda/developer/Index', '', '3', 'el-icon-user-solid', '', '0', '1', '2019-11-11 14:38:34', '3', '2020-01-09 19:22:52');
INSERT INTO `pd_auth_menu` VALUES ('603976297063910529', '菜单配置', '', '\0', '/auth/menu', 'pinda/auth/menu/Index', '', '3', '', '', '101', '1', '2019-07-25 15:46:11', '3', '2019-11-11 14:31:52');
INSERT INTO `pd_auth_menu` VALUES ('603981723864141121', '角色管理', '', '\0', '/auth/role', 'pinda/auth/role/Index', '', '4', '', '', '101', '1', '2019-07-25 16:07:45', '3', '2019-11-11 14:31:57');
INSERT INTO `pd_auth_menu` VALUES ('603982542332235201', '组织管理', '', '\0', '/user/org', 'pinda/user/org/Index', '', '0', '', '', '101', '1', '2019-07-25 16:11:00', '3', '2020-01-11 08:51:22');
INSERT INTO `pd_auth_menu` VALUES ('603982713849908801', '岗位管理', '', '\0', '/user/station', 'pinda/user/station/Index', '', '1', '', '', '101', '1', '2019-07-25 16:11:41', '3', '2019-11-11 14:28:43');
INSERT INTO `pd_auth_menu` VALUES ('603983082961243905', '用户管理', '', '\0', '/user/user', 'pinda/user/user/Index', '', '2', '', '', '101', '1', '2019-07-25 16:13:09', '3', '2020-01-09 19:27:02');
INSERT INTO `pd_auth_menu` VALUES ('605078672772170209', '操作日志', '', '\0', '/developer/optLog', 'pinda/developer/optLog/Index', '', '3', '', '', '104', '1', '2019-07-28 16:46:38', '3', '2019-11-11 14:35:14');
INSERT INTO `pd_auth_menu` VALUES ('605078979149300257', '数据库监控', '', '\0', '/developer/db', 'pinda/developer/db/Index', '\0', '2', '', '', '104', '1', '2019-07-28 16:47:51', '3', '2020-01-10 10:40:42');
INSERT INTO `pd_auth_menu` VALUES ('605079239015793249', '接口文档', '', '\0', 'http://39.100.244.120:8760/api/gate/doc.html', 'Layout', '', '5', '', '', '104', '1', '2019-07-28 16:48:53', '3', '2020-01-10 10:33:23');
INSERT INTO `pd_auth_menu` VALUES ('605079411338773153', '注册配置中心', '', '\0', 'http://localhost:8848/nacos', 'Layout', '\0', '6', '', '', '104', '1', '2019-07-28 16:49:34', '3', '2020-01-10 10:40:47');
INSERT INTO `pd_auth_menu` VALUES ('645215230518909025', '登录日志', '', '\0', '/developer/loginLog', 'pinda/developer/loginLog/Index', '', '4', '', '', '104', '3', '2019-11-16 10:54:59', '3', '2019-11-16 10:54:59');
INSERT INTO `pd_auth_menu` VALUES ('667033750256747169', '文件管理', '', '\0', '/file/attachment', 'pinda/file/attachment/Index', '\0', '5', '', '', '101', '3', '2020-01-15 15:53:59', '3', '2020-02-05 08:47:15');
INSERT INTO `pd_auth_menu` VALUES ('676762150244450433', '接口路由', '', '\0', '/ofpay', 'pinda/ofpay/Index', '', '10', 'el-icon-guide', '', '0', '3', '2020-02-11 12:11:10', '3', '2020-02-11 12:11:10');
INSERT INTO `pd_auth_menu` VALUES ('676762509503365569', '调用记录', '', '\0', '/ofpay/receive', 'pinda/ofpay/receive/Index', '', '0', '', '', '676762150244450433', '3', '2020-02-11 12:12:36', '3', '2020-02-11 12:14:24');
INSERT INTO `pd_auth_menu` VALUES ('676762719185011233', '请求记录', '', '\0', '/ofpay/send', 'pinda/ofpay/send/Index', '', '1', '', '', '676762150244450433', '3', '2020-02-11 12:13:26', '3', '2020-02-11 12:13:26');
INSERT INTO `pd_auth_menu` VALUES ('680085395794296897', '平台管理', '', '\0', '/ofpay/platform', 'pinda/ofpay/platform/Index', '', '2', '', '', '676762150244450433', '3', '2020-02-20 16:16:34', '3', '2020-02-20 18:24:30');
INSERT INTO `pd_auth_menu` VALUES ('681133179561574689', '客户管理', '1', '\0', '/ofpay/customer', 'pinda/ofpay/customer/Index', '', '3', '', '', '676762150244450433', '3', '2020-02-23 13:40:05', '3', '2020-03-01 18:31:12');

-- ----------------------------
-- Table structure for `pd_auth_resource`
-- ----------------------------
DROP TABLE IF EXISTS `pd_auth_resource`;
CREATE TABLE `pd_auth_resource` (
  `id` bigint(20) NOT NULL COMMENT 'ID',
  `code` varchar(150) DEFAULT '' COMMENT '资源编码\n规则：\n链接：\n数据列：\n按钮：',
  `name` varchar(150) NOT NULL DEFAULT '' COMMENT '接口名称',
  `menu_id` bigint(20) DEFAULT NULL COMMENT '菜单ID\n#c_auth_menu',
  `method` varchar(10) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `describe_` varchar(255) DEFAULT '' COMMENT '接口描述',
  `create_user` bigint(20) DEFAULT NULL COMMENT '创建人id',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_user` bigint(20) DEFAULT NULL COMMENT '更新人id',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `UN_CODE` (`code`) USING BTREE COMMENT '编码唯一'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='资源';

-- ----------------------------
-- Records of pd_auth_resource
-- ----------------------------
INSERT INTO `pd_auth_resource` VALUES ('643444685339100193', 'org:add', '添加', '603982542332235201', 'POST', '/org', '', '3', '2019-11-11 13:39:28', '3', '2019-11-11 13:39:50');
INSERT INTO `pd_auth_resource` VALUES ('643444685339100194', 'role:config', '配置', '603981723864141121', 'POST', '/role/authority', '', '3', '2019-11-11 13:39:28', '3', '2020-03-03 19:57:51');
INSERT INTO `pd_auth_resource` VALUES ('643444685339100195', 'resource:add', '添加', '603976297063910529', 'POST', '/resource', '', '3', '2019-11-11 13:39:28', '3', '2019-11-11 13:39:50');
INSERT INTO `pd_auth_resource` VALUES ('643444685339100196', 'resource:update', '修改', '603976297063910529', 'PUT', '/resource', '', '3', '2019-11-11 13:39:28', '3', '2019-11-11 13:39:50');
INSERT INTO `pd_auth_resource` VALUES ('643444685339100197', 'resource:delete', '删除', '603976297063910529', 'DELETE', '/resource', '', '3', '2019-11-11 13:39:28', '3', '2019-11-11 13:39:50');
INSERT INTO `pd_auth_resource` VALUES ('643444819758154945', 'org:update', '修改', '603982542332235201', 'PUT', '/org', '', '3', '2019-11-11 13:40:00', '3', '2019-11-11 13:40:00');
INSERT INTO `pd_auth_resource` VALUES ('643444858974897441', 'org:delete', '删除', '603982542332235201', 'DELETE', '/org', '', '3', '2019-11-11 13:40:09', '3', '2019-11-11 13:40:09');
INSERT INTO `pd_auth_resource` VALUES ('643444897201784193', 'org:view', '查询', '603982542332235201', 'GET', '/org/tree', '', '3', '2019-11-11 13:40:18', '3', '2020-03-03 19:53:41');
INSERT INTO `pd_auth_resource` VALUES ('643444992357959137', 'org:import', '导入', '603982542332235201', 'POST', '/org', '', '3', '2019-11-11 13:40:41', '3', '2019-11-11 13:40:41');
INSERT INTO `pd_auth_resource` VALUES ('643445016773002817', 'org:export', '导出', '603982542332235201', 'GET', '/org', '', '3', '2019-11-11 13:40:47', '3', '2019-11-11 13:40:47');
INSERT INTO `pd_auth_resource` VALUES ('643445116756821697', 'station:add', '添加', '603982713849908801', 'POST', '/station', '', '3', '2019-11-11 13:41:11', '3', '2019-11-11 13:41:11');
INSERT INTO `pd_auth_resource` VALUES ('643445162915137313', 'station:update', '修改', '603982713849908801', 'PUT', '/station', '', '3', '2019-11-11 13:41:22', '3', '2019-11-11 13:41:22');
INSERT INTO `pd_auth_resource` VALUES ('643445197954353025', 'station:delete', '删除', '603982713849908801', 'DELETE', '/station', '', '3', '2019-11-11 13:41:30', '3', '2019-11-11 13:41:30');
INSERT INTO `pd_auth_resource` VALUES ('643445229575210977', 'station:view', '查看', '603982713849908801', 'GET', '/station/page', '', '3', '2019-11-11 13:41:38', '3', '2020-03-03 19:54:12');
INSERT INTO `pd_auth_resource` VALUES ('643445262110427201', 'station:export', '导出', '603982713849908801', 'GET', '/station', '', '3', '2019-11-11 13:41:45', '3', '2019-11-11 13:41:45');
INSERT INTO `pd_auth_resource` VALUES ('643445283996305569', 'station:import', '导入', '603982713849908801', 'POST', '/station', '', '3', '2019-11-11 13:41:51', '3', '2019-11-11 13:41:51');
INSERT INTO `pd_auth_resource` VALUES ('643445352703199521', 'user:add', '添加', '603983082961243905', 'POST', '/user', '', '3', '2019-11-11 13:42:07', '3', '2019-11-11 13:42:07');
INSERT INTO `pd_auth_resource` VALUES ('643445412774021505', 'user:update', '修改', '603983082961243905', 'PUT', '/user', '', '3', '2019-11-11 13:42:21', '3', '2019-11-11 13:42:21');
INSERT INTO `pd_auth_resource` VALUES ('643445448081672673', 'user:delete', '删除', '603983082961243905', 'DELETE', '/user', '', '3', '2019-11-11 13:42:30', '3', '2019-11-11 13:42:30');
INSERT INTO `pd_auth_resource` VALUES ('643445477274028609', 'user:view', '查看', '603983082961243905', 'GET', '/user/page', '', '3', '2019-11-11 13:42:37', '3', '2020-03-03 19:54:41');
INSERT INTO `pd_auth_resource` VALUES ('643445514607528609', 'user:import', '导入', '603983082961243905', 'POST', '/user', '', '3', '2019-11-11 13:42:46', '3', '2019-11-11 13:42:46');
INSERT INTO `pd_auth_resource` VALUES ('643445542076025601', 'user:export', '导出', '603983082961243905', 'GET', '/user', '', '3', '2019-11-11 13:42:52', '3', '2019-11-11 13:42:52');
INSERT INTO `pd_auth_resource` VALUES ('643445641149680705', 'menu:add', '添加', '603976297063910529', 'POST', '/menu', '', '3', '2019-11-11 13:43:16', '3', '2019-11-11 13:43:16');
INSERT INTO `pd_auth_resource` VALUES ('643445674330819745', 'menu:update', '修改', '603976297063910529', 'PUT', '/menu', '', '3', '2019-11-11 13:43:24', '3', '2019-11-11 13:43:24');
INSERT INTO `pd_auth_resource` VALUES ('643445704177487105', 'menu:delete', '删除', '603976297063910529', 'DELETE', '/menu', '', '3', '2019-11-11 13:43:31', '3', '2019-11-11 13:43:31');
INSERT INTO `pd_auth_resource` VALUES ('643445747320098145', 'menu:view', '查看', '603976297063910529', 'GET', '/menu/tree', '', '3', '2019-11-11 13:43:41', '3', '2020-03-03 19:55:10');
INSERT INTO `pd_auth_resource` VALUES ('643445774687931841', 'menu:export', '导出', '603976297063910529', 'GET', '/menu', '', '3', '2019-11-11 13:43:48', '3', '2019-11-11 13:43:48');
INSERT INTO `pd_auth_resource` VALUES ('643445802106097185', 'menu:import', '导入', '603976297063910529', 'POST', '/menu', '', '3', '2019-11-11 13:43:54', '3', '2019-11-11 13:43:54');
INSERT INTO `pd_auth_resource` VALUES ('643448338154263521', 'role:add', '添加', '603981723864141121', 'POST', '/role', '', '3', '2019-11-11 13:53:59', '3', '2019-11-11 13:53:59');
INSERT INTO `pd_auth_resource` VALUES ('643448369779315777', 'role:update', '修改', '603981723864141121', 'PUT', '/role', '', '3', '2019-11-11 13:54:06', '3', '2019-11-11 13:54:06');
INSERT INTO `pd_auth_resource` VALUES ('643448507767723169', 'role:delete', '删除', '603981723864141121', 'DELETE', '/role', '', '3', '2019-11-11 13:54:39', '3', '2019-11-11 13:54:39');
INSERT INTO `pd_auth_resource` VALUES ('643448611161511169', 'role:view', '查看', '603981723864141121', 'GET', '/role/page', '', '3', '2019-11-11 13:55:04', '3', '2020-03-03 19:55:44');
INSERT INTO `pd_auth_resource` VALUES ('643448656451605857', 'role:export', '导出', '603981723864141121', 'GET', '/role', '', '3', '2019-11-11 13:55:15', '3', '2019-11-11 13:55:15');
INSERT INTO `pd_auth_resource` VALUES ('643448730950833601', 'role:import', '导入', '603981723864141121', 'POST', '/role', '', '3', '2019-11-11 13:55:32', '3', '2019-11-11 13:55:32');
INSERT INTO `pd_auth_resource` VALUES ('643448826945869409', 'role:auth', '授权', '603981723864141121', 'POST', '/role/user', '', '3', '2019-11-11 13:55:55', '3', '2020-03-03 19:57:57');
INSERT INTO `pd_auth_resource` VALUES ('643450770317909249', 'optLog:view', '查看', '605078672772170209', 'GET', '/optLog', '', '3', '2019-11-11 14:03:39', '3', '2019-11-11 14:03:39');
INSERT INTO `pd_auth_resource` VALUES ('643450853134441825', 'optLog:export', '导出', '605078672772170209', 'GET', '/optLog', '', '3', '2019-11-11 14:03:58', '3', '2019-11-11 14:03:58');
INSERT INTO `pd_auth_resource` VALUES ('645288214990422241', 'optLog:delete', '删除', '605078672772170209', 'DELETE', '/optLog', '', '3', '2019-11-16 15:45:00', '3', '2019-11-16 15:45:00');
INSERT INTO `pd_auth_resource` VALUES ('645288283693121889', 'loginLog:delete', '删除', '645215230518909025', 'DELETE', '/loginLog', '', '3', '2019-11-16 15:45:16', '3', '2019-11-16 15:45:16');
INSERT INTO `pd_auth_resource` VALUES ('645288375300915649', 'loginLog:export', '导出', '645215230518909025', 'GET', '/loginLog', '', '3', '2019-11-16 15:45:38', '3', '2019-11-16 15:45:38');
INSERT INTO `pd_auth_resource` VALUES ('667033832750318369', 'file:add', '添加', '667033750256747169', 'POST', '/file', '', '3', '2020-01-15 15:54:19', '3', '2020-01-15 15:54:19');
INSERT INTO `pd_auth_resource` VALUES ('667033888949797761', 'file:update', '修改', '667033750256747169', 'PUT', '/file', '', '3', '2020-01-15 15:54:32', '3', '2020-01-15 15:54:32');
INSERT INTO `pd_auth_resource` VALUES ('667033951713362913', 'file:delete', '删除', '667033750256747169', 'DELETE', '/file', '', '3', '2020-01-15 15:54:47', '3', '2020-01-15 15:54:47');
INSERT INTO `pd_auth_resource` VALUES ('667034024379679809', 'file:view', '查看', '667033750256747169', 'GET', '/file', '', '3', '2020-01-15 15:55:05', '3', '2020-01-15 15:55:05');
INSERT INTO `pd_auth_resource` VALUES ('676763119808152449', 'receive:view', '查看', '676762509503365569', 'GET', '/receiveRecord/page', '', '3', '2020-02-11 12:15:02', '3', '2020-03-03 23:29:14');
INSERT INTO `pd_auth_resource` VALUES ('676763196182234113', 'send:view', '查看', '676762719185011233', 'GET', '/sendRecord/page', '', '3', '2020-02-11 12:15:20', '3', '2020-03-03 23:29:03');
INSERT INTO `pd_auth_resource` VALUES ('684536767625301441', 'rule:config-view', '配置-查看', '603981723864141121', 'GET', '/role/authority/*', '', '3', '2020-03-03 23:04:44', '3', '2020-03-03 23:26:26');
INSERT INTO `pd_auth_resource` VALUES ('684539815017848257', 'resource:view', '查看', '603976297063910529', 'GET', '/resource/page', '', '3', '2020-03-03 23:16:50', '3', '2020-03-03 23:16:50');

-- ----------------------------
-- Table structure for `pd_auth_role`
-- ----------------------------
DROP TABLE IF EXISTS `pd_auth_role`;
CREATE TABLE `pd_auth_role` (
  `id` bigint(20) NOT NULL,
  `name` varchar(30) NOT NULL DEFAULT '' COMMENT '角色名称',
  `code` varchar(20) DEFAULT '' COMMENT '角色编码',
  `describe_` varchar(100) DEFAULT '' COMMENT '功能描述',
  `status` bit(1) DEFAULT b'1' COMMENT '状态',
  `readonly` bit(1) DEFAULT b'0' COMMENT '是否内置角色',
  `create_user` bigint(20) DEFAULT '0' COMMENT '创建人id',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_user` bigint(20) DEFAULT '0' COMMENT '更新人id',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `UN_CODE` (`code`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='角色';

-- ----------------------------
-- Records of pd_auth_role
-- ----------------------------
INSERT INTO `pd_auth_role` VALUES ('100', '平台管理员', 'PT_ADMIN', '平台内置管理员', '', '', '1', '2019-10-25 13:46:00', '3', '2020-03-03 21:19:27');
INSERT INTO `pd_auth_role` VALUES ('643779012732130273', '普通员工', 'BASE_USER', '只有最基本的权限', '', '\0', '3', '2019-11-12 11:47:58', '3', '2019-11-16 09:47:11');
INSERT INTO `pd_auth_role` VALUES ('645198153556958497', '部门经理', 'DEPT_MANAGER', '管理本级以及子级用户', '', '\0', '3', '2019-11-16 09:47:07', '3', '2020-03-19 13:30:25');

-- ----------------------------
-- Table structure for `pd_auth_role_authority`
-- ----------------------------
DROP TABLE IF EXISTS `pd_auth_role_authority`;
CREATE TABLE `pd_auth_role_authority` (
  `id` bigint(20) NOT NULL COMMENT '主键',
  `authority_id` bigint(20) NOT NULL COMMENT '权限id\n#c_auth_resource\n#c_auth_menu',
  `authority_type` varchar(10) NOT NULL DEFAULT 'MENU' COMMENT '权限类型\n#AuthorizeType{MENU:菜单;RESOURCE:资源;}',
  `role_id` bigint(20) NOT NULL COMMENT '角色id\n#c_auth_role',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `create_user` bigint(20) DEFAULT '0' COMMENT '创建人',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `IDX_KEY` (`role_id`,`authority_type`,`authority_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='角色的资源';

-- ----------------------------
-- Records of pd_auth_role_authority
-- ----------------------------
INSERT INTO `pd_auth_role_authority` VALUES ('646807586212951009', '643444685339100193', 'RESOURCE', '646807483838377697', '2019-11-20 20:22:26', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('646807586229728257', '101', 'MENU', '646807483838377697', '2019-11-20 20:22:26', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('646807586229728289', '643464272629728001', 'MENU', '646807483838377697', '2019-11-20 20:22:26', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('646807586229728321', '643464953478514081', 'MENU', '646807483838377697', '2019-11-20 20:22:26', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('646807586229728353', '643464392888812545', 'MENU', '646807483838377697', '2019-11-20 20:22:26', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('646807586233922689', '603982542332235201', 'MENU', '646807483838377697', '2019-11-20 20:22:26', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('648840524161089921', '605080648767505601', 'MENU', '645198153556958497', '2019-11-26 11:00:36', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('648840524186255777', '605080107379327969', 'MENU', '645198153556958497', '2019-11-26 11:00:36', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('648840524190450113', '101', 'MENU', '645198153556958497', '2019-11-26 11:00:36', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('648840524190450145', '605080359394083937', 'MENU', '645198153556958497', '2019-11-26 11:00:36', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('648840524190450177', '102', 'MENU', '645198153556958497', '2019-11-26 11:00:36', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('648840524194644513', '103', 'MENU', '645198153556958497', '2019-11-26 11:00:36', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('648840524198838849', '603983082961243905', 'MENU', '645198153556958497', '2019-11-26 11:00:36', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('648840524198838881', '105', 'MENU', '645198153556958497', '2019-11-26 11:00:36', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('648840524203033217', '106', 'MENU', '645198153556958497', '2019-11-26 11:00:36', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('648840524203033249', '107', 'MENU', '645198153556958497', '2019-11-26 11:00:36', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('648840524203033281', '605078463069552993', 'MENU', '645198153556958497', '2019-11-26 11:00:36', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('648840524207227617', '603981723864141121', 'MENU', '645198153556958497', '2019-11-26 11:00:36', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('648840524207227649', '605078371293987105', 'MENU', '645198153556958497', '2019-11-26 11:00:36', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('648840524207227681', '605079751035454305', 'MENU', '645198153556958497', '2019-11-26 11:00:36', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('648840524207227713', '605080023753294753', 'MENU', '645198153556958497', '2019-11-26 11:00:36', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('648840524211422049', '603976297063910529', 'MENU', '645198153556958497', '2019-11-26 11:00:36', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('690284625204871937', '643445116756821697', 'RESOURCE', '100', '2020-03-19 19:44:40', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('690284625213260577', '643444685339100197', 'RESOURCE', '100', '2020-03-19 19:44:40', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('690284625217454913', '643445802106097185', 'RESOURCE', '100', '2020-03-19 19:44:40', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('690284625217454945', '643448826945869409', 'RESOURCE', '100', '2020-03-19 19:44:40', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('690284625221649281', '643444685339100196', 'RESOURCE', '100', '2020-03-19 19:44:40', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('690284625225843617', '643444685339100193', 'RESOURCE', '100', '2020-03-19 19:44:40', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('690284625225843649', '643445514607528609', 'RESOURCE', '100', '2020-03-19 19:44:40', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('690284625225843681', '643444685339100195', 'RESOURCE', '100', '2020-03-19 19:44:40', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('690284625225843713', '643444685339100194', 'RESOURCE', '100', '2020-03-19 19:44:40', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('690284625230038049', '667033888949797761', 'RESOURCE', '100', '2020-03-19 19:44:40', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('690284625230038081', '643448507767723169', 'RESOURCE', '100', '2020-03-19 19:44:40', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('690284625230038113', '643445197954353025', 'RESOURCE', '100', '2020-03-19 19:44:40', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('690284625230038145', '645288283693121889', 'RESOURCE', '100', '2020-03-19 19:44:40', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('690284625234232481', '643444897201784193', 'RESOURCE', '100', '2020-03-19 19:44:40', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('690284625234232513', '667034094479082657', 'RESOURCE', '100', '2020-03-19 19:44:40', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('690284625234232545', '643448730950833601', 'RESOURCE', '100', '2020-03-19 19:44:40', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('690284625238426881', '667033832750318369', 'RESOURCE', '100', '2020-03-19 19:44:40', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('690284625238426913', '643445412774021505', 'RESOURCE', '100', '2020-03-19 19:44:40', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('690284625242621249', '643445262110427201', 'RESOURCE', '100', '2020-03-19 19:44:40', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('690284625242621281', '643448656451605857', 'RESOURCE', '100', '2020-03-19 19:44:40', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('690284625246815617', '643450853134441825', 'RESOURCE', '100', '2020-03-19 19:44:40', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('690284625246815649', '643445774687931841', 'RESOURCE', '100', '2020-03-19 19:44:40', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('690284625246815681', '667034024379679809', 'RESOURCE', '100', '2020-03-19 19:44:40', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('690284625246815713', '684539815017848257', 'RESOURCE', '100', '2020-03-19 19:44:40', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('690284625251010049', '643445477274028609', 'RESOURCE', '100', '2020-03-19 19:44:40', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('690284625251010081', '684536767625301441', 'RESOURCE', '100', '2020-03-19 19:44:40', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('690284625255204417', '643445352703199521', 'RESOURCE', '100', '2020-03-19 19:44:40', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('690284625255204449', '643445747320098145', 'RESOURCE', '100', '2020-03-19 19:44:40', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('690284625259398785', '643445016773002817', 'RESOURCE', '100', '2020-03-19 19:44:40', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('690284625259398817', '643445162915137313', 'RESOURCE', '100', '2020-03-19 19:44:40', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('690284625259398849', '643444858974897441', 'RESOURCE', '100', '2020-03-19 19:44:40', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('690284625263593185', '643450770317909249', 'RESOURCE', '100', '2020-03-19 19:44:40', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('690284625263593217', '643444992357959137', 'RESOURCE', '100', '2020-03-19 19:44:40', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('690284625263593249', '643445229575210977', 'RESOURCE', '100', '2020-03-19 19:44:40', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('690284625263593281', '643445641149680705', 'RESOURCE', '100', '2020-03-19 19:44:40', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('690284625263593313', '643444819758154945', 'RESOURCE', '100', '2020-03-19 19:44:40', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('690284625267787649', '643448369779315777', 'RESOURCE', '100', '2020-03-19 19:44:40', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('690284625267787681', '643448338154263521', 'RESOURCE', '100', '2020-03-19 19:44:40', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('690284625267787713', '643445704177487105', 'RESOURCE', '100', '2020-03-19 19:44:40', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('690284625267787745', '676763119808152449', 'RESOURCE', '100', '2020-03-19 19:44:40', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('690284625267787777', '643445283996305569', 'RESOURCE', '100', '2020-03-19 19:44:40', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('690284625271982113', '643445674330819745', 'RESOURCE', '100', '2020-03-19 19:44:40', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('690284625271982145', '643445542076025601', 'RESOURCE', '100', '2020-03-19 19:44:40', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('690284625271982177', '645288214990422241', 'RESOURCE', '100', '2020-03-19 19:44:40', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('690284625271982209', '645288375300915649', 'RESOURCE', '100', '2020-03-19 19:44:40', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('690284625276176545', '676763196182234113', 'RESOURCE', '100', '2020-03-19 19:44:40', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('690284625276176577', '643445448081672673', 'RESOURCE', '100', '2020-03-19 19:44:40', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('690284625276176609', '643448611161511169', 'RESOURCE', '100', '2020-03-19 19:44:40', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('690284625276176641', '667033951713362913', 'RESOURCE', '100', '2020-03-19 19:44:40', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('690284625280370977', '645215230518909025', 'MENU', '100', '2020-03-19 19:44:40', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('690284625280371009', '605079411338773153', 'MENU', '100', '2020-03-19 19:44:40', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('690284625280371041', '603983082961243905', 'MENU', '100', '2020-03-19 19:44:40', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('690284625280371073', '667033750256747169', 'MENU', '100', '2020-03-19 19:44:40', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('690284625280371105', '603982542332235201', 'MENU', '100', '2020-03-19 19:44:40', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('690284625284565441', '603981723864141121', 'MENU', '100', '2020-03-19 19:44:40', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('690284625284565473', '676762509503365569', 'MENU', '100', '2020-03-19 19:44:40', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('690284625284565505', '681133179561574689', 'MENU', '100', '2020-03-19 19:44:40', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('690284625284565537', '605079239015793249', 'MENU', '100', '2020-03-19 19:44:40', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('690284625288759873', '605078672772170209', 'MENU', '100', '2020-03-19 19:44:40', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('690284625288759905', '603976297063910529', 'MENU', '100', '2020-03-19 19:44:40', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('690284625288759937', '676762719185011233', 'MENU', '100', '2020-03-19 19:44:40', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('690284625288759969', '680085395794296897', 'MENU', '100', '2020-03-19 19:44:40', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('690284625288760001', '605078979149300257', 'MENU', '100', '2020-03-19 19:44:40', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('690284625292954337', '101', 'MENU', '100', '2020-03-19 19:44:40', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('690284625292954369', '104', 'MENU', '100', '2020-03-19 19:44:40', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('690284625292954401', '676762150244450433', 'MENU', '100', '2020-03-19 19:44:40', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('690284625292954433', '603982713849908801', 'MENU', '100', '2020-03-19 19:44:40', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('690609420521966817', '643445116756821697', 'RESOURCE', '643779012732130273', '2020-03-20 17:15:17', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('690609420526161153', '643445262110427201', 'RESOURCE', '643779012732130273', '2020-03-20 17:15:17', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('690609420526161185', '643444992357959137', 'RESOURCE', '643779012732130273', '2020-03-20 17:15:17', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('690609420530355521', '643444685339100193', 'RESOURCE', '643779012732130273', '2020-03-20 17:15:17', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('690609420530355553', '643444897201784193', 'RESOURCE', '643779012732130273', '2020-03-20 17:15:17', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('690609420530355585', '643445016773002817', 'RESOURCE', '643779012732130273', '2020-03-20 17:15:17', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('690609420534549921', '643445229575210977', 'RESOURCE', '643779012732130273', '2020-03-20 17:15:17', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('690609420534549953', '643444819758154945', 'RESOURCE', '643779012732130273', '2020-03-20 17:15:17', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('690609420534549985', '643445162915137313', 'RESOURCE', '643779012732130273', '2020-03-20 17:15:17', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('690609420534550017', '643445283996305569', 'RESOURCE', '643779012732130273', '2020-03-20 17:15:17', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('690609420534550049', '603982713849908801', 'MENU', '643779012732130273', '2020-03-20 17:15:17', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('690609420538744385', '101', 'MENU', '643779012732130273', '2020-03-20 17:15:17', '3');
INSERT INTO `pd_auth_role_authority` VALUES ('690609420538744417', '603982542332235201', 'MENU', '643779012732130273', '2020-03-20 17:15:17', '3');

-- ----------------------------
-- Table structure for `pd_auth_role_org`
-- ----------------------------
DROP TABLE IF EXISTS `pd_auth_role_org`;
CREATE TABLE `pd_auth_role_org` (
  `id` bigint(20) NOT NULL COMMENT 'ID',
  `role_id` bigint(20) DEFAULT NULL COMMENT '角色ID\n#c_auth_role',
  `org_id` bigint(20) DEFAULT NULL COMMENT '部门ID\n#c_core_org',
  `create_time` datetime DEFAULT NULL,
  `create_user` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='角色组织关系';

-- ----------------------------
-- Records of pd_auth_role_org
-- ----------------------------
INSERT INTO `pd_auth_role_org` VALUES ('684510274555769057', '100', '100', '2020-03-03 21:19:27', '3');
INSERT INTO `pd_auth_role_org` VALUES ('684510274564157697', '100', '101', '2020-03-03 21:19:27', '3');
INSERT INTO `pd_auth_role_org` VALUES ('684510274564157729', '100', '102', '2020-03-03 21:19:27', '3');
INSERT INTO `pd_auth_role_org` VALUES ('684510274564157761', '100', '643775612976106881', '2020-03-03 21:19:27', '3');
INSERT INTO `pd_auth_role_org` VALUES ('684510274564157793', '100', '643775664683486689', '2020-03-03 21:19:27', '3');
INSERT INTO `pd_auth_role_org` VALUES ('684510274564157825', '100', '643775904077582049', '2020-03-03 21:19:27', '3');
INSERT INTO `pd_auth_role_org` VALUES ('684510274564157857', '100', '643776324342648929', '2020-03-03 21:19:27', '3');
INSERT INTO `pd_auth_role_org` VALUES ('684510274564157889', '100', '643776407691858113', '2020-03-03 21:19:27', '3');
INSERT INTO `pd_auth_role_org` VALUES ('684510274564157921', '100', '643776508795556193', '2020-03-03 21:19:27', '3');
INSERT INTO `pd_auth_role_org` VALUES ('684510274568352257', '100', '643776594376135105', '2020-03-03 21:19:27', '3');
INSERT INTO `pd_auth_role_org` VALUES ('684510274568352289', '100', '643776633823564321', '2020-03-03 21:19:27', '3');
INSERT INTO `pd_auth_role_org` VALUES ('684510274568352321', '100', '643776668917305985', '2020-03-03 21:19:27', '3');
INSERT INTO `pd_auth_role_org` VALUES ('684510274568352353', '100', '643776713909605089', '2020-03-03 21:19:27', '3');
INSERT INTO `pd_auth_role_org` VALUES ('684510274568352385', '100', '643776757199016769', '2020-03-03 21:19:27', '3');
INSERT INTO `pd_auth_role_org` VALUES ('684510274568352417', '100', '684470048693160353', '2020-03-03 21:19:27', '3');
INSERT INTO `pd_auth_role_org` VALUES ('690190442947420673', '645198153556958497', '100', '2020-03-19 13:30:25', '3');
INSERT INTO `pd_auth_role_org` VALUES ('690190442951615009', '645198153556958497', '101', '2020-03-19 13:30:25', '3');
INSERT INTO `pd_auth_role_org` VALUES ('690190442951615041', '645198153556958497', '643775612976106881', '2020-03-19 13:30:25', '3');
INSERT INTO `pd_auth_role_org` VALUES ('690190442951615073', '645198153556958497', '643776594376135105', '2020-03-19 13:30:25', '3');
INSERT INTO `pd_auth_role_org` VALUES ('690190442951615105', '645198153556958497', '643776633823564321', '2020-03-19 13:30:25', '3');
INSERT INTO `pd_auth_role_org` VALUES ('690190442951615137', '645198153556958497', '102', '2020-03-19 13:30:25', '3');
INSERT INTO `pd_auth_role_org` VALUES ('690190442955809473', '645198153556958497', '643776668917305985', '2020-03-19 13:30:25', '3');
INSERT INTO `pd_auth_role_org` VALUES ('690190442955809505', '645198153556958497', '643776713909605089', '2020-03-19 13:30:25', '3');
INSERT INTO `pd_auth_role_org` VALUES ('690190442955809537', '645198153556958497', '643776757199016769', '2020-03-19 13:30:25', '3');
INSERT INTO `pd_auth_role_org` VALUES ('690190442955809569', '645198153556958497', '643775904077582049', '2020-03-19 13:30:25', '3');
INSERT INTO `pd_auth_role_org` VALUES ('690190442955809601', '645198153556958497', '643775664683486689', '2020-03-19 13:30:25', '3');
INSERT INTO `pd_auth_role_org` VALUES ('690190442955809633', '645198153556958497', '643776324342648929', '2020-03-19 13:30:25', '3');
INSERT INTO `pd_auth_role_org` VALUES ('690190442955809665', '645198153556958497', '643776407691858113', '2020-03-19 13:30:25', '3');
INSERT INTO `pd_auth_role_org` VALUES ('690190442955809697', '645198153556958497', '643776508795556193', '2020-03-19 13:30:25', '3');

-- ----------------------------
-- Table structure for `pd_auth_user`
-- ----------------------------
DROP TABLE IF EXISTS `pd_auth_user`;
CREATE TABLE `pd_auth_user` (
  `id` bigint(20) NOT NULL COMMENT 'ID',
  `account` varchar(30) NOT NULL COMMENT '账号',
  `name` varchar(50) NOT NULL COMMENT '姓名',
  `org_id` bigint(20) DEFAULT NULL COMMENT '组织ID\n#c_core_org',
  `station_id` bigint(20) DEFAULT NULL COMMENT '岗位ID\n#c_core_station',
  `email` varchar(255) DEFAULT NULL COMMENT '邮箱',
  `mobile` varchar(20) DEFAULT '' COMMENT '手机',
  `sex` varchar(1) DEFAULT 'N' COMMENT '性别\n#Sex{W:女;M:男;N:未知}',
  `status` bit(1) DEFAULT b'0' COMMENT '启用状态 1启用 0禁用',
  `avatar` varchar(255) DEFAULT '' COMMENT '头像',
  `work_describe` varchar(255) DEFAULT '' COMMENT '工作描述\r\n比如：  市长、管理员、局长等等   用于登陆展示',
  `password_error_last_time` datetime DEFAULT NULL COMMENT '最后一次输错密码时间',
  `password_error_num` int(11) DEFAULT '0' COMMENT '密码错误次数',
  `password_expire_time` datetime DEFAULT NULL COMMENT '密码过期时间',
  `password` varchar(64) NOT NULL DEFAULT '' COMMENT '密码',
  `last_login_time` datetime DEFAULT NULL COMMENT '最后登录时间',
  `create_user` bigint(20) DEFAULT '0' COMMENT '创建人id',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_user` bigint(20) DEFAULT '0' COMMENT '更新人id',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `UN_ACCOUNT` (`account`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='用户';

-- ----------------------------
-- Records of pd_auth_user
-- ----------------------------
INSERT INTO `pd_auth_user` VALUES ('3', 'pinda', '平台管理员', '100', '100', '', '', 'M', '', 'BiazfanxmamNRoxxVxka.png', '超级管理员', '2020-03-21 18:48:51', '0', null, 'cea87ef1cb2e47570020bf7c014e1074', '2020-03-21 18:48:53', '1', '2019-09-02 11:32:02', '3', '2020-01-15 15:39:59');
INSERT INTO `pd_auth_user` VALUES ('641577229343523041', 'test', '赵六', '102', '100', '', '', 'M', '', 'BiazfanxmamNRoxxVxka.png', '', '2020-03-18 13:55:15', '0', null, 'cea87ef1cb2e47570020bf7c014e1074', '2020-03-18 13:55:26', '3', '2019-11-06 09:58:56', '3', '2020-01-10 16:32:11');
INSERT INTO `pd_auth_user` VALUES ('641590096981656001', 'manong', '李四', '101', '645199319300842081', '', '', 'M', '', 'BiazfanxmamNRoxxVxka.png', '122', '2020-03-21 18:49:20', '0', null, 'cea87ef1cb2e47570020bf7c014e1074', '2020-03-21 18:49:21', '3', '2019-11-06 10:50:01', '3', '2020-03-01 13:22:08');
INSERT INTO `pd_auth_user` VALUES ('648841103860041025', '11111', '王五', '643776668917305985', '645200885772724545', '', '', 'M', '', 'BiazfanxmamNRoxxVxka.png', '', null, '0', null, 'cea87ef1cb2e47570020bf7c014e1074', null, '3', '2019-11-26 11:02:54', '3', '2020-02-06 13:20:46');
INSERT INTO `pd_auth_user` VALUES ('683356335357559137', 'test1', '测试', null, null, '', '', 'W', '', 'BiazfanxmamNRoxxVxka.png', '', '2020-02-29 16:55:10', '0', null, 'cea87ef1cb2e47570020bf7c014e1074', '2020-02-29 16:55:10', '3', '2020-02-29 16:54:07', '3', '2020-03-01 19:12:06');

-- ----------------------------
-- Table structure for `pd_auth_user_role`
-- ----------------------------
DROP TABLE IF EXISTS `pd_auth_user_role`;
CREATE TABLE `pd_auth_user_role` (
  `id` bigint(20) NOT NULL,
  `role_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '角色ID\n#c_auth_role',
  `user_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '用户ID\n#c_core_accou',
  `create_user` bigint(20) DEFAULT NULL COMMENT '创建人ID',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `IDX_KEY` (`role_id`,`user_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='角色分配\r\n账号角色绑定';

-- ----------------------------
-- Records of pd_auth_user_role
-- ----------------------------
INSERT INTO `pd_auth_user_role` VALUES ('646807547461776193', '646807483838377697', '641590096981656001', '3', '2019-11-20 20:22:17');
INSERT INTO `pd_auth_user_role` VALUES ('647449120218284897', '647449059488957153', '641577229343523041', '641577229343523041', '2019-11-22 14:51:39');
INSERT INTO `pd_auth_user_role` VALUES ('683356538315735681', '645198153556958497', '641577229343523041', '3', '2020-02-29 16:54:55');
INSERT INTO `pd_auth_user_role` VALUES ('683356538332512929', '645198153556958497', '683356335357559137', '3', '2020-02-29 16:54:55');
INSERT INTO `pd_auth_user_role` VALUES ('689124069395663201', '100', '3', '3', '2020-03-16 14:53:02');
INSERT INTO `pd_auth_user_role` VALUES ('690652179203096993', '643779012732130273', '641590096981656001', '3', '2020-03-20 20:05:11');
INSERT INTO `pd_auth_user_role` VALUES ('690652179211485633', '643779012732130273', '641577229343523041', '3', '2020-03-20 20:05:11');

-- ----------------------------
-- Table structure for `pd_common_login_log`
-- ----------------------------
DROP TABLE IF EXISTS `pd_common_login_log`;
CREATE TABLE `pd_common_login_log` (
  `id` bigint(20) NOT NULL COMMENT '主键',
  `request_ip` varchar(50) DEFAULT '' COMMENT '操作IP',
  `user_id` bigint(20) DEFAULT NULL COMMENT '登录人ID',
  `user_name` varchar(50) DEFAULT NULL COMMENT '登录人姓名',
  `account` varchar(30) DEFAULT '' COMMENT '登录人账号',
  `description` varchar(255) DEFAULT '' COMMENT '登录描述',
  `login_date` date DEFAULT NULL COMMENT '登录时间',
  `ua` varchar(500) DEFAULT '0' COMMENT '浏览器请求头',
  `browser` varchar(100) DEFAULT NULL COMMENT '浏览器名称',
  `browser_version` varchar(255) DEFAULT NULL COMMENT '浏览器版本',
  `operating_system` varchar(100) DEFAULT NULL COMMENT '操作系统',
  `location` varchar(50) DEFAULT '' COMMENT '登录地点',
  `create_time` datetime DEFAULT NULL,
  `create_user` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `IDX_BROWSER` (`browser`) USING BTREE,
  KEY `IDX_OPERATING` (`operating_system`) USING BTREE,
  KEY `IDX_LOGIN_DATE` (`login_date`,`account`) USING BTREE,
  KEY `IDX_ACCOUNT_IP` (`account`,`request_ip`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='登录日志';

-- ----------------------------
-- Records of pd_common_login_log
-- ----------------------------

-- ----------------------------
-- Table structure for `pd_common_opt_log`
-- ----------------------------
DROP TABLE IF EXISTS `pd_common_opt_log`;
CREATE TABLE `pd_common_opt_log` (
  `id` bigint(20) NOT NULL COMMENT '主键',
  `request_ip` varchar(50) DEFAULT '' COMMENT '操作IP',
  `type` varchar(5) DEFAULT 'OPT' COMMENT '日志类型\n#LogType{OPT:操作类型;EX:异常类型}',
  `user_name` varchar(50) DEFAULT '' COMMENT '操作人',
  `description` varchar(255) DEFAULT '' COMMENT '操作描述',
  `class_path` varchar(255) DEFAULT '' COMMENT '类路径',
  `action_method` varchar(50) DEFAULT '' COMMENT '请求方法',
  `request_uri` varchar(50) DEFAULT '' COMMENT '请求地址',
  `http_method` varchar(10) DEFAULT 'GET' COMMENT '请求类型\n#HttpMethod{GET:GET请求;POST:POST请求;PUT:PUT请求;DELETE:DELETE请求;PATCH:PATCH请求;TRACE:TRACE请求;HEAD:HEAD请求;OPTIONS:OPTIONS请求;}',
  `params` longtext COMMENT '请求参数',
  `result` longtext COMMENT '返回值',
  `ex_desc` longtext COMMENT '异常详情信息',
  `ex_detail` longtext COMMENT '异常描述',
  `start_time` timestamp NULL DEFAULT NULL COMMENT '开始时间',
  `finish_time` timestamp NULL DEFAULT NULL COMMENT '完成时间',
  `consuming_time` bigint(20) DEFAULT '0' COMMENT '消耗时间',
  `ua` varchar(500) DEFAULT '' COMMENT '浏览器',
  `create_time` datetime DEFAULT NULL,
  `create_user` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `index_type` (`type`) USING BTREE COMMENT '日志类型'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='系统日志';

-- ----------------------------
-- Records of pd_common_opt_log
-- ----------------------------

-- ----------------------------
-- Table structure for `pd_core_org`
-- ----------------------------
DROP TABLE IF EXISTS `pd_core_org`;
CREATE TABLE `pd_core_org` (
  `id` bigint(20) NOT NULL COMMENT 'ID',
  `name` varchar(255) NOT NULL DEFAULT '' COMMENT '名称',
  `abbreviation` varchar(255) DEFAULT '' COMMENT '简称',
  `parent_id` bigint(20) DEFAULT '0' COMMENT '父ID',
  `tree_path` varchar(255) DEFAULT ',' COMMENT '树结构',
  `sort_value` int(11) DEFAULT '1' COMMENT '排序',
  `status` bit(1) DEFAULT b'1' COMMENT '状态',
  `describe_` varchar(255) DEFAULT '' COMMENT '描述',
  `create_time` datetime DEFAULT NULL,
  `create_user` bigint(20) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `update_user` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  FULLTEXT KEY `FU_PATH` (`tree_path`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='组织';

-- ----------------------------
-- Records of pd_core_org
-- ----------------------------
INSERT INTO `pd_core_org` VALUES ('100', '品达物流集团有限公司', '品达集团', '0', ',', '1', '', '总公司', '2019-07-10 17:02:18', '1', '2020-02-20 20:57:11', '3');
INSERT INTO `pd_core_org` VALUES ('101', '品达上海分公司', '上海品达', '100', ',100,', '0', '', '上海分公司', '2019-08-06 09:10:53', '1', '2020-01-10 06:23:32', '3');
INSERT INTO `pd_core_org` VALUES ('102', '品达北京分公司', '品达北京', '100', ',100,', '1', '', '北京分公司', '2019-11-07 16:13:09', '1', '2020-01-10 06:23:48', '3');
INSERT INTO `pd_core_org` VALUES ('643775612976106881', '综合部', '综合部', '101', ',100,101,', '0', '', '前台&HR', '2019-11-12 11:34:27', '3', '2020-03-01 18:25:34', '3');
INSERT INTO `pd_core_org` VALUES ('643775664683486689', '管理层', '', '100', ',100,', '3', '', '', '2019-11-12 11:34:39', '3', '2019-11-12 11:36:16', '3');
INSERT INTO `pd_core_org` VALUES ('643775904077582049', '总经办', '', '100', ',100,', '2', '', '', '2019-11-12 11:35:37', '3', '2019-11-12 11:36:52', '3');
INSERT INTO `pd_core_org` VALUES ('643776324342648929', '财务部', '', '100', ',100,', '4', '', '', '2019-11-12 11:37:17', '3', '2019-11-12 11:37:40', '3');
INSERT INTO `pd_core_org` VALUES ('643776407691858113', '市场部', '', '100', ',100,', '5', '', '', '2019-11-12 11:37:37', '3', '2019-11-12 11:37:37', '3');
INSERT INTO `pd_core_org` VALUES ('643776508795556193', '销售部', '', '100', ',100,', '6', '', '', '2019-11-12 11:38:01', '3', '2019-11-12 11:38:01', '3');
INSERT INTO `pd_core_org` VALUES ('643776594376135105', '研发部', '', '101', ',100,101,', '1', '', 'java/html', '2019-11-12 11:38:21', '3', '2020-03-01 18:25:57', '3');
INSERT INTO `pd_core_org` VALUES ('643776633823564321', '产品部', '', '101', ',100,101,', '2', '', '', '2019-11-12 11:38:31', '3', '2019-11-12 11:38:31', '3');
INSERT INTO `pd_core_org` VALUES ('643776668917305985', '综合部', '', '102', ',100,102,', '0', '', '', '2019-11-12 11:38:39', '3', '2019-11-12 11:38:39', '3');
INSERT INTO `pd_core_org` VALUES ('643776713909605089', '研发部', '', '102', ',100,102,', '0', '', '', '2019-11-12 11:38:50', '3', '2019-11-12 11:38:50', '3');
INSERT INTO `pd_core_org` VALUES ('643776757199016769', '销售部', '', '102', ',100,102,', '2', '', '', '2019-11-12 11:39:00', '3', '2019-11-12 11:39:00', '3');

-- ----------------------------
-- Table structure for `pd_core_station`
-- ----------------------------
DROP TABLE IF EXISTS `pd_core_station`;
CREATE TABLE `pd_core_station` (
  `id` bigint(20) NOT NULL COMMENT 'ID',
  `name` varchar(255) NOT NULL DEFAULT '' COMMENT '名称',
  `org_id` bigint(20) DEFAULT '0' COMMENT '组织ID\n#c_core_org',
  `status` bit(1) DEFAULT b'1' COMMENT '状态',
  `describe_` varchar(255) DEFAULT '' COMMENT '描述',
  `create_time` datetime DEFAULT NULL,
  `create_user` bigint(20) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `update_user` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='岗位';

-- ----------------------------
-- Records of pd_core_station
-- ----------------------------
INSERT INTO `pd_core_station` VALUES ('100', '总经理', '643775904077582049', '', '总部-1把手', '2019-07-10 17:03:03', '1', '2019-11-16 09:59:17', '3');
INSERT INTO `pd_core_station` VALUES ('101', '副总经理', '643775904077582049', '', '总部-2把手', '2019-07-22 17:07:55', '1', '2019-11-16 09:59:21', '3');
INSERT INTO `pd_core_station` VALUES ('642032719487828225', '研发经理', '643776594376135105', '', '子公司-研发部老大', '2019-11-07 16:08:49', '3', '2019-11-16 09:53:42', '3');
INSERT INTO `pd_core_station` VALUES ('645199319300842081', '副总经理', '101', '', '子公司-老大', '2019-11-16 09:51:45', '3', '2019-11-16 09:53:50', '3');
INSERT INTO `pd_core_station` VALUES ('645199745026892801', '产品经理', '643776633823564321', '', '子公司-产品部老大', '2019-11-16 09:53:27', '3', '2019-11-16 09:54:01', '3');
INSERT INTO `pd_core_station` VALUES ('645200064280536545', '人事经理', '643775612976106881', '', '子公司-综合老大', '2019-11-16 09:54:43', '3', '2019-11-16 09:54:43', '3');
INSERT INTO `pd_core_station` VALUES ('645200151886964289', 'Java工程师', '643776594376135105', '', '普通员工', '2019-11-16 09:55:04', '3', '2019-11-16 09:55:04', '3');
INSERT INTO `pd_core_station` VALUES ('645200250243393185', '需求工程师', '643776633823564321', '', '普通员工', '2019-11-16 09:55:27', '3', '2019-11-16 09:55:27', '3');
INSERT INTO `pd_core_station` VALUES ('645200304014370561', 'UI工程师', '643776633823564321', '', '普通员工', '2019-11-16 09:55:40', '3', '2019-11-16 09:55:40', '3');
INSERT INTO `pd_core_station` VALUES ('645200358959753057', '运维工程师', '643776594376135105', '', '普通员工', '2019-11-16 09:55:53', '3', '2019-11-16 09:55:53', '3');
INSERT INTO `pd_core_station` VALUES ('645200405453612993', '前台小姐姐', '643775612976106881', '', '普通员工', '2019-11-16 09:56:04', '3', '2019-11-16 09:56:04', '3');
INSERT INTO `pd_core_station` VALUES ('645200545698555937', '人事经理', '643776668917305985', '', '北京分公司-综合部老大', '2019-11-16 09:56:38', '3', '2019-11-16 09:56:38', '3');
INSERT INTO `pd_core_station` VALUES ('645200670781089921', '研发经理', '643776713909605089', '', '北京分公司-研发部老大', '2019-11-16 09:57:07', '3', '2019-11-16 09:57:07', '3');
INSERT INTO `pd_core_station` VALUES ('645200806559099105', '销售经理', '643776757199016769', '', '北京销售部老大', '2019-11-16 09:57:40', '3', '2019-11-16 09:57:40', '3');
INSERT INTO `pd_core_station` VALUES ('645200885772724545', '行政', '643776668917305985', '', '普通员工', '2019-11-16 09:57:59', '3', '2019-11-16 09:57:59', '3');
INSERT INTO `pd_core_station` VALUES ('645200938289605025', '大前端工程师', '643776713909605089', '', '普通员工', '2019-11-16 09:58:11', '3', '2019-11-16 09:58:11', '3');
INSERT INTO `pd_core_station` VALUES ('645201064705927681', '销售员工', '643776757199016769', '', '普通员工', '2019-11-16 09:58:41', '3', '2019-11-16 09:58:41', '3');
INSERT INTO `pd_core_station` VALUES ('645201184268757601', '销售总监', '643775664683486689', '', '总部2把手', '2019-11-16 09:59:10', '3', '2019-11-16 09:59:10', '3');
INSERT INTO `pd_core_station` VALUES ('645201307765844833', '财务总监', '643776324342648929', '', '总部2把手', '2019-11-16 09:59:39', '3', '2019-11-16 09:59:39', '3');
INSERT INTO `pd_core_station` VALUES ('645201405757369281', '市场经理', '643776407691858113', '', '总部市场部老大', '2019-11-16 10:00:03', '3', '2019-11-16 10:00:03', '3');
INSERT INTO `pd_core_station` VALUES ('645201481133206561', '销售总监', '643776508795556193', '', '总部销售部老大', '2019-11-16 10:00:21', '3', '2019-11-16 10:00:21', '3');
INSERT INTO `pd_core_station` VALUES ('645201573391117441', '前端工程师', '643776594376135105', '', '普通员工', '2019-11-16 10:00:43', '3', '2020-03-01 19:11:58', '3');

导入实体类

前面我们已经介绍了通用权限系统中涉及到的数据表，一般在开发过程中我们会创建和数据表对应的实体类来封装相关信息。在课程资料中已经提供了相关实体类Entity和相关DTO，直接复制到pd-auth-entity工程中即可。

认证和鉴权流程

品达通用权限系统对外提供的功能中认证和鉴权是其核心功能，通过导入的初始工程可以发现其中有两个服务，即网关服务和权限服务。其中用户认证需要在权限服务中完成，鉴权需要在网关服务中完成。在实现认证和鉴权之前我们必须明确认证和鉴权的整体执行流程。

认证流程

1、用户通过前端系统发送登录请求，请求中携带账号、密码、验证码等信息。

2、前端登录请求首先请求到网关服务，网关服务将请求路由到权限微服务。

3、权限微服务进行认证操作，如果认证通过则生成jwt token返回给前端，同时将用户拥有的资源权限使用userId作为key保存到缓存中。

注：缓存中保存的用户资源权限是由pd_auth_resource资源表中的method和url两个字段的值拼接成的。例如，某个用户拥有删除日志的权限，在表中删除日志权限对应一条数据，其中method的值为DELETE，url的值为/optLog，那么缓存中保存的用户拥有的资源权限为：DELETE/optLog。

鉴权流程

1、用户认证后访问其他功能时将jwt token放在请求头中，首先经过网关服务处理。

2、在网关服务的过滤器中获取请求头中的token并进行解析，将解析出的用户相关数据放在zuul的header中。

注：之所以要将用户相关数据放在zuul的header中，是因为在后续的网关AccessFilter过滤器和权限服务中都会使用到这些数据。

3、在网关服务的过滤器中进行鉴权相关处理。

归去来兮★

关注

0
点赞
踩
1

收藏

觉得还不错? 一键收藏
0
评论
复制链接

分享到 QQ

分享到新浪微博

扫一扫

专栏目录