wp_term_taxonomy 

This table stores the type of categorizations called taxonomies. This table consists of six columns. Let's identify some of the most important columns in this table:

term_id This is the ID of the term and is used to form the connection with the wp_terms table.
taxonomy This is the unique slug for the taxonomy. Default taxonomies are category and post_tag.
parent Stores the parent term when using sub-terms in your site.
count Stores the number of posts and custom post types that belong to this taxonomy.

This table contains default taxonomies for category and post_tag, to be used in normal WordPress posts. We can create custom taxonomies such as job skills in a job management site, product types in an online store, ...

Get WordPress Development Quick Start Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.