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...

Relationships:

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)



Tables:

user (requestor)
--------
- id
- name


friend
--------
- requestee_id
- requestor_id
- requested_on
- approved_on
- declined_on


user (requestee)
--------
- id
- name


Basically I am trying to mimic what a lot of other Forums - including SitePoint - offer their membership.

Comments and suggestions welcome.

Thanks,


Debbie