[drupal-devel] Random: Drupal Relationships

[Dries Buytaert]

Morbus Iff wrote:
> In working with taxonomy, I'm now leaning toward the following as a 
> replacement for term_node (I'm using words here for readability, but 
> assume all "id" columns are, in fact, numbers):
> 
>    tid | uid    | type    | id
>   -----------------------------
>   cat  | morbus | image   | 67
>   cat  | moshe  | node    | 17
>   dog  | killes | comment | 129
>   cool | dries  | user    | 1

Difficult to say without proper benchmarking.  I'm sure some relations 
are better captured in separate tables, while for some relations it 
might be beneficial to use a single table.  It all depends on how you 
want to use (query) the data, and how frequent.

Personally, I'd start off with extending taxonomy for folksonomies and 
nothing more.

-- 
Dries Buytaert  ::  http://www.buytaert.net/