Managing TAGS for many different tables - Design Logic Help

[eluser]gon[/eluser]
Perhaps you need one more table:

A table containing just 1 column: a site-wide ID. Let's call it RESOURCE_ID.

Every table using tags would have its own unique key ID, AND also a column called RESOURCE_ID.

For example, if you have posts and comments, post number 1 could have RESOURCE_ID = 1. Comment number 1 would have RESOURCE_ID = 2.

The trick is assigning the tags to the RESOURCE_ID, not to the unique key ID of the tables.

So there aren't collisions between 2 rows of different tables that happen to have the same ID. (the post 1 and comment 1 for example).