[wp-trac] [WordPress Trac] #58826: Please add a default post relations table

[WordPress Trac]

#58826: Please add a default post relations table
-------------------------+-----------------------------
 Reporter:  jcc5018      |      Owner:  (none)
     Type:  enhancement  |     Status:  new
 Priority:  normal       |  Milestone:  Awaiting Review
Component:  Database     |    Version:
 Severity:  critical     |   Keywords:
  Focuses:               |
-------------------------+-----------------------------
 As I am sure you know, people have bee using wordpress for a lot of things
 other than a simple blogging platform. And while your structure allows for
 basic functionality and relationships, There is a lot of room for
 improvement. As people continue to add more and more custom post types and
 related meta, the default posts/post meta tables will quickly become
 filled and make web queries slow.

 In addition, the taxonomy system is very limiting, as that is not the only
 way one would want to group like items. The most common way, would be POST
 relationships. If a Class has many students, and students have many
 classes, Displaying an intermediary page between the two is very difficult
 with the current set up. Therefore, I'd like to request an extension to
 the database structure as described below in the link below. At minimum
 the 1st option should be considered as an alternative to archive pages
 with taxonomies.

 [https://imgur.com/a/L9q4bAf]

 If I type  domain.exp/articles/for/baseball where baseball is a sports
 custom post type and arcticles is just one of several custom post types, I
 expect a query  select * from articles where hobby_slug = 'baseball'

 Currently everyone expects me to make the sport CPT  a taxonomy, but if
 the sport has its own custom fields, and taxonomies already attached, that
 does not work.  This system would be usable in a thousand different use
 cases and would make your platform more versatile.  USERS, comments, posts
 and custom post types are all Models. Make it easier to establish any
 relation between them please.

-- 
Ticket URL: <https://core.trac.wordpress.org/ticket/58826>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform