sql表设计.sql

来自「我的一个Ado.Net一个框架设计」· SQL 代码 · 共 53 行

select * from dbo.EEmployee
exec EMenuTree 'admin'
select  *  from EMenu order by ChildNode
create table EMenu----菜单表
(
RowId int identity(1,1) primary key not null,
ChildNode varchar(200) not null,
ParentNode varchar(200),
NodeName varchar(50) not null,
NodeUrl varchar(50),
Target varchar(20),
Memo varchar(100),
NodeImage varchar(50)--菜单图片地址
)
create unique index I_EMenu_ChildNode on EMenu(ChildNode)
----------------------------------------
create table EPageRight
(
RowId int identity(1,1) not null,
Account Account references EEmployee(Account) not null,
PagePath varchar(200),
Inserts bit default 0,
Deletes bit default 0,
Updates bit default 0,
Selects bit default 0
)
create index I_EPageRight_RowId on EPageRight(RowId)
create index I_EPageRight_Account on EPageRight(Account)
create index I_EPageRight_PagePath on EPageRight(PagePath)
----------------------------------------------------------
create table EEmployeeChange
(
RowId int identity(1,1) primary key not null,
Account Account references EEmployee(Account) not null,
Company varchar(70) not null,
Department varchar(90) not null,
IsInOut bit default 0 not null,--0正常在公司，1调入公司，2出差，3调出公司，4辞职
Mobile varchar(20) check(len(Mobile)=11),
CompanyPhone varchar(20),
Station varchar(50),--岗位
Duty varchar(50),--职务,职责
WordAdress varchar(200),
Province varchar(50),
City varchar(50),
DutyName varchar(50),--职称
SchoolAge varchar(20),
PolityDegree varchar(20),
ForeignType varchar(20),
LanguageLevel int,
RecortDate datetime,
CreateDate datetime
)
create unique index I_EEmployeeChange_Account on EEmployeeChange(Account)