SQL权限数据库基础库设计(与EasyUI相关)

create database QxDB go use QxDB 模块 create table ModuleInfo Id int primary key Name varchar 20 Sort int insert into ModuleInfo values 800 教务管理 800 insert into ModuleInfo values 900 学生管理 900 功能 create table FunctionInfo Id int primary key Name varchar 20 Sort int Url varchar 30 ModuleId int foreign key references ModuleInfo Id insert into FunctionInfo values 800100 信息管理 100 Home Index 800 insert into FunctionInfo values 900100 成绩管理 100 Home Grade 900 操作 create table ActionInfo Id int primary key Name varchar 20 Icon varchar 20 Method varchar 20 Sort int FunctionId int foreign key references FunctionInfo Id insert into ActionInfo values 80010010 查询 icon search saveFun 10 800100 insert into ActionInfo values 80010020 新增 icon add addFun 20 800100 insert into ActionInfo values 80010030 编辑 icon edit editFun 30 800100 insert into ActionInfo values 80010040 删除 icon delete deleteFun 40 800100 insert into ActionInfo values 90010010 查询 icon search saveFun 10 900100 insert into ActionInfo values 90010020 新增 icon add addFun 20 900100 insert into ActionInfo values 90010030 编辑 icon edit editFun 30 900100 insert into ActionInfo values 90010040 删除 icon delete deleteFun 40 900100 角色 create table RoleInfo Id int primary key Name varchar 20 Sort int insert into RoleInfo values 100 系统管理员 10 insert into RoleInfo values 200 普通管理员 20 角色对应的权限 create table RoleDetailInfo Id int identity primary key RoleId int foreign key references RoleInfo Id ActionId int foreign key references ActionInfo Id insert into RoleDetailInfo values 100 80010010 insert into RoleDetailInfo values 100 80010020 insert into RoleDetailInfo values 100 80010030 用户 create table UserInfo Id int primary key Name varchar 20 Sort int insert into UserInfo values 100 张三 10 用户对应的角色 create table UserDetailInfo Id int identity primary key UserId int foreign key references UserInfo Id RoleId int foreign key references RoleInfo Id insert into UserDetailInfo values 100 200 字典信息表 DictionaryInfo create table DictionaryInfo Id int primary key Name varchar 50 not null Category int not null 静态字典 create table StaticDictionary Id int primary key Name varchar 50 not null DictionaryId int Sort int 基础字典 create table CommonDictionary Id int primary key Name varchar 50 not null DictionaryId int Sort int Grid 配置项表 create table GridInfo Id int primary key Name varchar 30 AutoRowHeight int FitColumns int Striped int Method varchar 30 NowRap int IdField varchar 30 Url varchar 30 LoadMsg varchar 50 pagination int RowNumbers int SingleSelect int CheckOnSelect int SelectOnCheck in