I have always wondered how Facebook designed the friend <-> user relation.
I figure the user table is something like this:
I figure the table with user's data (sex, age etc connected via user email I would assume).
How does it connect all the friends to this user?
Something like this?
Probably not. Because the number of users is unknown and will expand.