User relationships

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

DW Relationship Table

		User X
		Subscribe	Access	Both	Neither
User Y	Subscribe	XSYS Mutual subscriptions; X and Y subscribe to each other, but don't give each other access.	XAYS X lets Y access their stuff, and Y subscribes to X , but X doesn't subscribe to Y.	XBYS X gives access to and subscribes to Y, but Y only subscribes to X and does not give them access.	XNYS Y subscribes to X , but X doesn't subscribe or give access to Y.
	Access	XSYA Y gives access to X and X subscribes to Y, but Y doesn't subscribe to X .	XAYA Mutual access; X and Y give each other access, but neither subscribes to the other.	XBYA X subscribes to Y and gives them access, but Y only gives access to Y and doesn't subscribe.	XNYA Y gives X access, but X does not subscribe or give access to Y.
	Both	XSYB Y gives access to and subscribes to X , but X only subscribes to Y and does not give them access.	XAYB Y subscribes to X and gives them access, but X only gives access to Y and doesn't subscribe.	XBYB The equivalent of "friending" on LJ--X and Y both subscribe and give each other access.	XNYB Y both subscribes and gives access to X , but X doesn't subscribe or give access to Y.
	Neither	XSYN X subscribes to Y, but Y doesn't subscribe or give access to X .	XAYN X gives Y access, but X does not subscribe or give access to Y.	XBYN X both subscribes and gives access to Y, but Y doesn't subscribe or give access to Y.	XNYN X and Y have no direct connections.

LJ Relationship Table

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

		User X
		Friend	Not Friend
User Y	Friend	XFYF X and Y have friended each other.	XNYF Y is friends with X, but X is not friends with Y.
	Not Friend	XFYN X is friends with Y, but X is not friends with Y.	XNYN X and Y have no direct connections.