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?