Linking "Friends" with the account holders profile

Question

I am designing an application where an account holder has "friends". How would I go about linking those friends to the original account holder? Would an efficient SQL table be something like:

AccountHolderID (varChar 20)
FriendsID (nText)

Answer 1

We implement something similar--using a table to hold the friends... Ours breaks down quite simply as a table of friends...

AccountHolderId( type)
FriendAccountHolderId ( type)
Created(datetime)  // useful for tracking when the friend was added

Both of the Id fields link back to the Accounts/Users table.