social-networking

Database design - Friend activities

Hi, Currently I am designing a small twitter/facebook kind of system, where in a user should be able to see his friends latest activities. I am using ASP.NET with MySQL database. My Friendships table is as follows: |Friendshipid|friend1|Friend2|confirmed| Friend1 and Friend2 in the above table are userids. User activities table ...

Frinds table for a social network website

Hello, Now i am working on a social network website and i already built the friends table for this website but i need some suggesion before i moved forward. I have a user table where user_id is the primary field. So for frinds i made a friends table with fields like friend1,friend2,is_active what i do actually when user1 send a frie...