Managing TAGS for many different tables - Design Logic Help

[eluser]gon[/eluser]
I always use InnoDB tables, and foreign keys.
In that case it makes sense to have a one column table, with auto_increment.
When inserting in any other table, you use the one-column table to get the next RESOURCE_ID, and then make the insert in the other table.

Obviously, the one-column table is not used when doing selects.

Anyway, I read your post too fast, so my suggestion may not be very useful.