I'm trying to find the best way for a basic security system for a website. I know I want users and groups.
I thought I'd have:
user_table
user_id
user_name
...
group_type
group_id
group_name
parent_id
...
group_table
id
user_id
group_id
First one is the user, second one is the group, and the third one is the intermediary table that connects the two. One user has many groups.
Does this sound ok?
GROUP_TYPE
table should be namedGROUP
or something similar, and yourGROUP_TABLE
should reference both Users and Groups, as that's what it's linking.SELECT
and a fieldFROM
so you can have a query likeSELECT [FROM] FROM [SELECT]