User relationships

The main user is User A. User B is someone who User A has some kind of relationship to--note that this can include things like User B subscribing to A, but A has nothing to do with them.

DW Relationship Table

		User A
		Subscribe	Access	Both	Neither
User B	Subscribe	1 Mutual subscriptions; A and B subscribe to each other, but don't give each other access.	2 A lets B access their stuff, and B subscribes to A, but A doesn't subscribe to B.	3 A gives access to and subscribes to B, but B only subscribes to A and does not give them access.	N1 B subscribes to A, but A doesn't subscribe or give access to B.
	Access	4 B gives access to A and A subscribes to B, but B doesn't subscribe to A.	5 Mutual access; A and B give each other access, but neither subscribes to the other.	6 A subscribes to B and gives them access, but B only gives access to B and doesn't subscribe.	N2 B gives A access, but A does not subscribe or give access to B.
	Both	7 B gives access to and subscribes to A, but A only subscribes to B and does not give them access.	8 B subscribes to A and gives them access, but A only gives access to B and doesn't subscribe.	9 The equivalent of "friending" on LJ--A and B both subscribe and give each other access.	N3 B both subscribes and gives access to A, but A doesn't subscribe or give access to B.
	Neither	N4 A subscribes to B, but B doesn't subscribe or give access to A.	N5 A gives B access, but A does not subscribe or give access to B.	N6 A both subscribes and gives access to B, but B doesn't subscribe or give access to B.	X A and B have no direct connections.

LJ Relationship Table

This is for comparison--relationships on LJ are much simpler!

		User A
		Friend	Not Friend
User B	Friend	1 A and B have friended each other.	2 B is friends with A, but A is not friends with B.
	Not Friend	3 A is friends with B, but B is not friends with A.	X A and B have no direct connections.