Usually, you'd have 3 tables: USER, FRIEND, and a third table named
something like USER_FRIEND. They'd be set up like:
USER:
emailID (PK)
userName
Password
Address
Etc
FRIEND:
emailID (PK)
USER_FRIEND
user_emailID (PK)
friend_emailID (PK)
Hello,
I'm having conceptualizing the correct relationship for what seems a very
simple scenario:
Scenario:
I have a standard "USERS" table...
USERS have a list of "FRIENDS", these can be other members or also non
members... Similar to facebook...
My main issue is conceptualizing the relations
