Right now I'm working on a module for relationships between users and blogs (for a blog can have plenty users!).
I've started programming an hour ago thus no visible demo yet but I'd like to put my ideas here to find out if someone has a better solution for it. Should save me some time afterwards ;-)
possible relations:
A->B
and B->A
where A and B can be either a blog or user. It is a directed graph thus the relationship A->B can differ from B->A.
I'd like to organzise the types of relationships in a different table for two reasons:
extendable, saves db space in very large communites and translateable because I want to add a language flag (CHAR(5) e.g. 'de-de' or 'de-at' if you want to discuss that detail).
Of course the relationships will have a short and long (desciption) text.
Data will come through the individual user profiles and for blogs via the blog options.
New thread about conrete look will come tomorrow, save your thoughts until then.