2022年SQL权限数据库基础库设计讲课讲稿

1、SQL 权 限 数 据 库 基 础 库 设 计 与 Eas y UI 相 关 精品资料create database QxDB go use QxDB -模块create table ModuleInfo Id int primary key, Name varchar20, Sort int ; insert into ModuleInfo values800,教务治理 ,800 insert into ModuleInfo values900,同学治理 ,900 -功能create table FunctionInfo Id int primary key, Name varchar20,

2、 Sort int, Url varchar30, ModuleId int foreign key references ModuleInfoId ; insert into FunctionInfo values800100,信息治理 ,100,/Home/Index,800 insert into FunctionInfo values900100,成果治理 ,100,/Home/Grade,900 -操作create table ActionInfo Id int primary key, Name varchar20, Icon varchar20, Method varchar20

3、, Sort int, 仅供学习与沟通,如有侵权请联系网站删除 感谢2 精品资料FunctionId int foreign key references FunctionInfoId, ; 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,8

4、00100 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 int

5、o ActionInfo values 90010040,删除,icon-delete,deleteFun,40,900100 -角色create table RoleInfo Id int primary key, Name varchar20, Sort int ; insert into RoleInfo values100,系统治理员 ,10 insert into RoleInfo values200,一般治理员 ,20 -角色对应的权限create table RoleDetailInfo Id int identity primary key, RoleId int foreig

6、n key references RoleInfoId, ActionId int foreign key references ActionInfoId, ; insert into RoleDetailInfo values 100,80010010 insert into RoleDetailInfo values 100,80010020 insert into RoleDetailInfo values 100,80010030 -用户仅供学习与沟通,如有侵权请联系网站删除 感谢3 精品资料create table UserInfo Id int primary key, Name

7、varchar20, Sort int ; insert into UserInfo values 100,张三,10 -用户对应的角色create table UserDetailInfo Id int identity primary key, UserId int foreign key references UserInfoId, RoleId int foreign key references RoleInfoId, ; insert into UserDetailInfo values100,200 -字典信息表 DictionaryInfo create table Dicti

8、onaryInfo Id int primary key , Name varchar50 not null, Category int not null ; -静态字典create table StaticDictionary Id int primary key, Name varchar50 not null, DictionaryId int, Sort int, ; -基础字典create table CommonDictionary Id int primary key, Name varchar50 not null, DictionaryId int, 仅供学习与沟通,如有侵权

9、请联系网站删除 感谢4 精品资料Sort int, ; -Grid 配置项表create table GridInfo Id int primary key, Name varchar30, AutoRowHeight int, FitColumns int, Striped int, Method varchar30, NowRap int, IdField varchar30, Url varchar30, LoadMsg varchar50, pagination int, RowNumbers int, SingleSelect int, CheckOnSelect int, SelectOnCheck int, PagePosition var