By default all of the WordPress database tables will start with the prefix “wp_” (e.g. wp_users, wp_posts, etc.). Because this is the default value, you’ll often hear the tables referred to (and written about) using the “wp_” prefix. Let’s look at how and why this prefix is modified.
A list of the database tables (and the columns in those tables) used by a default WordPress installation. This is the companion blog post to my talk, “Introduction to the WordPress Database”.
In the WordPress database table “wp_term_taxonomy”, each row almost always has the same value for the two columns ‘term_taxonomy_id’ and ‘term_id’. What is the difference between these two columns?