Now that I have created Member Profiles, and they are viewable by others, I want the ability for a Member to be able to add other Members to their "Friends List".
There will be a need for the person receiving the "Friend Request" to accept the request before a link is established. Also, both the "requestor" and "requestee" need a way to sever the "friendship" if they so choose.
Anyways, I could use some help setting up my Tables, Fields, and Relationships!!
Here is what I have come up with so far, but I'm really not sure how to do things...
One and only one USER (requestor) may have zero or more FRIENDS
One and only one USER (requestee) may have zero or more FRIENDS
user (requestor) -||-----0<- friend ->0------||- user (requestee)
Basically I am trying to mimic what a lot of other Forums - including SitePoint - offer their membership.
Comments and suggestions welcome.