Database Design Question
- by Soo
Ok SO, I have a user table and want to define groups of users together.  The best solution I have for this is to create three database tables as follows:
UserTable
user_id
user_name
UserGroupLink
group_id
member_id
GroupInfo
group_id
group_name
This method keeps the member and group information separate.  This is just my way of thinking.  Is there a better way to do this?  Also, what is a good naming convention for tables that link two other tables?