In order to remove thousands of old taxonomies and terms used during development, I recommended the following SQL queries to another dev:
TRUNCATE wp_terms; TRUNCATE wp_termmeta; TRUNCATE wp_term_taxonomy; TRUNCATE wp_term_relationships;
The dev told me that after he ran these queries he had a myriad of problem and other data being deleted. Other than terms and taxonomies, what other data might be stored in those tables? We know that non-post related information is stored in
wp_posts, such as Navigation Menus. In a similar vein, are non-terms data stored in the above-mentioned tables?
EDIT: Note that one can read the table structures to see exactly what obvious data is being stored, which all seems related to the Terms, Taxonomies, and their metadata and relations. This question is asking what non-obvious data may be stored in those tables as well, i.e. if they were to be truncated what data not related to Terms or Taxonomies would be lost. This is in a similar vein to loosing Navigation Menu configurations when truncating
wp_posts, which is not obvious from examining the table structure and names of
wp_posts and related tables.