Desining a database question

Hi,

i need store relation between people... (friends, family)

i have a table with list of users.

i need to design a table where i would like to store relation between users. i.e. who are friends of xx etc.

will really appreciate if someone can guide me how to create such table.

Here is how I would set it up:

TUsers
intUserID
strUsername
strPassword
strFirstName
strLastName
strAddressLine1
strAddressLine2
strCity
strState
strZipCode

TUserFriends
intUserID
intFriendID
intUserFriendRelationshipID

TUserFriendRelationShips
intUserFriendRelationshipID
strUserFriendRelationship

|||

thanks a lot,