how is friendship stored in database - Page 2

healdem · #16 (**permalink**) 01-16-09, 02:36

Quote:

Originally Posted by r937

that's pretty cool

do you remember or did you save the url?

try here

...was tempted to go for this reference instead

freeBatjko · #17 (**permalink**) 01-20-09, 04:38

Quote:

Originally Posted by chiefman

if B refuses the request from A, should the record be removed then?
I found Facebook's database schema from the Internet, and there is a table named FriendRelation. property "AreFriends" should identify the relationship between two people and I guess its type is boolean

That is quite nice... reverse engineered the flickr post says... not bad, although I wonder how accurate this is then.

I don't think the property "AreFriends" would be boolean, or there is another property somewhere, because it would not cover the bi-directional relationship of friendship requests...
In my example before, the record would not be deleted if the request is denied, but the status column would simply be populated with "denied", so that this rejection is saved. I'm sure Facebook can't just use a boolean "are they friends or not" variable.

chiefman · #18 (**permalink**) 01-20-09, 05:21

Quote:

Originally Posted by freeBatjko

That is quite nice... reverse engineered the flickr post says... not bad, although I wonder how accurate this is then.

I don't think the property "AreFriends" would be boolean, or there is another property somewhere, because it would not cover the bi-directional relationship of friendship requests...
In my example before, the record would not be deleted if the request is denied, but the status column would simply be populated with "denied", so that this rejection is saved. I'm sure Facebook can't just use a boolean "are they friends or not" variable.

it makes sense. thanks

Internet Services

Web Development

Digital Marketing

Consumer Tech