User – friends tables creation
795482Oct 26 2010 — edited Oct 29 2010I 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