Hi all,
im currently developing a category module. As we know category can be apply to many module such as posts, product, page and etc.
If i need such module into my system, eventually i will have a lot of associative tables for many to many relationship.
So ideally, i will retain all associative info in table called categories_relationships, and use type column to differential the table module.
As i know, wordpress is powerful managing those categories, tags and menu into a few table, (wp_terms, wp_term_relationships, wp_term_taxonomy)
i would like to know any suggestion or better solution? appreciate!!!