基于角色的权限访问控制数据库设计- cychai的专栏- CSDN博客(4)

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