how to make a facebook-like social network

Question

I started since a while making a new social network using ASP.NET with C# just like facebook and I found that it doesn't make sense to make something already exist . but i don't care :D I'll make it any way and I need to your opinions about the database design for the news feed, friends and comments !!

News Feed
SenderId - ReceiverId - Text - ImgUrl - OtherUrl - Date_ - LastUpdate - Id(EventId)PK

Friends
SenderId - ReceiverId - State - Id PK

Comments
EventId - Text - UserId - Id PK

does this design appropriate or could be better !!
in the other side if there is any ideas for a social network i'll be so appreciated ..
thanx a lot :)

Answer 1

This question has no right answer, its a bit a strange question.

For what is the LastUpdate? You have a Date already.

For what is the ReceiverId in the newsfeed?

I think you could add groups, so one can group its friends accordingly and give the group the appropriate rights (same as on facebook). that would make your simple db_schema a little more interresting.