表1.users
字段:userid ,password ,role表2.role
字段:roleid ,name ,resc表3.resc
字段:rescid ,name ,rescString表4.userrole
字段:urid ,userid ,roleid表5.roleresc
字段:rrid , roleid , rescid建表代码不用上传,只看设置主键和外键步骤!
字段:userid ,password ,role表2.role
字段:roleid ,name ,resc表3.resc
字段:rescid ,name ,rescString表4.userrole
字段:urid ,userid ,roleid表5.roleresc
字段:rrid , roleid , rescid建表代码不用上传,只看设置主键和外键步骤!
--仅供参考
表1.users
字段:userid primary key,password ,role表2.role
字段:roleid primary key,name ,resc表3.resc
字段:rescid primary key,name ,rescString表4.userrole
字段:urid primary key,userid references users(userid),roleid references role(roleid)表5.roleresc
字段:rrid primary key, roleid references role(roleid), rescid references resc(rescid)
alter table t add constraint tfk foreign key (testid) references t(testid);