sqlite - How should I design database tables when I need to refer the same database twice?

Question

In my use case, the business logic is to create a secret friend type of app. The logic should allow the user to create a group of friends. The same friend can be in the different groups.

So I'm thinking that this is a many-to-many relationship case.

In one of my solutions, my idea was to have 3 tables:

friends	groups	friend_pair_groups
id	id	id
name	friend_giver_id	name
phone_number	friend_receiver_id

question from:https://stackoverflow.com/questions/65873277/how-should-i-design-database-tables-when-i-need-to-refer-the-same-database-twice

Answer 1

Waitting for answers