I just had a look at the ERD of the Wordpress CMS system and I think I found a mistake... Check the relation between the wp_term_taxonomy and the wp_terms table: https://codex.wordpress.org/images/9/9e/WP3.0-ERD.png

If I'm correct ONE wp_term_taxonomy (like "brands") can have more wp_terms (like "puma", "nike" etc.) and not otherwise? Cause it says now that one term can have more taxonomies, am I right?

migrated from stackoverflow.com Nov 14 '13 at 14:02

This question came from our site for professional and enthusiast programmers.

  • Erik, can you please move the solution to an Answer and mark it as the correct one? So this Question doesn't remain "unanswered", thanks. – brasofilo Nov 13 '13 at 19:58

I found the reason:

term_id is the ID of a term in the terms table.

term_taxonomy_id is a unique ID for the term + taxonomy pair.

see: What's the difference between term_id and term_taxonomy_id

Still, I think it's a bit strange to do it this way. Also because I think it doesn´t make sence to not put the taxonomy names in a separate table.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.