04-20-2019, 10:40 AM
(04-20-2019, 10:36 AM)Nuelnike Wrote: Hello Everyone,
am nuelnike and am very very new to userspice actually I stumbled on it on my quest for a secured, flexible, and easy php framework. but I really want to know how MySQL tables are connected using user spice DB function.
example: I have a table named projects, which is related to table 'categories' by 'id' and also related to table 'users' by userid so am wondering how possible it is to connect the tables all together so that when I list all data in table 'projects' all projects displayed will have a category name and an ownername attached to it.
We basically do the same thing...connect ids usually on another table. I think the best way to see this in actions is to look at the users table (id) and the permissions table(id) and then go look at user_permission_matches and you will see it is just a 3rd table that links the ids of the first two. As you add/remove permissions (and level) those tables are modified.