October 3rd, 2013, 03:13 AM
where to store friend relationship
Originally Posted by requinix
if when one user have ping for friend request then database have store one record
a_id u_id f_id status
1 1 3 pending
2 3 2 success
when f_id based user accept then pending convert to "success" now as per database 1 is 3 friend status is success, that means both are friend.
my question is if both are friend then where show store in normal database, for SQL query check.
Last edited by requinix; October 3rd, 2013 at 03:50 AM.
Reason: split from http://forums.devshed.com/database-management-46/question-on-facebook-s-database-structure-790884.html
October 3rd, 2013, 06:44 AM
you could leave it right there
Originally Posted by amarbhanu