go
declare @CurrentUser sysname select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description', '客户',
'user', @CurrentUser, 'table', 'customer' go
/*==============================================================*/
/* Table: employee */
/*==============================================================*/ create table employee (
employeeID int not null, employeeName varchar(64) null, sex int null, age int null, Department varchar(64) null, constraint PK_EMPLOYEE primary key (employeeID) ) go
declare @CurrentUser sysname select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description', '员工',
'user', @CurrentUser, 'table', 'employee' go
/*==============================================================*/
/* Table: guest */
/*==============================================================*/ create table guest (
guestID int not null, guestName nvarchar(64) null, constraint PK_GUEST primary key (guestID) ) go
declare @CurrentUser sysname select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description', '访客',
'user', @CurrentUser, 'table', 'guest' go
/*==============================================================*/
/* Table: role */
/*==============================================================*/ create table role (
roleID int not null, roleName varchar(64) null, constraint PK_ROLE primary key (roleID) ) go
/*==============================================================*/
/* Table: \ */
/*==============================================================*/ create table \
ID int not null,
Name varchar(20) null, Password varchar(20) null, constraint PK_USER primary key (ID) ) go
declare @CurrentUser sysname select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description', '用户数据表',
'user', @CurrentUser, 'table', 'user' go
/*==============================================================*/
/* Table: userRole */
/*==============================================================*/ create table userRole (
userID int not null, roleID int not null, constraint PK_USERROLE primary key (userID, roleID) )
go
declare @CurrentUser sysname select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description', '用户角色关系表',
'user', @CurrentUser, 'table', 'userRole' go
alter table RolePermission add constraint
FK_ROLEPERM_FK_PERMIS_PERMISSI foreign key (permissionID)
references Permission (ID) go
alter table RolePermission
add constraint FK_ROLEPERM_FK_ROLE_R_ROLE foreign key (roleID)
references role (roleID) go
alter table customer
add constraint FK_CUSTOMER_FK_USER_I_USER foreign key (customerID) references \
go
alter table employee
add constraint FK_EMPLOYEE_FK_USER_I_USER foreign key (employeeID) references \go
alter table guest
add constraint FK_GUEST_FK_USER_I_USER foreign key (guestID)
references \go
alter table userRole
add constraint FK_USERROLE_FK_ROLE_R_ROLE foreign key (roleID)
references role (roleID) go
alter table userRole
add constraint FK_USERROLE_FK_USER_I_USER foreign key (userID) references \go