create TABLE sys_dept(
dept_id varchar(64) not null primary key,
dept_name varchar(64) not null,
pid varchar(64) not null
);
create TABLE sys_user(
user_id varchar(64) not null primary key,
username varchar(64) not null,
`password` varchar(64) not null,
dept_id varchar(64) not null
);
create TABLE sys_role(
role_id VARCHAR(64) not null PRIMARY key,
role_name VARCHAR(64) not null
);
create table sys_permission(
per_id VARCHAR(64) not null PRIMARY key,
per_name varchar(64) not null,
per_nation varchar(64) not null
);
create table sys_user_role(
user_id varchar(64) not null,
role_id varchar(64) not null
);
create table sys_role_permission(
role_id varchar(64) not null,
per_id varchar(64) not null
);
create TABLE sys_menu(
menu_id varchar(64) not null primary key,
menu_name varchar(64) not NULL,
url varchar(128) not null,
type TINYINT(1) not null,
icon varchar(32),
pid varchar(64) not null
);
create table sys_role_menu(
role_id varchar(64) not null,
menu_id varchar(64) not null
);
create TABLE sys_menu_per(
menu_id varchar(64) not null,
per_id varchar(64) not null
);
权限设计系统——SQL
最新推荐文章于 2022-04-07 18:22:53 发布