What is the purpose of the “term_id” column in the “wp_term_taxonomy” table?

In versions of WordPress prior to 4.2 terms could belong to multiple taxonomies. This is no longer the case and in WordPress 4.2 or newer new terms cannot belong to multiple taxonomies and any existing terms that belong to multiple taxonomies are split into multiple terms whenever they are updated.

You can read this post for an introduction to the change from before it was made: https://make.wordpress.org/core/2015/02/16/taxonomy-term-splitting-in-4-2-a-developer-guide/

There is also this article which describes the splitting process: https://developer.wordpress.org/plugins/taxonomies/split-terms-wp-4-2/

So unless you are dealing with pre-4.2 data the values of these columns should always be the same.

Related Posts:

  1. What does wp_term_taxonomy.parent reference?
  2. Clear Terms from Taxonomy for Specific Post IDs?
  3. Slow wp_term_relationships query
  4. How are terms connected with posts in database?
  5. Is altering a default WordPress database table update safe?
  6. What are terms and taxonomy, how they related to post and how these three are stored in database?
  7. get_tags() return an empty array after added tags with wp_insert_term()
  8. Make an Items attribute searchable (taxonomy using existing attribute)
  9. WordPress database products structure
  10. get value from ‘terms’ table
  11. I cannot change anything in my wordpress database from within wordpress?
  12. get_the_terms is not working
  13. What is this JavaScript “require”?
  14. Using wpdb to connect to a separate database
  15. How to show a hierarchical terms list?
  16. How can I make a WordPress database portable and url independent?
  17. wpdb->insert multiple record at once
  18. How to migrate a HTTPS WordPress installation to localhost?
  19. Control term order on a per-post basis
  20. How to stop WordPress using utf8mb4_unicode_520_ci collation?
  21. How do I list custom taxonomy terms without the links?
  22. Exclude posts that only have the ‘Uncategorized’ category [duplicate]
  23. How to monitor server for error establishing a database connection
  24. Exporting revisions
  25. WP_Options ID high
  26. Default WordPress settings API data sanitization
  27. Fatal error: Call to undefined function dbDelta()
  28. Connect to remote database using Localhost install
  29. How to use multiple database in wordpress?
  30. Using get_terms for custom taxonomy in functions.php
  31. Is it possible to get a Previous/Next Taxonomy term archive URL?
  32. get_post_terms not working as expected
  33. Is removing orphaned wp_postmeta records safe?
  34. How to intercept update_option() before it saves data?
  35. Get posts that matches specific terms of multiple custom taxonomies
  36. wpdb query on custom table not working [closed]
  37. Error connecting to DB in /wp-includes/wp-db.php on line 1538 [closed]
  38. Set Display Name to first and last name (phpmyadmin SQL Query)
  39. How to fix unchanged URLs in Database after running serialized search and replace script?
  40. How to query the WordPress database to get posts of a certain custom post type, taxonomy and field?
  41. SQL Error wp_commentmeta – incorrect table definition
  42. display taxonomy slug from term ID
  43. Can I generate then display a mixed list of linked and unlinked terms
  44. WordPress database error – Error in SQL syntax – I can’t identify any error?
  45. Get posts of ONE taxonomy term of custom post type
  46. Merging two wp_posts tables while avoiding duplicates
  47. Set multiple Post Terms in same Taxonomy
  48. How can i add custom fields into the contact form 7 [closed]
  49. Merging two databases without borking it
  50. How Yoast SEO plugin works with variable %%name%%?
  51. Move out of sync posts from one database to another
  52. MS Access to manage WordPress Database
  53. Query multiple tables at once?
  54. List taxonomy term slugs within shortcode (do_shortcode)
  55. Custom WordPress Table wpdb
  56. Displaying Custom Taxonomy without a hyperlink
  57. CreateOrUpdate in WordPress
  58. $wpdb->get_results($wpdb->prepare(… You have an error in your SQL syntax;
  59. Transferring/Uploading Data from DB to WordPress
  60. Can local WordPress installs share /wp-content/ folder and database?
  61. How can I change the output display of my pagination?
  62. Remote database connection and local development
  63. How to display taxonomy term custom meta (using wp_get_object_terms?)?
  64. How can I detect right db type?
  65. Add search bar to Custom Database Table in WordPress Dashboard
  66. Design problems when exporting remote database for local development
  67. How do you render posts from outside wordpress?
  68. A change in URL slug in database returns 404, how can I do auto-redirect?
  69. Second ezSQL initialization for MSSQL
  70. Fetch a single row from a custom table for to a given ID
  71. muliple wordpress installs (network) on different databases
  72. Use wp_list_categories to list parent categories from actual term
  73. Database structure cheatsheet
  74. White Screen in Home Page
  75. Continuous SQL query errors from outside source
  76. How to escape percentage sign(%) in sql query with $wpdb->prepare?
  77. Recovery – Restore Database after moving folder location locally
  78. Migrate Users From laravel to wordpress
  79. WordPress has been updated! Before we send you on your way, we have to update your database to the newest version
  80. how add more field to wp user and save it to database
  81. How do I cleanup my database with data that is no longer being used?
  82. How to create a non removable taxonomy term?
  83. Malware in old website – how to migrate?
  84. taxquery taxonomy get terms
  85. $product->ID in has_term() not working, but manually inputting the ID works, why?
  86. How to display $wpdb->insert_id; value on redirected page
  87. how do you get one specific term from a shortcode attribute?
  88. Should I Use only wpdb Class to Write Custom Queries?
  89. Auto populate form fields based on serial input or pull listings from other websites?
  90. Catchable fatal error in formatting.php
  91. Wrong url for the images while using same database for two WordPress installations
  92. Sending WordPress database information to cross domain the safe way?
  93. Database Name Change
  94. Taxonomy Grid Archive Help?
  95. How to associate an image with a term taxononmy and publish it on frontpage?
  96. Weird characters in title if it contain “ ”
  97. Display yesterday’s last post’s Custom field from Unique terms of one Taxonomies
  98. Where To Find bb_profile_data(); In bbPress?
  99. Author template – separate custom post type by custom taxonomy term for $curauth
  100. One information repeated on multiple locations on one site [closed]
tech