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

Popular posts from this blog

ios - Adding an SKSpriteNode to SKScene from a child SKSpriteNode -

Matlab transpose a table vector -

c# - Textbox not clickable but editable -