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 relationship for member to member
contacts.
TABLES:
USER:
emailID (PK)
userName
Password
Address
Etc
FRIEND:
emailID (PK)
friendEmailID (PK)
RELATIONSHIPS:
USER.emailID (1) --- FRIEND.emailID (many)
USER.emailID (many) --- FRIEND.friendEmailID (1)
Does this work or is this a cyclical many-to-many relationship? (1 User can
have many friends, 1 friend can belong to many users)... If so, what's the
correct (normalized) way of representing this?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
