Database has a users table with user_id as key, and a groups table with a composite key of group_id and user_id where either key can be repeated but the combination of the two is unique.