I'm trying to create a Secret Santa application. The basic entities
are users, groups, relationships, and suggestions. (If User1 has a
relationship with User2, then User1 will not be assigned to be Secret
Santa for User2).
I'm trying to figure out how to model this so that I can leverage
The users table contains: id, full_name, email, username, password
The groups table contains: id, group_name, group_password
The relationships table contains: user1id, user2id, group_id
The suggestions table contains: user_id, group_id, suggestion
The users_groups table contais: user_id, group_id, assigned_pick
I'm a bit confused as how to model the relationship between the users,
relationships, and groups table.
Also, the group_id is a foreign key in almost every table. Am I missing
Any feedback is greatly appreciated!