mysql - How to compare query results for multiple tables? -
I have 3 tables, users, AccessControlKey and AccessControlGroup. Users can be assigned multiple products. AccessControlKeys can be assigned to multiple AccessControlGroups, however, the user can not be assigned more than one access control control, i.e. a user has several access control groups assigned to it, the access controller is assigned to the AccessControl group. For many relatives between Accesscontrolkeys and users and accesscontrolkeys and accesscontrolgroups, I have two different tables. I have the following table descriptions for the 3 tables and relationships mapping table. How can I apply unique access controls to more than one access control group for a user?
From your description, I guess each There is a AccessControlKey in
user and the key is multiple
AccessControlGroup s. P> I might change the data structure and change my
User_BelongsTo_AccessControlGroup to
User_AccessControlKey (
user to
AccessControlKey ); You can apply specificity here. You can still go to
User 's
AccessControlGroup s and
AccessControlKey_BelongsTo_AccessControlGroup via this table.
Comments
Post a Comment