[wp-trac] [WordPress Trac] #37686: Add object_type column to term_relationships table

[WordPress Trac]

#37686: Add object_type column to term_relationships table
-----------------------------+------------------------------
 Reporter:  johnjamesjacoby  |       Owner:
     Type:  enhancement      |      Status:  new
 Priority:  normal           |   Milestone:  Awaiting Review
Component:  Taxonomy         |     Version:
 Severity:  normal           |  Resolution:
 Keywords:  2nd-opinion      |     Focuses:
-----------------------------+------------------------------

Comment (by MikeSchinkel):

 Thoughts on this.

 It really feels unnecessary to add a field to the `wp_term_relationships`
 table. Instead I would propose that we add an `'object_type'` element to
 the `$args` array passed to `register_taxonomy()` and handle in that
 manner. Worst case we could add the value to `wp_term_taxonomy` if we need
 it in the database.

 Adding to the`wp_term_relationships` table will end up bloating an
 efficient table relationship that is only 51 bytes per row to become much
 larger.

 Or are there use-cases that I am missing that one of these proposed
 alternatives will not accommodate?
 ----
 And for those who care, think about how much effort it will be to update
 the tables on WordPress.com... #justsaying

--
Ticket URL: <https://core.trac.wordpress.org/ticket/37686#comment:4>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform