权限管理模型（数据库建模）

create table FunCategory
(
 CategoryId int identity(1,1) primary key not null,
 CategoryName varchar(30),
 Sort int default(0),
 CategoryImg varchar(50)
)
go

create table Fun
(
 FunId int identity(1000,1) primary key not null,
 CategoryId int foreign key references FunCategory(CategoryId),
 FunName varchar(30) unique,
 Url varchar(50),
 Sort int default(0),
 FunImg varchar(50)
)
go

create table [Role]
(
 RoleId int identity(200,1) primary key not null,
 RoleName varchar(30)
)
go

create table [User]
(
 UserId int identity(1,1) primary key not null,
 UserName varchar(30) unique,
 UserPwd varchar(30),
 RoleId int foreign key references [Role](RoleId),
 Email varchar(36),
 ProfileInfo varchar(100)
)
go

create table Privilege
(
 PrivilegeId int identity(500,1) primary key not null,
 RoleId int foreign key references [Role](RoleId),
 FunId int foreign key references Fun(FunId),
 ReadPrivilege bit default(0),
 AddPrivilege bit default(0),
 ChangePrivilege bit default(0),
 DeletePrivilege bit default(0)
)
go