Trying to understand WP database structure – wp_term_relationships

  • Hey everyone, I’m trying to understand the structure of the WordPress database, and there’s one particular link I’m not getting.

    According to the ERD here, the wp_term_relationships table has 1:n identifying relationships with 3 tables: wp_posts, wp_links and wp_term_taxonomy. As far as I understand, this means that each record in the wp_term_relationships table should have a foreign key for each of these three tables. However, according to the ERD, it only has two foreign keys: object_id (which I assume is the primary key of wp_posts) and term_taxonomy_id (which is the primary key of wp_term_taxonomy).

    Where’s the missing foreign key for the wp_links table? Maybe I’m just missing part of my brain ??

  • The topic ‘Trying to understand WP database structure – wp_term_relationships’ is closed to new replies.