new table to handle requests to join and/or add people to groups.
this table might also handle setting parent_groups to child and for general social networking requests.
anything two users have to mutually agree on should go in here.
request table schema
request_user_id
response_user_id
group_id (to keep the scope of the request)
req_id (add to group / added to group / request parent / all that stuff)
res_id (user's response to said request (i.e. deny, accept))
new table to handle requests to join and/or add people to groups.
this table might also handle setting parent_groups to child and for general social networking requests.
anything two users have to mutually agree on should go in here.
request table schema
request_user_id response_user_id group_id (to keep the scope of the request) req_id (add to group / added to group / request parent / all that stuff) res_id (user's response to said request (i.e. deny, accept))