Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

User – friends tables creation

795482Oct 26 2010 — edited Oct 29 2010
I want to create a database where i have a users table and i need to implement a friends table where a user can have many other user as friends; so i am think of the friends as a multi-value field so i am going to create a separate table named Friends where the primary key will be the (first user ID & the second user ID) and the first user ID will be the foreign key referring to the user Id field at the users table .
So is there a way to better implement this scenario and does the above scenario have some problems late on ?
Thansk
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 26 2010
Added on Oct 26 2010
20 comments
537 views