Social Network DB Schema

redonkulus · #1 (**permalink**) 12-11-07, 16:09

Hey now,

I 'm looking to add a Friends section to my website, right now I have built the user sign up / management myself and it works great. Now I want my users to be able to make friends with each other.

I was thinking of creating a new table called my_friends but I'm not sure how the table should be setup. Should I just have a column for user_id and then friends_id and thats how the users are associated?

I'm not really sure, does anyone have any tips for me?

-r

gvee · #2 (**permalink**) 12-11-07, 16:38

I reckon your idea sounds fine... But...

If I have you as my friend, does that instantly make me your friend?

Code:

SELECT user_id
     , friend_id
FROM    my_friends
WHERE  <my user id> IN (user_id, friend_id)

If so the above will catch it.
If not simply change the where clause to read

Code:

WHERE  <my user id> = friend_id

mike_bike_kite · #3 (**permalink**) 12-11-07, 18:47

Quote:

Now I want my users to be able to make friends with each other ... Should I just have a column for user_id and then friends_id

If only life was that simple

redonkulus · #4 (**permalink**) 12-12-07, 15:41

Hmm good question. I would think that you ask the person to be your friend and then they accept. Therefore, each person shows up as a friend of the other.

Internet Services

Web Development

Digital Marketing

Consumer Tech