Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
hs_jha
Starting Member
2 Posts |
 Posted - 2009-12-15 : 03:20:29
|
| Hi friends and geeks ,I am trying to design a database (MS Sql) for social networking portal..The problem i am stuck at is how to design a Friends Connections table..The table will keep all the users accepted friends...The way you see in orkut or facebook scenario...What field actually is required in this table beside FriendsUserIDWhat happens when a user is accepted as friend and now i want to remove from my list...All data of FriendUserID is deleted or some bit field (True/False) controls it... |
|
|
RyanRandall
Master Smack Fu Yak Hacker
1074 Posts |
Posted - 2009-12-15 : 06:21:21
|
| These might be of use: http://dbdesign-sn.blogspot.com/http://www.techcrunch.com/2007/07/24/9-ways-to-build-your-own-social-network/Ryan Randall - Yak of all tradesSolutions are easy. Understanding the problem, now, that's the hard part. |
 |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2009-12-21 : 09:34:15
|
| You can also try to look for the keywords "expanding networks" here on this site and the web...this thread should give you some insight on how to build your network:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=89323- Lumbagohttp://xkcd.com/327/ |
|
|
|
|
|
|
Design of Social network connections table