2022年SQL權(quán)限數(shù)據(jù)庫基礎(chǔ)庫設(shè)計(jì)講課講稿

1、SQL 權(quán) 限 數(shù) 據(jù) 庫 基 礎(chǔ) 庫 設(shè) 計(jì) 與 Eas y UI 相 關(guān) 精品資料create database QxDB go use QxDB -模塊create table ModuleInfo Id int primary key, Name varchar20, Sort int ; insert into ModuleInfo values800,教務(wù)治理 ,800 insert into ModuleInfo values900,同學(xué)治理 ,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, 僅供學(xué)習(xí)與溝通,如有侵權(quán)請聯(lián)系網(wǎng)站刪除 感謝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,系統(tǒng)治理員 ,10 insert into RoleInfo values200,一般治理員 ,20 -角色對應(yīng)的權(quán)限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 -用戶僅供學(xué)習(xí)與溝通,如有侵權(quán)請聯(lián)系網(wǎng)站刪除 感謝3 精品資料create table UserInfo Id int primary key, Name

7、varchar20, Sort int ; insert into UserInfo values 100,張三,10 -用戶對應(yīng)的角色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 ; -靜態(tài)字典create table StaticDictionary Id int primary key, Name varchar50 not null, DictionaryId int, Sort int, ; -基礎(chǔ)字典create table CommonDictionary Id int primary key, Name varchar50 not null, DictionaryId int, 僅供學(xué)習(xí)與溝通,如有侵權(quán)

9、請聯(lián)系網(wǎng)站刪除 感謝4 精品資料Sort int, ; -Grid 配置項(xiàng)表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